如何使用Django中的ID列表订购相关表

Question

这是我试图执行的示例；

class GroupA(models.Model):
    name=models.CharField(max_length=250)

class GroupB(models.Model):
   category = models.CharField(max_length=250)
   group_a = models.ForeignKey(GroupA)

我有ID列表； [1，2，3]。如何使用ID列表通过groupb执行groupa的顺序。

目前，我要返回的数据的一个示例是；

[
{
"id": 3,
"category": "Category 1",
"group_a": [
   {
     "id": 2,
     "name": "John"
   },
   {
     "id": 1,
     "name": "Doe"
   },
   {
     "id": 3,
     "name": "Jane"
   }
]
}
]

我要存档的是使用ID列表订购group_a的数据； [1，2，3]。因此它将返回这样的东西；

[
{
"id": 3,
"category": "Category 1",
"group_a": [
   {
     "id": 1,
     "name": "Doe"
   },
   {
     "id": 2,
     "name": "John"
   },
   {
     "id": 3,
     "name": "Jane"
   }
]
}
]

//编辑

serializer.py

class GroupASerializer(serializers.ModelSerializer):
    class Meta:
       model = GroupA
       fields = "__all__"

class GroupBSerializer(serializers.ModelSerializer):
    group_a = GroupASerializer(read_only=True, many=True)
    class Meta:
       model = GroupB
       fields = "__all__"

views.pys.py

class GroupBView(APIView):
    serializer_class = GroupBSerializer
    permission_classes = (IsAuthenticated,)

    def get(self, request):
        group_trip = GroupB.objects.all()
        serializer = GroupBSerializer(group_trip, many=True)
        return Response(serializer.data)

Answer 1

也许您应该使用ModelViewSet

class GroupViewSet(viewsets.ModelViewSet):
    queryset = GroupB.objects.all()
    serializer_class = GroupBSerializer
    permission_classes = [permissions.IsAuthenticated]

    def get_queryset(self):
        return GroupB.objects.all().order_by('id')

我没有检查它是否有效