Converting a zip file to bytea to store in postgres - python

Question

I would like to store zip files in a postgres database using python.

It seems like this should be easy, but I can't work it out.

This is what I've tried - my issue is how to convert the zipfile to a bytea object.

from zipfile import ZipFile
from io import BytesIO, StringIO


filename = "test.zip"
with ZipFile(filename, 'w') as zip_archive:
    binary_stream = BytesIO(zip_archive)

def store_blob(filename, blob):
    with db.engine.connect() as connection:
        res = connection.execute('''INSERT INTO test (filename, model_file) VALUES (%s,                     %s)''', (filename, blob ))


store_blob(filename, binary_stream)

attempting to convert to bytea - is there a way of doing that without opening it? — yahop19531
– yahop19531, Commented Jul 28, 2020 at 16:48
What is the actual error that you are observing? If you add an error message or stacktrace, there are more chances to correctly diagnose the problem. — Juanda
– Juanda, Commented Jul 28, 2020 at 17:41

Mike Organek · Accepted Answer · 2020-07-28 16:55:22Z

1

If the file already exists, then your code should look like this:

def store_blob(filename, blob):
    with db.engine.connect() as connection:
        res = connection.execute(
             '''INSERT INTO test (filename, model_file) VALUES (%s,%s)''', 
             (filename, blob ))

filename = "test.zip"
with open(filename, 'rb') as zip_archive:
    store_blob(filename, zip_archive.read())

Your code does not need to know about the format of the file. All you want to do is to open it for read with the binary flag to prevent decoding, and pass its read() (which produces a b'') as a parameter to the execute()

answered Jul 28, 2020 at 16:55

Mike Organek

12.6k3 gold badges15 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jaimish11 · Accepted Answer · 2020-07-28 17:08:41Z

0

I believe there's an accepted answer here already Storing Zip file in Postgres

You can use the bin2hex() function as demonstrated in the above answer.

Info on postgres bytea datatypes: https://www.postgresql.org/docs/current/datatype-binary.html#AEN5318

answered Jul 28, 2020 at 17:08

jaimish11

5645 silver badges18 bronze badges

1 Comment

JJ Ward Over a year ago

OP asked specifically about python implementation, not php.

Collectives™ on Stack Overflow

Converting a zip file to bytea to store in postgres - python

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related