Jun 19, 2022 · Jun 16, 2022 · Jun 16, 2022 · Jun 16, 2022 · Jun 16, 2022 · Jun 16, 2022
diff --git a/Doc/library/sqlite3.rst b/Doc/library/sqlite3.rst
 .. literalinclude:: ../includes/sqlite3/rowclass.py


 .. _sqlite3-connection-context-manager:

 Using the connection as a context manager
 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

 Connection objects can be used as context managers
 that automatically commit or rollback transactions.  In the event of an
 exception, the transaction is rolled back; otherwise, the transaction is
 committed:
 A :class:`Connection` object can be used as a context manager that
 automatically commits or rolls back open transactions when leaving the body of
 the context manager.
 If the body of the :keyword:`with` statement finishes without exceptions,
 the transaction is committed.
 If this commit fails,
 or if the body of the ``with`` statement raises an uncaught exception,
 the transaction is rolled back.

 If there is no open transaction upon leaving the body of the ``with`` statement,
 the context manager is a no-op.

 .. note::

   The context manager neither implicitly opens a new transaction
   nor closes the connection.

 .. literalinclude:: ../includes/sqlite3/ctx_manager.py

diff --git a/Misc/NEWS.d/next/Documentation/2022-06-16-10-10-59.gh-issue-61162.1ypkG8.rst b/Misc/NEWS.d/next/Documentation/2022-06-16-10-10-59.gh-issue-61162.1ypkG8.rst
 Clarify :mod:`sqlite3` behavior when :ref:`sqlite3-connection-context-manager`.
Original file line number	Diff line number	Diff line change
Expand Up		@@ -1431,13 +1431,27 @@ case-insensitively by name:
		.. literalinclude:: ../includes/sqlite3/rowclass.py


		.. _sqlite3-connection-context-manager:

		Using the connection as a context manager
erlend-aasland marked this conversation as resolved. Show resolvedHide resolved
		^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

		Connection objects can be used as context managers
		that automatically commit or rollback transactions. In the event of an
erlend-aasland marked this conversation as resolved. Show resolvedHide resolved
		exception, the transaction is rolled back; otherwise, the transaction is
		committed:
		A :class:`Connection` object can be used as a context manager that
		automatically commits or rolls back open transactions when leaving the body of
		the context manager.
		If the body of the :keyword:`with` statement finishes without exceptions,
		the transaction is committed.
erlend-aasland marked this conversation as resolved. Show resolvedHide resolved
		If this commit fails,
		or if the body of the ``with`` statement raises an uncaught exception,
		the transaction is rolled back.
erlend-aasland marked this conversation as resolved. Show resolvedHide resolved

		If there is no open transaction upon leaving the body of the ``with`` statement,
		the context manager is a no-op.

		.. note::

		The context manager neither implicitly opens a new transaction
		nor closes the connection.

		.. literalinclude:: ../includes/sqlite3/ctx_manager.py

Expand Down
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1 @@
		Clarify :mod:`sqlite3` behavior when :ref:`sqlite3-connection-context-manager`.