刘刊 > pantheon-0.58 > Vulcan::SQLiteDB

Download:
pantheon-0.58.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Source  

NAME ^

Vulcan::SQLiteDB - SQLite database interface

SYNOPSIS ^

 use base qw( Vulcan::SQLiteDB );

 my $db = Vulcan::SQLiteDBI->new( '/database/file' => @table );

 $db->select( foo => 'name', [ 1, 'bar' ] );

METHODS ^

column()

Returns table columns.

table()

Returns table names.

create( $table )

Create $table.

insert( $table, @record )

Inserts @record into $table.

dump( $table )

Dump all records from $table.

truncate( $table )

Delete all records from $table.

drop( $table )

Drop $table.

select( $table, $column, %query )

Select $column from $table.

delete( $table, %query )

Delete records from $table.

QUERY ^

%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' )"
syntax highlighting: