I asked on the SQLAlchemy group how to execute SQL statements at
application initialisation (to make the Oracle session case
insensitive).
I was given a snippet which involves adding listeners to the
SQLAlchemy create_engine call:
class MySetup:
def connect(self, dbapi_con, con_record):
dbapi_con.execute('alter session set NLS_SORT=BINARY_CI')
dbapi_con.execute('alter session set NLS_COMP=LINGUISTIC')
engine = create_engine('oracle:...', listeners=[MySetup()])
How can I accomplish this when using Turbogears?
(I am using TG1.1 and Elixir on top of SQLAlchemy)
Thanks for your help,
Tim
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
