summaryrefslogtreecommitdiffstats
path: root/Doc/includes/sqlite3/text_factory.py
diff options
context:
space:
mode:
authorErlend E. Aasland <erlend.aasland@protonmail.com>2022-08-31 05:54:54 (GMT)
committerGitHub <noreply@github.com>2022-08-31 05:54:54 (GMT)
commitf7e7bf161aaec5a5cffdcec7c97e1f09e445421b (patch)
treee9d339cca5899de4dd2fed407baad75af2631d96 /Doc/includes/sqlite3/text_factory.py
parent8ba22b90cafdf83d26318905a021311c6932d2c0 (diff)
downloadcpython-f7e7bf161aaec5a5cffdcec7c97e1f09e445421b.zip
cpython-f7e7bf161aaec5a5cffdcec7c97e1f09e445421b.tar.gz
cpython-f7e7bf161aaec5a5cffdcec7c97e1f09e445421b.tar.bz2
gh-96414: Inline code examples in sqlite3 docs (#96442)
Diffstat (limited to 'Doc/includes/sqlite3/text_factory.py')
-rw-r--r--Doc/includes/sqlite3/text_factory.py29
1 files changed, 0 insertions, 29 deletions
diff --git a/Doc/includes/sqlite3/text_factory.py b/Doc/includes/sqlite3/text_factory.py
deleted file mode 100644
index c0d87cd..0000000
--- a/Doc/includes/sqlite3/text_factory.py
+++ /dev/null
@@ -1,29 +0,0 @@
-import sqlite3
-
-con = sqlite3.connect(":memory:")
-cur = con.cursor()
-
-AUSTRIA = "Österreich"
-
-# by default, rows are returned as str
-cur.execute("select ?", (AUSTRIA,))
-row = cur.fetchone()
-assert row[0] == AUSTRIA
-
-# but we can make sqlite3 always return bytestrings ...
-con.text_factory = bytes
-cur.execute("select ?", (AUSTRIA,))
-row = cur.fetchone()
-assert type(row[0]) is bytes
-# the bytestrings will be encoded in UTF-8, unless you stored garbage in the
-# database ...
-assert row[0] == AUSTRIA.encode("utf-8")
-
-# we can also implement a custom text_factory ...
-# here we implement one that appends "foo" to all strings
-con.text_factory = lambda x: x.decode("utf-8") + "foo"
-cur.execute("select ?", ("bar",))
-row = cur.fetchone()
-assert row[0] == "barfoo"
-
-con.close()