[DB-SIG] paramstyles, again (and now voting)

[M.-A. Lemburg]

On 2007-06-04 16:00, Carsten Haese wrote:
>> So I'm:
>>
>>  * +1 on making support one param style mandatory for all
>>    implementations
> 
> Any one? Let's make named mandatory, then.

I intentionally left this open :-)

We should have a vote on it. Let's gather votes for say two weeks
and then see what the outcome is.

Here's my vote:

 +1 on qmark
 +0 on named
 +0 on numeric
 -1 on format
 -1 on pyformat

>>  * +1 on requiring an interface to adjust the param style on a
>>    per connection or even per cursor basis, so that it's easy
>>    to setup an implementation to the mandatory param style
>>    (in case the module defaults to another param style for backwards
>>    compatibility reasons)
>>
>>    This interface would have to support at least the mandatory
>>    param style.
> 
> +1, let's discuss what that interface should look like.

We basically have two options:

 * use an attribute which is inherited from connections to
   cursors

 * use a get/set method approach with much the same meaning

For simplicity, I'd be in favor of adding a settable
.paramstyle attribute.

>>  * -1 on doing auto-detection of param styles at .execute()
>>    call time based on parsing the SQL statement
> 
> I now agree with -1 on making auto-detection mandatory as long as there
> is a way to turn it on. How about making a special paramstyle called
> auto?

Sounds like a plan :-)

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jun 04 2007)
>>> 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 mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX 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