测试平台开发（五）Django实现项目管理功能

一、创建用户应用

打开 Tools > Run manage.py Task…，运行 startapp空格加应用名称

startapp projects

生成应用后一定要记得将应用名加入到settings.py文件里名为INSTALLED_APPS的列表中，遵循规范加入到列表的最后，再添加应用也一样

1 # settings.py
2 INSTALLED_APPS=[
3 　　……,
4 　　'projects',
5 ]

二、编写数据模型

 1 # projects/models.py
 2 from django.db import models
 3 
 4 from utils.base_models import BaseModel
 5 
 6 
 7 class Projects(BaseModel):
 8     id = models.AutoField(primary_key=True, verbose_name='id主键')
 9     name = models.CharField(max_length=50, unique=True, verbose_name='项目名')
10     leader = models.CharField(max_length=50, verbose_name='负责人')
11     tester = models.CharField(max_length=50, verbose_name='测试人员')
12     programer = models.CharField(max_length=50, verbose_name='开发人员')
13     publish_app = models.CharField(max_length=50, verbose_name='应用名称')
14     desc = models.CharField(max_length=200, verbose_name='简要描述', blank=True, default="", null=True)
15 
16     class Meta:
17         db_table = 'lx_projects'
18         verbose_name = '项目信息'
19         verbose_name_plural = verbose_name
20 
21     def __str__(self):
22         return self.name

迁移数据库，打开 Tools > Run manage.py Task…，依次行

makemigrations
migrate

三、编写视图函数

1.表单校验，在projects目录下创建forms.py文件，用来校验创建项目数据和修改时输入的数据

  1 # projects/forms.py
  2 from django import forms
  3 from django.core.exceptions import ValidationError
  4 
  5 from projects.models import Projects
  6 
  7 
  8 class CreateForm(forms.Form):
  9     name = forms.CharField(
 10         label="项目名",
 11         required=True,
 12         max_length=50,
 13         min_length=2,
 14         error_messages={
 15             "required": "项目名不能为空",
 16             "max_length": "项目名最长不能超过50个字符",
 17             "min_length": "项目名最小长度为2"
 18         })
 19     leader = forms.CharField(
 20         label="负责人",
 21         required=True,
 22         max_length=50,
 23         min_length=2,
 24         error_messages={
 25             "required": "负责人不能为空",
 26             "max_length": "负责人最长不能超过50个字符",
 27             "min_length": "负责人最小长度为2"
 28         })
 29     tester = forms.CharField(
 30         label="测试人员",
 31         required=True,
 32         max_length=50,
 33         min_length=2,
 34         error_messages={
 35             "required": "测试人员不能为空",
 36             "max_length": "测试人员最长不能超过50个字符",
 37             "min_length": "测试人员最小长度为2"
 38         })
 39     programer = forms.CharField(
 40         label="开发人员",
 41         required=True,
 42         max_length=50,
 43         min_length=2,
 44         error_messages={
 45             "required": "开发人员不能为空",
 46             "max_length": "开发人员最长不能超过50个字符",
 47             "min_length": "开发人员最小长度为2"
 48         })
 49     publish_app = forms.CharField(
 50         label="应用名称",
 51         required=True,
 52         max_length=50,
 53         min_length=2,
 54         error_messages={
 55             "required": "应用名称不能为空",
 56             "max_length": "应用名称最长不能超过50个字符",
 57             "min_length": "应用名称最小长度为2"
 58         })
 59     desc = forms.CharField(
 60         label="简要描述",
 61         required=False,
 62         max_length=200,
 63         error_messages={
 64             "max_length": "简要描述最长不能超过200个字符",
 65         })
 66 
 67     def clean_name(self):
 68         val = self.cleaned_data.get("name")
 69         ret = Projects.objects.filter(name=val).values("name")
 70         if not ret:
 71             return val
 72         else:
 73             raise ValidationError("该项目名已存在!")
 74 
 75 
 76 class UpdateForm(forms.Form):
 77     name = forms.CharField(
 78         label="项目名",
 79         required=False,
 80         max_length=50,
 81         min_length=2,
 82         error_messages={
 83             "max_length": "项目名最长不能超过50个字符",
 84             "min_length": "项目名最小长度为2"
 85         })
 86     leader = forms.CharField(
 87         label="负责人",
 88         required=False,
 89         max_length=50,
 90         min_length=2,
 91         error_messages={
 92             "max_length": "负责人最长不能超过50个字符",
 93             "min_length": "负责人最小长度为2"
 94         })
 95     tester = forms.CharField(
 96         label="测试人员",
 97         required=False,
 98         max_length=50,
 99         min_length=2,
100         error_messages={
101             "max_length": "测试人员最长不能超过50个字符",
102             "min_length": "测试人员最小长度为2"
103         })
104     programer = forms.CharField(
105         label="开发人员",
106         required=False,
107         max_length=50,
108         min_length=2,
109         error_messages={
110             "max_length": "开发人员最长不能超过50个字符",
111             "min_length": "开发人员最小长度为2"
112         })
113     publish_app = forms.CharField(
114         label="应用名称",
115         required=False,
116         max_length=50,
117         min_length=2,
118         error_messages={
119             "max_length": "应用名称最长不能超过50个字符",
120             "min_length": "应用名称最小长度为2"
121         })
122     desc = forms.CharField(
123         label="简要描述",
124         required=False,
125         max_length=200,
126         error_messages={
127             "max_length": "简要描述最长不能超过200个字符",
128         })

2.在utils目录下的common.py文件写入一个字典去除空值的函数，下面回用到

1 # utils/common.py
2 ……
3 
4 def removeEmpty(data):
5     data2 = {}
6     for o in data:
7         if not data[o] == '':
8             data2[o] = data[o]
9     return data2

