executemany fails when passing a list of dicts

[Mattias Lundell]

Binary package hint: python-mysqldb

using the table:
--------------------
create table a(f1 int, f2 int);

and the python code:
---------------------------

import MySQLdb

conn = MySQLdb.connect('localhost','root','root','test')
cursor = conn.cursor()

vals = [{'f1' : 1, 'f2' : 2}]
sql = "insert into a values (%(f1)s, %(f2)s)"

print MySQLdb.__version__
cursor.execute(sql, vals[0])
print "execute works"
cursor.executemany(sql, vals)
print "execute many works"

gives the result:
--------------------

1.2.2
execute works
Traceback (most recent call last):
  File "test.py", line 11, in <module>
    cursor.executemany(sql, vals)
  File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 217, in executemany
    self.errorhandler(self, exc, value)
  File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
ValueError: incomplete format

but should give:
--------------------

1.2.2
execute works
execute many works

[dino99 (9d9)]

This version has expired