Vue + Django 2.0.6 学习笔记 5.11 过滤2 搜索排序

た入场券 2022-01-26 15:06 200阅读 0赞

先说过滤，过滤除了上一篇说的到内容还有这些：

from .models import Goods
    
    
    class GoodsFilter(django_filters.rest_framework.FilterSet):
        """
        商品的过滤类
        """
        price_min = django_filters.NumberFilter(field_name='shop_price', lookup_expr='gte')
        price_max = django_filters.NumberFilter(field_name='shop_price', lookup_expr='lte')
    # 这是部分匹配 不分大小写
        name = django_filters.CharFilter(field_name='name', lookup_expr='icontains')
    
    
        class Meta:
            model = Goods
            fields = ['price_min','price_max', 'name']

除了大于小于还可以通过文字过滤 具体可参考官方文档

嗯。。好吧 官方文档大致浏览了下没找到

直接看源码 发现：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NvdWx3eWI_size_16_color_FFFFFF_t_70][]

原来这货直接调用forms的字段设置 那就参照forms的字段就完事了

如果要完全匹配搜索的话就不加lookup\_expr

import django_filters
    
    from django.db.models import Q
    
    from .models import Goods
    
    
    class GoodsFilter(django_filters.rest_framework.FilterSet):
        """
        商品的过滤类
        """
        price_min = django_filters.NumberFilter(field_name='shop_price', lookup_expr='gte')
        price_max = django_filters.NumberFilter(field_name='shop_price', lookup_expr='lte')
        # 这是全部匹配
        name = django_filters.CharFilter(field_name='name')
    
    
        class Meta:
            model = Goods
            fields = ['price_min','price_max', 'name']

效果

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NvdWx3eWI_size_16_color_FFFFFF_t_70 1][]

再说搜索功能：

官方文档

[https://www.django-rest-framework.org/api-guide/filtering/\#searchfilter][https_www.django-rest-framework.org_api-guide_filtering_searchfilter]

使用方法：

from rest_framework import filters
    
    class GoodsListViewset(mixins.ListModelMixin, viewsets.GenericViewSet):
        """
        商品列表页,分页，过滤，搜索，排序
        """
    
        queryset = Goods.objects.all().order_by('id')
        serializer_class = GoodsSerializer
        pagination_class = GoodsPagination
    # 添加搜索功能
        filter_backends = (DjangoFilterBackend,filters.SearchFilter)
    # 设置好搜索涉及的字段
        search_fields = ('name', 'goods_brief', 'goods_desc')
        filter_class = GoodsFilter

效果

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NvdWx3eWI_size_16_color_FFFFFF_t_70 2][]

同时 搜索可以匹配正则

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NvdWx3eWI_size_16_color_FFFFFF_t_70 3][]

回头可以试试

最后说排序：

class GoodsListViewset(mixins.ListModelMixin, viewsets.GenericViewSet):
        """
        商品列表页,分页，过滤，搜索，排序
        """
    
        queryset = Goods.objects.all().order_by('id')
        serializer_class = GoodsSerializer
        pagination_class = GoodsPagination
    # 这里 添加排序功能
        filter_backends = (DjangoFilterBackend,filters.SearchFilter, filters.OrderingFilter)
        search_fields = ('name', 'goods_brief', 'goods_desc')
    # 这添加排序字段
        ordering_fields = ('sold_num', 'add_time')
        filter_class = GoodsFilter
    # 如果需要自定义搜索和排序功能也是向上面过滤这样 没验证过 嘿嘿 具体看官方文档
        search_class = XXX
        ordering_class = XXX

[https://www.django-rest-framework.org/api-guide/filtering/\#orderingfilter][https_www.django-rest-framework.org_api-guide_filtering_orderingfilter]

完结

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NvdWx3eWI_size_16_color_FFFFFF_t_70]: /images/20220126/46a0dc19d7784eebbd7a4626636a2fd9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NvdWx3eWI_size_16_color_FFFFFF_t_70 1]: /images/20220126/cc8c49e46dda42d3b6fa90660e0fdbe7.png
[https_www.django-rest-framework.org_api-guide_filtering_searchfilter]: https://www.django-rest-framework.org/api-guide/filtering/#searchfilter
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NvdWx3eWI_size_16_color_FFFFFF_t_70 2]: /images/20220126/989e0838cc1e4199a7077d160ff909f1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NvdWx3eWI_size_16_color_FFFFFF_t_70 3]: /images/20220126/685611e76c1043f89da1239ad0994651.png
[https_www.django-rest-framework.org_api-guide_filtering_orderingfilter]: https://www.django-rest-framework.org/api-guide/filtering/#orderingfilter