[sqlalchemy] query().all() OK, query().delete() can't locate bind

2009-09-15 Thread jeff.enderw...@gmail.com
I'm trying to delete in bulk using query(). query() seems to work fine: (Pdb) Session.query(TreeNode).filter(TreeNode.guid.in_ (deadNodeGuids)).all() [, ] But delete() is not happy: (Pdb) Session.query(TreeNode).filter(TreeNode.guid.in_ (deadNodeGuids)).delete() *** UnboundExecutionError: Coul

[sqlalchemy] Re: Keepalives / reconnect

2009-09-19 Thread jeff.enderw...@gmail.com
Thanks for the links. It seems that the proposed soln to the mysql 8hr idle connection time is: a) recycle connections before they can be clipped by mysql, b) extend the mysql timeout interval (aggregating what I've seen in other postings across the 'net). Would it make sense to actually re-try a