Re: [RDBO] Problem with a Speculative Load

2007-05-17 Thread Jeffrey Horn
Never mind. It was a bug in my override of the load() method within Bill::DB::Object::Acct (didn't shift from @_ before calling $self->SUPER::load(@_). My bad! Many apologies! -- Jeff Horn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey Horn S

[RDBO] Problem with a Speculative Load

2007-05-17 Thread Jeffrey Horn
I have a table that has a unique key on (encrypt_ver_num, e_acct_num, pay_type_id) and a primary key of (acct_id). The following code: #!/usr/bin/perl use Bill::DB::Object::Acct; use Data::Dumper; my $acct = Bill::DB::Object::Acct->new( pay_type_id => 1, e_acct_num => 'c8923a1e7de803ac73372d64

Re: [RDBO] Nested many-to-many

2007-05-17 Thread John Siracusa
Can you also post the table definitions? (Simplified, if necessary.) On 5/17/07 5:19 PM, Wiggins d'Anconia wrote: > 'company_branches' stores a one-to-many of companies to their branches. > 'user_company_map' stores what I thought would originally be a many-to-many > between the users and the comp

[RDBO] Nested many-to-many

2007-05-17 Thread Wiggins d'Anconia
Based on my reading of the mailing list archives I have gathered that what I initially was attempting is just not possible, that is to have a many-to-many map_record be used as half of another many-to-many (if I am wrong about that reading please correct). I can live with that, as long as I can

[RDBO] ANNOUNCE: Rose::Object 0.84 released

2007-05-17 Thread John Siracusa
Yes, Rose::Object. It had a bug that prevented Rose::DB::Object's new "helpers" setup() parameter from working. Rose::DB::Object 0.765 will require Rose::Object 0.84 or later once it's released, but you should upgrade to Rose::Object 0.84 right now if you want the "helpers" setup param to work wi

Re: [RDBO] cascading Manager queries

2007-05-17 Thread Jonathan Vanasco
On May 17, 2007, at 3:12 PM, Michael Reece wrote: > here is a bit of ugliness that hints at what i am after: I think i do some similar stuff, so I'll give my advice -- which you may be better off to not take ;) I never use 'make manager methods'. i started it as a memory saver because i us

Re: [RDBO] cascading Manager queries

2007-05-17 Thread John Siracusa
On 5/17/07, Michael Reece <[EMAIL PROTECTED]> wrote: > my $count = $collection->count_assets_published( > [ \'t2.pubdate >= NOW() - INTERVAL ? DAY' => $num_days ] # > ); > > i can't refer to 'asset.pubdate' in this query param, because RDBOM > insists i use a scalar-ref here, and

[RDBO] cascading Manager queries

2007-05-17 Thread Michael Reece
in Collection.pm, i have sub count_assets { my $self = shift; return CollectionAsset::Manager->get_collection_assets_count( require_objects => ['asset'], query => [ collection_id => $self- >collection_id, @_ ], ); } s

Re: [RDBO] Short cut for setting map records data

2007-05-17 Thread John Siracusa
On 5/17/07, Derek Watson <[EMAIL PROTECTED]> wrote: > I have gone down a similar path before, > > http://www.mail-archive.com/rose-db-object@lists.sourceforge.net/msg01792.html Yeah, I was about to post that link. Thanks :) > When you need to manipulate the map records themselves, setup an > add

Re: [RDBO] Short cut for setting map records data

2007-05-17 Thread Derek Watson
I have gone down a similar path before, http://www.mail-archive.com/rose-db-object@lists.sourceforge.net/msg01792.html The short story is that a map_record is not designed to be manipulated, it's only there for convenience when fetching related objects from a many-to-many relationship call, such

Re: [RDBO] feature request: not not_found (found?)

2007-05-17 Thread Jonathan Vanasco
On Oct 24, 2006, at 12:26 AM, John Siracusa wrote: >> b) i have it doing that already. it's just weird having a double >> negative... it seems odd that found isn't in there already > > The success case is clear: you get a true return value back from > load(). > When there's a failure, dependin

[RDBO] Short cut for setting map records data

2007-05-17 Thread Wiggins d'Anconia
I'm fairly new to the "with_map_records" manager arg, and possibly this is already available but I couldn't find documentation or an easy way to achieve it. Is it possible to set fields of the mapping table during an "add" operation. For example: $company->add_users( { username => 'bob'

Re: [RDBO] small bug in use_key

2007-05-17 Thread John Siracusa
On 5/17/07, Jonathan Vanasco <[EMAIL PROTECTED]> wrote: > if you use_key on the primary key, rose doesn't do anything. Fixed in SVN. Thanks for the report. -John - This SF.net email is sponsored by DB2 Express Download DB2