On 19 Aug 2009, at 18:32, Mike Conley wrote:
> The delete method of query supports bulk deletes. > In your case it might be something like > > session.query(Users).filter(User.officeid==office.id).delete() > > Any query can be used; there are probably more elegant ways to take > advantage of the relation 'users' also. > > Make sure you read the documentation for Query.delete() to > understand the impact of the 'synchronize_session' keyword Thanks for the tip - I wasn't aware of query's delete method. Still, it strikes me as a bit inefficient to look up objects that I already have at hand. (Even if the engine has to look them up due to lazy loading, *I* have them at hand.) Ah well. Demitri --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@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 -~----------~----~----~----~------~----~------~--~---