如何在序列化器中使用count（）和sum（）？

Question

我想计算sum_of_rating/number_of_rating上的平均评分。

class SearchWorkingProfessionals(APIView):
    def post(self,request,format=None):
        tags = request.data.get('tag_arr')
        city_name = request.data.get('city_name')
        tags_list = tags.split(',')
        ws = WorkSamplesModel.objects.filter(business_account__serviceareasmodel__city_name=city_name,
        business_account__professiontagsmodel__tag_name__in=tags_list,
        is_business_card_image=True).distinct()
        serializer = SearchWorkingProgessionalsSerializer(ws,many=True)
        resp = {'resp':serializer.data}
        return Response(resp)

class FeedbackModel(models.Model):
    feedback_text = models.CharField(max_length=20)
    rating = models.IntegerField()
    business_account = models.ForeignKey(BusinessAccountModel,on_delete=models.CASCADE)
    
    class Meta:
        db_table = 'feedback'

这是我当前的序列化器

class SearchWorkingProgessionalsSerializer(serializers.Serializer):
    business_account_id = serializers.IntegerField()
    first_name = serializers.CharField(source='business_account.user.first_name')
    last_name = serializers.CharField(source='business_account.user.last_name')
    profile_pic = serializers.ImageField(source='business_account.user.profile_pic')
    business_title = serializers.CharField(source='business_account.business_title')
    business_description = serializers.CharField(source='business_account.business_description')
    status = serializers.CharField(source='business_account.status')
    note = serializers.CharField(source='business_account.note')
    work_sample_image = serializers.ImageField()
    work_sample_description = serializers.CharField(max_length=1000)

class WorkSamplesModel(models.Model):
    work_sample_image = models.ImageField(blank=True,null=True,upload_to="work_samples")
    work_sample_description = models.CharField(max_length=1000)
    is_business_card_image = models.BooleanField(default=False)
    business_account = models.ForeignKey(BusinessAccountModel,on_delete=models.CASCADE)

如何使用此序列化器计算平均评分？

Answer 1

您唯一的选择是这种情况是使用serializermethodfield。像这样的事情应该起作用（如果我了解您要的内容）：

from django.db.models import Avg

class SearchWorkingProgessionalsSerializer(serializers.Serializer):
    count_feedbacks = serializer.SerializerMethodField()
    average_rating = serializer.SerializerMethodField()

    # Returns the number of ratings
    def get_count_feedbacks(self, instance):
        return instance.business_account.feedbackmodel_set.count()  

    # Returns the average rating
    def get_average_rating(self, instance)
        return instance.business_account.feedbackmodel_set.aggregate(average_rating=Avg('rating'))['average_rating']

Answer 2

您始终可以编写serializers.serializermethodfield（）以在串行化中返回动态计算的字段。

在您的具体情况下，您也应该发布Worksplessmodel，以更加清晰。

Answer 3

以下代码为我工作..！

from django.db.models import Avg
...


class SearchWorkingProfessionalsSerializer(serializers.Serializer):
    business_account_id = serializers.IntegerField()
    first_name = serializers.CharField(source='business_account.user.first_name')
    last_name = serializers.CharField(source='business_account.user.last_name')
    profile_pic = serializers.ImageField(source='business_account.user.profile_pic')
    business_title = serializers.CharField(source='business_account.business_title')
    business_description = serializers.CharField(source='business_account.business_description')
    status = serializers.CharField(source='business_account.status')
    note = serializers.CharField(source='business_account.note')
    work_sample_image = serializers.ImageField()
    work_sample_description = serializers.CharField(max_length=1000)
    feedback_count = serializers.SerializerMethodField('get_feedback_count')
    average_rating = serializers.SerializerMethodField()

    def get_feedback_count(self, instance):
        return instance.business_account.feedbackmodel_set.count()

    def get_average_rating(self, instance):
        return instance.business_account.feedbackmodel_set.aggregate(average_rating=Avg('rating'))['average_rating']