[DB-SIG] API 3.0 limiting paramstyle to ['named', 'qmark'] is okay. ('format' is not desirable)

M.-A. Lemburg mal at egenix.com
Fri May 17 19:51:23 CEST 2013


On 17.05.2013 19:44, Michael Bayer wrote:
> 
> On May 17, 2013, at 1:30 PM, M.-A. Lemburg <mal at 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/


More information about the DB-SIG mailing list