How to serialize a ValuesQuerySet using django-rest-framework?

Question

I'd like to build an API for a complex query.

Having read the documentation, I prefer using django-rest-framework, which will provide serialization and pagination automatically for a ValuesQuerySet, rather than doing my own serialization.

However, I only found docs for default model QuerySet and did not find any documentation for serializing ValuesQuerySet (when the model is not known). How can I do that?

I've seen this answer but the solution was not applicable in my case.

Here is the code, NOT using django-rest-framework:

@login_required
def category_tallies(request):
    my_friends = FacebookUser.objects.filter(user_id=request.user.id)
    cat_tallies = FacebookLike.objects.filter(id__in=my_friends).values('category').annotate(Count('category')).order_by('-category__count')
    return HttpResponse(
        json.dumps(cat_tallies),
        mimetype='application/json')

karthikr · Accepted Answer · 2014-06-22 18:14:06Z

1

Try this:

from django.core import serializers

cat_tallies = FacebookLike.objects.filter(id__in=my_friends).annotate(count=Count('category')).order_by('-count')
json_dump = serializers.serialize('json', cat_tallies, fields=('category','count'))

answered Jun 22, 2014 at 18:14

karthikr

100k26 gold badges208 silver badges191 bronze badges

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

2 Comments

Nimo Over a year ago

Can serializers.serialize do pagination?

karthikr Over a year ago

All paginator needs is an iterable. So, yes you can

Collectives™ on Stack Overflow

How to serialize a ValuesQuerySet using django-rest-framework?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related