DBIx::Class::ResultSetColumn - helpful methods for messing with a single column of the resultset
$rs = $schema->resultset('CD')->search({ artist => 'Tool' }); $rs_column = $rs->get_column('year'); $max_year = $rs_column->max; #returns latest year
A convenience class used to perform operations on a specific column of a resultset.
my $obj = DBIx::Class::ResultSetColumn->new($rs, $column);
Creates a new resultset column object from the resultset and column passed as params
Returns the next value of the column in the resultset (undef is there is none).
undef
Much like $rs->next but just returning the one value
Returns all values of the column in the resultset (undef is there are none).
Much like $rs->all but returns values rather than row objects
Wrapper for ->func. Returns the lowest value of the column in the resultset (undef is there are none).
Wrapper for ->func. Returns the highest value of the column in the resultset (undef is there are none).
Wrapper for ->func. Returns the sum of all the values in the column of the resultset. Use on varchar-like columns at your own risk.
Runs a query using the function on the column and returns the value. For example $rs = $schema->resultset("CD")->search({}); $length = $rs->get_column('title')->func('LENGTH');
Produces the following SQL SELECT LENGTH( title ) from cd me
Luke Saunders <luke.saunders@gmail.com>
You may distribute this code under the same terms as Perl itself.
To install DBIx::Class, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::Class
CPAN shell
perl -MCPAN -e shell install DBIx::Class
For more information on module installation, please visit the detailed CPAN module installation guide.