Re: "Dynamic" database handles?

[prev] [thread] [next] [Date index for 2005/01/23]

On Sat, Jan 22, 2005 at 06:44:30PM -0500, Daniel Collis Puro wrote:
> I'm looking to use Class::DBI in an application where the DB connection
> info is passed in at run time. I'm building a generic e-commerce system
> around CGI::Application, HTML::Template and a few of my other favorite
> modules.
> 
> The idea is I'd set up the relationships between tables in separate
> classes via Class::DBI and then use the CDBI classes in my
> CGI::Application modules along with Class::DBI::AsForm.
> 
> I must be dense, because I can't figure out a clean way to pass a DBI
> handle or DSN info at run time, and I want this system to be generic
> enough to completely avoid hard-coding database connections.
> 
> What am I missing? This is all meant to run under mod_perl, so please
> keep this in mind.

I'm doing the same sort of thing at the moment; contact me off-list if you're
interested in a technology share.

Meantime, try overriding the db_Main method like so -

package CDBI::BaseClass;

#__PACKAGE__->connection(...) Don't need this now

sub db_Main {
  return DBI->connect_cached(...); # Insert runtime DSN selection here
}

        -- 
            Matt S Trout            Brag sheet:    http://trout.me.uk/services.html
LAMP, Infrastructure        Contact:       services@xxxxx.xx.xx
   and Automation
     specialist                                       Do it once. Do it right.