DBIx::DBSchema::DBD::SQLite(3pm)

DBIx::DBSchema::DBD::SQLite3pm

Sqlite native driver for dbix::dbschema

Usage

use DBI; use DBIx::DBSchema;

$dbh = DBI->connect('dbi:SQLite:tns_service_name', 'user','pass'); $schema = new_native DBIx::DBSchema $dbh;

Overview

This module implements a SQLite-native driver for DBIx::DBSchema.

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.

Releases

10 releases since Debian 4.0 (Etch); the text changed 6 times.

  1. 4.0
  2. 5.0
  3. 6.0
  4. 7
  5. 8
  6. 9–11
  7. 12–13

Authors

Jesse Vincent <[email protected]>

Nathan Anderson <http://1id.com/=nathan.anderson>

From libdbix-dbschema-perl 0.47-1 in Debian 13 (Trixie). Parsed by carta from the page's man source.