Python sqlite transactions

Question

How do I use sqlite transactions in python?

The following code raises the exception OperationalError: cannot commit - no transaction is active on the cur.execute('COMMIT') line:

import sqlite3
con = sqlite3.connect(':memory:')
cur = con.cursor()
cur.execute('CREATE TABLE test(p)')
cur.execute('BEGIN')
cur.execute('INSERT INTO test(p) values (?)', (1,))
cur.execute('COMMIT')

I've played around with isolation_level but none of the values gets rid of the exception.

Answers to this question might help you: http://stackoverflow.com/questions/15856976/transactions-with-python-sqlite3 — mechanical_meat, Sep 05 '14 at 20:18
https://docs.python.org/2/library/sqlite3.html#controlling-transactions — Mazdak, Sep 05 '14 at 20:19

Robᵩ · Accepted Answer · 2014-09-05T20:42:05.350

1

Try turning on autocommit mode:

con.isolation_level = None

References:

edited Sep 05 '14 at 20:42

answered Sep 05 '14 at 20:23

Robᵩ

163,533
20
239
308

Tried all the other values forgot to try out `None` :( – simonzack Sep 05 '14 at 20:24
Doesn't autocommit mode mean that each `execute` is wrapped in a transaction? – simonzack Sep 05 '14 at 20:25
No. It means that each execute is wrapped in a transaction, **unless** there is a transaction pending. "*Autocommit mode is disabled by a BEGIN statement. Autocommit mode is re-enabled by a COMMIT or ROLLBACK.*" -- http://www.sqlite.org/c3ref/get_autocommit.html – Robᵩ Sep 05 '14 at 20:27

Python sqlite transactions

1 Answers1