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 -- 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 08:59 >To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> >Subject: [sqlite] Default isolation_level for sqlite3.connect? > >Hi, > >I don't see what is the default isolation_level here. Is it None? Thanks. > >https://docs.python.org/3/library/sqlite3.html#module-functions-and- >constants >sqlite3.connect(database[, timeout, detect_types, isolation_level, >check_same_thread, factory, cached_statements, uri])ΒΆ > >-- >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