Insert binary data as array.array type to sqlite3 DB as BLOB in python

test_sqlite3_blob.py

import sqlite3
import array

a = array.array('B', [3, 1, 2,5,41,44,231,212,0,66,67,68])

b = buffer(a.tostring())

conn = sqlite3.connect ('test.db')
conn.execute ('create table if not exists test (id integer primary key, b blob)')

conn.execute ('delete from test')
conn.execute ('insert into test (b) values (?)', (b,))
conn.commit ()

cur = conn.cursor ()
cur.execute ('select b from test')
r = cur.fetchone()

print 'returned value', r[0].__class__
print 'matching', ("OK" if r[0] == b else "NG")