Re: [sqlalchemy] Database session variables with connection pooling

2015-03-07 Thread Michael Bayer
Kent wrote: > I'm implementing database session variables (in Oracle, > DBMS_SESSION.SET_CONTEXT(...)), in order to be able to set (from sqlalchemy) > and retrieve (from a database trigger) the application userid and URL path > during table audit triggers. > > The tricky bit is that if I se

[sqlalchemy] Database session variables with connection pooling

2015-03-07 Thread Kent
I'm implementing database session variables (in Oracle, DBMS_SESSION.SET_CONTEXT(...)), in order to be able to set (from sqlalchemy) and retrieve (from a database trigger) the application userid and URL path during table audit triggers. The tricky bit is that if I set the user to 'user1', that

Re: [sqlalchemy] Complicated self join

2015-03-07 Thread Dani Hodovic
I thought subquery and alias where equivalent. Thanks Mike! Den fredag 6 mars 2015 kl. 01:29:20 UTC+1 skrev Michael Bayer: > > > > Dani Hodovic > wrote: > > > I've been struggling with a query that gets the most recent date as > described here: http://stackoverflow.com/a/123481/2966951 > > > >