Re: [SQLObject] how to select objects with foreign keys that point to non existing rows?

sophana Tue, 31 Oct 2006 04:43:40 -0800

Oleg Broytmann a écrit :

On Tue, Oct 31, 2006 at 11:48:26AM +0100, sophana wrote:

The question is in the subject. Sorry if it is a newbie question...
When destroying objects, I forgot to clear all pointers to it.
How can I select them?


to_delete = []
for row in connection.queryAll("SELECT id FROM my_table"):
   id = row[0]
   try:
      MyTable.get(id)
   except:
      to_delete.append(id)


Oleg.

Thanks,
Is there no way of selecting that without doing a python iteration?
In my case, it is object A which has a foreignKey to object B
And I delete some B instances.

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Re: [SQLObject] how to select objects with foreign keys that point to non existing rows?

Reply via email to