summaryrefslogtreecommitdiffstats
path: root/Lib/sqlite3
Commit message (Collapse)AuthorAgeFilesLines
* [3.9] gh-80254: Disallow recursive usage of cursors in `sqlite3` converters ↵Erlend Egeberg Aasland2022-05-051-0/+43
| | | | | | | | | | | | | | (#92278) * [3.9] gh-80254: Disallow recursive usage of cursors in `sqlite3` converters (cherry picked from commit c908dc5b4798c311981bd7e1f7d92fb623ee448b) Co-authored-by: Sergey Fedoseev <fedoseev.sergey@gmail.com> Co-authored-by: Jelle Zijlstra <jelle.zijlstra@gmail.com> * Fix ref leak in pysqlite_cursor_iternext * Explicitly free resources at test tearDown()
* Fix typo in the sqlite3 docs (GH-31915) (GH-32158)Miss Islington (bot)2022-03-291-1/+1
| | | | | | Co-authored-by: Jonathan <89750679+AHypnotoad@users.noreply.github.com> (cherry picked from commit 66584c890d016e40d707400130d1cd98f2aedde9) Co-authored-by: Jonathan <jonathan.joyner94@gmail.com>
* [3.9] bpo-43853: Expand test suite for SQLite UDF's (GH-27642) (GH-31030) ↵Erlend Egeberg Aasland2022-03-021-61/+65
| | | | | (GH-31586) (cherry picked from commit 3eb3b4f270757f66c7fb6dcf5afa416ee1582a4b)
* bpo-45677: Reword first section of `sqlite3` docs (GH-29326) (GH-29567)Miss Islington (bot)2021-11-151-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * 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-45612: Add sqlite3 module docstring (GH-29224) (GH-29289)Miss Islington (bot)2021-10-281-0/+34
| | | | | (cherry picked from commit 4dd1e84789f0bd2da83ad06d23c569bf03713a50) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* [3.9] Fix typos in the Lib directory (GH-28775) (GH-28803)Christian Clauss2021-10-071-2/+2
| | | | | | | | Fix typos in the Lib directory as identified by codespell. Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu> (cherry picked from commit 745c9d9dfc1ad6fdfdf1d07420c6273ff67fa5be) Automerge-Triggered-By: GH:JulienPalard
* [3.9] bpo-25130: Make SQLite tests more compatible with PyPy (GH-28021) ↵Serhiy Storchaka2021-08-293-3/+7
| | | | | | (GH-28023) (cherry picked from commit 07d3d54)
* [3.9] bpo-27334: roll back transaction if sqlite3 context manager fails to ↵Erlend Egeberg Aasland2021-08-251-2/+76
| | | | commit (GH-26202) (GH-27944)
* [3.9] bpo-44822: Don't truncate `str`s with embedded NULL chars returned by ↵Erlend Egeberg Aasland2021-08-061-0/+28
| | | | | | `sqlite3` UDF callbacks (GH-27588). (GH-27639) (cherry picked from commit 8f010dc920e1f6dc6a357e7cc1460a7a567c05c6)
* [3.9] bpo-43853: Handle sqlite3_value_text() errors (GH-25422). (GH-27627)Erlend Egeberg Aasland2021-08-061-5/+7
| | | | (cherry picked from commit 006fd869e4798b68e266f5de89c83ddb531a756b)
* [3.9] bpo-31746: Prevent segfaults when sqlite3.Connection is uninitialised ↵Erlend Egeberg Aasland2021-07-291-1/+23
| | | | | | | (GH-27431) (GH-27465) (cherry picked from commit 7e311e496b0e26b3d3c62fe9b0ed2a4677c37ee9) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* [3.9] sqlite3 test suite now works with SQLITE_DQS=0 (GH-26032). (GH-26128)Erlend Egeberg Aasland2021-05-141-1/+1
| | | | | (cherry picked from commit be7e467bcf5e419302d887904ef3e8fd310c68e7) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* bpo-40810: Fix CheckTraceCallbackContent for SQLite pre 3.7.15 (GH-20530)Miss Islington (bot)2021-01-041-0/+8
| | | | | | | Ref. [SQLite 3.7.15 changelog](https://sqlite.org/changes.htmlGH-version_3_7_15): _"Avoid invoking the sqlite3_trace() callback multiple times when a statement is automatically reprepared due to SQLITE_SCHEMA errors."_ (cherry picked from commit f7f0ed59bcc41ed20674d4b2aa443d3b79e725f4) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* bpo-41815: SQLite: segfault if backup called on closed database (GH-22322)Miss Islington (bot)2020-09-211-0/+7
| | | | | | | | | | | | | | | | GH- [bpo-41815](): SQLite: fix segfault if backup called on closed database Attempting to backup a closed database will trigger segfault: ```python import sqlite3 target = sqlite3.connect(':memory:') source = sqlite3.connect(':memory:') source.close() source.backup(target) ``` (cherry picked from commit bfee9fad84531a471fd7864e88947320669f68e2) Co-authored-by: Peter McCormick <peter@pdmccormick.com>
* bpo-41662: Fix bugs in binding parameters in sqlite3 (GH-21998)Miss Islington (bot)2020-09-172-1/+26
| | | | | | | | | * When the parameters argument is a list, correctly handle the case of changing it during iteration. * When the parameters argument is a custom sequence, no longer override an exception raised in ``__len__()``. (cherry picked from commit 0b419b791077414bbc011a412698ebb362b63761) Co-authored-by: Serhiy Storchaka <storchaka@gmail.com>
* bpo-40784: Fix sqlite3 deterministic test (GH-20448)Miss Islington (bot)2020-05-291-9/+27
| | | | | (cherry picked from commit c610d970f5373b143bf5f5900d4645e6a90fb460) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
* bpo-39652: Truncate the column name after '[' only if PARSE_COLNAMES is set. ↵Serhiy Storchaka2020-03-212-4/+4
| | | | (GH-18942)
* bpo-38185: Fixed case-insensitive string comparison in sqlite3.Row indexing. ↵Serhiy Storchaka2019-09-171-7/+18
| | | | (GH-16190)
* bpo-38175: Fix a memory leak in comparison of sqlite3.Row objects. (GH-16155)Serhiy Storchaka2019-09-161-7/+21
|
* closes bpo-37347: Fix refcount problem in sqlite3. (GH-14268)gescheit2019-07-131-58/+13
|
* bpo-37406: sqlite3 raises TypeError for wrong operation type (GH-14386)Victor Stinner2019-06-262-3/+3
| | | | | The sqlite3 module now raises TypeError, rather than ValueError, if operation argument type is not str: execute(), executemany() and calling a connection.
* bpo-35504: Fix segfaults and SystemErrors when deleting certain attrs. ↵Zackery Spytz2018-12-171-0/+4
| | | | (GH-11175)
* bpo-32788: Better error handling in sqlite3. (GH-3723)Serhiy Storchaka2018-12-101-3/+25
| | | Propagate unexpected errors (like MemoryError and KeyboardInterrupt) to user.
* bpo-34052: Prevent SQLite functions from setting callbacks on exceptions. ↵Sergey Fedoseev2018-12-051-19/+64
| | | | (GH-8113)
* bpo-34041: Allow creating deterministic functions in ↵Sergey Fedoseev2018-07-081-0/+23
| | | | Connection.create_function() (GH-8086)
* Spelling fixes to docs, docstrings, and comments (GH-6374)Ville Skyttä2018-04-201-1/+1
|
* bpo-27645: Fix version number in 'database in transaction' fallback (GH-6131)Aviv Palivoda2018-03-181-3/+1
| | | It was actually fixed in SQLite 3.8.8, not 3.8.7.
* bpo-27645: Skip test_bad_target_in_transaction if SQLite == 3.8.7.1 (GH-6067)Berker Peksag2018-03-111-0/+2
|
* bpo-27645: Add support for native backup facility of SQLite (GH-4238)Emanuele Gaifas2018-03-101-0/+162
|
* Remove unused var from CheckCancelOperation test (GH-4317)Simon Willison2017-11-071-2/+0
| | | It looks like this was copied from one of the previous tests, which did use it.
* bpo-31843: sqlite3.connect() now accepts PathLike objects as database name ↵Anders Lorentsen2017-11-071-0/+11
| | | | (#4299)
* bpo-31764: Prevent a crash in sqlite3.Cursor.close() in case the Cursor ↵Oren Milman2017-11-071-0/+3
| | | | object is uninitialized (#3958)
* bpo-31770: Prevent a crash and refleaks when calling ↵Oren Milman2017-11-071-0/+18
| | | | sqlite3.Cursor.__init__() more than once (#3968)
* bpo-31370: Remove support for threads-less builds (#3385)Antoine Pitrou2017-09-071-5/+1
| | | | | | * Remove Setup.config * Always define WITH_THREAD for compatibility.
* bpo-26187: Test that set_trace_callback() is not called multiple times (GH-461)Aviv Palivoda2017-04-091-0/+20
| | | | | | conn.set_trace_callback() shouldn't be called multiple times when the schema is changing. This has indirectly been fixed by using sqlite3_prepare_v2() in bpo-9303.
* bpo-28518: Start a transaction implicitly before a DML statement (#245)Berker Peksag2017-02-261-0/+9
| | | Patch by Aviv Palivoda.
* Issue #29123: Merge from 3.5Berker Peksag2016-12-311-2/+1
|\
| * Issue #29123: Make CheckSqlTimestamp more robustBerker Peksag2016-12-311-2/+1
| |
* | Issue #27897: Fixed possible crash in sqlite3.Connection.create_collation()Serhiy Storchaka2016-09-261-0/+22
|\ \ | |/ | | | | if pass invalid string-like object as a name. Patch by Xiang Zhang.
| * Issue #27897: Fixed possible crash in sqlite3.Connection.create_collation()Serhiy Storchaka2016-09-261-0/+22
| | | | | | | | if pass invalid string-like object as a name. Patch by Xiang Zhang.
* | Issue #10740: sqlite3 no longer implicitly commit an open transaction before ↵Berker Peksag2016-09-111-8/+28
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* | Issue #21250: Merge from 3.5Berker Peksag2016-09-061-1/+100
|\ \ | |/
| * Issue #21250: Add tests for SQLite's ON CONFLICT clauseBerker Peksag2016-09-061-1/+100
| | | | | | | | Initial patch by Alex LordThorsen.
* | Issue #27881: Fixed possible bugs when setting ↵Serhiy Storchaka2016-09-011-4/+27
|\ \ | |/ | | | | | | | | sqlite3.Connection.isolation_level. Based on patch by Xiang Zhang.
| * Issue #27881: Fixed possible bugs when setting ↵Serhiy Storchaka2016-09-011-4/+27
| | | | | | | | | | | | sqlite3.Connection.isolation_level. Based on patch by Xiang Zhang.
* | Issue #27861: Fixed a crash in sqlite3.Connection.cursor() when a factorySerhiy Storchaka2016-08-291-3/+17
|\ \ | |/ | | | | creates not a cursor. Patch by Xiang Zhang.
| * Issue #27861: Fixed a crash in sqlite3.Connection.cursor() when a factorySerhiy Storchaka2016-08-291-3/+17
| | | | | | | | creates not a cursor. Patch by Xiang Zhang.
* | Issue #10513: Merge from 3.5Berker Peksag2016-08-261-0/+31
|\ \ | |/
| * Issue #10513: Fix a regression in Connection.commit()Berker Peksag2016-08-261-0/+31
| | | | | | | | | | | | Statements should not be reset after a commit. Backported from https://github.com/ghaering/pysqlite/commit/029050896b1e6058573abeef5a8970384c0c7faa
* | Issue #21718: Merge from 3.5Berker Peksag2016-08-211-1/+41
|\ \ | |/