NAME
SQL::Stash - A stash for SQL queries
SYNOPSIS
package SQL::Stash::Foo;
use base qw(SQL::Stash);
__PACKAGE__->stash('select_foo', 'SELECT * FROM Foo');
1;
package main;
my $dbh = DBI->connect('dbi:SQLite:dbname=:memory:', '', '');
my $stash = SQL::Stash::Foo->new();
my $sth = $stash->retrieve('select_foo');
$sth->execute();
while(my $row = $sth->fetchrow_arrayref()) {
print("$_\n") for @$row;
}
DESCRIPTION
SQL::Stash is a simple query library for SQL statements. SQL statements
are populated at the class level. SQL::Stash objects prepare these
statements as late as possible (i.e. before they are executed).
SQL::Stash is in concept very similar to Ima::DBI, but differs by having
instance-specific database handles and statements, and by supporting
externally defined database handles.
METHODS
new
SQL::Stash->new(%args);
Designated constructor. Instantiates a new SQL::Stash object. The "dbh"
argument, a DBI-like object, must be provided.
my $dbh = DBI->connect('dbi:SQLite:dbname=:memory:', '', '');
my $stash = SQL::Stash->new('dbh' => $dbh);
stash
SQL::Stash::Foo->stash($name, $statement, $should_cache);
$stash->stash($name, $statement, $should_cache);
Stash an SQL "statement". The method can be called both on the class and
instance. If the class method is called the "statement" will be added to
the global stash. If the instance method is called the "statement" will
only be added to the instance-specific "stash".
The "name" is used as an identifier in order to later retrieve it. The
"should_cache" parameter is optional and specifies whether "prepare()"
or "prepare_cached()" is used to prepare the "statement". It defaults to
"true".
SQL::Stash::Foo->stash('select_foo', 'SELECT * FROM Foo');
retrieve
$stash->retrieve($name, @_);
Prepare the statement stored via stash, identified by "name", and return
a prepared statement handle. The SQL statement may be modified by
transform_sql before it is prepared.
transform_sql
$stash->transform_sql($sql, @_)
Transform the SQL statement before it is prepared to enable dynamically
generated statements. The default implementation is to use sprintf, but
sub-classes may override this method to perform any transformation.
$stash->transform_sql("SELECT * FROM %s", "table");
#=> SELECT * FROM table
SEE ALSO
Ima::DBI SQL::Bibliosoph SQL::Snippet
AUTHOR
Sebastian Nowicki <
[email protected]>
