The default is an empty string (ie, ''). It can take the value None, '', 'DEFERRED', 'IMMEDIATE', 'EXCLUSIVE' and the value (if not None) is appended to the BEGIN when a magical transaction is started, and if None, then you are indicating that you will be using manual transaction control
isolation_level command None None '' (default) BEGIN 'DEFERRED' BEGIN DEFERRED 'IMMEDIATE' BEGIN IMMEDIATE 'EXCLUSIVE' BEGIN EXCLUSIVE You can set the isolation_level in the connect call (the default is '') or read/change it with the .isolation_level property of a connection object. >>> import sqlite3 >>> db = sqlite3.connect(':memory:') >>> db.isolation_level '' >>> db.isolation_level = None >>> db.isolation_level >>> >>> db = sqlite3.connect(':memory:', isolation_level=None) >>> db.isolation_level >>> -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On >Behalf Of Peng Yu >Sent: Thursday, 30 January, 2020 09:55 >To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> >Subject: Re: [sqlite] Default isolation_level for sqlite3.connect? > >On 1/30/20, Keith Medcalf <kmedc...@dessus.com> wrote: >> >> The isolation_level specifies the default suffix to put after 'BEGIN' >when >> beginning a transaction. Inside the library the following is used when >the >> magic wants to start a transaction: >> >> if isolation_level is not None: >> .execute('BEGIN %s' % isolation_level) >> >> This is so that you can set isolation_level to 'IMMEDIATE' so that all >> magically initiated transactions are BEGIN IMMEDIATE rather than the >default >> BEGIN DEFERRED > >Are you saying the default isolation_level is equivalent to IMMEDIATE? >Or you are not answering my specific question of what is the default >of isolation_level? I think the default paremeter value of >isolation_level of the function sqlite3.connect() is just None. It is >not the case? > >-- >Regards, >Peng >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users