not to answer every question today, but we also added an "autocommit" flag for
this kind of thing:
connection.execution_options(autocommit=True).execute("statement that normally
isn't autocommit")
some background:
http://www.sqlalchemy.org/docs/core/connections.html#understanding-autocommit
On Jun 2, 2011, at 3:16 PM, RVince wrote:
> I found the answer. I needs to be wrapped in a transaction, like this:
>
> engine = engine_from_config(config, 'sqlalchemy.')
> connection = engine.connect()
> trans = connection.begin()
> try:
> connection.execute('truncate table cms_history;')
> trans.commit()
> except :
> trans.rollback()
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" 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/sqlalchemy?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en.
