DjangoRestFramework: Unable to return count in JSON Response

Question

I've a table Orders which contains ID, store_name, order_date, ..... I want to create an endpoint which returns me the JSON which consists of Count of Orders from all the Stores. Something as follows:

[{store_name: 'Target', count: 10}, {store_name: 'Walmart', count: 20}, {store_name: 'Costco', count: 5}]

The query I wrote is:

queryset = Stores.objects.all().values('store_name').annotate(total=Count('store_name'))

When I print queryset, I'm getting what I need as mentioned above. But when I serialize the data, I get the following:

[{store_name: 'Target'}, {store_name: 'Walmart'}, {store_name: 'Costco'}]

Not sure what am I doing wrong.. I've included my code. (I'm not including import statements)

serializer.py

class StoresSerializer(ModelSerializer):
    class Meta:
        model = Stores
        exclude = ['order_date',]

views.py

class StoresViewSet(ModelViewSet):
    queryset = Stores.objects.all().values('store_name').annotate(total=Count('store_name'))
    serializer_class = StoresSerializer

What am I missing?

Check that question stackoverflow.com/questions/18434425/… — Ivan Semochkin
– Ivan Semochkin, Commented Jan 17, 2017 at 11:33

Community · Accepted Answer · 2017-05-23 12:08:57Z

0

Using one old topic it would go as follows

models.py (simplified version just to demonstrate the idea)

class Store(models.Model):
    name = models.CharField(max_length=100)

class Order(models.Model):
    store_name = models.ForeignKey(Store)
    order_date = models.DateTimeField(auto_now_add=True)

serializer.py

from rest_framework.serializers import ModelSerializer
from rest_framework import serializers
from .models import Store

class StoresSerializer(ModelSerializer):
    orders = serializers.IntegerField()

    class Meta:
        model = Store
        fields = ('name', 'orders')

views.py

class StoresViewSet(viewsets.ModelViewSet):
    queryset = Store.objects.all().values('name').annotate(orders=Count('order'))
    serializer_class = StoresSerializer

edited May 23, 2017 at 12:08

CommunityBot

11 silver badge

answered Jan 17, 2017 at 12:12

Marcin Pęciak

1314 bronze badges

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

Collectives™ on Stack Overflow

DjangoRestFramework: Unable to return count in JSON Response

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related