3.编写用户应用的视图函数

  1 # projects/views.py
  2 from django.http import JsonResponse
  3 from django.views import View
  4 from django.core.paginator import Paginator
  5 
  6 from projects.forms import CreateForm, UpdateForm
  7 from projects.models import Projects
  8 from utils.common import result, removeEmpty
  9 from utils.jwt_permission_required import auth_permission_required
 10 
 11 
 12 class CreateListView(View):
 13     # 分页 + 项目名模糊查询
 14     @auth_permission_required("class_func")
 15     def get(self, request):
 16         result["message"] = "查询成功"
 17         result["success"] = True
 18         page = request.GET.get("page", 1)
 19         size = request.GET.get("size", 10)
 20         name = request.GET.get("name", "")
 21         projects = Projects.objects.filter(is_delete=False, name__contains=name)
 22         projectss = Paginator(projects, size)
 23         project_list = []
 24         for project in projectss.page(page):
 25             project_list.append({
 26                 'id': project.id,
 27                 'name': project.name,
 28                 'leader': project.leader,
 29                 'tester': project.tester,
 30                 'programer': project.programer,
 31                 'publish_app': project.publish_app,
 32                 'desc': project.desc
 33             })
 34         result["details"] = {
 35             "records": project_list,
 36             "pages": projectss.num_pages,
 37             "total": projectss.count
 38         }
 39         # JsonResponse第一个参数默认只能为dict字典，如果设为其他类型，需要将safe设为False
 40         return JsonResponse(result, safe=False, status=200)
 41 
 42     # 创建数据
 43     @auth_permission_required("class_func")
 44     def post(self, request):
 45         result["message"] = "保存失败"
 46         result["success"] = False
 47         result["details"] = None
 48         json_data = request.body.decode('utf-8')
 49         if json_data:
 50             python_data = eval(json_data)
 51             data = CreateForm(python_data)
 52             if data.is_valid():
 53                 print(data.cleaned_data)
 54                 Projects.objects.create(**data.cleaned_data)
 55                 result["message"] = "保存成功"
 56                 result["success"] = True
 57                 result["details"] = data.cleaned_data
 58                 return JsonResponse(result, status=200)
 59             else:
 60                 result["details"] = data.errors
 61                 return JsonResponse(result, status=400)
 62         return JsonResponse(result, status=500)
 63 
 64 
 65 class UpdateDeleteView(View):
 66     # 更新数据
 67     @auth_permission_required("class_func")
 68     def put(self, request, pk):
 69         result["message"] = "更新失败"
 70         result["success"] = False
 71         result["details"] = None
 72         ret = Projects.objects.filter(id=pk, is_delete=False).values("id")
 73         if ret:
 74             json_data = request.body.decode('utf-8')
 75             if json_data:
 76                 python_data = eval(json_data)
 77                 data = UpdateForm(python_data)
 78                 if data.is_valid():
 79                     a = Projects.objects.filter(name=python_data["name"]).values("id").first()
 80                     if not a or a["id"] == pk:
 81                         d = removeEmpty(data.cleaned_data)
 82                         Projects.objects.filter(id=pk).update(**d)
 83                         result["message"] = "更新成功"
 84                         result["success"] = True
 85                         result["details"] = d
 86                         return JsonResponse(result, status=200)
 87                     else:
 88                         result["details"] = "该项目名已存在"
 89                         return JsonResponse(result, status=400)
 90                 else:
 91                     result["details"] = data.errors
 92                     return JsonResponse(result, status=400)
 93             return JsonResponse(result, status=500)
 94         else:
 95             result["details"] = "项目不存在"
 96             return JsonResponse(result, status=400)
 97 
 98     # 逻辑删除
 99     @auth_permission_required("class_func")
100     def delete(self, request, pk):
101         result["message"] = "删除失败"
102         result["success"] = False
103         result["details"] = None
104         ret = Projects.objects.filter(id=pk, is_delete=False).values("id").first()
105         if ret:
106             project = Projects.objects.get(id=pk)
107             project.is_delete = True
108             project.save()
109             result["message"] = "删除成功"
110             result["success"] = True
111             return JsonResponse(result, status=200)
112         result["details"] = "项目不存在"
113         return JsonResponse(result, status=400)
114 
115 # 获取id和name
116 @auth_permission_required("func")
117 def names(reuqest):
118     result["message"] = "查询成功"
119     result["success"] = True
120     projects = Projects.objects.filter(is_delete=False).values("id", "name")
121     project_list = []
122     for project in projects:
123         project_list.append({
124             'id': project["id"],
125             'name': project["name"],
126         })
127     result["details"] = project_list
128     return JsonResponse(result, safe=False, status=200)

四、编写应用的路由

在projects目录下创建urls.py文件

 1 #projects/urls.py
 2 from django.urls import path
 3 
 4 from projects import views
 5 
 6 urlpatterns = [
 7     path('', views.CreateListView.as_view()),
 8     path('<int:pk>', views.UpdateDeleteView.as_view()),
 9     path('names',views.names)
10 ]

五、定义全局路由

1 # testplatform/urls.py
2 from django.contrib import admin
3 from django.urls import path, include
4 
5 urlpatterns = [
6     path('api/admin/', admin.site.urls),
7     path('api/user/', include("users.urls")),
8     path('api/project/', include("projects.urls"))
9 ]

六、测试

1. 分页+项目名模糊查询

2. 创建数据

3. 更新数据

4. 逻辑删除

5. 获取id和name

GitHub持续更新：地址https://github.com/debugf/testplatform

转载请注明出处，商用请征得作者本人同意，谢谢！！！