On Jan 4, 2011, at 8:58 AM, Will wrote: > Hello, > > I noticed that when setting passive_deletes="all" on a relationship > and try to delete the parent object sqlalchemy still tries to query > the child object. For the way my models are set up I can't have the > child object be queried. I'm using a hybrid of horizontal and > vertical sharding in this relationship and sometimes the corresponding > table does not exist so it cannot be queried. > > I have a patch that seems to fix the problem but I don't understand > sqlalchemy enough to know if this is the proper fix or if it should be > done somewhere else. > > http://pastebin.com/wd2Dsdwu > > This particular problem does not occur with passive_deletes=True but > other problems occur because I don't want existing objects to have any > fields nullified either if they are loaded in sqlalchemy. > > I narrowed down the reason why this occurs to orm/attributes on line > 383 but that doesn't seem to be the appropriate place for the fix.
Thanks for the tip, this is ticket 2013 and is fixed for 0.7/0.6. The fix is a generalized version of yours so you were right on it. > > Thanks for any input. > > -Will > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.