On 17.05.2013 19:44, Michael Bayer wrote: > > On May 17, 2013, at 1:30 PM, M.-A. Lemburg <m...@egenix.com> wrote: > >> As for how to adjust the paramstyle, I think Vernon's summary >> is a good one. SQLAlchemy and other applications could then >> do (*): >> >> import dbapi_module >> # We want named paramstyle on all connections: >> dbapi_module.paramstyle = 'named' >> >> and reduce the overhead of having to escape percent signs. > > just to confirm - that'll work on connections and cursors too, right? I > wouldn't want to do it at the module level.
Yes: """ The module scope variable provides the default for all connections created with the module, so the sequence goes like this: module.paramstyle -> connection.paramstyle -> cursor.paramstyle """ -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, May 17 2013) >>> Python Projects, Consulting and Support ... http://www.egenix.com/ >>> mxODBC.Zope/Plone.Database.Adapter ... http://zope.egenix.com/ >>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/ ________________________________________________________________________ 2013-05-07: Released mxODBC Zope DA 2.1.2 ... http://egenix.com/go46 2013-05-06: Released mxODBC 3.2.3 ... http://egenix.com/go45 ::::: Try our mxODBC.Connect Python Database Interface for free ! :::::: eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48 D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg Registered at Amtsgericht Duesseldorf: HRB 46611 http://www.egenix.com/company/contact/ _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
