• Python Web开发 之 学生管理系统(2)[实现筛选，搜索，分页]

    DRF --- 过滤

    过滤的URL规范： https://abc.com/api/v2/students/?sno=95001

    https://abc.com/api/v2/students/?name=李&mobile=1234

    安装：pip install django-filter

    注册到installed_apps中

    1. # rest framework 全局设置
    2. REST_FRAMEWORK = {
    3.     # 过滤
    4.     'DEFAULT_FILTER_BACKENDS': ('django_filters.rest_framework.DjangoFilterBackend',),
    5. }
    1. # ============= 导入模块 ==============
    2. from django_filters import FilterSet, filters
    3. from studentweb.models import Faculty, Major, Student
    4.  
    5.  
    6. # --- Faculty的Filter类 ---
    7. class FacultyFilter(FilterSet):
    8.     # 重新需要支持模糊匹配的字段
    9.     name = filters.CharFilter(field_name='name', lookup_expr="icontains")
    10.  
    11.     class Meta:
    12.         model = Faculty
    13.         fields = ('name', )
    14.  
    15.  
    16. # --- Major的Filter类 ---
    17. class MajorFilter(FilterSet):
    18.     # 重新需要支持模糊匹配的字段
    19.     name = filters.CharFilter(field_name='name', lookup_expr="icontains")
    20.  
    21.     class Meta:
    22.         model = Major
    23.         fields = ('name', 'faculty')
    24.  
    25.  
    26. # --- Student的Filter类 ---
    27. class StudentFilter(FilterSet):
    28.     sno = filters.CharFilter(field_name='sno', lookup_expr="icontains")
    29.     name = filters.CharFilter(field_name='name', lookup_expr="icontains")
    30.     mobile = filters.CharFilter(field_name='mobile', lookup_expr="icontains")
    31.     major = filters.CharFilter(field_name='major')
    32.     faculty = filters.CharFilter(field_name='major__faculty')
    33.  
    34.     class Meta:
    35.         model = Student
    36.         fields = ('sno', 'name', 'mobile', 'major')
    1. from django.shortcuts import render
    2. from rest_framework.viewsets import ModelViewSet
    3. from studentweb.models import Faculty,Major,Student
    4. from studentweb.serializer import FacultySerialzer,MajorSerialzer,StudentSerialzer
    5. from django_filters.rest_framework import DjangoFilterBackend  # 实现筛选的后台模块
    6. from django_filters import FilterSet, filters
    7. from studentweb.filter import FacultyFilter,MajorFilter,StudentFilter
    8. from rest_framework.response import Response
    9. from rest_framework import status
    10. from rest_framework.decorators import action
    11. # Create your views here.
    12.  
    13.  
    14. # Faculty视图
    15. class FacultyViewSet(ModelViewSet):
    16.     """
    17.            create:
    18.            创建院系信息
    19.            retrieve:
    20.            获取院系信息详情数据
    21.            update:
    22.            完整更新院系信息
    23.            partial_update:
    24.            部分更新院系信息
    25.            destroy:
    26.            删除院系信息
    27.            list:
    28.            获取所有院系信息
    30.            """
    31.     queryset = Faculty.objects.all()
    32.     serializer_class = FacultySerialzer
    33.     filterset_fields = ('name',)
    34.  
    35.  
    36.  
    37. # --- Major视图---
    38. class MajorViewSet(ModelViewSet):
    39.     """
    40.     create:
    41.     创建专业信息
    42.     retrieve:
    43.     获取专业信息详情数据
    44.     update:
    45.     完整更新专业信息
    46.     partial_update:
    47.     部分更新专业信息
    48.     destroy:
    49.     删除专业信息
    50.     list:
    51.     获取所有专业信息
    53.     """
    54.     queryset = Major.objects.all()
    55.     serializer_class = MajorSerialzer
    56.     filterset_fields = ('name', 'faculty')
    57.     #filter_class = MajorFilter
    58.  
    59.  
    60. # --- Student视图---
    61. class StudentViewSet(ModelViewSet):
    62.     """
    63.     create:
    64.     创建学生信息
    65.     retrieve:
    66.     获取学生信息详情数据
    67.     update:
    68.     完整更新学生信息
    69.     partial_update:
    70.     部分更新学生信息
    71.     destroy:
    72.     删除学生信息
    73.     list:
    74.     获取所有学生信息
    76.     """
    77.  
    78.     queryset = Student.objects.all()
    79.     serializer_class = StudentSerialzer
    80.     filter_backends = (DjangoFilterBackend,)
    81.     #filterset_fields = ('sno', 'name', 'mobile', 'email', 'major')
    82.     #filter_class  = StudentFilter
    83.     # 自定义模糊搜索
    84.     # http://127.0.0.1:8000/api/v1/students/?name=王
    85.     # http://127.0.0.1:8000/api/v1/students/?name=&son=&mobile=18900998909
    86.     filterset_class = StudentFilter
    87.     # # 设置筛选后台
    88.     # filter_backends = (DjangoFilterBackend,)
    89.     #
    90.     # # 指定筛选的类
    91.     # # 指定筛选的类
    92.     # filter_class = StudentFilter
    93.     # # 指定查找匹配的字段 --- 学号、姓名、电话、邮箱、地址
    94.     # search_fields = ('sno', 'name', 'mobile', 'email', 'address')

     

     

     

    1. # --- Student视图---
    2. class StudentViewSet(ModelViewSet):
    3.     """
    4.     create:
    5.     创建学生信息
    6.     retrieve:
    7.     获取学生信息详情数据
    8.     update:
    9.     完整更新学生信息
    10.     partial_update:
    11.     部分更新学生信息
    12.     destroy:
    13.     删除学生信息
    14.     list:
    15.     获取所有学生信息
    17.     """
    18.  
    19.     queryset = Student.objects.all()
    20.     serializer_class = StudentSerialzer
    21.  
    22.     #filterset_fields = ('sno', 'name', 'mobile', 'email', 'major')
    23.     # 自定义模糊搜索
    24.     # http://127.0.0.1:8000/api/v1/students/?name=王
    25.     # http://127.0.0.1:8000/api/v1/students/?name=&son=&mobile=18900998909
    26.     filterset_class = StudentFilter
    27.     # # 设置筛选后台
    28.  
    29.     # # 指定筛选的类
    30.     # # 指定查找匹配的字段 --- 学号、姓名、电话、邮箱、地址
    31.     search_fields = ('sno', 'name', 'mobile', 'email', 'address')
    1. # rest framework 全局设置
    2. REST_FRAMEWORK = {
    3.     # 过滤 搜索
    4.     'DEFAULT_FILTER_BACKENDS': (
    5.         'django_filters.rest_framework.DjangoFilterBackend',
    6.         'rest_framework.filters.SearchFilter'
    7.  
    8.     ),
    9. }

     

     分页

     

    1. # rest framework 全局设置
    2. REST_FRAMEWORK = {
    3.     # 过滤 搜索
    4.     'DEFAULT_FILTER_BACKENDS': (
    5.         'django_filters.rest_framework.DjangoFilterBackend',
    6.         'rest_framework.filters.SearchFilter'
    7.  
    8.     ),
    9.     # 分页
    10.     'DEFAULT_PAGINATION_CLASS': 'rest_framework.pagination.PageNumberPagination',
    11.     'PAGE_SIZE': 10
    12.  
    13. }

     已经全局设置10条了

    1. http://127.0.0.1:8000/api/v1/students/?page=1&size=5
    2. {
    3.     "count": 15,
    4.     "next": "http://127.0.0.1:8000/api/v1/students/?page=2&size=5",
    5.     "previous": null,
    6.     "results": [
    7.         {
    8.             "sno": "0000",
    9.             "name": "林锡鸿",
    10.             "gender": "男",
    11.             "birthday": "2022-09-01T21:42:00Z",
    12.             "mobile": "15625775964",
    13.             "email": "411856938@qq.com",
    14.             "address": "珠海",
    15.             "image": "",
    16.             "major": 1
    17.         },
    18.         {
    19.             "sno": "950001",
    20.             "name": "王晓宇",
    21.             "gender": "男",
    22.             "birthday": "2022-03-01T00:00:00Z",
    23.             "mobile": "13099881122",
    24.             "email": "wangxiaoyu@qq.com",
    25.             "address": "上海市闵行区春都路88号",
    26.             "image": "",
    27.             "major": 2
    28.         },
    29.         {
    30.             "sno": "950002",
    31.             "name": "陈鹏",
    32.             "gender": "男",
    33.             "birthday": "2001-12-08T00:00:00Z",
    34.             "mobile": "18809871288",
    35.             "email": "chenpeng@qq.com",
    36.             "address": "南京市鼓楼区北京东路88号",
    37.             "image": "http://192.168.182.140:8000/media/images/4ec342ef63994d8da66bb2390718bb9b.webp",
    38.             "major": 24
    39.         },
    40.         {
    41.             "sno": "950003",
    42.             "name": "王艳",
    43.             "gender": "女",
    44.             "birthday": "2002-09-02T00:00:00Z",
    45.             "mobile": "17712344321",
    46.             "email": "wangyan@gmail.com",
    47.             "address": "上海市徐汇区漕宝路22号",
    48.             "image": "",
    49.             "major": 1
    50.         },
    51.         {
    52.             "sno": "950004",
    53.             "name": "李明奇",
    54.             "gender": "男",
    55.             "birthday": "2002-03-01T00:00:00Z",
    56.             "mobile": "13877612312",
    57.             "email": "limingqi@abc.com",
    58.             "address": "上海市徐汇区龙漕路89号",
    59.             "image": "",
    60.             "major": 3
    61.         },
    62.         {
    63.             "sno": "950005",
    64.             "name": "杨晓彤",
    65.             "gender": "女",
    66.             "birthday": "2002-03-01T00:00:00Z",
    67.             "mobile": "15565435564",
    68.             "email": "yangxiaotong@sohu.com",
    69.             "address": "上海市闵行区金都路1200号",
    70.             "image": "",
    71.             "major": 5
    72.         },
    73.         {
    74.             "sno": "950006",
    75.             "name": "王一超",
    76.             "gender": "男",
    77.             "birthday": "2002-03-01T00:00:00Z",
    78.             "mobile": "18900998909",
    79.             "email": "wangyichao@qq.com",
    80.             "address": "上海市闵行区银都路118号",
    81.             "image": "",
    82.             "major": 6
    83.         },
    84.         {
    85.             "sno": "950007",
    86.             "name": "陈旭",
    87.             "gender": "男",
    88.             "birthday": "2002-03-01T00:00:00Z",
    89.             "mobile": "13312344543",
    90.             "email": "chenxu@263.com",
    91.             "address": "上海市闵行区清红路812号",
    92.             "image": "",
    93.             "major": 7
    94.         },
    95.         {
    96.             "sno": "950008",
    97.             "name": "曾霞",
    98.             "gender": "女",
    99.             "birthday": "2002-03-01T00:00:00Z",
    100.             "mobile": "16612389078",
    101.             "email": "zengxia@hotmail.com",
    102.             "address": "南京市溧水区宝塔路88号",
    103.             "image": "",
    104.             "major": 8
    105.         },
    106.         {
    107.             "sno": "950009",
    108.             "name": "张三丰",
    109.             "gender": "男",
    110.             "birthday": "2002-03-01T00:00:00Z",
    111.             "mobile": "18876341209",
    112.             "email": "zhang@88.com",
    113.             "address": "江苏省泰州市姜堰区华港镇254号",
    114.             "image": "",
    115.             "major": 9
    116.         }
    117.     ]
    118. }

    设置分页类

    1. # -*- coding: utf-8 -*-
    2. from rest_framework.pagination import PageNumberPagination
    3.  
    4. class MyPageNumberPagination(PageNumberPagination):
    5.     page_size = 5
    6.     page_query_param = "page"
    7.     page_size_query_param = "size"
    8.     max_page_size = 50
    1. queryset = Student.objects.all()
    2.     serializer_class = StudentSerialzer
    3.     pagination_class = MyPageNumberPagination
    4.  
    5.     #filterset_fields = ('sno', 'name', 'mobile', 'email', 'major')
    6.     # 自定义模糊搜索
    7.     # http://127.0.0.1:8000/api/v1/students/?name=王
    8.     # http://127.0.0.1:8000/api/v1/students/?name=&son=&mobile=18900998909
    9.     filterset_class = StudentFilter
    10.     # # 设置筛选后台
    11.  
    12.     # # 指定筛选的类
    13.     # # 指定查找匹配的字段 --- 学号、姓名、电话、邮箱、地址
    14.     search_fields = ('sno', 'name', 'mobile', 'email', 'address')
    1. http://127.0.0.1:8000/api/v1/students/?page=1&size=5
    2. {
    3.     "count": 15,
    4.     "next": "http://127.0.0.1:8000/api/v1/students/?page=2&size=5",
    5.     "previous": null,
    6.     "results": [
    7.         {
    8.             "sno": "0000",
    9.             "name": "林锡鸿",
    10.             "gender": "男",
    11.             "birthday": "2022-09-01T21:42:00Z",
    12.             "mobile": "15625775964",
    13.             "email": "411856938@qq.com",
    14.             "address": "珠海",
    15.             "image": "",
    16.             "major": 1
    17.         },
    18.         {
    19.             "sno": "950001",
    20.             "name": "王晓宇",
    21.             "gender": "男",
    22.             "birthday": "2022-03-01T00:00:00Z",
    23.             "mobile": "13099881122",
    24.             "email": "wangxiaoyu@qq.com",
    25.             "address": "上海市闵行区春都路88号",
    26.             "image": "",
    27.             "major": 2
    28.         },
    29.         {
    30.             "sno": "950002",
    31.             "name": "陈鹏",
    32.             "gender": "男",
    33.             "birthday": "2001-12-08T00:00:00Z",
    34.             "mobile": "18809871288",
    35.             "email": "chenpeng@qq.com",
    36.             "address": "南京市鼓楼区北京东路88号",
    37.             "image": "http://192.168.182.140:8000/media/images/4ec342ef63994d8da66bb2390718bb9b.webp",
    38.             "major": 24
    39.         },
    40.         {
    41.             "sno": "950003",
    42.             "name": "王艳",
    43.             "gender": "女",
    44.             "birthday": "2002-09-02T00:00:00Z",
    45.             "mobile": "17712344321",
    46.             "email": "wangyan@gmail.com",
    47.             "address": "上海市徐汇区漕宝路22号",
    48.             "image": "",
    49.             "major": 1
    50.         },
    51.         {
    52.             "sno": "950004",
    53.             "name": "李明奇",
    54.             "gender": "男",
    55.             "birthday": "2002-03-01T00:00:00Z",
    56.             "mobile": "13877612312",
    57.             "email": "limingqi@abc.com",
    58.             "address": "上海市徐汇区龙漕路89号",
    59.             "image": "",
    60.             "major": 3
    61.         }
    62.     ]
    63. }

  • 相关阅读:
    Flask框架中Jinja2模板中测试器（判断值类型）
    PLM、ERP 和 MES，制造业的三剑客
    数据库选型与优化：策略与技巧的探讨
    OPPO，被折叠的高端之路
    shiro-第二篇-整合springboot
    2.Mybatis XML 方法的基本用法
    数说故事携重磅产品入选胖鲸数字化创新产品
    app全屏广告变现，有哪些利弊？如何发挥全屏广告的变现潜力？
    ffplay使用dxva2实现硬解渲染
    使用python生成大量数据写入es数据库并查询操作2
  • 原文地址：https://blog.csdn.net/weixin_38107457/article/details/126633276