SQL::Object - Yet another SQL condition builder
use SQL::Object qw/sql_obj/; my $sql = sql_obj('foo.id=?',1); $sql->as_sql; # 'foo.id=?' $sql->bind; # qw/1/ $sql->and('foo.name=?','nekokak'); $sql->as_sql; # 'foo.id=? AND foo.name=?' $sql->bind; # qw/1 nekokak/ $sql->as_sql; # 'foo.id=? AND foo.name=?' my $other_cond = sql_obj('foo.id=?', 2); $other_cond->and('foo.name=?','tokuhirom'); $other_cond->as_sql; # 'foo.id=? AND foo.name=?' $sql = $sql | $other_cond; # $sql->compose_or($other_cond) $sql->as_sql; # ('foo.id=? AND foo.name=?') OR ('foo.id=? AND foo.name=?') $sql->bind; # qw/1 nekokak 2 tokuhirom/ $sql->add_parens; $sql = $sql & sql('baz.name=?','lestrrat'); # $sql->compose_and(sql('baz.name=?','lestrrat')) $sql->as_sql; # ((('foo.id=? AND foo.name=?') OR ('foo.id=? AND foo.name=?')) OR (foo.id IN (?,?))) AND baz.name=? $sql = sql_obj('SELECT * FROM user WHERE ') + $sql; $sql->as_sql; # SELECT * FROM user WHERE ((('foo.id=? AND foo.name=?') OR ('foo.id=? AND foo.name=?')) OR (foo.id IN (?,?))) AND baz.name=?
SQL::Object is raw level SQL maker
create SQL::Object's instance.
create SQL::Object::Type's instance
see "SQL::Object::Type"
create SQL::Object's instance
compose sql. operation 'ADN'.
compose sql. operation 'OR'.
compose sql object. operation 'AND'.
compose sql object. operation 'OR'.
bracket off current SQL.
get sql statement.
get sql bind variables.
SQL::Object:Type is SQL Types wrapper.
return setting dereferenced value.
return setting value reference.
return setting SQLType.
Atsushi Kobayashi <nekokak _at_ gmail _dot_ com>
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
To install SQL::Object, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SQL::Object
CPAN shell
perl -MCPAN -e shell install SQL::Object
For more information on module installation, please visit the detailed CPAN module installation guide.