diff options
author | Erlend Egeberg Aasland <erlend.aasland@innova.no> | 2021-05-19 07:41:19 (GMT) |
---|---|---|
committer | GitHub <noreply@github.com> | 2021-05-19 07:41:19 (GMT) |
commit | 92d1064727d6b7f4136f9c09ab52ae15e3676afe (patch) | |
tree | ae8bf88ce5406adf0d8fc2f0f64f8b20de077142 /Doc/includes/sqlite3/ctx_manager.py | |
parent | 901443757333a66ff2b5c85eba30dc1c48eac321 (diff) | |
download | cpython-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.py | 8 |
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 |