At last here is the solution to resize images on bytea columns with
plpythonu
Thanks to all especially to Adrian
CREATE OR REPLACE FUNCTION public.ajustar(randstring bytea)
RETURNS bytea
LANGUAGE plpythonu
AS $function$
from io import BytesIO
import PIL
from PIL import Image
basewidth = 300
mem_file = BytesIO()
mem_file.write(randstring)
img = Image.open(mem_file)
wpercent = (basewidth/float(img.size[0]))
hsize = int((float(img.size[1])*float(wpercent)))
img = img.resize((basewidth,hsize), PIL.Image.ANTIALIAS)
salida = io.BytesIO
img.save(salida, format='JPEG')
hex_data = output.getvalue()
img.close()
return hex_data
$function$
And here is how to resize all images from database:
update personal set foto=ajustar(foto) where foto is not null;
2016-10-20 19:48 GMT-05:00 Nahum Castro <nahumcas...@gmail.com>:
> As far as I know the process to resize the image is:
>
> read(bytea) -> load_to_memory(image) -> resize(image) ->
> recode_to_bytea(image) -> store(bytea)
>
> You helped me with the first two.
>
> When I run the function ajustar(image)
> update personal set image=ajustar(image)
>
> I tried to do a direct resizing from bytea but python can't understand the
> hexadecimal data from bytea as an jpeg image. Though I tried with with
> plpython2u.
> Thanks
>
> 2016-10-20 19:00 GMT-05:00 Adrian Klaver <adrian.kla...@aklaver.com>:
>
>> On 10/20/2016 04:51 PM, Nahum Castro wrote:
>>
>>> Hello Adrian.
>>>
>>> The result image to replace the big one.
>>>
>>
>> So if you are replacing the data in a bytea column with a function that
>> returns bytea, why encode it?
>>
>> Unless I am missing something why not just UPDATE with the raw(bytea)
>> return value?
>>
>>
>>> I have a table with images @ 12K but, went on vacation an when returned
>>> someone replaced the pictures with high resolution images @6M. The app
>>> then become very slow and halted.
>>>
>>> I have already made the script in python to resize all the images from a
>>> folder before to upload to the database, so it occurred to me do the
>>> same but on the database.
>>>
>>> Thanks again.
>>>
>>> 2016-10-20 18:32 GMT-05:00 Adrian Klaver <adrian.kla...@aklaver.com
>>> <mailto:adrian.kla...@aklaver.com>>:
>>>
>>> On 10/20/2016 02:42 PM, Nahum Castro wrote:
>>>
>>> Hello,
>>>
>>> The script always returns.
>>> select encode(ajustar(foto), 'escape') from personal where
>>> id=193;
>>> encode
>>> ------------------------------------------------------------
>>> -----
>>> <PIL.Image.Image image mode=RGB size=300x347 at 0x7F08A11B1650>
>>>
>>>
>>>
>>> So what do you want it to return a where do you want to return?
>>>
>>>
>>> --
>>> Adrian Klaver
>>> adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
>>>
>>>
>>>
>>>
>>> --
>>> *Nahum Castro González*
>>> Blvd. Perdigón 214, Brisas del Lago.
>>> CP 37207
>>> León, Guanajuato, México
>>> Tel (477)1950304
>>> Cel (477)1274694
>>>
>>
>>
>> --
>> Adrian Klaver
>> adrian.kla...@aklaver.com
>>
>
>
>
> --
> *Nahum Castro González*
> Blvd. Perdigón 214, Brisas del Lago.
> CP 37207
> León, Guanajuato, México
> Tel (477)1950304
> Cel (477)1274694
>
--
*Nahum Castro González*
Blvd. Perdigón 214, Brisas del Lago.
CP 37207
León, Guanajuato, México
Tel (477)1950304
Cel (477)1274694
