NAME¶
DBIx::DBSchema::DBD::SQLite - SQLite native driver for DBIx::DBSchema
SYNOPSIS¶
use DBI; use DBIx::DBSchema;
$dbh = DBI->connect('dbi:SQLite:tns_service_name', 'user','pass'); $schema =
new_native DBIx::DBSchema $dbh;
DESCRIPTION¶
This module implements a SQLite-native driver for DBIx::DBSchema.
AUTHOR¶
Jesse Vincent <jesse@bestpractical.com>
API¶
- columns CLASS DBI_DBH TABLE
- Given an active DBI database handle, return a listref of
listrefs (see perllol), each containing six elements: column name, column
type, nullability, column length, column default, and a field reserved for
driver-specific use (which for sqlite is whether this col is a primary
key)
- primary_key CLASS DBI_DBH TABLE
- Given an active DBI database handle, return the primary key
for the specified table.
- unique CLASS DBI_DBH TABLE
- Given an active DBI database handle, return a hashref of
unique indices. The keys of the hashref are index names, and the values
are arrayrefs which point a list of column names for each. See
"HASHES OF LISTS" in perldsc and DBIx::DBSchema::ColGroup.
- index CLASS DBI_DBH TABLE
- Given an active DBI database handle, return a hashref of
(non-unique) indices. The keys of the hashref are index names, and the
values are arrayrefs which point a list of column names for each. See
"HASHES OF LISTS" in perldsc and DBIx::DBSchema::ColGroup.
