Re: multiple database users

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

On 6 Jun 2005, at 11:29, Hartmaier Alexander wrote:

> And where can/should I override the default db_Main?
> I have no idea how to do that...

It's just a Class::DBI method. The only confusing thing is that it =20
doesn't exist until Ima::DBI places it into Class::DBI's namespace. =20
You override it in the usual way, by putting a similar method in your =20=

base class.

There's a popular example in Perrin's http://wiki.class-dbi.com/=20
index.cgi?UsingWithModPerl that might help, or you could start with =20
something simple like this (untested and possibly silly):

my $handles =3D {};
my $db_options =3D {
     RaiseError         =3D> 1,
     AutoCommit         =3D> 0,
     FetchHashKeyName   =3D> 'NAME_lc',
     ShowErrorStatement =3D> 1,
     ChopBlanks         =3D> 1,
     RootClass          =3D> 'DBIx::ContextualFetch'
};

sub db_Main {
     my $dbh;
     return $handles->{ $ENV{USER} } ||=3D DBI->connect_cached(
         $dsn, $db_user, $db_pass, $db_options
      );
}

... where $dsn, $db_user and $db_pass come from your config and =20
presumably depend on the user.

with this in place, you can remove the set_db calls from your base =20
class or data classes, as it will be ignored.

will





>
> -Alex
>
>
> -----Urspr=FCngliche Nachricht-----
> Von: William Ross [mailto:will@xxxxxxx.xxx]
> Gesendet: Freitag, 3. Juni 2005 10:43
> An: Hartmaier Alexander
> Cc: cdbi-talk@xxxxxx.xxxxx.xxx
> Betreff: Re: multiple database users
>
> On 2 Jun 2005, at 18:43, Hartmaier Alexander wrote:
>
>
>> Hi list!
>>
>> I just found out that one of my scripts is using the wrong db user
>> to access my database.
>>
>> I created different users with different access rights in oracle I
>> used before CDBI.
>>
>> The connection info is stored in the base class so a different user
>> means a different db connection regardless which parameter is
>> different.
>>
>> This topic was already on the list but for different databases but
>> I think it=92s the same problem
>>
> It is the same problem. If you want cdbi to use a different database
> handle under different circumstances, you need a sub db_Main() in
> your base class (or wherever) that selects the handle according to
> your criteria. That sub needs to return an appropriate
> DBIx::ContextualFetch object, btw, and should be as quick as possible
> as it's called very frequently.
>
>
> will
>