summaryrefslogtreecommitdiff
path: root/Doc/includes/sqlite3/blob.py
diff options
context:
space:
mode:
Diffstat (limited to 'Doc/includes/sqlite3/blob.py')
-rw-r--r--Doc/includes/sqlite3/blob.py12
1 files changed, 12 insertions, 0 deletions
diff --git a/Doc/includes/sqlite3/blob.py b/Doc/includes/sqlite3/blob.py
new file mode 100644
index 0000000000..61994fb82d
--- /dev/null
+++ b/Doc/includes/sqlite3/blob.py
@@ -0,0 +1,12 @@
+import sqlite3
+
+con = sqlite3.connect(":memory:")
+con.execute("create table test(blob_col blob)")
+con.execute("insert into test(blob_col) values (zeroblob(10))")
+
+blob = con.blobopen("test", "blob_col", 1)
+blob.write(b"Hello")
+blob.write(b"World")
+blob.seek(0)
+print(blob.read()) # will print b"HelloWorld"
+blob.close()