OK, that’s good, but it does mean that your construct isn’t doing the
“autocommit” part correctly, because engine.execute(..) should work.The
docs for doing that are at:
http://docs.sqlalchemy.org/en/rel_0_9/core/compiler.html#enabling-autocommit-on-a-construct.
Mike Richards
The suggested change from
engine.execute(create_view_command)
to
with engine.begin() as connection:
connection.execute(create_view_command)
works. Thank you much, and have a nice day Michael!
On Tuesday, February 10, 2015 at 4:47:37 PM UTC-8, Michael Bayer wrote:
Mike Richards
When attempting to create a SQL Server view the method located on
StackOverflow
http://stackoverflow.com/questions/9766940/how-to-create-an-sql-view-with-sqlalchemy
does not work. Am I missing something?
I've tried enabling autocommit in _execution_options to no avail. Beyond
that I'm unsure what
Mike Richards justanotherb...@gmail.com wrote:
When attempting to create a SQL Server view the method located on
StackOverflow does not work. Am I missing something?
I've tried enabling autocommit in _execution_options to no avail. Beyond that
I'm unsure what to try next.
Thank you