summaryrefslogtreecommitdiffstats
path: root/Doc/library/sqlite3.rst
Commit message (Collapse)AuthorAgeFilesLines
* gh-90923: Improve sqlite3.Connection.execute* docs (GH-91643)Miss Islington (bot)2022-04-171-12/+9
| | | | | | | | - Drop 'nonstandard'; it does not add any value - Try to be more concise - Make return value a little more explicit (cherry picked from commit 017f07a229a337e9c17bed8cd1879e0177a8d89d) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* [3.9] sqlite3: normalise pre-acronym determiners (GH-31772) (GH-31807)Jelle Zijlstra2022-03-121-5/+5
| | | | | | | For consistency, replace "a SQL" with "an SQL".. (cherry picked from commit 2d5835a019a46573d5b1b614c8ef88d6b564d8d4) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* [3.9] Docstring: replace pysqlite with sqlite3 (GH-31758) (GH-31778)Jelle Zijlstra2022-03-091-2/+2
| | | | | | | Replace two instances of "pysqlite" with "sqlite3" in sqlite3 docstrings. Also reword "is a no-op" to "does nothing" for clarity.. (cherry picked from commit b33a1ae703338e09dc0af5fbfd8ffa01d3ff75da) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* [3.9] bpo-46402: Promote SQLite URI tricks in sqlite3 docs (GH-30660) (#30672)Erlend Egeberg Aasland2022-01-181-8/+22
| | | | | | | | | | | | * bpo-46402: Promote SQLite URI tricks in `sqlite3` docs (GH-30660) Provide some examples of URI parameters in sqlite connect(). Co-authored-by: Ned Batchelder <ned@nedbatchelder.com> (cherry picked from commit bdf2ab1887a2edfb089a3c2a1590cf1e84ea0048) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no> * Update suspicious rules
* [3.9] bpo-46261: Update `sqlite3.Cursor.lastrowid` docs (GH-30407)Miss Islington (bot)2022-01-081-8/+9
|
* bpo-45677: Reword first section of `sqlite3` docs (GH-29326) (GH-29567)Miss Islington (bot)2021-11-151-18/+20
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * bpo-45677: Avoid addressing the reader as 'you' in sqlite3 docs * Adjust wording * Adjust wording again * Typo * Update Doc/library/sqlite3.rst Co-authored-by: Jacob Walls <jacobtylerwalls@gmail.com> * Address review: adjust wording * Update Doc/library/sqlite3.rst Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com> * Update Lib/sqlite3/__init__.py Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com> * Update Doc/library/sqlite3.rst Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com> * Update Doc/library/sqlite3.rst Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com> * Update Lib/sqlite3/__init__.py Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com> * Update Doc/library/sqlite3.rst Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com> * Apply Alex' suggestion, and apply 80 char limit to PR * Minor adjustment Co-authored-by: Jacob Walls <jacobtylerwalls@gmail.com> Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com> (cherry picked from commit 6c5a312fb6d92e879bf4c570b94e18bb9ffe5970) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no> Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* bpo-45335: Add note to `sqlite3` docs about "timestamp" converter (GH-29200) ↵Miss Islington (bot)2021-10-291-0/+6
| | | | | | | (GH-29320) (cherry picked from commit 3877fc02f7a8801ba5ce0e94b6075b3fdd9778d0) Co-authored-by: Ian Fisher <ian@iafisher.com>
* bpo-45608: Document missing `sqlite3` DB-API attributes and methods ↵Miss Islington (bot)2021-10-281-0/+46
| | | | | | | (GH-29219) (GH-29282) (cherry picked from commit 88d8a1a340fb09c54d47f354f5fd7d4fbc5f0c78) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* sqlite3: Modernize documentation around unicode and bytes. (GH-28652) (GH-28695)Miss Islington (bot)2021-10-051-2/+2
| | | | | (cherry picked from commit 1dac95c814763eb8a53896ac4326d8d51895d43d) Co-authored-by: Julien Palard <julien@palard.fr>
* bpo-41203: Replace Mac OS X and OS X with macOS (GH-28515) (GH-28524)Miss Islington (bot)2021-09-231-1/+1
| | | | | | | | | | Replace old names when they refer to actual versions of macOS. Keep historical names in references to older versions. Co-authored-by: Patrick Reader <_@pxeger.com> (cherry picked from commit 36122e18148c5b6c78ebce1d36d514fd7cf250f5) Co-authored-by: Serhiy Storchaka <storchaka@gmail.com>
* bpo-45089: Improve sqlite3 trace callback docs (GH-28238) (GH-28372)Miss Islington (bot)2021-09-151-5/+13
| | | | | | | - Add link to str object and sqlite3 transaction control - Mention that exceptions are not propagated (cherry picked from commit 51056b40e711d84692d099ac8970077b33c7fafd) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* Fix typo in sqlite3.rst (GH-27415) (GH-27418)Miss Islington (bot)2021-07-281-1/+1
| | | | | | preceeding -> preceding (cherry picked from commit fbe87023bf33e941373a5fca023652a825db7baf) Co-authored-by: Ikko Ashimine <eltociear@gmail.com>
* bpo-44639: fix typo in sqlite.rst (transation => transaction) (GH-27145) ↵Miss Islington (bot)2021-07-141-1/+1
| | | | | | | | | | | | | | (GH-27149) To my understanding, this is supposed to say "transaction". See the relevant source: https://github.com/python/cpython/blob/a158b20019b50e3ece6e4743ec4e6ae8d818b690/Modules/_sqlite/connection.cGH-L1434-L1467 (cherry picked from commit 1ca27f264730abaaa48b3c5e7c6eafb45017b824) Co-authored-by: Jack DeVries <58614260+jdevries3133@users.noreply.github.com> Co-authored-by: Jack DeVries <58614260+jdevries3133@users.noreply.github.com>
* bpo-30593: Doc'ed that executescript() disregards isolation level (GH-26220)Miss Islington (bot)2021-05-191-1/+5
| | | | | (cherry picked from commit 901443757333a66ff2b5c85eba30dc1c48eac321) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* bpo-20364: Improve sqlite3 placeholder docs (GH-25003)Miss Islington (bot)2021-04-141-38/+33
| | | | | (cherry picked from commit 3386ca0b36327afeef8d7eff277b2aed1030c08d) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* bpo-43446: Fix markup in sqlite3 footnote (GH-24806)Miss Islington (bot)2021-03-091-1/+1
| | | | | (cherry picked from commit 62a03cd490f81c0fb01eaceb31aa8a4c7800ed0e) Co-authored-by: Kamil Turek <kamil.turek@hotmail.com>
* bpo-43396: Normalise naming in sqlite3 doc examples (GH-24746)Miss Islington (bot)2021-03-041-25/+25
| | | | | (cherry picked from commit 40d1b831ecd1b5b6a4fce9a908a6e61b50b360a0) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* bpo-43059: Remove reference to legacy external sqlite3 repository (GH-24364)Miss Islington (bot)2021-01-311-4/+0
| | | | | (cherry picked from commit e60344364245a23a7a1b25d5ebce6833652a656c) Co-authored-by: L <3177243+LukeLR@users.noreply.github.com>
* bpo-38413: Remove outdated section about multithreading in sqlite3 (GH-23159)Vladimir2021-01-061-13/+0
| | | (cherry picked from commit f9949f82e17c88609adb53eff3a7d5cd63a645bd)
* bpo-42755: Fix sqlite3.Connection.backup docs (GH-23965)Miss Islington (bot)2020-12-271-1/+1
| | | | | | The `pages` argument default value now reflects the implementation. (cherry picked from commit abba83b4b91f78dc556dc0b7700ecb46cba22c01) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* bpo-41724: Explain when the conversion is not possible with detect_types ↵Miss Islington (bot)2020-12-201-1/+3
| | | | | | | | | | enabled (GH-23855) (GH-23862) * Explain when the conversion is not possible with detect_types enabled (cherry picked from commit 09a36cdfb7c22f44df45b44e5561776206bcedfb) Co-authored-by: sblondon <sblondon@users.noreply.github.com> Co-authored-by: sblondon <sblondon@users.noreply.github.com>
* Fix typo in sqlite3 documentation (GH-19965)Naglis2020-05-061-1/+1
| | | *first* is repeated twice.
* bpo-39652: Truncate the column name after '[' only if PARSE_COLNAMES is set. ↵Serhiy Storchaka2020-03-211-3/+4
| | | | (GH-18942)
* bpo-37390: Add audit event table to documentations (GH-14406)Steve Dower2019-06-271-1/+1
| | | Also updates some (unreleased) event names to be consistent with the others.
* bpo-37363: Add audit events for a range of modules (GH-14301)Steve Dower2019-06-241-0/+2
|
* bpo-34580: Update sqlite3 examples to call close() explicitly (GH-9079)Xtreak2019-05-191-1/+5
| | | | | The sqlit3.Connection object doesn't call its close() method when it's used as a context manager.
* bpo-35054: Add yet more index entries for symbols. (GH-10121)Serhiy Storchaka2018-10-281-0/+3
|
* bpo-8145: Improve isolation_level documentation (GH-8499)Berker Peksag2018-07-291-14/+22
| | | Initial patch by R. David Murray.
* bpo-34061: Document sqlite3.NotSupportedError (GH-8172)Marcin Niemira2018-07-081-1/+8
|
* bpo-34041: Allow creating deterministic functions in ↵Sergey Fedoseev2018-07-081-2/+9
| | | | Connection.create_function() (GH-8086)
* bpo-34018: Doc'd that type names of SQLite converters are case-insensitive. ↵Sergey Fedoseev2018-07-031-2/+2
| | | | (GH-8042)
* bpo-31378: Document sqlite3.OperationalError exception (GH-7677)Zackery Spytz2018-06-131-0/+7
|
* bpo-27645: Add support for native backup facility of SQLite (GH-4238)Emanuele Gaifas2018-03-101-0/+50
|
* bpo-25910: Fixes redirection from http to https (#4674)Sanyam Khurana2017-12-061-1/+1
|
* bpo-31843: sqlite3.connect() now accepts PathLike objects as database name ↵Anders Lorentsen2017-11-071-3/+10
| | | | (#4299)
* Returning 1 from the set_progress_handler handler cancels query (GH-4120)Simon Willison2017-11-021-0/+4
|
* bpo-29725: DOC: add text for arraysize in sqlite3.Cursor (#947)csabella2017-04-041-0/+5
| | | * bpo-29725: DOC: add text for arraysize in sqlite3.Cursor
* bpo-29121: Remove outdated documentation about transactions (#313)Berker Peksag2017-02-261-8/+3
| | | | Patch by Aviv Palivoda.
* Issue #19795: Mark up None as literal text.Serhiy Storchaka2016-10-191-4/+4
|\
| * Issue #19795: Mark up None as literal text.Serhiy Storchaka2016-10-191-4/+4
| |
* | Issue #10740: sqlite3 no longer implicitly commit an open transaction before ↵Berker Peksag2016-09-111-3/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | DDL statements This commit contains the following commits from ghaering/pysqlite: * https://github.com/ghaering/pysqlite/commit/f254c534948c41c0ceb8cbabf0d4a2f547754739 * https://github.com/ghaering/pysqlite/commit/796b3afe38cfdac5d7d5ec260826b0a596554631 * https://github.com/ghaering/pysqlite/commit/cae87ee68613697a5f4947b4a0941f59a28da1b6 * https://github.com/ghaering/pysqlite/commit/3567b31bb5e5b226ba006213a9c69dde3f155faf With the following additions: * Fixed a refcount error * Fixed a compiler warning * Made the string comparison a little more robust * Added a whatsnew entry
* | Merge from 3.5Berker Peksag2016-09-071-1/+1
|\ \ | |/
| * Use shorter version of Connection.isolation_level in sqlite3.rstBerker Peksag2016-09-071-1/+1
| |
* | Issue #27861: Fixed a crash in sqlite3.Connection.cursor() when a factorySerhiy Storchaka2016-08-291-4/+4
|\ \ | |/ | | | | creates not a cursor. Patch by Xiang Zhang.
| * Issue #27861: Fixed a crash in sqlite3.Connection.cursor() when a factorySerhiy Storchaka2016-08-291-4/+4
| | | | | | | | creates not a cursor. Patch by Xiang Zhang.
* | Merge from 3.5Berker Peksag2016-08-241-1/+1
|\ \ | |/
| * Fix typo in Cursor.execute().Berker Peksag2016-08-241-1/+1
| |
* | Issue #6057: Merge from 3.5Berker Peksag2016-08-241-2/+32
|\ \ | |/
| * Issue #6057: Document exceptions in sqlite3 moduleBerker Peksag2016-08-241-2/+32
| | | | | | | | Patch by Jaysinh Shukla and Stéphane Wirtel.
* | Issue #16864: Cursor.lastrowid now supports REPLACE statementBerker Peksag2016-06-141-3/+10
|/ | | | Initial patch by Alex LordThorsen.