DBIx::DBSchema::DBD - DBIx::DBSchema Driver Writer's Guide and Base Class


NAME

DBIx::DBSchema::DBD - DBIx::DBSchema Driver Writer's Guide and Base Class


SYNOPSIS

  perldoc DBIx::DBSchema::DBD
  package DBIx::DBSchema::DBD::FooBase
  use DBIx::DBSchmea::DBD;
  @ISA = qw(DBIx::DBSchema::DBD);


DESCRIPTION

Drivers should be named DBIx::DBSchema::DBD::DatabaseName, where DatabaseName is the same as the DBD:: driver for this database. Drivers should implement the following class methods:

columns CLASS DBI_DBH TABLE
Given an active DBI database handle, return a listref of listrefs (see the perllol manpage), each containing six elements: column name, column type, nullability, column length, column default, and a field reserved for driver-specific use.

column CLASS DBI_DBH TABLE COLUMN
Same as columns above, except return the listref for a single column. You can inherit from DBIx::DBSchema::DBD to provide this function.

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 the perldsc manpage and the DBIx::DBSchema::ColGroup manpage.

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 the perldsc manpage and the DBIx::DBSchema::ColGroup manpage.


TYPE MAPPING

You can define a %typemap array for your driver to map ``standard'' data types to database-specific types. For example, the MySQL TIMESTAMP field has non-standard auto-updating semantics; the MySQL DATETIME type is what other databases and the ODBC standard call TIMESTAMP, so one of the entries in the MySQL %typemap is:

  'TIMESTAMP' => 'DATETIME',

Another example is the Pg %typemap which maps the standard types BLOB and LONG VARBINARY to the Pg-specific BYTEA:

  'BLOB' => 'BYTEA',
  'LONG VARBINARY' => 'BYTEA',

Make sure you use all uppercase-keys.


AUTHOR

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


COPYRIGHT

Copyright (c) 2000 Ivan Kohler Copyright (c) 2000 Mail Abuse Prevention System LLC All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.


BUGS


SEE ALSO

the DBIx::DBSchema manpage, the DBIx::DBSchema::DBD::mysql manpage, the DBIx::DBSchema::DBD::Pg manpage, the DBIx::DBSchema::ColGroup manpage, the DBI manpage, the DBI::DBD manpage, the perllol manpage, HASHES OF LISTS in the perldsc manpage

 DBIx::DBSchema::DBD - DBIx::DBSchema Driver Writer's Guide and Base Class