SQL::Executor::Iterator - iterator for SQL::Executor
use DBI; use SQL::Executor; my $dbh = DBI->connect($dsn, $id, $pass); my $ex = SQL::Executor->new($dbh); # my $itr= $ex->select_named('SELECT id, value1 FROM SOME_TABLE WHERE value2 = :arg1', { arg1 => 'aaa' });
$sth: DBI's statement handler $table_name: table name $executor: SQL::Executor object $select_id: select_id(UUID) this is used for to make Row object uniquely
return row hashref by default. if specified callback or table_callback option is specified in SQL::Executor::new(), callback will be called.
Takuya Tsuchida <tsucchi {at} cpan.org>
SQL::Executor, DBI, SQL::Maker, DBIx::Simple
Codes for named placeholder is taken from Teng's search_named.
Copyright (C) Takuya Tsuchida
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
To install SQL::Executor, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SQL::Executor
CPAN shell
perl -MCPAN -e shell install SQL::Executor
For more information on module installation, please visit the detailed CPAN module installation guide.