django后台管理之组合查询(轮子造好,直接使用)

列表使用*
字典使用**

此套轮子,适用于后台管理,可以通过时间来查询,通过id来查询,通过关键字来查询,可以单个查询也可以组合起来查询, 简单快捷,开发效率杠杠滴

如图:

上代码:

轮子

import operator
import logging

from functools import reduce

from rest_framework.views import APIView

from django.db.models import Q

logger = logging.getLogger('base')


# Create your views here.
class Search_List_Apiview(APIView):
    # 关键字查询field   # 必填
    search_fields = None # ["description__contains", "charge_id__contains"]
    # datetime field 查询时间的字段   # 必填
    datetime_fields = [] # ["createDate"]
    # default order sort 默认的排序   # 非必填
    default_order_sort_field = None # ["-createDate"]
    # models   必填
    model_class = None 
    # 默认查询，为提供同一个表根据不同的默认条件获取不同意义的数据     非必填
    default_filters = None # {}
    # 设置query_params中的key      非必填
    request_key = None # []   

    def get_queryset(self, request):
        # 查询结果顺序
        order_fields = request.query_params.getlist("order_fields", self.default_order_sort_field)

        # 得到time
        start_time = request.query_params.get("start_time", None)
        end_time = request.query_params.get("end_time", None)

        # 排除值为空的key-value, 排除无效属性key-val
        _items = {key: val for key, val in request.query_params.items() if val and key in dir(self.model_class) and key not in ("start_time", "end_time")}

		# 自定义加入参数
        category_id = _items.get('category_id', None)
        if category_id == 'empty':
            _items['category_id'] = None
        _items.pop("order_fields", None)
        # 加入关键字, 使用or关键字
        keywords = request.query_params.get("keywords", None)
        args = []
        if keywords and self.search_fields:
            search_dict = dict().fromkeys(self.search_fields, keywords)
            q_filter = [Q(**{key: keywords}) for key in self.search_fields if key]
            q_search = reduce(operator.or_, q_filter)
            args.append(q_search)

        # 根据时间筛选
        is_multi_datetime_field = 1 if len(self.datetime_fields) > 1 else 0

        if is_multi_datetime_field:
            pass
        else: # 单个时间字段开始，结束
            if start_time and end_time:
                filter_field_operator = "".join([self.datetime_fields[0], "__", "range"])
                datetime_dict = {filter_field_operator: [start_time, end_time]}
            elif start_time:
                filter_field_operator = "".join([self.datetime_fields[0], "__", "gte"])
                datetime_dict = {filter_field_operator: start_time}
            elif end_time:
                filter_field_operator = "".join([self.datetime_fields[0], "__", "lte"])
                datetime_dict = {filter_field_operator: end_time}
            else:
                datetime_dict = {}
            args.append(Q(**datetime_dict))

        filter_fields = _items
        
        # user = self.request.user
        # filter_fields.update({'user': user})
        # 默认查询，为提供同一个表根据不同的默认条件获取不同意义的数据
        if self.default_filters:
            filter_fields.update(self.default_filters)
        logger.info('当前获取到的查询参数为:%s'%filter_fields)
        logger.info('当前获取到的关键字参数和开始结束时间参数的列表为:%s'%args)
        object_list = self.model_class.objects.filter(*args, **filter_fields).order_by(*order_fields)
        logger.info('当前获取到的查询集合为:%s'%object_list)

        return object_list

view.py调用代码:

class Search_Comments(Search_List_Apiview):
    '''
    组合查询评论列表
    @params: start_time 
    @params: end_time 
    @params: status 
    @params: object_id 
    @params: keywords 
    '''
    pass
    # 关键字查询field, subclass , 不管是查询title,还是id,都必须使用__contains
    search_fields = ["videoinfos__title__contains", "videoinfos__id__contains"] 
    # datetime field 查询时间的字段 
    datetime_fields = ["commen_time"] # ["createDate"]
    # default order sort 默认的排序 
    default_order_sort_field = None # ["-createDate"]
    # models TODO: 
    model_class = Comment
    # 默认查询，为提供同一个表根据不同的默认条件获取不同意义的数据
    default_filters = None # {} # 可以用来区分评论的对象
    # 设置query_params中的key
    request_key = None # []
    
    def get(self, request):
        mes = {}
        user = request.use
        object_list=super(Search_Comments,self).get_queryset(request)
        data = CommentsSerializers(object_list, many=True).data
        return Response(data)