Automatically convert data type when using MySQLdb

Add following lines:

from MySQLdb.constants import FIELD_TYPE

def DateTime2string(object):
return str(object)

conv_dict = MySQLdb.converters.conversions
conv_dict[FIELD_TYPE.DATETIME] = DateTime2string

conn = MySQLdb.connect (host = 'host',
port = 'port',
user = 'user',
passwd = 'passwd',
db = 'db',
conv = conv_dict
)
Then the cursor will automatically convert all fields of DateTime type in resultset into str for you.
This trick was inspired by this post which unfortunately didn't work for me.

spockproxy released!

http://spockproxy.sourceforge.net/