/ 
DBIx-DBH-0.3
River stage zero No dependents
/ DBIx::DBH

NAME

DBIx::DBH - helper for DBI connection( data)?

SYNOPSIS

use DBIx::DBH;

my $config = DBIx::DBH->new
  (
    user => $user,
    pass => $pass,
    dsn  => { driver => 'mysql', port => 3306 },
    attr => { RaiseError => 1 }
  );

$config->for_rose_db; # outputs data structure for Rose::DB::register_db
$config->for_dbi;     # outputs data structure for DBI connect()
$config->dbh;  # makes a database connection with DBI
$config->conn; # makes a DBIx::Connector instance

ABSTRACT

DBIx::DBH allows you to specify the DBI dsn ( ""connect" in DBI ) as a hash ref instead of a string. A hashref is a more viable structure in a few cases:

  • working with Rose::DB

    "Registering_data_sources" in Rose::DB::Tutorial shows that Rose::DB expects the dsn information as discrete key-value pairs as opposed to a string. The ->for_rose_db method takes the DBIx::DBH instance and returns a hash array which can be consumed by "register_db" in Rose::DB

  • programmatic connection attempts

    It is much easier to manipulate a hash programmatically if you need to systematically modify it as part of a series of connection attempts.

  • high-level structure

    Whether you are talking about configuration file utilities or form data, most data from these modules comes back directly as hashes. So you have a more direct way of shuttling data into a database connection if you use this module:

    my $dbh = DBIx::DBH->(dsn => $cgi->form_data->{dsn})->dbh;

    Instead of a bunch of string twiddling.

METHODS

Legacy Version

A procedural version of DBIx::DBH is still available as DBIx::DBH::Legacy.

SEE ALSO

"Avoiding compound data in software and system design"

http://perlmonks.org/?node_id=835894

AUTHOR

Terrence Brannon, <bauhaus@metaperl.com>

thanks to Khisanth and Possum and DrForr on #perl-help

SOURCE CODE REPO

http://github.com/metaperl/dbix-dbh

COPYRIGHT AND LICENSE

Copyright (C) by Terrence Brannon

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.4 or, at your option, any later version of Perl 5 you may have available.