René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Document sqlite3.connect() as implicitly opening transactions in the new PEP-249 manual commit mode","articleBody":"# Documentation\r\n\r\nIn `sqlite3`, @malemburg [specified](https://github.com/python/cpython/issues/83638#issuecomment-1093853924)  that `connect()`, `commit()`, and `rollback()` implicitly open transactions in the new PEP-249 manual commit mode implemented in PR #93823:\r\n\r\n\u003e If this is set to False, the module could then implement the\r\n\u003e correct way of handling transactions, which means:\r\n\u003e \r\n\u003e a) start a new transaction when the connection is opened\r\n\u003e b) start a new transaction after .commit() and .rollback()\r\n\u003e c) don't start new transactions anywhere else\r\n\u003e d) run an implicit .rollback() when the connection closes\r\n\r\nSo I expect to see that information clearly documented.\r\n\r\nYet the PR documented it only for `commit()` and `rollback()` (item b), not for `connect()` (item a):\r\n\r\n```\r\n* :mod:`!sqlite3` ensures that a transaction is always open,\r\n  so :meth:`Connection.commit` and :meth:`Connection.rollback`\r\n  will implicitly open a new transaction immediately after closing\r\n  the pending one.\r\n```\r\n\r\nTo me it is important to document it also for `connect()` rather than relying on user’s deduction, which is not obvious at all since for instance in *legacy* manual commit mode, `sqlite3` does *not* implicitly open transactions when `connect()` is called but when `execute()` is called on a DML statement.\r\n\r\n\u003c!-- gh-linked-prs --\u003e\r\n### Linked PRs\r\n* gh-99825\r\n\u003c!-- /gh-linked-prs --\u003e\r\n","author":{"url":"https://github.com/geryogam","@type":"Person","name":"geryogam"},"datePublished":"2022-11-27T20:38:28.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/99824/cpython/issues/99824"}