In this Perl programming tutorial, we will look at how we can query our database using various SQL conditions and ResultSet methods.
Chapters:
00:00 Intro
00:35 Moving connect to a class
02:14 Note about ResultSet
03:00 METHOD: all
04:15 METHOD: search_rs
05:02 SQL: =
06:24 SQL: !=
07:02 SQL: LIKE
07:45 SQL: NOT LIKE
08:04 SQL: IN
08:51 SQL: NOT IN
09:08 SQL: NOT NULL
09:35 SQL: NULL
09:50 Multiple WHERE conditions
11:28 SQL: LENGTH
12:40 SQL: REGEXP
14:10 ResultSet methods
14:30 METHOD: first
15:15 METHOD: single
17:18 METHOD: find
22:12 Loop through results via METHOD:next
24:02 Outro
Docs:
https://metacpan.org/pod/DBIx::Class
https://metacpan.org/pod/DBIx::Class::Schema
https://metacpan.org/pod/DBIx::Class::ResultSet
https://metacpan.org/pod/DBIx::Class::Row
Tags:
#Perl #PerlProgramming #CodingInPerl #PerlDevelopment
