NAME

DBIx::Custom::SQLite - DBIx::Custom SQLite implementation

SYNOPSYS

use DBIx::Custom::SQLite;

# New
my $dbi = DBIx::Custom::SQLite->connect(user      => 'taro', 
                                        $password => 'kl&@K',
                                        database  => 'sample');

# Connect memory database
my $dbi = DBIx::Custom::SQLite->connect_memory;

METHODS

This class is DBIx::Custom::Basic subclass. You can use all methods of DBIx::Custom::Basic

connect

Connect to database

$dbi->connect;

If you set database, host, or port, data source is automatically created.

connect_memory

Connect memory database

$dbi->connect_memory;

reconnect_memory

Reconnect to memory databsse

$dbi->reconnect_memory;

last_insert_rowid

Get last insert id

$last_insert_rowid = $dbi->last_insert_rowid;

The folloing is last_insert_rowid sample.

$dbi->insert('books', {title => 'Perl', author => 'taro'});
$last_insert_rowid = $dbi->last_insert_rowid;

This is equal to SQLite function

last_insert_rowid()