[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