On Mar 3, 2009, at 8:19 PM, Sandstone wrote:
> > Hi, > > We are having problems efficiently setting the time zones for mysql > through sqlalchemy form clients in multiple timezones. > > We first tried setting the timezone through an engine execute but this > results in not all queries having the timezone setting applied. i.e. > eng.execute( "SET time_zone = 'Canada/East-Saskatchewan' " ). I'm > assuming this has something to do with the connection pool. it does. look into using the connection pool events API for this operation, so that the command is called exactly once for each new connection. http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/interfaces.html?highlight=pool%20listener#sqlalchemy.interfaces.PoolListener --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
