CODEWITHSUNDEEP
pythondjangojsonmysql
Software Enthusiastic
Software Enthusiastic

Reputation: 26425

Serializing resultset returned from mysqldb in python

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...

Upvotes: 0

Views: 1282

Answers (3)

Vince Busam
Vince Busam

Reputation: 61

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

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

Upvotes: 3

czarchaic
czarchaic

Reputation: 6318

Serializing Django objects (Django Docs)

Serializing Python Objects (Dive Into Python 3)

Upvotes: 0

miku
miku

Reputation: 188004

You can use rfc3339 strings instead:

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

See: JSON datetime between Python and JavaScript

Upvotes: 1

Related Questions