Zum Inhalt springen
Sie müssen registriert sein, um mit der Community zu interagieren.
Alle Beiträge Personen Abzeichen
Stichwörter (Alle anzeigen)
odoo accounting v14 pos v15
Über dieses Forum
Diese Frage wurde gekennzeichnet
pythonimagebinarypicturebytea
1 Antworten
9413 Ansichten
Avatar
Selverine

Hi everybody,

I would like to know if it possible to concert bytea picture into binary. I take the bytea into a field of the database and i want to "put" it into a binary field like this:

cr.execute('SELECT res_company.logo_web FROM res_company') res = cr.fetchall() v['logo_Print'] =base64.decodestring(str(res[0]))

But doesn't work.

Someone have some idea, please? How is possible to concert my "tuple" into a string and after binary?

Thanks a lot!

Selverine

Avatar
Verwerfen
Avatar
Andreas Brueckl
Beste Antwort

cr.fetchall() returns an array of arrays. If you cant to access the first column (logo_web) of the first row (I assume that there is only one row/company), then you have to use res[0][0].

Avatar
Verwerfen
Selverine
Autor

Hi Andreas, Thank you for your help. It works!

Verknüpfte Beiträge Antworten Ansichten Aktivität
Add a image (stored in database) in python/xml file Gelöst
python image xml picture
Avatar
Avatar
Avatar
3
März 15
21401
Unable to save a new, updated or duplicate stock item with an image in Odoo 10 Community
python error image
Avatar
0
Sept. 18
2742
Hello, I would like to know of any effective method that can help me compress the images that are uploaded to the site in a binary field and that they are saved compressed in my database.
python image method compression
Avatar
Avatar
1
Nov. 24
1043
Display an image field from different app
image custom binary product_images
Avatar
Avatar
2
Apr. 23
2958
How can we save binary Images into the filesysytem instead of database ? Gelöst
image filestore binary binaryfield
Avatar
Avatar
1
Dez. 22
5340