Skip to content

gh-96168: Add sqlite3 row factory how-to #99507

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
erlend-aasland merged 17 commits into from
Nov 25, 2022
Merged

gh-96168: Add sqlite3 row factory how-to #99507

Changes from 1 commit
Commits
Show all changes
17 commits
Select commit Hold shift + click to select a range
e985bab
gh-96168: Add sqlite3 row factory how-to
erlend-aasland Nov 15, 2022
15d4b4e
Suggest reading the row factory how-to at the end of the tutorial
erlend-aasland Nov 15, 2022
f5f24b4
Fix named tuple example usage
erlend-aasland Nov 15, 2022
85c34bc
Fix _fields helper
erlend-aasland Nov 15, 2022
0e7ea3b
Fix expected output in namedtuple row factory doctest
erlend-aasland Nov 15, 2022
413dc24
Address reviews
erlend-aasland Nov 16, 2022
ab98877
Document Cursor.row_factory; tweak some sentences
erlend-aasland Nov 16, 2022
53d4ce4
Sync with main
erlend-aasland Nov 17, 2022
1aca9df
Address reviews
erlend-aasland Nov 17, 2022
1719d0d
Address parts of latest review
erlend-aasland Nov 17, 2022
e1dd69a
Adjust row equality sentence and remove the premature optimisation ex…
erlend-aasland Nov 22, 2022
d12f559
Reword reference and remove example from ab98877
erlend-aasland Nov 22, 2022
a277467
Address most of CAM's latest review
erlend-aasland Nov 23, 2022
cd12c6b
Address review
erlend-aasland Nov 23, 2022
86a2c43
Address reviews
erlend-aasland Nov 24, 2022
f9fa2ee
Split dict row factory example in two
erlend-aasland Nov 25, 2022
6f50503
Missed one
erlend-aasland Nov 25, 2022
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
Address reviews
  • Loading branch information
@erlend-aasland
erlend-aasland committed Nov 24, 2022
commit 86a2c43ad791f0b6e8b0487b58cc5eb0e6a216f6
9 changes: 6 additions & 3 deletions Doc/library/sqlite3.rst
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -1317,7 +1317,7 @@ Connection objects

.. attribute:: row_factory

The default :attr:`~Cursor.row_factory`
The initial :attr:`~Cursor.row_factory`
for :class:`Cursor` objects created from this connection.
Assigning to this attribute does not affect the :attr:`!row_factory`
of existing cursors belonging to this connection, only new ones.
Expand Down Expand Up @@ -2364,14 +2364,14 @@ so all cursors created from the connection will use the same row factory.
:class:`!Row` provides indexed and case-insensitive named access to columns,
with minimal memory overhead and performance impact over a :class:`!tuple`.
To use :class:`!Row` as a row factory,
simply assign it to the :attr:`Connection.row_factory` attribute:
assign it to the :attr:`!row_factory` attribute:

.. doctest::

>>> con = sqlite3.connect(":memory:")
>>> con.row_factory = sqlite3.Row

Query results are now returned as :class:`!Row` instances:
Queries now return :class:`!Row` objects:

.. doctest::

Expand All @@ -2386,6 +2386,9 @@ Query results are now returned as :class:`!Row` instances:
>>> row["RADIUS"] # Column names are case-insensitive.
6378

To create and use a custom :attr:`~Cursor.row_factory`,
in this case returning a :class:`dict` mapping column names to values:

.. doctest::
Comment thread
erlend-aasland marked this conversation as resolved.
Outdated

>>> def dict_factory(cursor, row):
Expand Down