importpytest
fromsqlobjectimport BLOBCol, SQLObject
fromsqlobject.compatimport PY2
fromsqlobject.tests.dbtestimport setupClass, supports
########################################
# BLOB columns
########################################
[docs]
classImageData(SQLObject):
image = BLOBCol(default=b'emptydata', length=256)
[docs]
deftest_BLOBCol():
if not supports('blobData'):
pytest.skip("blobData isn't supported")
setupClass(ImageData)
if PY2:
data = ''.join([chr(x) for x in range(256)])
else:
data = bytes(range(256))
prof = ImageData(image=data)
iid = prof.id
ImageData._connection.cache.clear()
prof2 = ImageData.get(iid)
assert prof2.image == data
ImageData(image=b'string')
assert ImageData.selectBy(image=b'string').count() == 1