Saturday, November 26, 2011

how to use cursor.executemany?

code:
========
wkL = [("11111111111",), ("22222222222",), ("3333333333333",)]
#or wkL = ["11111111111","22222222222","3333333333333"]
cursor.executemany( u"insert into entries ( guestName, content )
values( '%s', 'ZZZZZZZZZZZ' )", wkL )

error
========
File "/base/data/home/apps/s~chatthor/1.354968998651775855/2.py",
line 19, in get
cursor.executemany( u"insert into entries ( guestName, content )
values( '%s', 'ZZZZZZZZZZZ' )", wkL )
File "/base/python27_runtime/python27_lib/versions/1/google/storage/
speckle/python/api/rdbms.py", line 344, in executemany
self.execute(statement, args)
File "/base/python27_runtime/python27_lib/versions/1/google/storage/
speckle/python/api/rdbms.py", line 290, in execute
response = self._conn.MakeRequest('Exec', request)
File "/base/python27_runtime/python27_lib/versions/1/google/storage/
speckle/python/api/rdbms.py", line 596, in MakeRequest
response = self._MakeRetriableRequest(stub_method, request)
File "/base/python27_runtime/python27_lib/versions/1/google/storage/
speckle/python/api/rdbms.py", line 620, in _MakeRetriableRequest
response = self.MakeRequestImpl(stub_method, request)
File "/base/python27_runtime/python27_lib/versions/1/google/storage/
speckle/python/api/rdbms_apiproxy.py", line 68, in MakeRequestImpl
raise OperationalError('could not connect: ' + str(e))
OperationalError: could not connect: ApplicationError: 1006
mysql_stmt_param_count: Not all variables bound. Got 1, expected 0.

No comments:

Post a Comment