The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

Tao::DBI::db - DBI connection with portable support for named placeholders in statements

SYNOPSIS

  use Tao::DBI qw(dbi_connect dbi_prepare);
  
  $dbh = dbi_connect($args);
  $sql = q{UPDATE T set a = :a, b = :b where k = :k};
  $stmt = $dbh->prepare($sql);
  $rc = $stmt->execute({ k => $k, a => $a, b => $b });
  
  # dbi_prepare() can also be used to create Tao::DBI::st
  $stmt = dbi_prepare($sql, { dbh => $dbh });
  

DESCRIPTION

new
  $dbh = DBI::db::new($args)

Note. Unless $args has an explicit pair at key "FetchHashKeyName", the connection uses "FetchHashKeyName" = 'NAME_lc'> which forces the keys in fetchrow_arrayref to come in lower case.

Note. Unless $args has an explicit pair at key "AutoCommit", the connection uses "AutoCommit" = 0> which means you have to commit or rollback explicitly.

execute
  $sth->execute($hash);
  $sth->execute($param);
  $sth->execute;

Returns

EXPORT

Nothing to be exported. Every method is available as a method.

BUGS

Please report bugs via CPAN RT http://rt.cpan.org/NoAuth/Bugs.html?Dist=Tao-DBI.

AUTHOR

Adriano R. Ferreira, <ferreira@cpan.org>

COPYRIGHT AND LICENSE

Copyright (C) 2005-2007 by Adriano R. Ferreira

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.