Re: [Dbix-class] Cascade deletes

2010-03-06 Thread Peter Rabbitson
Bill Moseley wrote: > > > On Sat, Mar 6, 2010 at 3:59 AM, Peter Rabbitson > wrote: > > > I notice that DBIC does a select to find the related rows (i.e. in the > > Cd table when looking for rows to cascade delete). Is there a reason > > that's done

Re: [Dbix-class] Cascade deletes

2010-03-06 Thread Bill Moseley
On Sat, Mar 6, 2010 at 3:59 AM, Peter Rabbitson > wrote: > > I notice that DBIC does a select to find the related rows (i.e. in the > > Cd table when looking for rows to cascade delete). Is there a reason > > that's done instead of just deleting directly? > > > > INSERT INTO artist ( label, nam

Re: [Dbix-class] Cascade deletes

2010-03-06 Thread Moritz Onken
> >> I notice that DBIC does a select to find the related rows (i.e. in the >> Cd table when looking for rows to cascade delete). Is there a reason >> that's done instead of just deleting directly? >> >> INSERT INTO artist ( label, name) VALUES ( ?, ? ): '1', 'test aritst' >> INSERT INTO cd ( a

Re: [Dbix-class] Cascade deletes

2010-03-06 Thread Peter Rabbitson
Bill Moseley wrote: > First, is there a way to globally disable cascade deletes? I know I can > add cascade_delete => 0 to the relationships, but I never want cascade > deletes in the ORM (I have a database that does that). > > Second, > > Say I have my music db and an error in a relationship na

Re: [Dbix-class] Cascade deletes

2010-03-06 Thread Pedro Melo
Hi, On Sat, Mar 6, 2010 at 1:07 AM, Bill Moseley wrote: > First, is there a way to globally disable cascade deletes?  I know I can > add cascade_delete => 0 to the relationships, but I never want cascade > deletes in the ORM (I have a database that does that). I did that once for exactly the sam