Activator::DBWrap DBI with convenience subroutines and consistant access accross all programs in a project. | |
Download |
Activator::DB Ranking & Summary
Advertisement
- License:
- Perl Artistic License
- Price:
- FREE
- Publisher Name:
- Karim A. Nassar
- Publisher web site:
- http://search.cpan.org/~knassar/
Activator::DB Tags
Activator::DB Description
Wrap DBI with convenience subroutines and consistant access accross all programs in a project. Activator::DB is a Perl module to wrap DBI with convenience subroutines and consistant access accross all programs in a project.Synopsis use Activator::DB; my $db = Activator::DB->connect('default'); # connect to default db * Get a single row: my @row = $db->getrow( $sql, $bind, @args ); my $rowref = $db->getrow_arrayref( $sql, $bind, @args ); * Get hashref of col->value pairs: my $hashref = $db->getrow_hashref( $sql, $bind, @args ); * Get all rows arrayref (these are identical): my $rowsref = $db->getall( $sql, $bind, @args ); my $rowsref = $db->getall_arrayrefs( $sql, $bind, @args ); * Get all rows ref: with each row a hashref of cols->value pairs: my $rowsref = $db->getall_hashrefs( $sql, $bind, @args ); * do any query ( usually INSERT, DELETE, UPDATE ): my $id = $db->do( $sql, $bind, @args ); * do query, but return id instead of success.: my $id = $db->do_id( $sql, $bind, @args ); ( NOTE: this is very mysql dependant at the moment) * Get data from a different db for a while: $db->connect('alt'); # connect to alternate db # do something $db->connect('def'); # reset to default connection # do something else * Transactions (NOT YET IMPLEMENTED):: my $altdb = Activator::DB->connect('altdb'); $db->begin_work(); $db->do( @stuff ); $db->do( @more_stuff ); $db->commit(); Requirements: · Perl
Activator::DB Related Software