[Python-checkins] Docs: improve sqlite3 placeholders example (#101092)
erlend-aasland
webhook-mailer at python.org
Wed Jan 18 04:36:48 EST 2023
https://github.com/python/cpython/commit/b84be8d9c0e6eca37be14c38250580251a3ef908
commit: b84be8d9c0e6eca37be14c38250580251a3ef908
branch: main
author: Erlend E. Aasland <erlend.aasland at protonmail.com>
committer: erlend-aasland <erlend.aasland at protonmail.com>
date: 2023-01-18T10:36:17+01:00
summary:
Docs: improve sqlite3 placeholders example (#101092)
files:
M Doc/library/sqlite3.rst
diff --git a/Doc/library/sqlite3.rst b/Doc/library/sqlite3.rst
index ba72b96c6741..8796bdfc0b6f 100644
--- a/Doc/library/sqlite3.rst
+++ b/Doc/library/sqlite3.rst
@@ -1958,19 +1958,18 @@ Here's an example of both styles:
con = sqlite3.connect(":memory:")
cur = con.execute("CREATE TABLE lang(name, first_appeared)")
- # This is the qmark style:
- cur.execute("INSERT INTO lang VALUES(?, ?)", ("C", 1972))
-
- # The qmark style used with executemany():
- lang_list = [
- ("Fortran", 1957),
- ("Python", 1991),
- ("Go", 2009),
- ]
- cur.executemany("INSERT INTO lang VALUES(?, ?)", lang_list)
-
- # And this is the named style:
- cur.execute("SELECT * FROM lang WHERE first_appeared = :year", {"year": 1972})
+ # This is the named style used with executemany():
+ data = (
+ {"name": "C", "year": 1972},
+ {"name": "Fortran", "year": 1957},
+ {"name": "Python", "year": 1991},
+ {"name": "Go", "year": 2009},
+ )
+ cur.executemany("INSERT INTO lang VALUES(:name, :year)", data)
+
+ # This is the qmark style used in a SELECT query:
+ params = (1972,)
+ cur.execute("SELECT * FROM lang WHERE first_appeared = ?", params)
print(cur.fetchall())
.. testoutput::
More information about the Python-checkins
mailing list