Serializing resultset returned from mysqldb in python

Question

Can anyone please help me in serializing resultset returned using mysqldb in python?

I get typeerror: datetime.date(2007, 11, 15) is not JSON serializable

What is the best way to do serialize into Json object in python?

I am using json.dumps(resultset) to serialize resultset...

Answer 1

You can use rfc3339 strings instead:

  json.dump(datetime.now().strftime('%Y-%m-%dT%H:%M:%S'))

See: http://stackoverflow.com/questions/455580/json-datetime-between-python-and-javascript

Answer 2

Serializing Django objects (Django Docs)

Serializing Python Objects (Dive Into Python 3)

Answer 3

Set the "default" function passed to json.dump:

>>> d=datetime.datetime.now()
>>> json.dumps(d,default=str)
'"2009-12-18 14:22:21.405095"'