NAME
DBIx::SQLEngine::Driver::SQLite - Support DBD::SQLite driver
SYNOPSIS
DBI Wrapper: Adds methods to a DBI database handle.
my
$sqldb
= DBIx::SQLEngine->new(
'dbi:SQLite:dbname=mydatafile.sqlite'
);
Portability Subclasses: Uses driver's idioms or emulation.
$hash_ary
=
$sqldb
->fetch_select(
table
=>
'students'
limit
=> 5,
offset
=> 10
);
DESCRIPTION
This package provides a subclass of DBIx::SQLEngine which compensates for SQLite's idiosyncrasies.
About Driver Subclasses
You do not need to use this package directly; when you connect to a database, the SQLEngine object is automatically re-blessed in to the appropriate subclass.
sql_limit
Adds support for SQL select limit clause.
do_insert_with_sequence
$sqldb
->do_insert_with_sequence(
$sequence_name
,
%sql_clauses
) :
$row_count
Implemented using _seq_do_insert_postfetch and seq_fetch_current.
seq_fetch_current
$sqldb
->seq_fetch_current( ) :
$current_value
Implemented using SQLite's dbh_func() "last_insert_rowid". Note that this doesn't fetch the current sequence value for a given table, since it doesn't respect the table and field arguments, but merely returns the last sequencial value created during this session.
detect_any
$sqldb
->detect_any ( ) :
$boolean
Returns 1, as we presume that the requisite driver modules are available or we wouldn't have reached this point.
sql_detect_table
$sqldb
->sql_detect_table (
$tablename
) :
%sql_select_clauses
Implemented using SQLite's "select * from $tablename limit 1".
dbms_create_column_types
$sqldb
->dbms_create_column_types () :
%column_type_codes
Implemented using SQLite's blob and int auto_increment types.
dbms_create_column_text_long_type
$sqldb
->dbms_create_column_text_long_type () :
$col_type_str
Implemented using SQLite's blob type.
dbms_column_types_unsupported
$sqldb
->dbms_column_types_unsupported () : 1
Capability Limitation: This driver does not store column type information.
dbms_indexes_unsupported
$sqldb
->dbms_indexes_unsupported () : 1
Capability Limitation: This driver does not support indexes.
dbms_storedprocs_unsupported
$sqldb
->dbms_storedprocs_unsupported () : 1
Capability Limitation: This driver does not support stored procedures.
dbms_detect_tables_unsupported
$sqldb
->dbms_detect_tables_unsupported () : 1
Capability Limitation: This driver does not return a list of available tables.
SEE ALSO
See DBIx::SQLEngine for the overall interface and developer documentation.
See DBIx::SQLEngine::Docs::ReadMe for general information about this distribution, including installation and license information.