MySQLdb blob and binary data

[Rune Hansen]

I'm storing gzipped data in a MySQL blob field. I can fetch the blob and
"wb" write the data to a file. It becomes a file containg gz data.

I can't take the same data and do anything sensible with it in python -
like say zlib.decompress(data).

How can I convert the binary data from the blob field to the gzipped
string it was stored as (java stores the string, Pickle is not an option)?

regards

/rune

 

[Denis S. Otkidach]

I'm storing gzipped data in a MySQL blob field. I can fetch the blob and
"wb" write the data to a file. It becomes a file containg gz data.

I can't take the same data and do anything sensible with it in python -
like say zlib.decompress(data).

How can I convert the binary data from the blob field to the gzipped
string it was stored as (java stores the string, Pickle is not an option)?

You can pass any file-like object to GzipFile class:

from gzip import GzipFile
from cStringIO import StringIO
GzipFile(fileobj=StringIO(data)).read()