NAME

DBIx::Custom::Query - Query

SYNOPSIS

my $query = DBIx::Custom::Query->new;

ATTRIBUTES

sql

my $sql = $query->sql;
$query  = $query->sql('select * from books where author = ?;');

SQL statement.

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.

sth

my $sth = $query->sth;
$query  = $query->sth($sth);

Statement handle of DBI

METHODS

DBIx::Custom::Query inherits all methods from Object::Simple.