Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
pythonimagebinarypicturebytea
1 Vastaa
10544 Näkymät
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
Hylkää
Avatar
Andreas Brueckl
Paras vastaus

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
Hylkää
Selverine
Tekijä

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

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
Add a image (stored in database) in python/xml file Ratkaistu
python image xml picture
Avatar
Avatar
Avatar
3
maalisk. 15
23097
Unable to save a new, updated or duplicate stock item with an image in Odoo 10 Community
python error image
Avatar
0
syysk. 18
3736
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
marrask. 24
2127
Display an image field from different app
image custom binary product_images
Avatar
Avatar
2
huhtik. 23
4144
How can we save binary Images into the filesysytem instead of database ? Ratkaistu
image filestore binary binaryfield
Avatar
Avatar
1
jouluk. 22
6717