Re: [RDBO] Cascading inserts w/ foreign keys

2006-12-22 Thread Chris Campise
Yep, that was it. I read those docs but some reason it didn't click with what I was doing. Thanks again for the help. On 12/22/06, John Siracusa <[EMAIL PROTECTED]> wrote: On 12/22/06 1:40 PM, Chris Campise wrote: > package My::DB::Parent; ... > relationships => > [ > child => > {

Re: [RDBO] Cascading inserts w/ foreign keys

2006-12-22 Thread John Siracusa
On 12/22/06 1:40 PM, Chris Campise wrote: > package My::DB::Parent; ... > relationships => > [ > child => > { > class => 'My::DB::Child', > column_map => { parent_id => 'parent_id' }, > type => 'one to many', > }, You have that listed as "one to many",

Re: [RDBO] Cascading inserts w/ foreign keys

2006-12-22 Thread Chris Campise
John- Thanks for the response. It's much appreciated. You are correct in that both pks for these two tables are auto_increments, so I went ahead and changed the column types to 'serial' as you suggested. I re-ran my test script, and I'm still getting two rows inserted into the 'child' table wit

Re: [RDBO] Cascading inserts w/ foreign keys

2006-12-22 Thread John Siracusa
On 12/22/06 1:40 PM, Chris Campise wrote: > The way I understood the above to work was that it would insert a new Parent > row and then auto-insert ONE (1) Child row with the child.parent_id foreign > key pointed back to parent.parent_Id. But there are two Child rows being > inserted, and neither

[RDBO] Cascading inserts w/ foreign keys

2006-12-22 Thread Chris Campise
Hi- First time poster. :) I have a simple mysql InnoDB database setup with two tables, Parent and Child. Child contains a foreign key into Parent. It's a pretty trivial setup, but I'm new to Rose::DB::Object and I'd like to be able to insert a new Product and have the Child inserted automatica