1DBSchema::DBD::SQLite(3U)ser Contributed Perl DocumentatiDoBnSchema::DBD::SQLite(3)
2
3
4
6 DBIx::DBSchema::DBD::SQLite - SQLite native driver for DBIx::DBSchema
7
9 use DBI; use DBIx::DBSchema;
10
11 $dbh = DBI->connect('dbi:SQLite:tns_service_name', 'user','pass');
12 $schema = new_native DBIx::DBSchema $dbh;
13
15 This module implements a SQLite-native driver for DBIx::DBSchema.
16
18 Jesse Vincent <jesse@bestpractical.com>
19
20 Nathan Anderson <http://1id.com/=nathan.anderson>
21
23 columns CLASS DBI_DBH TABLE
24 Given an active DBI database handle, return a listref of listrefs
25 (see perllol), each containing six elements: column name, column
26 type, nullability, column length, column default, and a field
27 reserved for driver-specific use (which for sqlite is whether this
28 col is a primary key)
29
30 primary_key CLASS DBI_DBH TABLE
31 Given an active DBI database handle, return the primary key for the
32 specified table.
33
34 unique CLASS DBI_DBH TABLE
35 Given an active DBI database handle, return a hashref of unique
36 indices. The keys of the hashref are index names, and the values
37 are arrayrefs which point a list of column names for each. See
38 "HASHES OF LISTS" in perldsc and DBIx::DBSchema::ColGroup.
39
40 index CLASS DBI_DBH TABLE
41 Given an active DBI database handle, return a hashref of (non-
42 unique) indices. The keys of the hashref are index names, and the
43 values are arrayrefs which point a list of column names for each.
44 See "HASHES OF LISTS" in perldsc and DBIx::DBSchema::ColGroup.
45
46
47
48perl v5.36.0 2023-01-20 DBSchema::DBD::SQLite(3)