Description

assignee = None
closed_at = None
created_at = <Date 2022-02-16.11:16:39.049>
labels = ['3.7', '3.8', '3.9', '3.10', '3.11', 'type-feature', 'library']
title = '[Doc] sqlite3 Cursor.execute() return value is unspecified'
updated_at = <Date 2022-02-16.14:38:06.489>
user = 'https://github.com/kephas'

activity = <Date 2022-02-16.14:38:06.489>
actor = 'erlendaasland'
assignee = 'none'
closed = False
closed_date = None
closer = None
components = ['Library (Lib)']
creation = <Date 2022-02-16.11:16:39.049>
creator = 'kephas'
dependencies = []
files = []
hgrepos = []
issue_num = 46767
keywords = []
message_count = 2.0
messages = ['413327', '413332']
nosy_count = 2.0
nosy_names = ['erlendaasland', 'kephas']
pr_nums = []
priority = 'normal'
resolution = None
stage = None
status = 'open'
superseder = None
type = 'enhancement'
url = 'https://bugs.python.org/issue46767'
versions = ['Python 3.7', 'Python 3.8', 'Python 3.9', 'Python 3.10', 'Python 3.11']

Activity

1. kephas commented on Feb 16, 2022

   

   kephasmannequin

   on Feb 16, 2022

   MannequinAuthor

   More actions

   In the documentation of the sqlite3 module, the return value for Connection.execute() is told to be the Cursor that was implicitly created, but nothing is said about the return value/type when using Cursor.execute().
2. kephas

   added

   3.7 (EOL)end of lifeend of life

   3.8 (EOL)end of lifeend of life

   3.9 (EOL)end of lifeend of life

   3.10 (EOL)end of lifeend of life

   3.11only security fixesonly security fixes

   stdlibStandard Library Python modules in the Lib/ directoryStandard Library Python modules in the Lib/ directory

   type-featureA feature request or enhancementA feature request or enhancement

   on Feb 16, 2022
3. erlend-aasland commented on Feb 16, 2022

   

   erlend-aasland

   on Feb 16, 2022

   Contributor

   More actions

   Quoting the docs:

   This is a nonstandard shortcut that creates a cursor object by calling the
   cursor() method, calls the cursor’s execute() method with the parameters
   given, and returns the cursor.

   There is already a backlink (or back reference) to the Connection.cursor() method, which again has a backlink to the Cursor class. What would you suggest to make things clearer?

   How about the following rewording:

   "[...] and returns the newly created cursor object".

   (IMO this is too verbose; I'm fine with the current docs.)
4. ezio-melotti

   transferred this issue fromon Apr 10, 2022
5. erlend-aasland

   added

   docsDocumentation in the Doc dirDocumentation in the Doc dir

   and removed

   type-featureA feature request or enhancementA feature request or enhancement

   on Apr 17, 2022
6. erlend-aasland commented on Apr 17, 2022

   

   erlend-aasland

   on Apr 17, 2022

   Contributor

   More actions

   After re-reading the current docs, I think a rewording might be helpful. I'll see if I can make things a little bit clearer.
7. erlend-aasland

   added a commit that references this issue on Apr 17, 2022

   pythongh-90923: Improve sqlite3.Connection.execute* docs

   0a48dd6
8. AlexWaygood

   removed

   3.8 (EOL)end of lifeend of life

   3.7 (EOL)end of lifeend of life

   on Apr 17, 2022
9. JelleZijlstra

   closed this as completedin #91643on Apr 17, 2022
10. JelleZijlstra

    added a commit that references this issue on Apr 17, 2022

    gh-90923: Improve sqlite3.Connection.execute* docs (#91643)

    017f07a
11. miss-islington

    added 3 commits that reference this issue on Apr 17, 2022

    pythongh-90923: Improve sqlite3.Connection.execute* docs (pythonGH-91643

    4dfd05f

    gh-90923: Improve sqlite3.Connection.execute* docs (GH-91643)

    2bcfe20

    gh-90923: Improve sqlite3.Connection.execute* docs (GH-91643)

    833ff16
12. erlend-aasland

    added

    topic-sqlite3

    on May 16, 2022
13. hello-adam

    added a commit that references this issue on Jun 2, 2022

    pythongh-90923: Improve sqlite3.Connection.execute* docs (pythonGH-91643

    21a92d3

Issue actions