Re: [RDBO] Loader failure on MySQL foreign key

On Feb 1, 2008 3:32 PM, John Siracusa <[EMAIL PROTECTED]> wrote: > This should be fixed in SVN now. It was actually a method-maker bug, > not a Loader bug. The Loader just happened to trigger it. Try it and > let me know. I'll probably send this fix out as 0.7663 if it works > for you. That di

[RDBO] Loader failure on MySQL foreign key

I was just tinkering with the loader, and might have found a bug. Create two tables: -- -- Table structure for table `attribute_types` -- CREATE TABLE IF NOT EXISTS `attribute_types` ( `id` bigint(20) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL, `table_name` varchar(255)

Re: [RDBO] redundant rows from queries with multiple one to manyrelationships

I think you're looking for this: http://search.cpan.org/~jsiracusa/Rose-DB-Object-0.7662/lib/Rose/DB/Obje ct/Manager.pm#with_objects The message pertains to the JOIN's being created. You won't get duplicate rows, but you'll get duplicate data within the related rows. If you're okay with it, set

[RDBO] Anyone done more advanced caching with rdbo?

Hi list, First, let me apologize for sending my last email to the list - I should have checked the reply-to. Anyways, I'm in the process of writing a My::DB::CHIObject that mimics and replaces RDBO::Cached and uses the CHI CPAN module. I've got it about 85% done, working with the FastMmap driver

Re: [RDBO] ANNOUNCE: Rose::DB::Object 0.7661 released

John, Not really a bug, but aren't you now burning extra CPU cycles on line 166 of RDBO::Cached? As far as I can tell, removing the line doesn't change the logic any. Picking nits, but in cache operations, every last optimization counts. Justin On Tue, 2008-01-29 at 10:53 -0500, John Siracusa

[RDBO] Proper usage of query_args?

Ever look at something so long your eyes bleed? I have a SKU object, with a relationship to object_attribute, like so: relationships => [ object_attributes => { type => 'one to many', class => 'My::DB::ObjectAttribute', manager_args =

Re: [RDBO] Cross Schema Relationships

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) ],

[RDBO] Cross Schema Relationships

Hi all, I'm very much a newb to Rose::DB::Object, but I gotta admit it's pretty cool stuff. I'm writing a perl API into an already existing schema that our company uses Java to interface with. So far, RDBO has made a huge undertaking much easier. I've hit my first snag though: We have SKU's, a

Re: [RDBO] Lazy Loading and Oracle?

> Can you post a self-contained example script that reproduces the > problem? No, it works fine when I try to put it in a self-contained script ;-) Must be something I'm doing wrong in my subclasses. My bad, sorry for the noise! Justin

[RDBO] Lazy Loading and Oracle?

Hi all, I was wondering if load_on_demand and Oracle was working on .765? I'm a newb of 24 hours, but I like what I see thus far! I'm just doing some testing, and I can't seem to get lazy loading to work with our Oracle db. My test script works fine up until I change one blob column to use 'laz