Re: [sqlalchemy] Multitenancy, filter selects, updates and deletes in do_orm_execute events

2020-12-27 Thread Frédéric CLEMENT
.statement = orm_execute_state.statement.options( with_loader_criteria( mapper.entity, mapper.entity.id.in_(rights), include_aliases=True ) ) return Le dimanche 27 décembre 2020 à 11:31:41 UTC+1, Frédéric CLEMENT a écrit : > Hi Mike, > Many thanks for your reply, giving a try to it as soon as it wil

Re: [sqlalchemy] Multitenancy, filter selects, updates and deletes in do_orm_execute events

2020-12-27 Thread Frédéric CLEMENT
uments['mapper'] > cls = mapper.class_ > > see if that works out and we will likely need to add an accessor that > guarantees being able to provide the target "mapper" and/or mappers for any > operation. > > > > > > On Wed, Dec 23, 2020, at 4:54

[sqlalchemy] Multitenancy, filter selects, updates and deletes in do_orm_execute events

2020-12-23 Thread Frédéric CLEMENT
Hi the list, Version 1.4Beta (hopefully 2.0 very soon) I am writing a multitenant application and I need to filter all requests using subqueries. I succeeded to do it for selects doing something like that : *for desc in orm_execute_state.statement.column_descriptions: t = desc['ty