Re: [sqlalchemy] RAW SQL working on Postgres but not in SQLAlchemy

2019-03-27 Thread Scheck David
Thanks for the answer Mike, I'll use your advice. It was indeed a problem of wrong database config. Thanks for the answer. Le mar. 26 mars 2019 à 19:29, Piyush Nalawade a écrit : > Big thanks. Learned something new. > > On Tue, Mar 26, 2019, 11:24 PM Jonathan Vanasco > wrote: > >> >> >> On

[sqlalchemy] can't update images

2019-03-27 Thread Scheck David
Hi everyone, I try to update an attribute but it appears that it doesn't save. Would you know why ? it's very strange because the print is good. but when I query again this uri_reference it finds Nonetype. here is the command : ``` @contextlib.contextmanager def db_session(settings):

Re: [sqlalchemy] can't update images

2019-03-27 Thread Scheck David
it's ok, it's saving but what is strange is that my query doesn't find this records: this is my sql : sql = 'SELECT ss.id, ss.name, ss.image_metadata FROM (SELECT image.id, image.image_metadata, image.name, json_array_elements(image.uri_reference)::text as uri_ref FROM image) ss WHERE