DBIx::PDlib 1.008 review

DBIx::PDlib is a Perl with DBI SQL abstraction and convenience methods. SYNOPSIS use DBIx::PDlib; my $db = DBIx::PDlib->co

License: Perl Artistic License File size: 10K Developer: Josh I. Miller

0

DBIx::PDlib is a Perl with DBI SQL abstraction and convenience methods.

SYNOPSIS

use DBIx::PDlib;
my $db = DBIx::PDlib->connect({
driver => 'mydriver',
host => 'myhost.com',
dbname => 'mydb',
user => 'myuser',
password => 'mypassword',
});

my ($name) = $db->select('name','table1',"id = '10'");

my $dbi_sth = $db->iterated_select('name','table1',
"id > 2",'ORDER BY name');
while (my ($name) = $dbi_sth->fetchrow_array) { ...do stuff... }

my $rv = $db->insert('table1',['id','name'],['11','Bob']);

my $rv = $db->update('table1',['name'],['Bob Jr.'],"id = '11'");

my $rv = $db->delete('table1',"id = '11'");

my @quoted = $db->quote( "something", $foo, $bar, @moredata );

my $rv = $db->raw_query("CREATE TABLE table1 (id int, name char)");

if ($db->connected) { ...we're connected... }

$db->disconnect;

ABSTRACT

DBIx::PDlib provides a simplified way to interact with DBI. It provides methods for SELECT, INSERT, UPDATE, and DELETE which result in having to type less code to do the DBI queries. It does as little as possible to make things easier.

What it doesn't do... It isn't trying to replace DBI. It's not trying to completely abstract SQL statement building into some 100% perllike syntax (though that is REALLY cool, and what I liked about DBIx::Abstract), but it does abstract it some.

Requirements:
Perl