summaryrefslogtreecommitdiffstats
path: root/Doc/library/sqlite3.rst
Commit message (Collapse)AuthorAgeFilesLines
* 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)
* gh-98716: Revert gh-96081: Escape lone stars in sqlite3 docs (#98720)Erlend E. Aasland2022-10-261-5/+5
|
* gh-97661: Improve accuracy of sqlite3.Cursor.fetchone docs (#97662)Jia Junjie2022-10-051-1/+3
| | | Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* gh-96810: Clarify for which statements sqlite3 implicitly opens transactions ↵Erlend E. Aasland2022-09-151-1/+2
| | | | (#96832)
* gh-96702: Order methods before attrs in sqlite3.Connection docs (#96703)Erlend E. Aasland2022-09-131-97/+96
|
* Docs: alphabetically order sqlite3.Cursor attrs (#96565)Erlend E. Aasland2022-09-041-30/+31
|
* gh-96168: Improve sqlite3 dict_factory example (#96457)Erlend E. Aasland2022-09-011-18/+9
| | | | Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM> Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
* gh-96414: Inline code examples in sqlite3 docs (#96442)Erlend E. Aasland2022-08-311-14/+380
|
* Docs: normalise sqlite3 placeholder how-to heading (#96413)Erlend E. Aasland2022-08-301-2/+2
|
* Docs: normalize SQL style in sqlite3 docs (#96403)Erlend E. Aasland2022-08-291-7/+7
|
* gh-95432: Add doctests for the sqlite3 docs (#96225)Erlend E. Aasland2022-08-291-64/+125
| | | | | | | 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
* gh-94635: Frame sqlite3 how-to headings as such & move default adapters to ↵C.A.M. Gerlach2022-08-241-48/+48
| | | | | | reference (#96136) Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com> Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
* gh-96096: Add undocumented SQLITE_OK/DENY/IGNORE sqlite3 constants (#96134)C.A.M. Gerlach2022-08-231-4/+14
| | | | Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com> Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
* gh-95432: Add doctest for sqlite3 tutorial (#96193)Erlend E. Aasland2022-08-231-16/+47
|
* gh-96121: Merge sqlite3.Row examples into sqlite3.Row class doc (#96122)Erlend E. Aasland2022-08-221-56/+18
| | | | Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com> Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
* Docs: Fix markup of module name in sqlite3 docs (#96115)Erlend E. Aasland2022-08-191-3/+3
|
* Doc: Use consistent markup for example Point class in sqlite3 (#96095)C.A.M. Gerlach2022-08-191-3/+3
|
* Docs: group sqlite3.Connection attributes and methods (#96090)Erlend E. Aasland2022-08-191-39/+37
|
* gh-94635: Remove sqlite3 doc introduction heading (#96089)Erlend E. Aasland2022-08-191-3/+0
|
* Docs: Escape lone stars in sqlite3 docs (#96081)Erlend E. Aasland2022-08-181-5/+5
|
* gh-95271: Rework sqlite3 tutorial (#95749)Erlend E. Aasland2022-08-181-50/+138
| | | | Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM> Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
* gh-95273: Improve sqlite3.complete_statement docs (#95840)Erlend E. Aasland2022-08-111-6/+17
| | | | Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com> Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>
* gh-95273: Reorganize sqlite3 doc module level funcs and vars (#95626)Erlend E. Aasland2022-08-081-158/+156
| | | | Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com> Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>
* gh-94635: Fixup sqlite3 'Introduction' seealso note (#95751)Erlend E. Aasland2022-08-061-12/+12
| | | | In gh-95269, the seealso note incorrectly ended up in the 'Tutorial' section.
* Docs: sqlite3 docs fixup (#95681)Erlend Egeberg Aasland2022-08-041-28/+28
| | | | | - Disable links to the module itself - Fix link indent - Consistent ref markup
* gh-95271: Extract placeholders howto from sqlite3 tutorial (#95522)Erlend Egeberg Aasland2022-08-041-26/+38
| | | | Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM> Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
* gh-95273: Improve documented return values and exceptions raised for sqlite3 ↵Erlend Egeberg Aasland2022-08-041-62/+72
| | | | | | class methods (#95530) Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com> Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com>
* Docs: fix two typos in the sqlite3 docs (#95661)ceh2022-08-041-2/+2
| | | | - statment => statement - transaciton => transaction
* gh-95273: Align sqlite3 const doc refs with the devguide recommendations ↵Erlend Egeberg Aasland2022-08-031-39/+39
| | | | (#95525)
* Docs: fix incorrect formatting in sqlite3 CLI docs (#95581)Erlend Egeberg Aasland2022-08-021-2/+4
|
* gh-77617: Add sqlite3 command-line interface (#95026)Erlend Egeberg Aasland2022-08-011-0/+20
| | | Co-authored-by: Serhiy Storchaka <storchaka@gmail.com>
* gh-95273: Clarify when sqlite_* attributes are added to sqlite3 exceptions ↵Erlend Egeberg Aasland2022-08-011-0/+3
| | | | (#95523)
* gh-94635: Add Reference, How-to, and Concepts headings to sqlite3 docs (#94636)Erlend Egeberg Aasland2022-07-301-98/+120
| | | Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>
* gh-95273: Relocate sqlite3 enable load extension note (#95430)Erlend Egeberg Aasland2022-07-291-12/+8
|
* gh-95432: Fixup sqlite3 tutorial example (#95431)Erlend Egeberg Aasland2022-07-291-5/+5
| | | | - the insert statement should have five placeholders, not four - missing ... in the multiline row list
* gh-95273: Improve sqlite3 class descriptions (#95379)Erlend Egeberg Aasland2022-07-291-8/+34
| | | Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>
* gh-95273: Move sqlite3 executemany examples from reference to tutorial (#95351)Erlend Egeberg Aasland2022-07-291-11/+26
|
* gh-95273: Condense sqlite3 executescript example (#95383)Erlend Egeberg Aasland2022-07-291-2/+9
|
* Docs: Fix refs & tweak wording in sqlite3 'Using shortcut methods'Erlend Egeberg Aasland2022-07-281-2/+3
| | | Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>