Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
pythonimagebinarypicturebytea
1 Odgovori
9790 Prikazi
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
Opusti
Avatar
Andreas Brueckl
Best Answer

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
Opusti
Selverine
Avtor

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

Related Posts Odgovori Prikazi Aktivnost
Add a image (stored in database) in python/xml file Solved
python image xml picture
Avatar
Avatar
Avatar
3
mar. 15
21935
Unable to save a new, updated or duplicate stock item with an image in Odoo 10 Community
python error image
Avatar
0
sep. 18
3049
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
1424
Display an image field from different app
image custom binary product_images
Avatar
Avatar
2
apr. 23
3268
How can we save binary Images into the filesysytem instead of database ? Solved
image filestore binary binaryfield
Avatar
Avatar
1
dec. 22
5771