cgi-session-user

[Cgi-session-user] Use an existing db handle?

[Brett S. <swi...@sw...>]

Is there way to pass CGI::Session an existing DB handle for use, rather
than a dsn and options?

I've got a module that centralizes all the dsn info, and spits out the
handle, but the docs don't make it look like I can use it with
CGI::Session.

-- 
SwiftOne  /  Brett Sanger
swi...@sw...   

Re: [Cgi-session-user] Use an existing db handle?

[Cees H. <ce...@gm...>]

On 11/21/05, Brett Sanger <swi...@sw...> wrote:
> Is there way to pass CGI::Session an existing DB handle for use, rather
> than a dsn and options?
>
> I've got a module that centralizes all the dsn info, and spits out the
> handle, but the docs don't make it look like I can use it with
> CGI::Session.

From the postgres driver docs:

$session =3D new CGI::Session("driver:PostgreSQL", undef,
        {Handle=3D>$dbh, TableName=3D>'my_sessions'});


So just pass a 'Handle' option with your database handle and it will use th=
at.

Cheers,

Cees

Re: [Cgi-session-user] Use an existing db handle?

[Mark S. <ma...@su...>]

On Mon, Nov 21, 2005 at 05:22:52PM -0500, Cees Hek wrote:
> On 11/21/05, Brett Sanger <swi...@sw...> wrote:
> > Is there way to pass CGI::Session an existing DB handle for use, rather
> > than a dsn and options?
> >
> > I've got a module that centralizes all the dsn info, and spits out the
> > handle, but the docs don't make it look like I can use it with
> > CGI::Session.
> 
> From the postgres driver docs:
> 
> $session = new CGI::Session("driver:PostgreSQL", undef,
>         {Handle=>$dbh, TableName=>'my_sessions'});

In the subversion repo for CGI::Session, I've added support for
lazy-loading the handle:

 $session = new CGI::Session("driver:PostgreSQL", undef,
         {Handle=> sub{$dbh}, TableName=>'my_sessions'});
                   ^^^^^^^^

This could improve the laziness if you are using this in conjunction 
with the CGI::Application DBH and Session and plugins, which lazy load
themselves.

The change allows the database handle to only be created if the session
is actually used. 

    Mark