Man pages sections > man3 > DBIx::DBSchema::DBD::SQLite

DBIx::DBSchema::DBD::SQLite - SQLite native driver for DBIx::DBSchema

DBSchema::DBD::SQLite(3pm) User Contributed Perl Documentation DBSchema::DBD::SQLite(3pm)

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.
2015-05-07 perl v5.20.2