Re: [sqlalchemy] Union query between multiple tables

2020-06-04 Thread Justvuur
Thanks Mike! You are the man! On Wednesday, 3 June 2020 00:12:19 UTC+2, Mike Bayer wrote: > > yes, for example with select(): > > s1 = select([t.c.c1, t.c.c2, t.c.c3]) > > s2 = select([t2.c.c1, t.c.c2, null().label('col4'), null.label('col5')]) > > u1 = union(s1, s2) > > > I'd recommend using

Re: [sqlalchemy] Ocassional Gevent BlockingSwitchOutError crashes when using pool_recycle

2020-06-04 Thread Tony Cosentini
Hey Mike, You were totally correct! We are migrating to a new engine (via an env var flag) and I totally forgot to wire up a call to remove() after handling requests with the new session. Thanks so much for suggestions! It made debugging this much easier. Tony On Wednesday, June 3, 2020 at