package DBIx::Custom::SQLite;

use base 'DBIx::Custom::Basic';

use strict;

use warnings;

use Carp 'croak';

__PACKAGE__->add_format(

    datetime => __PACKAGE__->formats->{SQL99_datetime},

    date     => __PACKAGE__->formats->{SQL99_date},

    time     => __PACKAGE__->formats->{SQL99_time},

);

sub connect {

    my $self = shift;

    if (!$self->data_source && (my $database = $self->database)) {

        $self->data_source("dbi:SQLite:dbname=$database");

    }

    return $self->SUPER::connect;

}

sub connect_memory {

    my $self = shift;

    # Data source for memory database

    $self->data_source('dbi:SQLite:dbname=:memory:');

    # Already connected

    croak("Already connected") if $self->connected;

    # Connect

    $self->connect;

    return $self;

}

sub reconnect_memory {

    my $self = shift;

    # Data source for memory database

    $self->data_source('dbi:SQLite:dbname=:memory:');

    # Reconnect

    $self->reconnect;

    return $self;

}

sub last_insert_id {

    my $self = shift;

    croak "Not yet connected" unless $self->connected;

    my $last_insert_id = $self->dbh->func('last_insert_rowid');

    return $last_insert_id;

}

=head1 NAME

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

=head1 Synopsys

    use DBIx::Custom::SQLite;

    # New

    my $dbi = DBIx::Custom::SQLite->new(user => 'taro', $password => 'kliej&@K',

                                        database => 'sample');

    # Connect memory database

    my $dbi->connect_memory;

=head1 See DBIx::Custom and DBIx::Custom::Basic documentation at first

This class is L<DBIx::Custom::Basic> subclass.

and L<DBIx::Custom::Basic> is L<DBIx::Custom> subclass

You can use all methods of L<DBIx::Custom::Basic> and <DBIx::Custom>

Please see L<DBIx::Custom::Basic> and <DBIx::Custom> documentation

=head1 Methods

=head2 connect

Connect to database

    $dbi->connect;

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

=head2 connect_memory

Connect memory database

    $dbi->connect_memory;

=head2 reconnect_memory

Reconnect to memory databsse

    $dbi->reconnect_memory;

=head2 last_insert_id

Get last insert id

    $last_insert_id = $dbi->last_insert_id;

The folloing is last_insert_id sample.

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

    $last_insert_id = $dbi->last_insert_id;

This is equal to SQLite function

    last_insert_rowid()

=head1 Author

Yuki Kimoto, C<< <kimoto.yuki at gmail.com> >>

Github L<http://github.com/yuki-kimoto>

I develope this module L<http://github.com/yuki-kimoto/DBIx-Custom>

=head1 Copyright & lisence

Copyright 2009 Yuki Kimoto, all rights reserved.

This program is free software; you can redistribute it and/or modify it

under the same terms as Perl itself.