[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

[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() [lajolla.main.tree.TreeNode object at 0x81c82c8c, lajolla.main.tree.TreeNode object at 0x81c8220c] But delete() is not happy: (Pdb)