summaryrefslogtreecommitdiffstats
path: root/Doc/library/sqlite3.rst
Commit message (Collapse)AuthorAgeFilesLines
* [3.12] gh-126259: Fix "unclosed database" warning in sqlite3 doctest ↵Miss Islington (bot)2024-11-011-0/+1
| | | | | | | (GH-126260) (#126266) (cherry picked from commit 295262c8ecb085b4fea552bc6229af3551bbaf7a) Co-authored-by: sobolevn <mail@sobolevn.me>
* [3.12] Use pep role instead of url (GH-121611) (#124173)Miss Islington (bot)2024-09-171-15/+14
| | | | Co-authored-by: Rafael Fontenelle <rffontenelle@users.noreply.github.com>
* [3.12] gh-123517: Remove unnecessary `:meth:` parentheses (gh-123518) ↵Wei-Hsiang (Matt) Wang2024-09-021-1/+1
| | | | (GH-123576)
* [3.12] docs: module page titles should not start with a link to themselves ↵Miss Islington (bot)2024-05-081-2/+2
| | | | | | | | (GH-117099) (#118791) docs: module page titles should not start with a link to themselves (GH-117099) (cherry picked from commit bcb435ee8ff41b5ec5d879ee0b6651f146a66151) Co-authored-by: Ned Batchelder <ned@nedbatchelder.com>
* [3.12] gh-111726: Explicitly close database connections in sqlite3 doctests ↵Miss Islington (bot)2024-04-081-0/+27
| | | | | | | | (GH-111730) (#117630) (cherry picked from commit a7702663e3f7efc81f0b547f1f13ba64c4e5addc) Co-authored-by: Nikita Sobolev <mail@sobolevn.me> Co-authored-by: Erlend E. Aasland <erlend@python.org>
* [3.12] gh-111726: Remove some doctests from sqlite3 docs (GH-117623) (#117625)Miss Islington (bot)2024-04-081-36/+7
| | | | | | | | | * remove load extension doctest since we cannot skip it conditionally * remove sys.unraisablehook example; using unraisable hooks is not "an improved debug experience" (cherry picked from commit e338e1a4ec5e43a02447f4ec80320d7fc12b3ed4) Co-authored-by: Erlend E. Aasland <erlend@python.org>
* [3.12] gh-111726: Cleanup test files after running sqlite3 doctest ↵Miss Islington (bot)2024-04-081-0/+8
| | | | | | | | | (GH-117604) (#117622) Remove all temporary databases in a dedicated 'testcleanup' step at the end of the file. (cherry picked from commit a453f5ef9d0b89bd00488d3814c6f0a2886342b8) Co-authored-by: Hugo van Kemenade <1324225+hugovk@users.noreply.github.com>
* [3.12] Docs: fix broken links (GH-116651) (#116700)Miss Islington (bot)2024-03-131-1/+1
| | | | | | (cherry picked from commit 3f1b6efee95c06f8912bcea4031afacdbc0d5684) Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com>
* [3.12] Docs: align sqlite3 docs with versionadded/versionchanged ↵Erlend E. Aasland2024-01-211-12/+12
| | | | | | | | recommendations (#114400) (#114402) (cherry picked from commit 336030161a6cb8aa5b4f42a08510f4383984703f) When a parameter is added to a function or method, use the 'versionchanged' directive, not 'versionadded'.
* [3.12] Docs: fix typo in doc for sqlite3.Cursor.execute (GH-112442) (#112444)Miss Islington (bot)2023-11-271-1/+1
| | | | | | Docs: fix typo in doc for sqlite3.Cursor.execute (GH-112442) (cherry picked from commit fb79e1ed4a985a487a02bb8585cc1bd2933dfa7c) Co-authored-by: Tom Levy <tomlevy93@gmail.com>
* [3.12] gh-108590: Improve sqlite3 docs on encoding issues and how to handle ↵Miss Islington (bot)2023-10-251-33/+50
| | | | | | | | | | | | | | | those (GH-108699) (#111324) Add a guide for how to handle non-UTF-8 text encodings. Link to that guide from the 'text_factory' docs. (cherry picked from commit 1262e41842957c3b402fc0cf0a6eb2ea230c828f) Co-authored-by: Erlend E. Aasland <erlend@python.org> Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com> Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM> Co-authored-by: Corvin <corvin@corvin.dev> Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com> Co-authored-by: Serhiy Storchaka <storchaka@gmail.com>
* [3.12] gh-110631: Fix reST indentation in `Doc/library` (GH-110685) (#110736)Miss Islington (bot)2023-10-111-12/+12
| | | | | | | | gh-110631: Fix reST indentation in `Doc/library` (GH-110685) Fix wrong indentation in the Doc/library dir. (cherry picked from commit bb7923f556537a463c403dc1097726d8a8e1a6f2) Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
* [3.12] gh-109234: Hint to contextlib.closing in sqlite3 context manager docs ↵Miss Islington (bot)2023-10-031-2/+2
| | | | | | | | | (GH-109322) (#110294) (cherry picked from commit 4227bfa8b273207a2b882f7d69c8ac49c3d2b57d) Co-authored-by: Lincoln <71312724+Lincoln-developer@users.noreply.github.com> Co-authored-by: blurb-it[bot] <43283697+blurb-it[bot]@users.noreply.github.com> Co-authored-by: Erlend E. Aasland <erlend@python.org>
* [3.12] Fix misc doc typos (GH-108592) (#108594)Miss Islington (bot)2023-08-291-1/+1
| | | | | | Fix misc doc typos (GH-108592) (cherry picked from commit 88f1c5b454c34efc167a94b5e2d67ec042834e5b) Co-authored-by: xzmeng <aumo@foxmail.com>
* [3.12] Docs: align the param spec of sqlite3.Connection methods with the ↵Miss Islington (bot)2023-08-221-2/+2
| | | | | | | | | | | implementation (GH-108285) (#108287) Docs: align the param spec of sqlite3.Connection methods with the implementation (GH-108285) - no parameters of create_aggregate() are positional-only - all parameters of create_collation() are positional-only (cherry picked from commit 893215a4e7f59eabb8ccdf188c4b9b1de5bd8966) Co-authored-by: Erlend E. Aasland <erlend@python.org>
* [3.12] gh-106909: Use role :const: for referencing module constants ↵Serhiy Storchaka2023-07-211-5/+5
| | | | | (GH-106910) (GH-106956) (cherry picked from commit 4b9948617f91175783609769aa6160e5b49b9ccc)
* [3.12] gh-96165: Clarify passing ":memory:" in sqlite3.connect() (GH-106451) ↵Miss Islington (bot)2023-07-111-2/+3
| | | | | | | (#106647) (cherry picked from commit f520804b039df0d87fb9df6f1fed2a9bc9df8d61) Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com>
* [3.12] gh-96165: Clarify omitting the FROM clause in SQLite queries ↵Miss Islington (bot)2023-07-111-0/+7
| | | | | | | (GH-106513) (#106645) (cherry picked from commit fc7ff1af457e27b7d9752600b3436641be90f598) Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com>
* [3.12] Docs: add links to 'callable' term in sqlite3 docs (GH-106072) (#106073)Miss Islington (bot)2023-06-251-17/+18
| | | | | (cherry picked from commit bef1c8761e3b0dfc5708747bb646ad8b669cbd67) Co-authored-by: Erlend E. Aasland <erlend@python.org>
* gh-101117: Improve accuracy of sqlite3.Cursor.rowcount docs (#104287)Erlend E. Aasland2023-05-111-1/+4
| | | | The SQLite C API sqlite3_changes() can only be relied upon when the current active statement has been run to completion.
* gh-100021: Document that sqlite3's executemany() discards resulting rows ↵Erlend E. Aasland2023-04-281-2/+9
| | | | (#103939)
* GH-103903: Test the minimum Sphinx version in CI (#103904)Adam Turner2023-04-271-3/+3
|
* gh-103489: Add get/set config methods to sqlite3.Connection (#103506)Erlend E. Aasland2023-04-261-0/+56
|
* gh-103015: Add entrypoint keyword param to sqlite3.Connection.load_extension ↵Erlend E. Aasland2023-04-261-2/+20
| | | | (#103073)
* Docs: fixup incorrect escape char in sqlite3 docs (#102945)Erlend E. Aasland2023-03-231-1/+1
|
* Docs: improve accuracy of sqlite3.Connection.interrupt() (#102904)Erlend E. Aasland2023-03-221-1/+1
| | | Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* Docs: improve the accuracy of the sqlite3.connect() timeout param (#102900)Erlend E. Aasland2023-03-221-3/+3
| | | Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* Fix typos in documentation and comments (GH-102374)Michael K2023-03-021-1/+1
| | | | | | | | Found some duplicate `to`s in the documentation and some code comments and fixed them. [Misc/NEWS.d/3.12.0a1.rst](https://github.com/python/cpython/blob/ed55c69ebd74178115cd8b080f7f8e7588cd5fda/Misc/NEWS.d/3.12.0a1.rst) also contains two duplicate `to`s, but I wasn't sure if it's ok to touch that file. Looks auto generated. I'm happy to amend the PR if requested. :) Automerge-Triggered-By: GH:AlexWaygood
* gh-101693: In sqlite3, deprecate using named placeholders with parameters ↵Erlend E. Aasland2023-02-151-1/+18
| | | | supplied as a sequence (#101698)
* Docs: use parameter list for sqlite3.Cursor.execute* (#101782)Erlend E. Aasland2023-02-101-12/+33
| | | Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com>
* Docs: improve accuracy of sqlite3 `check_same_thread` parameter (#101351)Marcos Pereira2023-02-011-4/+7
| | | | Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com> Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* gh-101386: fix typos found by codespell (#101387)Peter Jiping Xie2023-01-281-1/+1
|
* Docs: improve sqlite3 placeholders example (#101092)Erlend E. Aasland2023-01-181-13/+12
|
* gh-100668: Clarify how sqlite3 maps parameters onto placeholders (#100960)Erlend E. Aasland2023-01-141-9/+17
| | | Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* Fix typos in Doc folder (#100880)Semen Zhydenko2023-01-101-1/+1
|
* gh-99953: Purge mention of numeric param style from sqlite3 docs (#100630)Erlend E. Aasland2023-01-011-5/+1
| | | The PEP-249 numeric style has never been supported by sqlite3.
* gh-99087: Add missing newline for prompts in docs (GH-98993)Stanley2022-12-091-0/+1
| | | Add newline for prompts so copying to REPL does not cause errors.
* gh-96250: Improve sqlite3 injection attack example (#99270)Jia Junjie2022-12-081-6/+10
| | | | Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM> Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* Doc: Add summary line to isolation_level & autocommit sqlite3.connect params ↵C.A.M. Gerlach2022-12-011-0/+2
| | | | | | | (#99917) Add summary lines to isolation_level and autocommit connect() params Co-authored-by: Géry Ogam <gery.ogam@gmail.com>
* gh-99824: Document that sqlite3.connect implicitly open a transaction if ↵Géry Ogam2022-11-301-3/+3
| | | | | autocommit=False (#99825) Authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* Docs: both sqlite3 "point examples" now adapt to str (#99823)Erlend E. Aasland2022-11-271-1/+1
|
* gh-96168: Add sqlite3 row factory how-to (#99507)Erlend E. Aasland2022-11-251-41/+119
| | | | Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM> Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
* gh-83638: Add sqlite3.Connection.autocommit for PEP 249 compliant behaviour ↵Erlend E. Aasland2022-11-121-17/+154
| | | | | | | | | | (#93823) Introduce the autocommit attribute to Connection and the autocommit parameter to connect() for PEP 249-compliant transaction handling. Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com> Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM> Co-authored-by: Géry Ogam <gery.ogam@gmail.com>
* gh-99392: Fix sqlite3 converter recipes (#99393)naglis2022-11-121-3/+22
|
* Docs: add argument spec to sqlite3 CLI docs (#99200)Erlend E. Aasland2022-11-071-1/+6
|
* Docs: add `named` to the list of styles in the sqlite3.paramstyle attr docs ↵Nick Pope2022-11-031-3/+4
| | | | (#99078)
* gh-98716: Revert gh-96081: Escape lone stars in sqlite3 docs (#98720)Erlend E. Aasland2022-10-261-5/+5
|
* gh-97661: Improve accuracy of sqlite3.Cursor.fetchone docs (#97662)Jia Junjie2022-10-051-1/+3
| | | Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* gh-96810: Clarify for which statements sqlite3 implicitly opens transactions ↵Erlend E. Aasland2022-09-151-1/+2
| | | | (#96832)
* gh-96702: Order methods before attrs in sqlite3.Connection docs (#96703)Erlend E. Aasland2022-09-131-97/+96
|
generated by cgit v0.12 at 2026-01-10 02:27:47 (GMT)