Re: API 3.0 limiting paramstyle to ['named', 'qmark'] is okay. ('format' is not desirable)

"M.-A. Lemburg" <[email protected]>
Newsgroups gmane.comp.python.db
Organization eGenix.com Software GmbH; http://www.egenix.com/
Message-ID <[email protected]>
On 17.05.2013 19:44, Michael Bayer wrote:
> 
> On May 17, 2013, at 1:30 PM, M.-A. Lemburg <[email protected]> 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  -  [email protected]
http://mail.python.org/mailman/listinfo/db-sig
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.