Re: multiple database users

[prev] [thread] [next] [Date index for 2005/06/06]

From: Tony Bowden
Subject: Re: multiple database users
Date: 13:09 on 06 Jun 2005

On Mon, Jun 06, 2005 at 12:39:59PM +0100, William Ross wrote:
> something simple like this (untested and possibly silly):
> my $handles = {};
> my $db_options = {
>     RaiseError         => 1,
>     AutoCommit         => 0,
>     FetchHashKeyName   => 'NAME_lc',
>     ShowErrorStatement => 1,
>     ChopBlanks         => 1,
>     RootClass          => 'DBIx::ContextualFetch'
> };
> sub db_Main {
>     my $dbh;
>     return $handles->{ $ENV{USER} } ||= DBI->connect_cached(
>         $dsn, $db_user, $db_pass, $db_options
>      );
> }

You don't need to specify that db_options hash - it's already available
to you as Class->_default_attributes. Using the built in method will
also keep you in sync if the defaults change at a later date.

Tony

multiple database users
Hartmaier Alexander 17:43 on 02 Jun 2005

Re: multiple database users
Andreas Fromm 07:13 on 03 Jun 2005

Re: multiple database users
William Ross 08:42 on 03 Jun 2005

Re: multiple database users
Hartmaier Alexander 10:29 on 06 Jun 2005

Re: multiple database users
Mark Addison 11:20 on 06 Jun 2005

Re: multiple database users
William Ross 11:39 on 06 Jun 2005

Re: multiple database users
Tony Bowden 13:09 on 06 Jun 2005

Re: multiple database users
Mark Addison 13:34 on 06 Jun 2005

Re: multiple database users
Perrin Harkins 14:30 on 06 Jun 2005

Re: multiple database users
Hartmaier Alexander 11:31 on 06 Jun 2005

Re: multiple database users
Hartmaier Alexander 11:51 on 06 Jun 2005

Re: multiple database users
William Ross 13:46 on 06 Jun 2005

Re: multiple database users
Hartmaier Alexander 14:03 on 06 Jun 2005

Re: multiple database users
William Ross 15:30 on 06 Jun 2005

Re: multiple database users
Hartmaier Alexander 16:44 on 06 Jun 2005

Re: multiple database users
William Ross 18:26 on 06 Jun 2005

Re: multiple database users
Jay Strauss 02:53 on 07 Jun 2005

Re: multiple database users
Perrin Harkins 03:58 on 07 Jun 2005

Re: multiple database users
William Ross 10:23 on 07 Jun 2005

Re: multiple database users
Hartmaier Alexander 09:28 on 07 Jun 2005

Re: multiple database users
Perrin Harkins 12:49 on 07 Jun 2005

Re: multiple database users
Hartmaier Alexander 12:49 on 07 Jun 2005

Re: multiple database users
Perrin Harkins 12:54 on 07 Jun 2005

Re: multiple database users
Hartmaier Alexander 13:02 on 07 Jun 2005

Re: multiple database users
Mark Addison 13:47 on 07 Jun 2005