[Catalyst] One App, multiple databases

2008-11-19 Thread Jose Luis Martinez
Hello, This question has been asked a couple of times on the list, and I have found yet another solution to it, but I would like to hear if maybe I'm doing something wrong, or I will suffer serious pain by doing it my way :) We have an app that will connect to one database or another dependin

[Catalyst] Re: One App, multiple databases

2008-11-19 Thread kevin montuori
> "JLM" == Jose Luis Martinez <[EMAIL PROTECTED]> writes: JLM> We have an app that will connect to one database or another JLM> depending on the logged in user. i'm wondering why you wouldn't have two models with different connection information but that use the same schema? i might be mis

RE: [Catalyst] One App, multiple databases

2008-11-19 Thread Mesdaq, Ali
Are these db's exact copies as far as schema from each other? Or is it different tables and structure as well? Reason I am asking is because if its exactly the same and all your queries work the same and your logic works the same as well and the only difference is if user1 is connected then co

[Catalyst] need to patch Test::WWW::Mechanize::Catalyst

2008-11-19 Thread Jason Gottshall
My recent patch to 5.80 trunk (svn rev 8612) enables the setting of a default virtual hostname via import: use Catalyst::Test 'MyApp', { default_host => 'virtual.com' }; Based on my reading of the Test::WWW::Mech::Catalyst source, some minor changes would need to be made there in order to use

Re: [Catalyst] need to patch Test::WWW::Mechanize::Catalyst

2008-11-19 Thread Ash Berlin
On 19 Nov 2008, at 20:21, Jason Gottshall wrote: My recent patch to 5.80 trunk (svn rev 8612) enables the setting of a default virtual hostname via import: use Catalyst::Test 'MyApp', { default_host => 'virtual.com' }; Based on my reading of the Test::WWW::Mech::Catalyst source, some minor

Re: [Catalyst] need to patch Test::WWW::Mechanize::Catalyst

2008-11-19 Thread Jason Gottshall
Ash Berlin wrote: On 19 Nov 2008, at 20:21, Jason Gottshall wrote: My recent patch to 5.80 trunk (svn rev 8612) enables the setting of a default virtual hostname via import: use Catalyst::Test 'MyApp', { default_host => 'virtual.com' }; Based on my reading of the Test::WWW::Mech::Catalyst s

Re: [Catalyst] Re: One App, multiple databases

2008-11-19 Thread Jose Luis Martinez
kevin montuori escribió: i'm wondering why you wouldn't have two models with different connection information but that use the same schema? Because I wouldn't want application code touched for every user created or deleted... Every user will have a new db, and user creation should be automa

Re: [Catalyst] One App, multiple databases

2008-11-19 Thread Jose Luis Martinez
Mesdaq, Ali escribió: Are these db's exact copies as far as schema from each other? Or is it different tables and structure as well? Reason I am asking is because if its exactly the same and all your queries work the same and your logic works the same as well and the only difference is if use

Re: [Catalyst] One App, multiple databases

2008-11-19 Thread Chris Carline
On Wed, Nov 19, 2008 at 10:53 PM, Jose Luis Martinez <[EMAIL PROTECTED]> wrote: > Basically we giving multi-tentant capability to our app (which was ported > from some old CGIs). The CGIs where setup to load config files based on the > REMOTE_USER, so we gave each user a separate DB just by changin