In this Perl programming tutorial, we will look at how we can filter our ResultSet instances by limiting returned rows, ordering, selecting specific columns via "columns" and "select" conditions, and more!
We will cover the key parameters that you can apply to your ResultSet instances; however, there many more conditions that you can use. I encourage you to explore the ResultSet documentation and explore all the available conditions.
Chapters:
00:00 Intro
01:18 ARG: rows
01:36 ARG: page
02:50 ARG: offset
03:42 ARG: order_by
04:49 ARG: group_by
05:28 ARG: columns
09:25 ARG: +columns
10:52 ARG: select
11:45 ARG: as
14:50 ARG: having
17:02 Aliasing ARG: columns
18:18 ARG: having with ARG: columns
19:20 ARG: distinct
20:45 ARG: for
21:32 ARG: cache
23:39 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
