Package DE_EPAGES::Database::API::DBISQLite
central database interface for sqlite databases.
Base |
DE_EPAGES::Database::API::DBI |
Functions
disconnect
Disconnects the underlying database handle.
Syntax |
$dbi->disconnect; |
do
Executes the given statement and logs it via DE_EPAGES::Database::API::DBI::logTransaction.
Input |
|
dropIndex
Drops index $indexname from table $tablename.
Syntax |
$dbi->dropIndex($table, $indexname); |
Example |
$dbi->dropIndex('product', 'i_product_super'); |
Input |
|
existsIndex
Returns true if the index exists.
Syntax |
$exists = $dbi->existsIndex($Table, $IndexName); |
Example |
if( $dbi->existsIndex('product', 'i_product_super') ) { ... } |
Input |
|
transaction
Executes a code block in a transaction.
Syntax |
$dbi->transaction( $cCode, $cRollback ); |
Example |
$dbi->transaction( sub { $dbi->do( "DELETE FROM objects WHERE classid = 25" ); $dbi->do( "DELETE FROM classes WHERE classid = 25" ); } ); |
Input |
|