Activator::DB Wrap DBI with convenience subroutines and consistant access accross all programs in a project.
Download

Activator::DB Ranking & Summary

Activator::DB Tags

Perl module subroutines DBI convenience subroutines consistant access activator

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