python json serialize datetime

Question

First, a simple question on terms,
Encoding(json.dumps) means, converting something to json string,
decoding(json.loads) means, converting json string to json type(?)

I have a list of objects which I got from

>>> album_image_list = AlbumImage.objects.all().values(*fields)[offset:count]
>>> json.dumps(album_image_list[0], cls=DjangoJSONEncoder)
'{"album": 4, "album__title": "g jfd", "created_at": "2012-08-18T02:23:49Z", "height": 1024.0, "width": 512.0, "url_image": "http://--:8000/media/101ac908-df50-42cc-af6f-b172c8829a31.jpg"}'

but when I try the same on whole list (album_image_list),it fails...

>>> json.dumps(album_image_list, cls=DjangoJSONEncoder)
Traceback (most recent call last):
  File "<console>", line 1, in <module>
  File "/usr/lib/python2.6/json/__init__.py", line 237, in dumps
    **kw).encode(obj)
  File "/usr/lib/python2.6/json/encoder.py", line 367, in encode
    chunks = list(self.iterencode(o))
  File "/usr/lib/python2.6/json/encoder.py", line 317, in _iterencode
    for chunk in self._iterencode_default(o, markers):
  File "/usr/lib/python2.6/json/encoder.py", line 323, in _iterencode_default
    newobj = self.default(o)
  File "/home/--/virtualenvs/aLittleArtist/lib/python2.6/site-packages/django/core/serializers/json.py", line 75, in default
    return super(DjangoJSONEncoder, self).default(o)
  File "/usr/lib/python2.6/json/encoder.py", line 344, in default
    raise TypeError(repr(o) + " is not JSON serializable")
TypeError: [{'album': 4L, 'album__title': u'g jfd', 'created_at': datetime.datetime(2012, 8, 18, 2, 23, 49, tzinfo=<UTC>), 'height': 1024.0, 'width': 512.0, 'url_image': u'http://--:8000/media/101ac908-df50-42cc-af6f-b172c8829a31.jpg'}, {'album': 4L, 'album__title': u'g jfd', 'created_at': datetime.datetime(2012, 8, 18, 1, 54, 51, tzinfo=<UTC>), 'height': 512.0, 'width': 512.0, 'url_image': u'http://--:8000/media/e85d1cf7-bfd8-4e77-b90f-d1ee01c67392.jpg'}] is not JSON serializable
>>>

Why does it succeed on one element and fails on the list?

Sajid Ahmad · Accepted Answer · 2013-12-01 08:18:58Z

4

If you want to just dump a dictionary to JSON, just use json.dumps. It can easily be made to serialize objects by passing in a custom serialization class - there's one included with Django that deals with datetimes already:

from django.core.serializers.json import DjangoJSONEncoder
json.dumps(mydictionary, cls=DjangoJSONEncoder)

answered Dec 1, 2013 at 8:18

Sajid Ahmad

1,1445 gold badges18 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dgel · Accepted Answer · 2012-08-18 13:23:53Z

2

.values() doesn't actually return a list. It returns a ValuesQuerySet which is not serializable by the json module. Try converting album_image_list to a list:

json.dumps(list(album_image_list), cls=DjangoJSONEncoder)

answered Aug 18, 2012 at 13:23

dgel

16.9k8 gold badges62 silver badges76 bronze badges

2 Comments

eugene Over a year ago

QuerySet has 'lazy-loading' concept going on, although I don't quite get how it works. Does 'lazy' means it actually loads the 'fields' data lazily?. I guess ValuesQuerySet has already fetched 'fields data' and has nothing to do with lazy-loading?

dgel Over a year ago

I believe that a ValuesQuerySet is also lazy. It won't hit the database until you actually iterate through it or convert it to a list.

Community · Accepted Answer · 2017-05-23 10:28:04Z

0

Which DjangoJSONEncoder you are using? it looks like DjangoJSONEncoder may not support encoding list of results.

Try this:

JSON Serializing Django Models with simplejson

edited May 23, 2017 at 10:28

CommunityBot

11 silver badge

answered Aug 18, 2012 at 13:22

lucemia

6,6477 gold badges45 silver badges78 bronze badges

Comments

Manikanta · Accepted Answer · 2015-08-09 12:43:51Z

0

class DateTimeJSONEncoder(json.JSONEncoder):
    def default(self, obj):
        if isinstance(obj, datetime.datetime):
            return obj.isoformat()
        else:
            return super(DateTimeJSONEncoder, self).default(obj)

updated_at=DateTimeJSONEncoder().encode(p.updated_at)

This will help you to serialize datetime object

edited Aug 9, 2015 at 12:43

user447688

answered Aug 9, 2015 at 12:22

Manikanta

416 bronze badges

Collectives™ on Stack Overflow

python json serialize datetime

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related