Hi,
I'm trying to run low-level commands like DROP DATABASE / CREATE DATABASE,
with psycopg2.
In 1.3 I used the following:
with
pg_engine.connect().execution_options(isolation_level="AUTOCOMMIT",autocommit=True)
as conn:
conn.execute(command)
Now in 2.0 I run into many errors. I've read the migration guide and for me
this looks like the best:
with pg_engine.connect().execution_options(isolation_level="AUTOCOMMIT") as
conn:
conn.exec_driver_sql(command)
Is this the right one? I'm confused as isolation_level is not written in
the migration guide, I just had it from 1.3. But without isolation_level it
doesn't work.
Also, what is the difference between exec_driver_sql and execute + text()?
Zsolt
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/d0f06e70-f341-475e-8176-8bf0ac46ff94n%40googlegroups.com.
