Re: Default isolation_level for sqlite3.connect?
David Raymond <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <VI1PR07MB6029BEF0E1F7631C62CD1B0887040@VI1PR07MB6029.eurprd07.prod.outlook.com> |
Incorrect. "Not specifying one" is sqlite3.connect(fi) And the connection will still start implicit transactions for you. (with "begin;") "Setting it to None" is sqlite3.connect(fi, isolation_level = None) Which will turn off all implicit transactions, put it in autocommit mode, and you have to do all transaction management yourself. -----Original Message----- From: sqlite-users <[email protected]> On Behalf Of Peng Yu Sent: Thursday, January 30, 2020 11:29 AM To: SQLite mailing list <[email protected]> Subject: Re: [sqlite] Default isolation_level for sqlite3.connect? > and if you don't specify one it issues a plain "begin;" So that is basically isolation_level = None? Thanks. -- Regards, Peng _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users