From 91f40f3f78d6016a283989e32ec3d1fb61bcebca Mon Sep 17 00:00:00 2001 From: "Erlend E. Aasland" Date: Thu, 1 Sep 2022 23:47:59 +0200 Subject: gh-96168: Improve sqlite3 dict_factory example (#96457) Co-authored-by: C.A.M. Gerlach Co-authored-by: Ezio Melotti --- Doc/library/sqlite3.rst | 27 +++++++++------------------ 1 file changed, 9 insertions(+), 18 deletions(-) diff --git a/Doc/library/sqlite3.rst b/Doc/library/sqlite3.rst index 7ac7162..b188ca4 100644 --- a/Doc/library/sqlite3.rst +++ b/Doc/library/sqlite3.rst @@ -601,25 +601,16 @@ Connection objects Example: - .. testcode:: - - def dict_factory(cursor, row): - d = {} - for idx, col in enumerate(cursor.description): - d[col[0]] = row[idx] - return d - - con = sqlite3.connect(":memory:") - con.row_factory = dict_factory - cur = con.execute("SELECT 1 AS a") - print(cur.fetchone()["a"]) - - con.close() - - .. testoutput:: - :hide: + .. doctest:: - 1 + >>> def dict_factory(cursor, row): + ... col_names = [col[0] for col in cursor.description] + ... return {key: value for key, value in zip(col_names, row)} + >>> con = sqlite3.connect(":memory:") + >>> con.row_factory = dict_factory + >>> for row in con.execute("SELECT 1 AS a, 2 AS b"): + ... print(row) + {'a': 1, 'b': 2} If returning a tuple doesn't suffice and you want name-based access to columns, you should consider setting :attr:`row_factory` to the -- cgit v0.12