> if the isolation_level is None then no extra command is issued. > if the isolation_level is '' then the command BEGIN TRANSACTION; is issued > if the isolation_level is 'DEFERRED' then the command BEGIN DEFERRED > TRANSACTION; is issued > if the isolation_level is 'IMMEDIATE' then the command BEGIN IMMEDIATE > TRANSACTION; is issued > if the isolation_level is 'EXCLUSIVE' then the command BEGIN EXCLUSIVE > TRANSACTION; is issued
I got it. So it is basically from here https://www.sqlite.org/lang_transaction.html "Transactions can be DEFERRED, IMMEDIATE, or EXCLUSIVE. The default transaction behavior is DEFERRED." I still think that python sqlite3 module is better to be implemented to hide this level of detail. Otherwise, users in python will need to know "" is the same as DEFERRED at the raw SQLITE3 level. This information is totally unnecessary burden to a python user. -- Regards, Peng _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users