Convert multiple querysets to json in django

Question

I asked a related question earlier today

In this instance, I have 4 queryset results:

action_count = Action.objects.filter(complete=False, onhold=False).annotate(action_count=Count('name'))
hold_count = Action.objects.filter(onhold=True, hold_criteria__isnull=False).annotate(action_count=Count('name'))
visible_tags = Tag.objects.filter(visible=True).order_by('name').filter(action__complete=False).annotate(action_count=Count('action'))
hidden_tags = Tag.objects.filter(visible=False).order_by('name').filter(action__complete=False).annotate(action_count=Count('action'))

I'd like to return them to an ajax function. I have to convert them to json, but I don't know how to include multiple querysets in the same json string.

Keith Entzeroth · Accepted Answer · 2013-06-07 15:51:20Z

3

I know this thread is old, but using simplejson to convert django models doesn't work for many cases like decimals ( as noted by rebus above).

As stated in the django documentation, serializer looks like the better choice.

Django’s serialization framework provides a mechanism for “translating” Django models into other formats. Usually these other formats will be text-based and used for sending Django data over a wire, but it’s possible for a serializer to handle any format (text-based or not).

Django Serialization Docs

edited Jun 7, 2013 at 15:51

user1428660

answered Jan 10, 2013 at 17:55

Keith Entzeroth

2,0591 gold badge19 silver badges22 bronze badges

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

Comments

Davor Lucic · Accepted Answer · 2012-03-11 13:56:15Z

1

You can use Django's simplejson module. This code is untested though!

from django.utils import simplejson
dict = {
    'action_count': list(Action.objects.filter(complete=False, onhold=False).annotate(action_count=Count('name')).values()),
    'hold_count': list(Action.objects.filter(onhold=True, hold_criteria__isnull=False).annotate(action_count=Count('name')).values()),
    ...
}
return HttpResponse( simplejson.dumps(dict) )

I'll test and rewrite the code as necessary when I have the time to, but this should get you started.

edited Mar 11, 2012 at 13:56

Davor Lucic

29.5k9 gold badges68 silver badges77 bronze badges

answered Mar 10, 2012 at 20:25

Simon Steinberger

6,8565 gold badges63 silver badges101 bronze badges

5 Comments

Daniel Roseman Over a year ago

This won't actually work. You can't serialize a Django queryset like that, because the model instances themselves aren't serializable by the json module directly.

Simon Steinberger Over a year ago

Okay, thanks for the hint! I just re-wrote the code. Now actual lists of dictionaries are created on the fly. It should work - but it's still untested. Maybe it's not the most elegant way ...

Davor Lucic Over a year ago

You could use values() or values_list() instead of building dictionaries that way, specially since if any of the fields are ForeingKey or something it would again return an unserializable object. json.dumps(list(Model.object.filter().values())) for example.

Davor Lucic Over a year ago

Not sure would this work for example with decimal fields though.

Ed. Over a year ago

Thanks, all. I hacked this a bit, but got a working solution off the comments here.

Collectives™ on Stack Overflow

Convert multiple querysets to json in django

2 Answers 2

Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related