Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 v15 pos
Over dit forum
Deze vraag is gerapporteerd
pythonimagebinarypicturebytea
1 Beantwoorden
9122 Weergaven
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
Annuleer
Avatar
Andreas Brueckl
Beste antwoord

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
Annuleer
Selverine
Auteur

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

Gerelateerde posts Antwoorden Weergaven Activiteit
Add a image (stored in database) in python/xml file Opgelost
python image xml picture
Avatar
Avatar
Avatar
3
mrt. 15
21185
Unable to save a new, updated or duplicate stock item with an image in Odoo 10 Community
python error image
Avatar
0
sep. 18
2563
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
796
Display an image field from different app
image custom binary product_images
Avatar
Avatar
2
apr. 23
2745
How can we save binary Images into the filesysytem instead of database ? Opgelost
image filestore binary binaryfield
Avatar
Avatar
1
dec. 22
5073