DBIx::Custom::Query - Query
my $query = DBIx::Custom::Query->new;
columns
my $columns = $query->columns; $query = $query->columns(['auhtor', 'title']);
Column names.
default_filter
my $default_filter = $query->default_filter; $query = $query->default_filter('encode_utf8');
Default filter when parameter binding is executed.
filter
my $filter = $query->filter; $query = $query->filter({author => 'encode_utf8', title => 'encode_utf8'});
Filters when parameter binding is executed. This overwrites default_filter.
sql
my $sql = $query->sql; $query = $query->sql('select * from books where author = ?;');
SQL statement.
sth
my $sth = $query->sth; $query = $query->sth($sth);
Statement handle of DBI
DBIx::Custom::Query inherits all methods from Object::Simple.
To install DBIx::Custom, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::Custom
CPAN shell
perl -MCPAN -e shell install DBIx::Custom
For more information on module installation, please visit the detailed CPAN module installation guide.