dbix::dbschema::dbd::sqlite(3pm) [debian man page]

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.

perl v5.14.2							    2007-06-18						DBSchema::DBD::SQLite(3pm)

DBSchema::Index(3pm)					User Contributed Perl Documentation				      DBSchema::Index(3pm)

NAME

       DBIx::DBSchema::Index - Index objects

SYNOPSYS

	 use DBIx::DBSchema::Index;

	 $index = new DBIx::DBSchema::Index (
	   {
	   }
	 );

DESCRIPTION

       DBIx::DBSchema::Index objects represent a unique or non-unique database index.

METHODS

       new HASHREF | OPTION, VALUE, ...
	   Creates a new DBIx::DBschema::Index object.

	   Accepts either a hashref or a list of options and values.

	   Options are:

	   name - Index name
	   using - Optional index method
	   unique - Boolean indicating whether or not this is a unique index.
	   columns - List reference of column names (or expressions)
       name [ INDEX_NAME ]
	   Returns or sets the index name.

       using [ INDEX_METHOD ]
	   Returns or sets the optional index method.

       unique [ BOOL ]
	   Returns or sets the unique flag.

       columns [ LISTREF ]
	   Returns or sets the indexed columns (or expressions).

       columns_sql
	   Returns a comma-joined list of columns, suitable for an SQL statement.

       sql_create_index TABLENAME
	   Returns an SQL statment to create this index on the specified table.

       cmp OTHER_INDEX_OBJECT
	   Compares this object to another supplied object.  Returns true if they are identical, or false otherwise.

       cmp_noname OTHER_INDEX_OBJECT
	   Compares this object to another supplied object.  Returns true if they are identical, disregarding index name, or false otherwise.

AUTHOR

       Ivan Kohler <ivan-dbix-dbschema@420.am>

       Copyright (c) 2007 Ivan Kohler Copyright (c) 2007 Freeside Internet Services, Inc.  All rights reserved.  This program is free software;
       you can redistribute it and/or modify it under the same terms as Perl itself.

BUGS

       Is there any situation in which sql_create_index needs to return a list of multiple statements?

SEE ALSO

       DBIx::DBSchema::Table, DBIx::DBSchema, DBI

perl v5.14.2							    2007-06-28						      DBSchema::Index(3pm)