DBIx::Custom::Where - Where clause
my $where = DBIx::Custom::Where->new;
clause
$where->clause( ['and', '{= title}', ['or', '{< date}', '{> date}']] );
Where clause. Above one is expanded to the following SQL by to_string If all parameter names is exists.
"where ( {= title} and ( {< date} or {> date} ) )"
param
my $param = $where->param; $where = $where->param({title => 'Perl', date => ['2010-11-11', '2011-03-05']}, name => ['Ken', 'Taro']);
safety_character
my $safety_character = $self->safety_character; $dbi = $self->safety_character($name);
to_string
$where->to_string;
Convert where clause to string correspoinding to param name.
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.