Re: [RDBO] small bug in use_key

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

[RDBO] Short cut for setting map records data

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] Short cut for setting map records data

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] Short cut for setting map records data

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

[RDBO] cascading Manager queries

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, @_ ], ); } sub

Re: [RDBO] cascading Manager queries

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

[RDBO] ANNOUNCE: Rose::Object 0.84 released

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 with

[RDBO] Nested many-to-many

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

Re: [RDBO] Nested many-to-many

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

[RDBO] Problem with a Speculative Load

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 =

Re: [RDBO] Problem with a Speculative Load

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