diff options
author | Erlend Egeberg Aasland <erlend.aasland@innova.no> | 2022-07-29 07:40:44 (GMT) |
---|---|---|
committer | GitHub <noreply@github.com> | 2022-07-29 07:40:44 (GMT) |
commit | e9c8de669d40d993489981be2973d1ea5bd10d0c (patch) | |
tree | ab6dd6c431702b410e7b9912e1fe4ee5adb8b7cb | |
parent | 3e7cad3bca64ab213c66e2bd41c9d1cf1d057526 (diff) | |
download | cpython-e9c8de669d40d993489981be2973d1ea5bd10d0c.zip cpython-e9c8de669d40d993489981be2973d1ea5bd10d0c.tar.gz cpython-e9c8de669d40d993489981be2973d1ea5bd10d0c.tar.bz2 |
gh-95273: Condense sqlite3 executescript example (#95383)
-rw-r--r-- | Doc/includes/sqlite3/executescript.py | 25 | ||||
-rw-r--r-- | Doc/library/sqlite3.rst | 11 |
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() |