Python-Django 设置默认查询

场景描述

1，表A 和表B 是一对多
2，路由是由TableViewSet进来
3，（需求）查看表A的某一个详情时，再查询表B的时候默认过滤某个字段，此处以del_flag为例

为方便理解下面简单列出表关系和字段

Model类

class TableA(BaseModel):
    """
    表A
    """
    title = models.CharField(max_length=255, help_text="标题", default="", blank=True)
    no = models.CharField(max_length=255, help_text="编号", unique=True, default=uuid.uuid4, blank=True)
   
    is_read = models.IntegerField(help_text="是否已读",default=0)

    class Meta:
        verbose_name = verbose_name_plural = '表A'
        db_table = 'tableA'
class TableB(BaseModel):
    """
    表B
    """
    amount = models.DecimalField(help_text="申请金额", max_digits=18, decimal_places=2, default=0.0)
    remarks = models.CharField(help_text="备注", max_length=255, default="", blank=True)
    tablea= models.ForeignKey(TableA, help_text="事项", on_delete=models.PROTECT, default=2,
                               related_name="tableA")

    class Meta:
        verbose_name = verbose_name_plural = '表B'
        db_table = 'tableB'

序列化器（Serializers）

class TableASerializer(TableAListSerializer):
    no = UUIDBlankCharField(validators=[
        UniqueValidator(queryset=TableA.objects.all(), message='该编号已存在')])
    tableb= TableBSerializer(many=True, help_text='XXXX', required=False)
   
    remark = serializers.CharField(help_text="XXX", required=False, default=None,
                                   write_only=True)
    is_read = serializers.IntegerField(help_text="是否已读",required=False)

    @atomic
    def create(self, validated_data):
		XXXXXXXXXXXXX
        instance.save()
        return instance
    class Meta:
        model = TableA
        fields = (
            "title",
            "no",
            "tableb",
            "is_read"
        )
        
 class TableBSerializer(ChildrenModelSerializer):
    class Meta:
        model = TableB
        fields = (
            "amount",
            "remarks",
            "del_flag"
        )
        
 

方法

需要了解 Django的ListSerializer的to_representation方法，个人理解相当于java的构造方法。可以在你反序列化的时候为所欲为
修改后的序列化器

class DelFlagSerializer(serializers.ListSerializer):
    def to_representation(self, data):
        data = data.filter(del_flag=0)
        return super(DelFlagSerializer, self).to_representation(data)
class TableASerializer(TableAListSerializer):
    no = UUIDBlankCharField(validators=[
        UniqueValidator(queryset=TableA.objects.all(), message='该编号已存在')])
    tableb= TableBSerializer(many=True, help_text='XXXX', required=False)
   
    remark = serializers.CharField(help_text="XXX", required=False, default=None,
                                   write_only=True)
    is_read = serializers.IntegerField(help_text="是否已读",required=False)

    @atomic
    def create(self, validated_data):
		XXXXXXXXXXXXX
        instance.save()
        return instance
    class Meta:
        model = TableA
        fields = (
            "title",
            "no",
            "tableb",
            "is_read"
        )
        
 class TableBSerializer(ChildrenModelSerializer):
    class Meta:
        model = TableB
        fields = (
            "amount",
            "remarks",
            "del_flag"
        )
        list_serializer_class = DelFlagSerializer