[Catalyst] connecting to more than one database

jagdish eashwar jagdish.eashwar at gmail.com
Fri Jul 4 09:48:25 BST 2008

Using views doesn't seem to be a workable option. I tried using them, but
then DBIC complained that  they don't have primary keys. So I guess I have
to reconcile myself to putting all the tables in one database.


On Thu, Jul 3, 2008 at 11:09 PM, Bruce J Keeler <bruce at drangle.com> wrote:

> jagdish eashwar wrote:
>> Putting all the tables in one database is a solution. I am afraid,
>> however, that when I create a model using script/MyApp_create.pl for a
>> specific Catalyst application,  I'll get all the tables in the database
>>  into my  DBIC  schema. Is there a way of making MyApp_create.pl pick up
>> only a subset of the tables?
>> jagdish
>> O
> I don't know if mysql has a facility similar to Oracle's synonyms whereby
> you could alias tables from the common schema into the app-specific one. =
> not, it's possible that a simple views might work, something like:
>  create view employee as (select * from common.employee)
> Then just put all of the tables into the same DBIC schema.
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20080704/7aa5f=

More information about the Catalyst mailing list