summaryrefslogtreecommitdiffstats
path: root/Doc/includes/sqlite3/ctx_manager.py
diff options
context:
space:
mode:
authorErlend Egeberg Aasland <erlend.aasland@innova.no>2021-05-19 07:41:19 (GMT)
committerGitHub <noreply@github.com>2021-05-19 07:41:19 (GMT)
commit92d1064727d6b7f4136f9c09ab52ae15e3676afe (patch)
treeae8bf88ce5406adf0d8fc2f0f64f8b20de077142 /Doc/includes/sqlite3/ctx_manager.py
parent901443757333a66ff2b5c85eba30dc1c48eac321 (diff)
downloadcpython-92d1064727d6b7f4136f9c09ab52ae15e3676afe.zip
cpython-92d1064727d6b7f4136f9c09ab52ae15e3676afe.tar.gz
cpython-92d1064727d6b7f4136f9c09ab52ae15e3676afe.tar.bz2
bpo-44106: Improve sqlite3 example database contents (GH-26027)
Diffstat (limited to 'Doc/includes/sqlite3/ctx_manager.py')
-rw-r--r--Doc/includes/sqlite3/ctx_manager.py8
1 files changed, 4 insertions, 4 deletions
diff --git a/Doc/includes/sqlite3/ctx_manager.py b/Doc/includes/sqlite3/ctx_manager.py
index 6db77d4..2e1175e 100644
--- a/Doc/includes/sqlite3/ctx_manager.py
+++ b/Doc/includes/sqlite3/ctx_manager.py
@@ -1,19 +1,19 @@
import sqlite3
con = sqlite3.connect(":memory:")
-con.execute("create table person (id integer primary key, firstname varchar unique)")
+con.execute("create table lang (id integer primary key, name varchar unique)")
# Successful, con.commit() is called automatically afterwards
with con:
- con.execute("insert into person(firstname) values (?)", ("Joe",))
+ con.execute("insert into lang(name) values (?)", ("Python",))
# con.rollback() is called after the with block finishes with an exception, the
# exception is still raised and must be caught
try:
with con:
- con.execute("insert into person(firstname) values (?)", ("Joe",))
+ con.execute("insert into lang(name) values (?)", ("Python",))
except sqlite3.IntegrityError:
- print("couldn't add Joe twice")
+ print("couldn't add Python twice")
# Connection object used as context manager only commits or rollbacks transactions,
# so the connection object should be closed manually