Skip to content

Provides a wrapper around DBI with a very simulate interface. Makes it easy to do 99% of your DBI tasks.

Notifications You must be signed in to change notification settings

matisse/DBIx-Wrapper-VerySimple

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

DBIx::Wrapper::VerySimple - Simplify use of DBI
===============================================

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 <[email protected]>

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)


About

Provides a wrapper around DBI with a very simulate interface. Makes it easy to do 99% of your DBI tasks.

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages