delta/cpython-git.git/Modules/_sqlite, branch 3.10 github.com: python/cpython.git [3.10] gh-94321: Document sqlite3.PrepareProtocol (GH-94620) (#94671) 2022-07-07T23:44:09+00:00 Erlend Egeberg Aasland erlend.aasland@protonmail.com 2022-07-07T23:44:09+00:00 797745e749d06d7854605b184892dc07572d84bd (cherry picked from commit fb6dccae348b954d9f625031b54711a9a33da525) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com> 
(cherry picked from commit fb6dccae348b954d9f625031b54711a9a33da525)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>
 [3.10] gh-90016: Reword sqlite3 adapter/converter docs (GH-93095) (#94273) 2022-06-25T20:55:38+00:00 Erlend Egeberg Aasland erlend.aasland@protonmail.com 2022-06-25T20:55:38+00:00 deb4d0457ff368141a8939de6b06edc04621e831 Also add adapters and converter recipes. Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM> Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com. (cherry picked from commit bd3c1c187e0e4fde5aec6835d180e9eddde8ceb6) 
Also add adapters and converter recipes.

Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>
Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com.
(cherry picked from commit bd3c1c187e0e4fde5aec6835d180e9eddde8ceb6)
 [3.10] gh-93925: Improve clarity of sqlite3 commit/rollback, and close docs (GH-93926) (#94011) 2022-06-19T19:43:03+00:00 Erlend Egeberg Aasland erlend.aasland@innova.no 2022-06-19T19:43:03+00:00 c4440e6bc0d116a0dc7dfc1714bd2f5d3fee751e Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>. (cherry picked from commit 6446592c89b0c581c00e170ae6278291e940755c) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no> 
Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>.
(cherry picked from commit 6446592c89b0c581c00e170ae6278291e940755c)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
 [3.10] gh-79579: Improve DML query detection in sqlite3 (GH-93623) (#93801) 2022-06-14T13:05:36+00:00 Erlend Egeberg Aasland erlend.aasland@innova.no 2022-06-14T13:05:36+00:00 2229d34a6ef9c03e476882f46bba4d7c83552d1e The fix involves using pysqlite_check_remaining_sql(), not only to check for multiple statements, but now also to strip leading comments and whitespace from SQL statements, so we can improve DML query detection. pysqlite_check_remaining_sql() is renamed lstrip_sql(), to more accurately reflect its function, and hardened to handle more SQL comment corner cases. (cherry picked from commit 46740073ef32bf83964c39609c7a7a4772c51ce3) 
The fix involves using pysqlite_check_remaining_sql(), not only to check
for multiple statements, but now also to strip leading comments and
whitespace from SQL statements, so we can improve DML query detection.

pysqlite_check_remaining_sql() is renamed lstrip_sql(), to more
accurately reflect its function, and hardened to handle more SQL comment
corner cases.

(cherry picked from commit 46740073ef32bf83964c39609c7a7a4772c51ce3)
 [3.10] gh-93421: Update sqlite3 cursor.rowcount only after SQLITE_DONE (GH-93526) (GH-93599) 2022-06-08T11:31:14+00:00 Erlend Egeberg Aasland erlend.aasland@protonmail.com 2022-06-08T11:31:14+00:00 9cc0afcb8782c22575fa91756c54029c7e774dfb (cherry picked from commit 875de61) 
(cherry picked from commit 875de61)
 [3.10] gh-80254: Disallow recursive usage of cursors in `sqlite3` converters (#92274) 2022-05-05T19:46:21+00:00 Erlend Egeberg Aasland erlend.aasland@protonmail.com 2022-05-05T19:46:21+00:00 2a2421e538f9f7ceb419074909a313ba2c46f384 * [3.10] gh-80254: Disallow recursive usage of cursors in `sqlite3` converters (#29054) (cherry picked from commit f629dcfe835e349433e4c5099381d668e8fe69c8) 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 
* [3.10] gh-80254: Disallow recursive usage of cursors in `sqlite3` converters (#29054)

(cherry picked from commit f629dcfe835e349433e4c5099381d668e8fe69c8)

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
 [3.10] gh-89301: Fix regression with bound values in traced SQLite statements (#92147) 2022-05-02T16:21:13+00:00 Erlend Egeberg Aasland erlend.aasland@protonmail.com 2022-05-02T16:21:13+00:00 178d79ae67848e129958172e8a9ca4838f8503b9 (cherry picked from commit 721aa96540bb96700f8c4bab0b4095b43491dca1) 
(cherry picked from commit 721aa96540bb96700f8c4bab0b4095b43491dca1)
 [3.10] sqlite3: normalise pre-acronym determiners (GH-31772) (GH-31806) 2022-03-12T01:10:55+00:00 Jelle Zijlstra jelle.zijlstra@gmail.com 2022-03-12T01:10:55+00:00 d8ba5c102c54a5f0944638df4b6cda689faba7fa For consistency, replace "a SQL" with "an SQL".. (cherry picked from commit 2d5835a019a46573d5b1b614c8ef88d6b564d8d4) Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no> 
For consistency, replace "a SQL" with "an SQL"..
(cherry picked from commit 2d5835a019a46573d5b1b614c8ef88d6b564d8d4)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
[3.10] Docstring: replace pysqlite with sqlite3 (GH-31758) (GH-31777) 2022-03-09T18:19:27+00:00 Jelle Zijlstra jelle.zijlstra@gmail.com 2022-03-09T18:19:27+00:00 5dfe9817912cd020389f3e15e6d5ea98b08a543f 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> 
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.10] bpo-46878: Purge 'non-standard' from sqlite3 docstrings (GH-31612) (GH-31753) 2022-03-08T15:30:14+00:00 Erlend Egeberg Aasland erlend.aasland@innova.no 2022-03-08T15:30:14+00:00 f3d3b2d5c5599272660f4bbd5103aa8abc7c48c4 (cherry picked from commit 4d95fa1ac5d31ff450fb2f31b55ce1eb99d6efcb) 
(cherry picked from commit 4d95fa1ac5d31ff450fb2f31b55ce1eb99d6efcb)