Re: [Dbix-class] multiple database connection

2011-10-21 Thread Jorge Gonzalez
You don't specify if they are distinct DBs or you want to have some kind of high availability. If they are distinct DBs I'd say the easiest (canonical?) way would to define two different models, say MyApp::Model::DB1 and MyApp::Model::DB2 and configure each one separately. When you want to ext

Re: [Dbix-class] multiple database connection

2011-10-21 Thread Rippl, Steve
On Fri, Oct 21, 2011 at 7:52 AM, Roland Philibert wrote: > > Hi all, > Could anybody send me an example on how to connect multiple databases > using DBIC::Schema? > > I have: > > package MyApp::Model::DB; > > use strict; > use base 'Catalyst::Model::DBIC::Schema'; > > __PACKAGE__->config( >sch

[Dbix-class] multiple database connection

2011-10-21 Thread Roland Philibert
Hi all, Could anybody send me an example on how to connect multiple databases using DBIC::Schema? I have: package MyApp::Model::DB; use strict; use base 'Catalyst::Model::DBIC::Schema'; __PACKAGE__->config( schema_class => 'MyApp::Schema', connect_info => { dsn => 'dbi:mysq