[DB-SIG] db module wrapper

Randall Smith randall at tnr.cc
Fri Aug 20 21:26:55 CEST 2004


Dieter Maurer wrote:
> Randall Smith wrote at 2004-8-19 20:44 -0500:
> 
>>...
>>
>>>  As soon as you have a couple of "?", it becomes quite difficult
>>>  to grasp...
>>>
>>
>>Out of the format, named, numeric, pyformat, and qmark paramstyles, I 
>>find qmark the most simple.  What is difficult to grasp?
> 
> 
> The relationship between the "?"s and the corresponding arguments.
> You have to count "?"s and arguments and this can be difficult
> for non-trivial SQL statements with many "?".
> 
> Furthermore, the "?" provide no glue to the meaning of value.
> 

I see.  It would be possible to support more than 1 paramstyle by 
examining the type of the param input or allowing an explicit function 
parameter in execute as in execute(query, params, pstyle='named').

Randall


More information about the DB-SIG mailing list