summaryrefslogtreecommitdiff
path: root/doc/examples/blob_with.py
blob: fff9037e898d4575d322c9d9ab36cfa2fad2439c (plain)
1
2
3
4
5
6
7
8
9
10
11
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"