DBIx::Handler::Sunny - DBIx::Handler meets Sunny
use DBIx::Handler::Sunny; my $handler = DBIx::Handler::Sunny->new($dsn, $user, $pass, $opts); my $col = $handler->select_one('SELECT ...'); my $row = $handler->select_row('SELECT ...'); my $rows = $handler->select_all('SELECT ...');
DBIx::Handler::Sunny is a DBI handler with some useful interface. It ads DBIx::Handler to methods for selecting a column or row(s).
DBIx::Handler::Sunny
The methods are taken from DBIx::Sunny.
$col = $handler->select_one($query, @bind);
Shortcut for prepare, execute and fetchrow_arrayref->[0].
prepare
execute
fetchrow_arrayref->[0]
$row = $handler->select_row($query, @bind);
Shortcut for prepare, execute and fetchrow_hashref.
fetchrow_hashref
$rows = $handler->select_all($query, @bind);
Shortcut for prepare, execute and selectall_arrayref(..., { Slice => {} }, ...).
selectall_arrayref(..., { Slice => {} }, ...)
$id = $handler->last_insert_id
Retrieve the last insert ID by suitable way for the DB driver. Supported drivers are SQLite and MySQL.
DBIx::Handler
DBIx::Sunny
Copyright (C) INA Lintaro
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
INA Lintaro <tarao.gnn@gmail.com>
To install DBIx::Handler::Sunny, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::Handler::Sunny
CPAN shell
perl -MCPAN -e shell install DBIx::Handler::Sunny
For more information on module installation, please visit the detailed CPAN module installation guide.