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

score 3 · Answer 1 · answered Dec 18 '09 at 19:24

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"'

answered Dec 18 '09 at 19:24

Vince Busam

score 1 · Answer 2 · edited May 23 '17 at 11:48

1

You can use rfc3339 strings instead:

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

edited May 23 '17 at 11:48

Community

answered Dec 14 '09 at 05:43

miku

I have corrected my question, I am passing resultset to json.dumps and not datetime... – Software Enthusiastic Dec 14 '09 at 10:17

score 0 · Answer 3 · edited Dec 14 '09 at 07:25

0

edited Dec 14 '09 at 07:25

Imran

answered Dec 14 '09 at 06:21

czarchaic

3 Answers3