Re: [RDBO] Cross Schema Relationships

2008-01-03 Thread John Siracusa
On 1/3/08 11:14 AM, John Siracusa wrote: >> Because my schema name can change based upon domain and type (and I want >> to keep everything in My::DB), I did the following in my Inventory >> class: >> schema => My::DB->new_or_cached(type => 'custom')->schema, >> >> It works, and seems to be ok

Re: [RDBO] Cross Schema Relationships

2008-01-03 Thread John Siracusa
On Jan 3, 2008 10:41 AM, Justin Ellison <[EMAIL PROTECTED]> wrote: > Thanks for the reply John - see inline: >> but then override the schema in the inventory class: >> >>> package My::Inventory; >>> >>> use base qw(Rose::DB::Object); >>> >>> __PACKAGE__->meta->setup( >>> table => 'invento

Re: [RDBO] Cross Schema Relationships

2008-01-03 Thread Justin Ellison
Thanks for the reply John - see inline: > but then override the schema in the inventory class: > > > package My::Inventory; > > > > use base qw(Rose::DB::Object); > > > > __PACKAGE__->meta->setup( > > table => 'inventory', > > ... > > primary_key_columns => [ qw(sku_code) ],