SQLite::DBSQLite::DB module provides an object oriented wrapper to SQLite databases using DBI and DBD::SQLite modules. | |
Download |
SQLite::DB Ranking & Summary
Advertisement
- License:
- Perl Artistic License
- Price:
- FREE
- Publisher Name:
- Vitor Serra Mori
- Publisher web site:
- http://search.cpan.org/~vxx/SQLite-DB-0.04/lib/SQLite/DB.pm
SQLite::DB Tags
SQLite::DB Description
SQLite::DB module provides an object oriented wrapper to SQLite databases using DBI and DBD::SQLite modules. SQLite::DB module 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"; $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; Requirements: · Perl
SQLite::DB Related Software