python mysql使用executemany()出现TypeError
def insertData(self,table,param):
try:
self.db.set_character_set('utf8')
q= []
for x in param:
cols = ', '.join(x.keys())
values = '"," '.join(x.values())
q.append((table, cols, '"'+values+'"'))
sql = "INSERT INTO %s(%s) VALUES(%s)"
try:
result = self.cur.executemany(sql,q)
insert_id = self.db.insert_id()
self.db.commit()
except MySQLdb.Error,e:
#发生错误时回滚
self.db.rollback()
except MySQLdb.Error,e:
print self.getCurrentTime(),"数据库错误，原因%d: %s" % (e.args[0], e.args[1])其中q的部分内容为[('houseurl', 'url', u'"/ershoufang/szlh11469938.html"'), ('houseurl', 'url', u'"/ershoufang/szlh11470634.html"')]
执行以上代码后，出现以下问题：
29 sql = "INSERT INTO %s(%s) VALUES(%s)"
30 try:
---> 31 result = self.cur.executemany(sql,q)
32 insert_id = self.db.insert_id()
33 self.db.commit()
/usr/lib/python2.7/dist-packages/MySQLdb/cursors.pyc in executemany(self, query, args)
274 self.errorhandler(self, ProgrammingError, msg.args[0])
275 else:
--> 276 self.errorhandler(self, TypeError, msg)
277 except (SystemExit, KeyboardInterrupt):
278 raise
/usr/lib/python2.7/dist-packages/MySQLdb/connections.pyc in defaulterrorhandler(***failed resolving arguments***)
34 del connection
35 if isinstance(errorvalue, BaseException):
---> 36 raise errorvalue
37 if errorclass is not None:
38 raise errorclass(errorvalue)
TypeError: not all arguments converted during string formatting但是我一条条插入使用execute()就没问题。
