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) Session.query(TreeNode).filter(TreeNode.guid.in_
(deadNodeGuids)).delete()
*** UnboundExecutionError: Could not locate a bind configured on SQL
expression or this Session
I'm using 0.55, 'binds' (more than one engine), and scoped_session.
Any idea why the binds would 'stick' for the read query but not the
delete? Here's the binds:
Session.configure(binds={User:engineAccounts, TreeRoot:engineTrees,
TreeNode:engineTrees, Content:engineTrees})
TIA,
Jeff
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
