Re: [sqlite] What is the default value of isolation_level?

2019-10-25 Thread Keith Medcalf
On Friday, 25 October, 2019 13:49, Peng Yu wrote: >isolation_level is an empty string by default as shown below. But the >python manual does not say that it can take an empty string. What does >an empty string mean? Is it equivalent to None? Thanks. No. It means use the default. And sqlite3

Re: [sqlite] What is the default value of isolation_level?

2019-10-25 Thread Peng Yu
t; > > -Original Message- > From: sqlite-users On Behalf > Of Peng Yu > Sent: Friday, October 25, 2019 3:49 PM > To: SQLite mailing list > Subject: [sqlite] What is the default value of isolation_level? > > Hi, > > isolation_level is an empty string by default as s

Re: [sqlite] What is the default value of isolation_level?

2019-10-25 Thread David Raymond
ge- From: sqlite-users On Behalf Of Peng Yu Sent: Friday, October 25, 2019 3:49 PM To: SQLite mailing list Subject: [sqlite] What is the default value of isolation_level? Hi, isolation_level is an empty string by default as shown below. But the python manual does not say that it can take an emp

[sqlite] What is the default value of isolation_level?

2019-10-25 Thread Peng Yu
Hi, isolation_level is an empty string by default as shown below. But the python manual does not say that it can take an empty string. What does an empty string mean? Is it equivalent to None? Thanks. https://docs.python.org/3/library/sqlite3.html#connection-objects """ isolation_level Get

Re: [sqlite] What is the default value of isolation_level?

2019-10-25 Thread Keith Medcalf
On Friday, 25 October, 2019 14:02, Peng Yu wrote: >So basically an empty string in isolation_level is the same as >"DEFERRED"? This is confusing. I think it should have been implemented >so that the value of the isolation_level attribute is DEFERRED when it >is not specified in .connect(). But

Re: [sqlite] What is the default value of isolation_level?

2019-10-25 Thread Peng Yu
> 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

Re: [sqlite] What is the default value of isolation_level?

2019-10-25 Thread David Raymond
eases without that keyword" -Original Message- From: sqlite-users On Behalf Of Peng Yu Sent: Friday, October 25, 2019 4:02 PM To: SQLite mailing list Subject: Re: [sqlite] What is the default value of isolation_level? So basically an empty string in isolation_level is the same as