diff options
| author | Erlend E. Aasland <erlend.aasland@protonmail.com> | 2022-09-15 21:11:52 (GMT) |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-09-15 21:11:52 (GMT) |
| commit | 16c33a9676e2f3ef330d09f2ab515c56636fa09f (patch) | |
| tree | d3103d970b2337649b5b7eefa289ae85dfb9b29e /Doc/library | |
| parent | 303bd880475b510481d86a8c48b62d21d0e3bb53 (diff) | |
| download | cpython-16c33a9676e2f3ef330d09f2ab515c56636fa09f.zip cpython-16c33a9676e2f3ef330d09f2ab515c56636fa09f.tar.gz cpython-16c33a9676e2f3ef330d09f2ab515c56636fa09f.tar.bz2 | |
gh-96810: Clarify for which statements sqlite3 implicitly opens transactions (#96832)
Diffstat (limited to 'Doc/library')
| -rw-r--r-- | Doc/library/sqlite3.rst | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/Doc/library/sqlite3.rst b/Doc/library/sqlite3.rst index a99c0b9..e2774a5 100644 --- a/Doc/library/sqlite3.rst +++ b/Doc/library/sqlite3.rst @@ -2274,7 +2274,8 @@ If the connection attribute :attr:`~Connection.isolation_level` is not ``None``, new transactions are implicitly opened before :meth:`~Cursor.execute` and :meth:`~Cursor.executemany` executes -``INSERT``, ``UPDATE``, ``DELETE``, or ``REPLACE`` statements. +``INSERT``, ``UPDATE``, ``DELETE``, or ``REPLACE`` statements; +for other statements, no implicit transaction handling is performed. Use the :meth:`~Connection.commit` and :meth:`~Connection.rollback` methods to respectively commit and roll back pending transactions. You can choose the underlying `SQLite transaction behaviour`_ — |