NAME

SQLite::DB provides an object oriented wrapper to SQLite databases using DBI and DBD::SQLite modules.

SYNOPSIS

 use SQLite::DB;

 my $db = SQLite::DB->new('file');

 $db->connect;

 $db->select("select * from table where field = value") || print $db->get_error."\n";

 $db->select("select * from table where field = ?","value") || print $db->get_error."\n";

 $db->select("select * from table where field = ?","value") || print $db->get_error."\n";

 $result = $db->select_one_row("select max(field) as total FROM table");

 print $$result{TOTAL};

 $db->transaction_mode;

 $db->exec("INSERT (a,b,c) VALUES 'a','b','c'");
 $db->exec("INSERT (a,b,c) VALUES ?,?,?",'a','b','c');
 $db->exec("update table set field = value") || print $db->get_error."\n";

 $db->commit || print $db->get_error."\n";
 $db->rollback || print $db->get_error."\n";

 my $resultset = $db->get_dblist("select * from table","display_field","keyfield");

 if (!ref $resultset) {
   print $db->get_error."\n"
 } else {
   for (@$resultset) {
     print $resultset->[$_]->{id}." - ".$resultset->[$_]->{value}."\n";
   }
 }

 $db->disconnect;

DESCRIPTION

The goal is provide simple coding style to interact with SQLite databases.

Functions

• new(path to db file)

  Constructor.

EXPORT_OK

w2n

KNOWN BUGS

None.

AUTHOR

Vitor Serra Mori <vvvv767@hotmail.com.>

COPYRIGHT

This package is free software. Tou can redistribute and/or modify it under the same terms as Perl itself.

# }}}