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) ],
> >
> > schema => 'b_custom',
> > );
>
> That should do it.
Indeed it did. Thanks for that. I sent you a stripped down test case -
my My::DB looks more like this:
Domain Type Schema
pts main b_main
pts custom b_custom
prod main prod_main
prod custom prod_custom
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 okay - see any problems with that?
> Also, you may want to reconsider doing
> this in every
> class:
>
> > our $DB;
> >
> > sub init_db {
> > $DB ||= My::DB->new;
> > }
>
> When this code appears in every class, it means that all
> objects of a given
> class will share a single connection. That's an odd
> arrangement and perhaps
> not what you're aiming for :)
>
> If you want to share a Rose::DB object among all your
> Rose::DB::Object-derived classes, consider using Rose::DB's
> new_or_cached()
> method.
You were reading too much into my test case ;-). In my "real" project I
have two base classes which all other RDBO's inherit from,
My::DefaultObject and My:DefaultCachedObject, and I define init_db in
those two base classes (DefaultCachedObject actually calls
DefaultObject's db_init). When I initially set it up, I simply had
init_db call My::DB->new. The overhead of creating all those new
connections slowed things down a lot. I got the '$DB ||= My::DB->new;'
snippet from somewhere - maybe the mailing list? Anyways, it improved
execution time on my test script by cutting it in half. Plugging in
new_or_cached into my DefaultObject class works the same, and looks
cleaner, so I'll stick with it - but is there any difference here or is
it just semantics?
Justin
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Rose-db-object mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rose-db-object
