[DB-SIG] Mandatory parameters in execute

Thierry MICHEL thierry@geltrude.mixad.it
Tue, 16 May 2000 13:22:59 +0200


hi *,

	a imple question: the arguments prameter in the execute()
function (DBAPI 2.0) is marked as optional. that's right because
if you do a SELECT you don't need to pass any parameters? but what
about INSERTs? if the use of `arguments' is mandatory it is really
easy to control the types of the argument and do some conversions
(arrays and large objects, for example.) so the question is, if
the driver sets paramstyle to pyformat the user can build an INSERT
string outside of execute() and then use it or is he forced to build
the INSERT string by passing arguments python-style?

thanx,

federico and thierry