[DB-SIG] db module wrapper

Randall Smith randall at tnr.cc
Fri Aug 20 03:44:43 CEST 2004



Dieter Maurer wrote:
> Randall Smith wrote at 2004-8-18 15:22 -0500:
> 
>>...
>>* Standardize the params input to use the ? operator and a list.  The 
>>module translates input params and query into the one appropriate for 
>>the  native module.  For example with cx_Oracle: "Select foo from table 
>>where goo > ?" with params [myparam] converts to "Select foo from table 
>>where goo > :var1" with params {'var1':myparam}.  This is working with 
>>both psycopg and cx_Oracle.
> 
> 
> Why are you replacing a readable and reliable syntax by one
> that is difficult to read and unreliable?
> 
>   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?  I'm certainly 
not set on this and open to reasons to use another paramstyle, but my 
objective is to settle on one.

Randall


More information about the DB-SIG mailing list