Re: [sqlalchemy] Help translating query to sqlalchemy

2018-11-19 Thread Mike Bayer
On Mon, Nov 19, 2018 at 11:02 PM wrote: > > Hi everyone, > > I started with sqlalchemy a couple of weeks ago and I still have plenty to > learn. I'm trying to translate this query to the expression language, but I > have not been able to get what I need (right now I'm using text): the ARRAY() c

[sqlalchemy] Help translating query to sqlalchemy

2018-11-19 Thread jonathan . sandoval
Hi everyone, I started with sqlalchemy a couple of weeks ago and I still have plenty to learn. I'm trying to translate this query to the expression language, but I have not been able to get what I need (right now I'm using text): SELECT p.id, p.title, ( SELECT ARRAY(SELECT t.title FROM tags_post

Re: [sqlalchemy] Patterns for multitenancy

2018-11-19 Thread Eric Smith
Thanks -- the "before_compile" event seems interesting -- that could solve automatically adding a tenant on the SELECT side of things. What I wish for is a usage pattern like: 1. When a web request comes in, determine the appropriate tenant 2. Set the tenant somewhere associated with the c

Re: [sqlalchemy] Ms Access

2018-11-19 Thread Mike Bayer
On Mon, Nov 19, 2018 at 2:04 AM Abdallah Ally wrote: > > Hello guys. Can I use sqlalchemy with Ms Access? in theory, yes, in practice, uncertain. there's a dialect at https://bitbucket.org/zzzeek/sqlalchemy-access that probably is not in complete working order right now but can likely perform ba