[DB-SIG] A slightly different paramstyle suggestion

Michael Kleehammer mkleehammer at gmail.com
Thu Jun 21 21:43:56 CEST 2007


I like the idea of using *args and **kwargs a lot.  Not having to
build a sequence is nice and is an option I already provide in pyodbc:

  cursor.execute("insert into t(?,?)", a, b)

Using the two items to differentiate between qmark and named seems
like a simple idea and does not require connection or cursor
variables.

I also like the suggestion of *not* making either one required.  ODBC
drivers (and ODBC libraries themselves) already parse and rebuild SQL
to replace ? with whatever is native.

1) I am very leery of modifying application SQL.
2) pyodbc is C/C++; if the community wants to provide SQL rewriting
code to switch formats, I would want it in C/C++.  I've seen it
mentioned multiple times that it would be easy and I'm guessing the
assumption is it would always be in Python.

+1 for reducing the param styles to ? and named
+1 for using *args and **kwargs to differentiate between them.
-1 on requiring both (not yet, at least)

Michael Kleehammer
pyodbc maintainer
http://pyodbc.sourceforge.net


More information about the DB-SIG mailing list