summaryrefslogtreecommitdiffstats
path: root/Doc/includes/sqlite3/createdb.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/createdb.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/createdb.py')
-rw-r--r--Doc/includes/sqlite3/createdb.py10
1 files changed, 5 insertions, 5 deletions
diff --git a/Doc/includes/sqlite3/createdb.py b/Doc/includes/sqlite3/createdb.py
index ee2950b..4970212 100644
--- a/Doc/includes/sqlite3/createdb.py
+++ b/Doc/includes/sqlite3/createdb.py
@@ -12,15 +12,15 @@ if os.path.exists(DB_FILE):
con = sqlite3.connect(DB_FILE)
cur = con.cursor()
cur.execute("""
- create table people
+ create table lang
(
- name_last varchar(20),
- age integer
+ name varchar(20),
+ first_appeared integer
)
""")
-cur.execute("insert into people (name_last, age) values ('Yeltsin', 72)")
-cur.execute("insert into people (name_last, age) values ('Putin', 51)")
+cur.execute("insert into lang (name, first_appeared) values ('Forth', 1970)")
+cur.execute("insert into lang (name, first_appeared) values ('Ada', 1980)")
con.commit()