On Tue, Aug 24, 2004 at 02:55:51PM -0400, D. Richard Hipp wrote:
>
> I do not know if this new technique will be helpful to Python
> or not, but I thought I would bring it to your attention, just
> in case it is. Please note that the changes to support this
> are in CVS but have not be added to a "release". Also note
> that these changes are still considered experimental and are
> subject to change as more experience with the design becomes
> available.
Normally python programmers would like to see named arguments in
dictionary substation format:
d = { 'blob': 'a\0b', 'id': 2 }
cursor.execute("UPDATE t1 SET value=%(bigblob)s WHERE rowid=%(id)d", d)
but I don't know if this will map to named parameters. The binding
could transform %(bigblob)s into $bigblob and store the 's' format
character to do type checking at binding time. It seems like a lot of
work, though.
Cheers,
Matt
