I'm using Pylons with SQLAlchemy & Elixir.  I need to run three SQL
commands in sequence, but I have to be certain that all three are done
on the same connection.  So something like this in my controller class

from sqlalchemy import text
model.metadata.bind.execute(text("set enable_seqscan=off"))
model.metadata.bind.execute(text("select * from foo where bar
= :bar"), bar=1)
model.metadata.bind.execute(text("set enable_seqscan=on"))

Is there a way for me to be sure that all three of these commands
would occur on the same connection?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"pylons-discuss" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to