How to store binary data in pewee BlobField

Question

How can I store binary data io.BytesIO() in SQLlite DB using peewee?

When I try to store it in BlobField I'm getting following error:

ValueError: Value must be either a bytes, memoryview or BigBitFieldData instance.

It appears that you're not using `BlobField` but are using `BigBitField` instead. — coleifer, Mar 26 '18 at 19:37

score 4 · Accepted Answer · edited Sep 19 '22 at 17:50

4

It appears that you're not actually using a BlobField. However, to store data from a BytesIO object into an actual BlobField, you can:

# io.BytesIO.getvalue() method should return bytes.
some_model.blob_field = bytesio_obj.getvalue()

edited Sep 19 '22 at 17:50

smartexpert

answered Mar 26 '18 at 19:39

coleifer

score -2 · Answer 2 · answered Sep 24 '20 at 21:26

Building on the author's answer, I am putting a more end-to-end example here for people who aren't familiar with this the io

with open("file.parquet.gzip", "rb") as f:
    bytesio_obj = io.BytesIO(f.read())
    binary = bytesio_obj.getvalue()

some_model.blob_field = binary

2 Answers2