TRUNCATE sql statement

[RVince]

I am trying to issue a straight SQL TRUNCATE table command:

engine = engine_from_config(config, 'sqlalchemy.')
connection = engine.connect()
connection.execute('truncate table cms_history;')

Everything runs fine without error -- but the table does not truncate
-- nothing is affected. Am I missing something obviouis to others in
trying to do this? Thanks, RVince

[RVince]

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()

[Michael Bayer]

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

> --
> You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
> To post to this group, send email to sqlal...@googlegroups.com.
> To unsubscribe from this group, send email to sqlalchemy+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
>