summaryrefslogtreecommitdiffstats
path: root/Doc/library/sqlite3.rst
Commit message (Collapse)AuthorAgeFilesLines
* [3.13] docs: module page titles should not start with a link to themselves ↵Miss Islington (bot)2024-05-081-2/+2
| | | | | | | | (GH-117099) (#118790) 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>
* gh-111726: Explicitly close database connections in sqlite3 doctests (#111730)Nikita Sobolev2024-04-081-0/+27
| | | Co-authored-by: Erlend E. Aasland <erlend@python.org>
* gh-111726: Remove some doctests from sqlite3 docs (#117623)Erlend E. Aasland2024-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"
* gh-111726: Cleanup test files after running sqlite3 doctest (#117604)Hugo van Kemenade2024-04-081-0/+8
| | | | Remove all temporary databases in a dedicated 'testcleanup' step at the end of the file.
* Docs: fix broken links (#116651)Mariusz Felisiak2024-03-131-1/+1
|
* gh-91602: Add iterdump() support for filtering database objects (#114501)Mariusz Felisiak2024-02-061-1/+10
| | | | | | Add optional 'filter' parameter to iterdump() that allows a "LIKE" pattern for filtering database objects to dump. Co-authored-by: Erlend E. Aasland <erlend@python.org>
* Docs: align sqlite3 docs with versionadded/versionchanged recommendations ↵Erlend E. Aasland2024-01-211-12/+12
| | | | | | (#114400) When a parameter is added to a function or method, use the 'versionchanged' directive, not 'versionadded'.
* Docs: fix typo in doc for sqlite3.Cursor.execute (#112442)Tom Levy2023-11-271-1/+1
|
* gh-108590: Improve sqlite3 docs on encoding issues and how to handle those ↵Erlend E. Aasland2023-10-251-33/+50
| | | | | | | | | | | | (#108699) Add a guide for how to handle non-UTF-8 text encodings. Link to that guide from the 'text_factory' docs. 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>
* gh-110631: Fix reST indentation in `Doc/library` (#110685)Ezio Melotti2023-10-111-12/+12
| | | Fix wrong indentation in the Doc/library dir.
* Enhanced sqlite3 connection context management documentation with ↵Lincoln2023-10-031-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | contextlib.closing gh-109234 (#109322) * Enhanced sqlite3 connection context management documentation with contextlib.closing * 📜🤖 Added by blurb_it. * Fixed gitignore spelling error from nitignore to gitignore * Renamed .gitignore to .nitignore * Added generated doctests * Deleted sqlite3 generated files * Removed white-space changes * Removed News entry from the doc * Expanded a note that context manager can be used for connection management using contextlib.closing * Removed repeated contextlib.closing code snippet * Expanded the note around usage of context manageer for sqlite3 connection management * Deleted extra white-spaces * Deleted extra white-space * re-arranged context manager wording * Re-arranged word layout on how to use context manager * Fix whitespace errors * Remove unneeded change in .gitignore * Added suggested changes * Added suggested change redirecting to the contextlib.closing implementation * Added closing keyword * Removed line 2473 --------- Co-authored-by: blurb-it[bot] <43283697+blurb-it[bot]@users.noreply.github.com> Co-authored-by: Erlend E. Aasland <erlend@python.org>
* fix misaligned versionchanged blocks in sqlite3 docs (GH-110191)Ned Batchelder2023-10-021-9/+6
|
* gh-108278: Deprecate passing the first param of sqlite3.Connection callback ↵Erlend E. Aasland2023-08-291-6/+21
| | | | | | | | | | | | APIs by keyword (#108632) Deprecate passing the callback callable by keyword for the following sqlite3.Connection APIs: - set_authorizer(authorizer_callback) - set_progress_handler(progress_handler, ...) - set_trace_callback(trace_callback) The affected parameters will become positional-only in Python 3.15.
* Fix misc doc typos (#108592)xzmeng2023-08-291-1/+1
|
* gh-108278: Deprecate passing the three first params as keyword args for ↵Erlend E. Aasland2023-08-281-0/+10
| | | | | | | | | | | sqlite3 UDF creation APIs (#108281) Deprecate passing name, number of arguments, and the callable as keyword arguments, for the following sqlite3.Connection APIs: - create_function(name, nargs, callable, ...) - create_aggregate(name, nargs, callable) The affected parameters will become positional-only in Python 3.15.
* Docs: align the param spec of sqlite3.Connection methods with the ↵Erlend E. Aasland2023-08-221-2/+2
| | | | | | implementation (#108285) - no parameters of create_aggregate() are positional-only - all parameters of create_collation() are positional-only
* gh-105539: Emit ResourceWarning if sqlite3 database is not closed explicitly ↵Erlend E. Aasland2023-08-221-0/+6
| | | | (#108015)
* gh-93057: Deprecate positional use of optional sqlite3.connect() params ↵Erlend E. Aasland2023-08-151-0/+6
| | | | (#107948)
* gh-106909: Use role :const: for referencing module constants (GH-106910)Serhiy Storchaka2023-07-211-5/+5
|
* gh-96165: Clarify passing ":memory:" in sqlite3.connect() (#106451)Mariusz Felisiak2023-07-111-2/+3
|
* gh-96165: Clarify omitting the FROM clause in SQLite queries (#106513)Mariusz Felisiak2023-07-111-0/+7
|
* Docs: add links to 'callable' term in sqlite3 docs (#106072)Erlend E. Aasland2023-06-251-17/+18
|
* gh-105875: Require SQLite 3.15.2 or newer (#105876)Erlend E. Aasland2023-06-181-4/+1
| | | SQLite 3.15.2 was released 2016-11-28.
* 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)
generated by cgit v0.12 at 2024-11-30 00:36:07 (GMT)