首页 > 其他 > 详细

django_filters实现搜索

时间:2019-03-05 15:02:55      阅读:198      评论:0      收藏:0      [点我收藏+]

一.定义model

技术分享图片

# models.py

class Product(models.Model):
    name = models.CharField(max_length=255)
    author = models.CharField(max_length=255)
    price = models.DecimalField()
    description = models.TextField()
 

技术分享图片

二.定义filter

技术分享图片

# filters.py

import django_filters

class ProductFilter(django_filters.FilterSet):
    name = django_filters.CharFilter(lookup_expr='iexact')  # iexact表示精确匹配, 并且忽略大小写
    author = django_filters.CharFilter(lookup_expr='icontains') #icontains表示模糊查询(包含),并且忽略大小写
    price = django_filters.NumberFilter(look_expr='exact')  #exact表示精确匹配
    desc = django_filters.CharFilter('description', lookup_expr='contains') #对'description'字段进行操作,不填默认为desc
    #price__lte = django_filters.NumberFilter('price', lookup_expr='lte') #lte表示小于
    #price__gte = django_filters.NumberFilter('price', look_expr='gte')  # gte表示大于
class Meta:
        model = Product
        fields = ['name', 'author', 'price', 'description']
        #fields = {
             'price': ['lt', 'gt']
        }

技术分享图片

三.views中使用

技术分享图片

class ProductViewSets(mixins.ListModelMixin,
                   mixins.RetrieveModelMixin, 
                   mixins.UpdateModelMixin,  
                   mixins.DestroyModelMixin, 
                   mixins.CreateModelMixin,  
                   viewsets.GenericViewSet):
    queryset = Product.objects.all()
    serializer_class = ProductSerializer 
    filter_backends = (DjangoFilterBackend,)
    filter_class = ProductFilter
    search_fields = ('name', 'description')  # 模糊搜索的字段
    ordering_fields = ('price',)  # 排序的字段

django_filters实现搜索

原文:https://www.cnblogs.com/wenqiangit/p/10476805.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!