summaryrefslogtreecommitdiffstats
path: root/Doc/library/sqlite3.rst
Commit message (Collapse)AuthorAgeFilesLines
* Docs: improve accuracy of sqlite3.Connection.interrupt() (GH-102904)Miss Islington (bot)2023-03-221-1/+1
| | | | | | (cherry picked from commit 7b2d53daccf5a6479e179535068fd9a841db44fc) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com> Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* Docs: improve the accuracy of the sqlite3.connect() timeout param (GH-102900)Miss Islington (bot)2023-03-221-3/+3
| | | | | | (cherry picked from commit c24f1f1e874c283bb11d8b9fbd661536ade19fe9) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com> Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* [3.10] Fix typos in documentation and comments (GH-102374) (#102377)Alex Waygood2023-03-021-1/+1
| | | | | | | | | | | Fix typos in documentation and comments (GH-102374) 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 Co-authored-by: Michael K <michael-k@users.noreply.github.com>
* [3.10] Docs: use parameter list for sqlite3.Cursor.execute* (GH-101782) ↵Erlend E. Aasland2023-02-101-12/+35
| | | | | | | (#101808) Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com> (cherry picked from commit 2037ebf81bd4bbe5421421b822bd57cfd665a1e9)
* Docs: improve accuracy of sqlite3 `check_same_thread` parameter (GH-101351)Miss Islington (bot)2023-02-021-4/+7
| | | | | | | (cherry picked from commit ee21110086e277a0ac24f5f768f35847b4db3380) Co-authored-by: Marcos Pereira <3464445+marcospgp@users.noreply.github.com> Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com> Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* Docs: improve sqlite3 placeholders example (GH-101092)Miss Islington (bot)2023-01-181-13/+12
| | | | | (cherry picked from commit b84be8d9c0e6eca37be14c38250580251a3ef908) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* gh-100668: Clarify how sqlite3 maps parameters onto placeholders (GH-100960)Miss Islington (bot)2023-01-141-9/+17
| | | | | | (cherry picked from commit 206f05a46b426eb374f724f8e7cd42f2f9643bb8) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com> Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* gh-99953: Purge mention of numeric param style from sqlite3 docs (GH-100630)Miss Islington (bot)2023-01-011-5/+1
| | | | | | The PEP-249 numeric style has never been supported by sqlite3. (cherry picked from commit b7a68ab824249ebf053b8149ebb83cd8578781c9) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* gh-96250: Improve sqlite3 injection attack example (GH-99270)Miss Islington (bot)2022-12-081-6/+10
| | | | | | | (cherry picked from commit 41d4ac9da348ca33056e271d71588b2dc3a6d48d) Co-authored-by: Jia Junjie <62194633+jiajunjie@users.noreply.github.com> Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM> Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* Docs: both sqlite3 "point examples" now adapt to str (GH-99823)Miss Islington (bot)2022-11-271-1/+1
| | | | | (cherry picked from commit 276643e207d44c53b87a8108d5b00982defcce1e) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* gh-96168: Add sqlite3 row factory how-to (GH-99507)Miss Islington (bot)2022-11-251-41/+119
| | | | | | | (cherry picked from commit 8749121b07f48994ea47f2e7ff75fb13c13953f6) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com> Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM> Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
* gh-99392: Fix sqlite3 converter recipes (GH-99393)Miss Islington (bot)2022-11-121-3/+22
| | | | | (cherry picked from commit dfc1b17a23fed933cffa09eec125a7e8c90ea867) Co-authored-by: naglis <827324+naglis@users.noreply.github.com>
* Docs: add `named` to the list of styles in the sqlite3.paramstyle attr docs ↵Miss Islington (bot)2022-11-031-3/+4
| | | | | | | (GH-99078) (cherry picked from commit 016c7d37b6acfe2203542a2655080c6402b3be1f) Co-authored-by: Nick Pope <nick@nickpope.me.uk>
* [3.10] gh-98716: Revert gh-96081: Escape lone stars in sqlite3 docs ↵Erlend E. Aasland2022-10-261-2/+2
| | | | | | | (GH-98720) (#98737) (cherry picked from commit 365852a03a0c934ccd9b6c2b8e24c71181c41f03) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* gh-97661: Improve accuracy of sqlite3.Cursor.fetchone docs (GH-97662)Miss Islington (bot)2022-10-051-1/+3
| | | | | | Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM> (cherry picked from commit 4b83cd0b22428fbfccf1f0e85c0fc36be6ab7edf) Co-authored-by: Jia Junjie <62194633+jiajunjie@users.noreply.github.com>
* [3.10] gh-97567: Fixup cached_statements default value in sqlite3.connect ↵Jia Junjie2022-09-271-1/+1
| | | | | docs (#97568) This docs inconsistency was introduced by the 3.10 backport of gh-94629: gh-94646
* gh-96810: Clarify for which statements sqlite3 implicitly opens transactions ↵Miss Islington (bot)2022-09-151-1/+2
| | | | | | | (GH-96832) (cherry picked from commit 16c33a9676e2f3ef330d09f2ab515c56636fa09f) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* [3.10] gh-96702: Order methods before attrs in sqlite3.Connection docs ↵Erlend E. Aasland2022-09-131-97/+95
| | | | | | | (GH-96703). (#96789) (cherry picked from commit 49cceeb5c998a51bb12b7dbde17b53647bb52113) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* Docs: alphabetically order sqlite3.Cursor attrs (GH-96565)Miss Islington (bot)2022-09-041-30/+31
| | | | | (cherry picked from commit 9e5568578234f0ecd003247c8a2deaeb69976b4b) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* gh-96168: Improve sqlite3 dict_factory example (GH-96457)Miss Islington (bot)2022-09-011-18/+9
| | | | | | | Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM> Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com> (cherry picked from commit 91f40f3f78d6016a283989e32ec3d1fb61bcebca) Co-authored-by: Erlend E. Aasland <erlend.aasland@innova.no>
* [3.10] gh-96414: Inline code examples in sqlite3 docs (GH-96442). (#96453)Erlend E. Aasland2022-08-311-12/+307
| | | | | | * [3.10] gh-96414: Inline code examples in sqlite3 docs (GH-96442). (cherry picked from commit f7e7bf161aaec5a5cffdcec7c97e1f09e445421b) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* Docs: normalise sqlite3 placeholder how-to heading (GH-96413)Miss Islington (bot)2022-08-301-2/+2
| | | | | (cherry picked from commit 7b01ce7953c0e24aa7aeaf207216fc9e7aefd18a) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* [3.10] Docs: normalize SQL style in sqlite3 docs (GH-96403). (#96409)Erlend E. Aasland2022-08-301-6/+6
| | | | | (cherry picked from commit 6d403e264a7dcd1544a91708f139c6dd8612204d) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* [3.10] gh-95432: Add doctests for the sqlite3 docs (GH-96225) (#96379)Erlend E. Aasland2022-08-291-44/+88
| | | | | | | | | | As a consequence of the added test, this commit also includes fixes for broken examples. - Add separate namespace for trace tests bco. module level callback - Move more backup and cursor examples under separate namespaces. (cherry picked from commit bf9259776dff5348bc854983409ea68618c1f174) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* [3.10] gh-94635: Frame sqlite3 how-to headings as such & move default ↵Erlend E. Aasland2022-08-241-43/+45
| | | | | | | | | adapters to reference (GH-96136) (#96227) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com> Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>. (cherry picked from commit 6bda5b85b53443f3467865fbf85cbe72932e7cd6) Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* gh-96096: Add undocumented SQLITE_OK/DENY/IGNORE sqlite3 constants (GH-96134)Miss Islington (bot)2022-08-231-4/+14
| | | | | | | Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com> Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com> (cherry picked from commit d6259c58cbb48b8f3fbd70047f004ea19fe91e86) Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* gh-95432: Add doctest for sqlite3 tutorial (GH-96193)Miss Islington (bot)2022-08-231-16/+47
| | | | | (cherry picked from commit 04c73e5efbfea8ae9da5bd518cee96086017ef4f) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* gh-96121: Merge sqlite3.Row examples into sqlite3.Row class doc (GH-96122)Miss Islington (bot)2022-08-221-56/+18
| | | | | | | Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com> Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM> (cherry picked from commit 18b1782192f85bd26db89f5bc850f8bee4247c1a) Co-authored-by: Erlend E. Aasland <erlend.aasland@innova.no>
* Docs: Fix markup of module name in sqlite3 docs (GH-96115)Miss Islington (bot)2022-08-191-3/+3
| | | | | (cherry picked from commit ee9f22d3464308566c63e972133ebf71b7664baa) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* Doc: Use consistent markup for example Point class in sqlite3 (GH-96095)Miss Islington (bot)2022-08-191-3/+3
| | | | | (cherry picked from commit 303ef0913e5b80adbe63def41829bff5effab6a0) Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* Docs: group sqlite3.Connection attributes and methods (GH-96090)Miss Islington (bot)2022-08-191-39/+37
| | | | | (cherry picked from commit 1a140af40b7204faf7896b67b8ef5af200427565) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* gh-94635: Remove sqlite3 doc introduction heading (GH-96089)Miss Islington (bot)2022-08-191-3/+0
| | | | | (cherry picked from commit ede771cdf90431d4db22f98e35f43888842f231e) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* [3.10] Docs: Escape lone stars in sqlite3 docs (GH-96081). (#96085)Erlend E. Aasland2022-08-181-2/+2
| | | | | (cherry picked from commit 91afe66707237558d808aeca4683d0822aa0511e) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* gh-95271: Rework sqlite3 tutorial (GH-95749)Miss Islington (bot)2022-08-181-50/+138
| | | | | | | Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM> Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com> (cherry picked from commit c87ea10fc91f040822ab3eed2d08b073861360f6) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* [3.10] gh-95273: Improve sqlite3.complete_statement docs (GH-95840) (#95918)Erlend E. Aasland2022-08-121-8/+16
| | | | | | | Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com> Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>. (cherry picked from commit e6623e7083ce08a247e5df169bcc749f99327823) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* [3.10] gh-95273: Reorganize sqlite3 doc module level funcs and vars ↵Erlend E. Aasland2022-08-081-124/+121
| | | | | | | | | (GH-95626) (#95803) Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com> Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>. (cherry picked from commit 41c939cb35cda395388a775156c367676efffebe) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* gh-94635: Fixup sqlite3 'Introduction' seealso note (GH-95751)Miss Islington (bot)2022-08-061-12/+12
| | | | | | | In gh-95269, the seealso note incorrectly ended up in the 'Tutorial' section. (cherry picked from commit 56af5a200d60e86a8ac450264729d693053275e3) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
* [3.10] Docs: sqlite3 docs fixup (GH-95681) (#95684)Erlend Egeberg Aasland2022-08-051-24/+24
| | | | | | | | - Disable links to the module itself - Consistent ref markup (cherry picked from commit 44f1f63ad5cf00b6f50cef0cc1a62c42632138be) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>
* [3.10] gh-95271: Extract placeholders howto from sqlite3 tutorial (GH-95522) ↵Erlend Egeberg Aasland2022-08-041-26/+38
| | | | | | | | | (#95678) Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM> Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com> (cherry picked from commit b24e8b28a7dc585ba367a959be83393f2352d21d) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>
* [3.10] gh-95273: Improve documented return values and exceptions raised for ↵Erlend Egeberg Aasland2022-08-041-33/+18
| | | | | | | | | sqlite3 class methods (GH-95530) (#95674) Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com> Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com>. (cherry picked from commit 12d92c733cfc00ee630b30e4e0250da400c83395) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>
* Docs: fix two typos in the sqlite3 docs (GH-95661)Miss Islington (bot)2022-08-041-2/+2
| | | | | | | - statment => statement - transaciton => transaction (cherry picked from commit 962acd446839c7e10caf301931760133644ce8ca) Co-authored-by: ceh <emil@hessman.se>
* [3.10] gh-95273: Align sqlite3 const doc refs with the devguide ↵Erlend Egeberg Aasland2022-08-031-32/+32
| | | | | | | recommendations (GH-95525). (#95618) (cherry picked from commit 4d02572f8c39b16c83c0883917db4e31efc1048e) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>
* [3.10] gh-94635: Add Reference, How-to, and Explanation headings to sqlite3 ↵Erlend Egeberg Aasland2022-07-311-96/+120
| | | | | | | | | | docs (GH-94636) (#95483) Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>. (cherry picked from commit 6c439b978bf55b29f21c595e9375202d63c8208d) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com> * Fix refs
* gh-95273: Relocate sqlite3 enable load extension note (GH-95430)Miss Islington (bot)2022-07-291-12/+8
| | | | | (cherry picked from commit d92b19e1b500247f9a62b12b9da889b99fe333f6) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>
* gh-95432: Fixup sqlite3 tutorial example (GH-95431)Miss Islington (bot)2022-07-291-5/+5
| | | | | | | - the insert statement should have five placeholders, not four - missing ... in the multiline row list (cherry picked from commit 2fbee85931296bbeddae6358583e400ce5321f89) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>
* gh-95273: Improve sqlite3 class descriptions (GH-95379)Miss Islington (bot)2022-07-291-8/+34
| | | | | | Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM> (cherry picked from commit e003b64f40fa28954ec967024fa811adff6cffe7) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* gh-95273: Condense sqlite3 executescript example (GH-95383) (#95419)Miss Islington (bot)2022-07-291-2/+9
| | | | | (cherry picked from commit e9c8de669d40d993489981be2973d1ea5bd10d0c) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* gh-95273: Move sqlite3 executemany examples from reference to tutorial ↵Miss Islington (bot)2022-07-291-11/+26
| | | | | | | (GH-95351) (cherry picked from commit f0bf7956e60b452208f279146f928d71eb0aa11b) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* Docs: Fix refs & tweak wording in sqlite3 'Using shortcut methods' (#95358)Miss Islington (bot)2022-07-281-2/+3
| | | | | | Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM> (cherry picked from commit ea269b9a380a52828d4e401fa695737bcd699398) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>
* [3.10] gh-95273: Normalise sqlite3 reference wording (GH-95274) (#95330)Erlend Egeberg Aasland2022-07-271-42/+43
| | | | | | | Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com> Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>. (cherry picked from commit 2361908a9d5553102f2b2294af44852a76d2ab03) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
generated by cgit v0.12 at 2025-09-05 23:12:16 (GMT)