DBIx::Wrapper::VerySimple is a simple module that provides a high-level interface to the Perl DBI module. The provided methods are for fetching a single record (returns a hashref), many records (returns an arrayref of hashrefs), and for executing a non-select statement (returns a result code).
The intention here is that your application will have much cleaner code, so instead of writing:
$sql = 'SELECT name,address FROM $table WHERE zipcode=?';
$sth = $dbh->prepare($sql);
$rv = $sth->execute($zipcode);
@found_rows;
while ( my $hash_ref = $sth->fetchrow_hashref ) {
push( @found_rows, $hash_ref ); }
You would write:
$sql = 'SELECT name,address FROM $table WHERE zipcode=?'; $found_rows = $wrapper->fetch_all($sql,$zipcode); # An arrayref of hashrefs
INSTALLATION
To install this module type the following:
perl Makefile.PL
make
make test
make install
DEPENDENCIES
This module requires these other modules and libraries:
DBI (prefer version 1.34 or later)
COPYRIGHT AND LICENCE
Copyright (c)2001-2006 by Matisse Enzer <matisse@matisse.net>
This package is free software and is provided "as is" without express or implied warranty. It may be used, redistributed and/or modified under the terms of the Perl Artistic License (see http://www.perl.com/perl/misc/Artistic.html)