[Catalyst] connecting to more than one database
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?
> 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:
> Dev site: http://dev.catalyst.perl.org/
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Catalyst