this constructor 'new' is called when a DBIx::OptimalQuery->prepare method call is issued. my %opts = ( show => [] filter => "" sort => "" ); $sth = $oq->prepare(%opts); - same as - $sth = DBIx::OptimalQuery::sth->new($oq,%opts); $sth->execute( limit => [0, 10]);
use DBIx::OptimalQuery; my $oq = DBIx::OptimalQuery->new( select => { 'alias' => [dep, sql, nice_name, { OPTIONS } ] }
joins => { 'alias' => [dep, join_sql, where_sql, { OPTIONS } ] } named_filters => { 'name' => [dep, sql, nice] 'name' => { sql_generator => sub { my %args = @_; return [dep, sql, name] } title => "text displayed on interactive filter" } }, named_sorts => { 'name' => [dep, sql, nice] 'name' => { sql_generator => sub { return [dep, sql, name] } } }, debug => 0 | 1 );
3 POD Errors
The following errors were encountered while parsing the POD:
Unknown directive: =comment
To install CGI::OptimalQuery, copy and paste the appropriate command in to your terminal.
cpanm
cpanm CGI::OptimalQuery
CPAN shell
perl -MCPAN -e shell install CGI::OptimalQuery
For more information on module installation, please visit the detailed CPAN module installation guide.