Thread: [SQLObject] Same-Table Parent Relationship with a Foreign Key?
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Jamieson B. <jam...@ja...> - 2005-03-15 02:19:55
|
Say you have a SQL Object table like this: Geneology id (implicit) name parent_id Should parent_id be manually set to that record's id? Or should a foreign key relationship exist? I'm using MySQL without true foreign key support (3.23); foreign keys are accepted but essentially ignored. Does SQL Object enforce that behavior? Do cascade deletes occur? Say you want to delete an entire family tree from your database. If I deleted one of the parent ID's, would all the children automatically be deleted? What's the best way to normally do this? Thanks in advance! Jamie |
From: Jamieson B. <jam...@ja...> - 2005-03-15 13:09:31
|
Found the answer: http://sourceforge.net/mailarchive/forum.php?thread_id=6718542&forum_id=30269 Jamieson Becker wrote: > Say you have a SQL Object table like this: > > Geneology > id (implicit) > name > parent_id > > Should parent_id be manually set to that record's id? Or should a > foreign key relationship exist? I'm using MySQL without true foreign > key support (3.23); foreign keys are accepted but essentially ignored. > Does SQL Object enforce that behavior? Do cascade deletes occur? > > Say you want to delete an entire family tree from your database. If I > deleted one of the parent ID's, would all the children automatically > be deleted? > > What's the best way to normally do this? > > Thanks in advance! > > Jamie > |