NAME

DBIx::Handler::Sunny - DBIx::Handler meets Sunny

SYNOPSIS

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 ...');

DESCRIPTION

DBIx::Handler::Sunny is a DBI handler with some useful interface. It ads DBIx::Handler to methods for selecting a column or row(s).

The methods are taken from DBIx::Sunny.

METHODS

• select_one

    $col = $handler->select_one($query, @bind);
  

  Shortcut for prepare, execute and fetchrow_arrayref->[0].

• select_row

    $row = $handler->select_row($query, @bind);
  

  Shortcut for prepare, execute and fetchrow_hashref.

• select_all

    $rows = $handler->select_all($query, @bind);
  

  Shortcut for prepare, execute and selectall_arrayref(..., { Slice => {} }, ...).

• last_insert_id

    $id = $handler->last_insert_id
  

  Retrieve the last insert ID by suitable way for the DB driver. Supported drivers are SQLite and MySQL.

SEE ALSO

DBIx::Handler

DBIx::Sunny

LICENSE

Copyright (C) INA Lintaro

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

AUTHOR

INA Lintaro tarao.gnn@gmail.com