Vulcan::SQLiteDB - SQLite database interface
use base qw( Vulcan::SQLiteDB ); my $db = Vulcan::SQLiteDBI->new( '/database/file' => @table ); $db->select( foo => 'name', [ 1, 'bar' ] );
Returns table columns.
Returns table names.
Create $table.
Inserts @record into $table.
Dump all records from $table.
Delete all records from $table.
Drop $table.
Select $column from $table.
Delete records from $table.
%query consists of ARRAY indexed by column. The first array element is a boolean value that indcates if column is IN or NOT IN the rest of the array elements. i.e.
x => [ 0, 'foo', 'bar' ], y => [ 1, 'bar', 'baz' ]
means:
"WHERE x NOT IN ( 'foo','bar' ) AND y IN ( 'bar','baz' )"
To install pantheon, copy and paste the appropriate command in to your terminal.
cpanm
cpanm pantheon
CPAN shell
perl -MCPAN -e shell install pantheon
For more information on module installation, please visit the detailed CPAN module installation guide.