Hello everyone, greetings from Hong Kong.
I'm a relative noob with Python and have managed to break it. I'm hoping
someone would be kind enough to help out, or perhaps just point me in the right
direction.
I've written a program which pulls in an XML document from an API on a server
and populates the data into a MySQL table which I will then use to create
reports. Everything is fine up until the point it tries to write the record to
MySQL with this statement:
dbcur.execute("INSERT INTO BackupJobs (bj_bsname, bj_bsid, bj_startdate,
bj_starttime, bj_enddate, bj_endtime, bj_status, bj_uploadsize) values
(%s,%s,%s,%s,%s,%s,%s,%s)", newrecord)
which borks with this:
Traceback (most recent call last):
File "./blahblahblah.py", line 99, in <module>
dbcur.execute("INSERT INTO BackupJobs (bj_bsname, bj_bsid, bj_startdate,
bj_starttime, bj_enddate, bj_endtime, bj_status, bj_uploadsize) values
(%s,%s,%s,%s,%s,%s,%s,%s)", newrecord)
File "/usr/local/lib/python3.2/dist-packages/pymysql/cursors.py", line 100,
in execute
escaped_args = tuple(conn.escape(arg) for arg in args)
File "/usr/local/lib/python3.2/dist-packages/pymysql/cursors.py", line 100,
in <genexpr>
escaped_args = tuple(conn.escape(arg) for arg in args)
File "/usr/local/lib/python3.2/dist-packages/pymysql/connections.py", line
650, in escape
return escape_item(obj, self.charset)
File "/usr/local/lib/python3.2/dist-packages/pymysql/converters.py", line 31,
in escape_item
encoder = encoders[type(val)]
KeyError: <class 'builtin_function_or_method'>
I can dump out the (dummy) contents of the table using:
for r in dbcur:
print(r)
...so it seems the connection itself is working. User ID has full permissions,
I'm pretty sure the data types are correct for each field.
I can provide more code snippets if necessary.
I'd be very grateful for any help. And if you're in Hong Kong and have helped
me through this I'll buy you a beer too :-)
--
http://mail.python.org/mailman/listinfo/python-list
