CDBI::BDBI.pm - A subclass of Class::DBI containing several class data to be used by most Class::DBI libraries.
This module contains functions necessary to load other Class::DBI libraries. The only necessary one when setting up a database connection is &db_columns. See the samples directory for more detail. An extra Class::DBI search function, &search_regex, is provided which evidently searches with a regex operator (only for mysql and postgresql). I also temporarily copied methods that obtain a table's columns for mysql,postgresql and sqlite from their Class::DBI::* extensions.
This method is a wrapper around Class::DBI's &set_db, it's table and column declarations and &db_columns. You can specify defaults for any of the below options in a library config file. That way when you pass options to &setdb only the defaults are overidden.
%options can include any of the following as keys:
user($): username
pwd($): password
dbname($): database name
db($): database management system
choices are: mysql,postgres,sqlite
tb($): table name
cols(\@): column names
db_opts(\%): options passed as hashref to Class::DBI's &set_db
__PACKAGE__->setdb({tb=>'kings',db=>'mysql');
This method currently supports mysql,postgresql and sqllite.
Sets the &cols accessor which keeps a table's columns in order (which seems to be a problem with Class::DBI's &columns accessor). Afterwards, sets &printcols accessor which are columns to be manipulated by user for display purposes usually.
Here's a brief list of this module's global data
Note: datum with a * next to it must be defined for a Class::DBI library to work.
user($): database user
pwd($): database password
db($): database management system (dbms) ie mysql,postgres,sqlite
dbname($): database name
*tb($): table name
*cols(\@): column names
*printcols(\@):
db_opts(\%): options passed as hashref to Class::DBI's &set_db
_db_default(\%): defaults specific to dbms
This module will eventually incorporate loading tables via Class::DBI::Loader in order to switch tables within the shell.
An easier and more universal DBI or SQL way of obtaining a table's columns.
Me. Gabriel that is. If you want to bug me with a bug: cldwalker@chwhat.com If you like using perl,linux,vim and databases to make your life easier (not lazier ;) check out my website at www.chwhat.com.
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
