Django REST框架 - 对查询参数进行过滤 [英] Django REST framework - filtering against query param

问题描述

所以我使用REST框架创建了我的API，现在试图对它进行过滤。
这就是我的 models.py 看起来像...或多或少：

  class Airline（models.Model）：
 name = models.TextField（）
 
 class Workspace（models.Model）：
 airline = models.ForeignKey（Airline） 
 name = models.CharField（max_length = 100）
 
 class Passenger（models.Model）：
 workspace = models.ForeignKey（Workspace）
 title = models。 CharField（max_length = 200）
  

所以我想在我的JSON文件中看到特别是所有乘客工作空间或所有乘客特别是航空公司等。

这是我的， serializers.py

  class AirlineSerializer（serializers.ModelSerializer）：
 class Meta：
 model = Airline 
 
 
 class WorkspaceSerializer（serializers.ModelSerializer）：
 class Meta：
 model = Workspace 
 
 
 class PassengerSerializer（serializers.ModelSerializer）：
班Meta：
 model = Passenger 
  

和 views.py



  class AirlineList（generics.ListCreateAPIView）：
 model = Airline 
 serializer_class = AirlineSerializer 
 
 $ b $ AirlineDetail（generics.RetrieveUpdateDestroyAPIView）：
 model = Airline 
 serializer_class = AirlineSerializer 
 
 
 class WorkspaceList （generics.ListCreateAPIView）：
 model = Workspace 
 serializer_class = WorkspaceSerializer 
 
 
 class WorkspaceDetail（generics.RetrieveUpdateDestroyAPIView）：
 model = Workspace 
 serializer_class = WorkspaceSerializer 
 
 
 class PassengerList（generics.ListCreateAPIView）：
 model = Passenger 
 serializer_class = PassengerSerializer 
 
 
 PassengerDetail（generics.RetrieveUpdateDestroyAPIView）：
 model = Passenger 
 serializer_class = PassengerSerializer 
  

这是我第一次使用REST框架，我检查了文档，他们帮助我完成了迄今为止所做的工作，我想使用

筛选查询参数：
http://www.django-rest-framework.org/api-guide/filtering/#filtering-against-query-parameters

不能真的得到它..

解决方案

@limelights我设法做我想要的，这里是代码：

  class PassengerList（generics.ListCreateAPIView）：
 model = Passenger 
 serializer_class = PassengerSerializer 
 
＃显示所有的PASSENGERS特别是WORKSPACE 
＃或全部的乘客，特别是AIRLINE 
 def get_queryset（self）：
 queryset = Passenger.objects.all（）
 workspace = self.request.query_params.get（'workspace'）
 airline = self.request.query_params.get（'airline'）
 
如果工作区：
 queryset = queryset .filter（workspace_id =工作空间）
 elif航空公司：
 queryset = queryset.filter（workspace__airline_id = airline）
 
 return queryset 
  / pre> 
So I created my "API" using REST framework, now trying to do filtering for it.
That's how my models.py look like more or less:
class Airline(models.Model):
    name = models.TextField()

class Workspace(models.Model):
    airline = models.ForeignKey(Airline)
    name = models.CharField(max_length=100)

class Passenger(models.Model):
    workspace = models.ForeignKey(Workspace)
    title = models.CharField(max_length=200)
So I would like to see in my JSON file "all passengers in particular workspace" or "all passengers in particular airline" etc.

Here is my, serializers.py
class AirlineSerializer(serializers.ModelSerializer):
    class Meta:
        model = Airline


class WorkspaceSerializer(serializers.ModelSerializer):
    class Meta:
        model = Workspace


class PassengerSerializer(serializers.ModelSerializer):
    class Meta:
        model = Passenger
And views.py:
class AirlineList(generics.ListCreateAPIView):
    model = Airline
    serializer_class = AirlineSerializer


class AirlineDetail(generics.RetrieveUpdateDestroyAPIView):
    model = Airline
    serializer_class = AirlineSerializer


class WorkspaceList(generics.ListCreateAPIView):
    model = Workspace
    serializer_class = WorkspaceSerializer


class WorkspaceDetail(generics.RetrieveUpdateDestroyAPIView):
    model = Workspace
    serializer_class = WorkspaceSerializer


class PassengerList(generics.ListCreateAPIView):
    model = Passenger
    serializer_class = PassengerSerializer


class PassengerDetail(generics.RetrieveUpdateDestroyAPIView):
    model = Passenger
    serializer_class = PassengerSerializer
It's my first time using REST framework, I have checked the docs, they helped me with what I've done so far, I would like to use 

  
Filtering against query parameter:
  http://www.django-rest-framework.org/api-guide/filtering/#filtering-against-query-parameters
Can't really get it..
解决方案
So with the @limelights I managed to do what I wanted, here is the code:

class PassengerList(generics.ListCreateAPIView):
    model = Passenger
    serializer_class = PassengerSerializer

    # Show all of the PASSENGERS in particular WORKSPACE
    # or all of the PASSENGERS in particular AIRLINE
    def get_queryset(self):
        queryset = Passenger.objects.all()
        workspace = self.request.query_params.get('workspace')
        airline = self.request.query_params.get('airline')

        if workspace:
            queryset = queryset.filter(workspace_id=workspace)
        elif airline:
            queryset = queryset.filter(workspace__airline_id=airline)

        return queryset


                        
这篇关于Django REST框架 - 对查询参数进行过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！