8000 [3.11] gh-96810: Clarify for which statements sqlite3 implicitly opens transactions (GH-96832) by miss-islington · Pull Request #96854 · python/cpython · GitHub
[go: up one dir, main page]
Skip to content

[3.11] gh-96810: Clarify for which statements sqlite3 implicitly opens transactions (GH-96832) #96854

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 1 commit into from
Sep 15, 2022
Merged

[3.11] gh-96810: Clarify for which statements sqlite3 implicitly opens transactions (GH-96832) #96854

Changes from all commits
Commits
Show all changes
1 commit
Select commit
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
gh-96810: Clarify for which statements sqlite3 implicitly opens trans… 
…actions (GH-96832)

(cherry picked from commit 16c33a9)

Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
  • Loading branch information
@erlend-aasland @miss-islington
erlend-aasland authored and miss-islington committed Sep 15, 2022
commit 8031cd3d111afe9524fa0a89c3e435d21130975d
3 changes: 2 additions & 1 deletion Doc/library/sqlite3.rst
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -2236,7 +2236,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`_ —
Expand Down
0