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 remains in the
session in the database even when a different sqlalchemy thread grabs that
same session from the connection pool. I want to prevent the wrong
information accidentally still being in the session, so I want to be sure
to reset it when appropriate and I'm wondering whether checkout from the
Pool is the event you would recommend?
@event.listens_for(engine, 'checkout')
def receive_checkout(dbapi_connection, connection_record,
connection_proxy):
If the same database session is recycled from the connection pool, will it
have the same *connection_record*? I'd prefer to record the fact that I've
set the database session's variables on an object (such as
connection_record) so that subsequent requests can detect whether it needs
to be reset. Will connection_record correspond to a database session?
Thanks in advance for any advice here.
Kent
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
