current approach is to use the "creator" keyword to create_engine(),
which references a callable that returns a connection. you connect,
and then issue whatever additional SQL on the connection before
returning it. however this means your URL is just "<drivername>://"
and any additional portions of the URL are not used.
Jason will be adding some new hooks in 0.4 such that you can add a
function that gets called after the connection is established, so you
still connect via normal URL.
On Jul 24, 2007, at 5:01 AM, Paul Colomiets wrote:
>
> Hi,
>
> How can I place some initialization code for each connection in the
> pool?
>
> Currently I do something like this:
> engine.execute("SET collation_connection=utf8_general_ci")
> engine.execute("SET names utf8")
> engine.execute("SET character_set_client=utf8")
> engine.execute("SET character_set_results=utf8")
> before processing each http-request. But it needs to be done
> only once per connection.
>
> --
> Paul.
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
