[DB-SIG] what is the "correct" way to alter paramstyle in a PEP 249 interface?
mal at egenix.com
Sat Sep 26 11:16:01 CEST 2009
Vernon Cole wrote:
> I am planning to add, as an extension, the ability for adodbapi to change
> its paramstyle. I personally like "named" much better than "qmark", and it
> happens that django expects to have "format", so I will add that, too.
> My question is, what would be an appropriate way to specify the altered
> 1) As an attribute of the connection:
> con = adodbapi.connect('spam eggs")
> con.paramstyle = "named"
Most other configuration parameters are made available on
connections and cursors (with the cursor setting overriding the
connection one), so I think that's the most DB-API
compatible way of implementing this.
> 2) Make the module global mutable:
> adodbapi.adodbapi.paramstyle = "named" # [ ick! ]
> 3) As a named parameter of the connection:
> con = adodbapi.connect("spam eggs", paramstyle="named")
> Has anyone else done this?
> How did they do it?
> How will some speculated future db-api version 3.0 want it?
Probably in the way you mentioned above.
The module global would then provide to the default setting.
Professional Python Services directly from the Source (#1, Sep 26 2009)
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
::: Try our new 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
More information about the DB-SIG