summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorErlend Egeberg Aasland <erlend.aasland@innova.no>2022-07-29 07:40:44 (GMT)
committerGitHub <noreply@github.com>2022-07-29 07:40:44 (GMT)
commite9c8de669d40d993489981be2973d1ea5bd10d0c (patch)
treeab6dd6c431702b410e7b9912e1fe4ee5adb8b7cb
parent3e7cad3bca64ab213c66e2bd41c9d1cf1d057526 (diff)
downloadcpython-e9c8de669d40d993489981be2973d1ea5bd10d0c.zip
cpython-e9c8de669d40d993489981be2973d1ea5bd10d0c.tar.gz
cpython-e9c8de669d40d993489981be2973d1ea5bd10d0c.tar.bz2
gh-95273: Condense sqlite3 executescript example (#95383)
-rw-r--r--Doc/includes/sqlite3/executescript.py25
-rw-r--r--Doc/library/sqlite3.rst11
2 files changed, 9 insertions, 27 deletions
diff --git a/Doc/includes/sqlite3/executescript.py b/Doc/includes/sqlite3/executescript.py
deleted file mode 100644
index aea8943..0000000
--- a/Doc/includes/sqlite3/executescript.py
+++ /dev/null
@@ -1,25 +0,0 @@
-import sqlite3
-
-con = sqlite3.connect(":memory:")
-cur = con.cursor()
-cur.executescript("""
- create table person(
- firstname,
- lastname,
- age
- );
-
- create table book(
- title,
- author,
- published
- );
-
- insert into book(title, author, published)
- values (
- 'Dirk Gently''s Holistic Detective Agency',
- 'Douglas Adams',
- 1987
- );
- """)
-con.close()
diff --git a/Doc/library/sqlite3.rst b/Doc/library/sqlite3.rst
index 545f679..1d44540 100644
--- a/Doc/library/sqlite3.rst
+++ b/Doc/library/sqlite3.rst
@@ -1007,9 +1007,16 @@ Cursor Objects
*sql_script* must be a :class:`string <str>`.
- Example:
+ Example::
- .. literalinclude:: ../includes/sqlite3/executescript.py
+ # cur is an sqlite3.Cursor object
+ cur.executescript("""
+ begin;
+ create table person(firstname, lastname, age);
+ create table book(title, author, published);
+ create table publisher(name, address);
+ commit;
+ """)
.. method:: fetchone()