Re: DB relations and delete question

2008-07-03 Thread Russell Keith-Magee
On Fri, Jul 4, 2008 at 12:08 AM, Jad <[EMAIL PROTECTED]> wrote: > > Lets say we have Accounts that is referenced profile, group, interest > tables. > > If I delete the account ID 1 would the related data to that account in > profile, group and interest table be deleted in all cases of relation? >

Re: DB relations and delete question

2008-07-03 Thread Jad
I'm not asking about certain DB engine but how django would behave in presence of foriegn key? II will give an exampel of what arised this concern. http://www.djangoproject.com/documentation/db-api/ One-to-many relationships Forward If a model has a ForeignKey, instances of that model will

Re: DB relations and delete question

2008-07-03 Thread bbeaudreault
Wouldn't it depend on the type of DB? (mysql, postgresql,etc)? Or is this something enforced in django regardless of db? On Jul 3, 1:28 pm, Randy Barlow <[EMAIL PROTECTED]> wrote: > Jad wrote: > > Lets say we have Accounts that is referenced profile, group, interest > > tables. > > > If I delete

Re: DB relations and delete question

2008-07-03 Thread Randy Barlow
Jad wrote: > Lets say we have Accounts that is referenced profile, group, interest > tables. > > If I delete the account ID 1 would the related data to that account in > profile, group and interest table be deleted in all cases of relation? > One to one, one to many, many to many? same question

DB relations and delete question

2008-07-03 Thread Jad
Lets say we have Accounts that is referenced profile, group, interest tables. If I delete the account ID 1 would the related data to that account in profile, group and interest table be deleted in all cases of relation? One to one, one to many, many to many? same question applies to update