Object-Relational Mapping: Reading Data | #6 Perl DBIx Tutorial

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:

Tags:
#Perl #PerlProgramming #CodingInPerl #PerlDevelopment