from sqlobject import *
from dbtest import *

########################################
## BLOB columns
########################################

class ImageData(SQLObject):
    image = BlobCol(default='emptydata', length=65535)

def test_BLOBCol():
    if not supports('blob_data'):
        return
    
    setup_class(ImageData)

    data = ''.join([chr(x) for x in range(256)])

    prof = ImageData()
    prof.image = data
    iid = prof.id

    prof2 = ImageData.get(iid)
    assert prof2.image == data