summaryrefslogtreecommitdiff
path: root/doc/examples/blob_with.py
diff options
context:
space:
mode:
Diffstat (limited to 'doc/examples/blob_with.py')
-rw-r--r--doc/examples/blob_with.py12
1 files changed, 12 insertions, 0 deletions
diff --git a/doc/examples/blob_with.py b/doc/examples/blob_with.py
new file mode 100644
index 0000000..fff9037
--- /dev/null
+++ b/doc/examples/blob_with.py
@@ -0,0 +1,12 @@
+from pysqlcipher import dbapi2 as sqlite3
+con = sqlite3.connect(":memory:")
+# creating the table
+con.execute("create table test(id integer primary key, blob_col blob)")
+con.execute("insert into test(blob_col) values (zeroblob(10))")
+# opening blob handle
+with con.blob("test", "blob_col", 1, 1) as blob:
+ blob.write("a" * 5)
+ blob.write("b" * 5)
+ blob.seek(0)
+ print blob.read() # will print "aaaaabbbbb"
+