The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

DBIx::QueryByName::SthPool - A pool of statement handles

DESCRIPTION

An instance of DBIx::QueryByName::SthPool stores all the statement handles obtained by calling queries by name. It contains the logic for retrying failed queries.

DO NOT USE DIRECTLY!

INTERFACE

This API is subject to change!

my $pool = DBIx::QueryByName::SthPool->new();

Instanciate DBIx::QueryByName::SthPool.

$pool->parent($dbixquerybyname)

Called after new() to tell the sth pool of which instance of DBIx::QueryByName it is related to.

$pool->finish_all_sths();

Call finish on all the statement handles opened by the current process via calls to named queries.

$pool->prepare($queryname)

Prepare the sql query associated to the query with name $queryname.

$pool->prepare_and_execute($queryname,$value1,$value2,$value3...)

or

$pool->prepare_and_execute($queryname,\@values1,\@values2,\@values3...)

Call execute respectively execute_array for the statement handle associated with $queryname