sqlite savepoint problem [solved]
Laszlo Nagy
gandalf at shopzeus.com
Fri Mar 12 05:12:39 EST 2010
>> #1. By using isolation_level = None, connection objects (used as a
>> context manager) WON'T automatically commit or rollback transactions.
>> #2. Using any isolation level, connection objects WON'T automatically
>> begin a transaction.
>> #3. Possibly, include your connection manager class code, to show how to
>> do it "the expected" way.
>>
>> Also one should clarify in the documentation, what isolation_level does.
>> Looks like setting isolation_level to None is not really an "auto commit
>> mode". It is not even part of sqlite itself. It is part of the python
>> extension.
>>
>
> I think of it as almost the opposite - you have to set
> isolation_level=None to get the unadulterated behaviour of the
> underlying sqlite library.
>
> I'm sure the devs would appreciate a documentation patch (submission
> details at http://python.org/dev/patches/). I'm also pretty confident
> that I won't have time to do one up anytime soon :-)
>
Patch submitted.
http://bugs.python.org/issue8145
More information about the Python-list
mailing list