NAME

MooseX::Role::DBIx::Connector - give your Moose class DBIx::Connector powers

SYNOPSIS

  package MyClass;
  use Moose;
  with 'MooseX::Role::DBIx::Connector';

  package main;

  my $c = MyClass->new(
      db_dsn  => 'dbi:Pg:dbname=foo;host=bar',
      db_user => 'mikey',
      db_password => 'seekrit',
      db_attrs => { Foo => 'Bar' },
     );

  $c->db_conn->dbh->selectall_arrayref( ... );

  $c->db_conn->txn( fixup => sub { ... } );


  ### more advanced usage

  package BigClass;
  use Moose;
  with 'MooseX::Role::DBIx::Connector' => { connection_name => 'itchy'    };
  with 'MooseX::Role::DBIx::Connector' => { connection_name => 'scratchy' };

  package main;

  my $c = BigClass->new(
      itchy_dsn  => 'dbi:Pg:dbname=foo;host=bar',
      itchy_user => 'mikey',
      itchy_password => 'seekrit',

      scratchy_dsn   => 'dbi:SQLite:dbname=somefile',
     );

  $c->itchy_conn->dbh->selectall_arrayref( ... );
  $c->scratchy_conn->txn( fixup => sub { ... } );

DESCRIPTION

Generic parameterized Moose role to give your class accessors to manage one or more DBIx::Connector connections.

ROLE PARAMETERS

connection_name

Name for this connection, which is the prefix for all the generated accessors. Default 'db', which means that you get the accessors db_dsn, db_user, db_password, db_attrs, and db_conn.

connection_description

Plaintext description of this connection. Only used in generating documentation for each of the generated accessors.

accessor_options

Hashref of additional options to pass to the generated accessors, e.g.

  package MyClass;
  use Moose;
  with 'MooseX::Role::DBIx::Connector' => {
    connection_name  => 'itchy',
    accessor_options => { 'itchy_dsn'  => [ traits => ['GetOpt'], ],
                          'itchy_user' => [ default => 'minnie_the_moocher' ],
                        }
  };

ATTRIBUTES

(connection_name)_conn

Get a DBIx::Connector connection object for the given connection info.

(connection_name)_dsn

DBI DSN for your connection. Required.

(connection_name)_user

Username for the connection.

(connection_name)_password

Password for the connection.

(connection_name)_attrs

Hashref of DBI attributes for the connection. Passed to DBIx::Connector, which passes them to DBI's connect()

AUTHOR

Robert Buels, <rmb32@cornell.edu>