接口平台测试开发--day16

一、pycharm 从git拉取代码

• 1、VCS--Get Versoin Controll

• 2、具体配置内容

二、执行manage.py

1、pycharm路径

   

• 2、创建项目startapp +项目名称

• 例如：startapp sksystem

• 3、为新创建的项目新增urls.py
• earth/urls.py 增加路径

from django.contrib import admin
from django.urls import path, include
from sksystem import urls as sksUrls
from example import urls as urls


urlpatterns = [
    path('admin/', admin.site.urls),
    path('example/',include(urls)),
    path('api/', include(sksUrls)),  # 例子url，访问的时候就是/example/book
]

 

或者这样修改，将不用的example去除

from django.contrib import admin
from django.urls import path, include

#from sksystem import urls

urlpatterns = [
    path('admin/', admin.site.urls),
    path('api/', include(urls)),  # 例子url，访问的时候就是/example/book
]

 

 4、settings.py 增加新增的项目

三、数据库设计：

 

 

 

 

 

 

 

 

models.py

from django.db import models
from utils import tools
from earth import settings


# Create your models here.


class BaseModel(models.Model):
    '''公共字段'''
    is_delete_choice = (
        (0, '删除'),
        (1, '正常')
    )
    is_delete = models.SmallIntegerField(choices=is_delete_choice, default=1, verbose_name='是否被删除')
    create_time = models.DateTimeField(verbose_name='创建时间', auto_now_add=True)  # auto_now_add的意思，插入数据的时候，自动取当前时间
    update_time = models.DateTimeField(verbose_name='修改时间', auto_now=True)  # 修改数据的时候，时间会自动变

    class Meta:
        abstract = True  # 只是用来继承的,不会创建这个表


class User(BaseModel):
    '''用户表'''
    phone = models.CharField(verbose_name='手机号', max_length=11, unique=True)
    email = models.EmailField(verbose_name='邮箱', max_length=25, unique=True)
    password = models.CharField(verbose_name='密码', max_length=32)
    username = models.CharField(verbose_name='昵称', default='Python小学生', max_length=20)

    @staticmethod
    def make_password(raw_password):
        '''生成密码'''
        before_password = '%s%s' % (raw_password, settings.SECRET_KEY)  # 生成密码的算法，可以自己改
        after_password = tools.md5(before_password)
        return after_password

    def set_password(self, raw_password):
        '''设置密码'''
        self.password = self.make_password(raw_password)

    def check_password(self, raw_password):
        '''校验登录密码'''
        return self.make_password(raw_password) == self.password

    def __str__(self):
        return self.username

    class Meta:
        verbose_name = '用户表'
        verbose_name_plural = verbose_name
        db_table = 'user'

class Parameter(BaseModel):#继承BaseModel
    '''全局参数表'''
    name = models.CharField(verbose_name='参数名', max_length=100, unique=True)#unique=True 唯一
    desc = models.CharField(verbose_name='描述', max_length=200, null=True)#null=True允许传空
    value = models.CharField(verbose_name='参数值', max_length=100)

    def __str__(self):
        return self.name

    class Meta:
        verbose_name = '全局参数'
        verbose_name_plural = verbose_name
        db_table = 'parameter'
        ordering = ['-id']  # 按照id倒排。


class Project(BaseModel):
    '''项目表'''
    name = models.CharField(verbose_name='项目名', max_length=100, unique=True)
    desc = models.CharField(verbose_name='描述', max_length=200, null=True)
    host = models.CharField(verbose_name='域名', max_length=1024)
    user = models.ForeignKey(User, on_delete=models.DO_NOTHING, db_constraint=False, verbose_name='创建者')
    #on_delete=models.DO_NOTHING 当删除的时候不做任何事情 db_constraint=False 不是真正的去创建外键

    def __str__(self):
        return self.name

    class Meta:
        verbose_name = '项目表'
        verbose_name_plural = verbose_name
        db_table = 'project'
        ordering = ['-id']  # 按照id倒排。


class Interface(BaseModel):
    '''接口'''
    name = models.CharField(verbose_name='接口名称', max_length=100, unique=True)
    uri = models.CharField(verbose_name='接口路径', max_length=1024)
    params = models.CharField(verbose_name='默认参数', max_length=2048,null=True,blank=True)
    headers = models.CharField(verbose_name='默认Headers', max_length=2048,null=True,blank=True)
    user = models.ForeignKey(User, on_delete=models.DO_NOTHING, db_constraint=False, verbose_name='创建者')
    project = models.ForeignKey(Project, on_delete=models.DO_NOTHING, db_constraint=False, verbose_name='归属项目')

    def __str__(self):
        return self.name

    class Meta:
        verbose_name = '接口表'
        verbose_name_plural = verbose_name
        db_table = 'interface'
        ordering = ['-id']  # 按照id倒排。


class Case(BaseModel):
    '''用例表'''
    title = models.CharField(verbose_name='用例标题', max_length=100)
    project = models.ForeignKey(Project, on_delete=models.DO_NOTHING, db_constraint=False, verbose_name='归属项目')
    interface = models.ForeignKey(Interface, on_delete=models.DO_NOTHING, db_constraint=False, verbose_name='接口')
    user = models.ForeignKey(User, on_delete=models.DO_NOTHING, db_constraint=False, verbose_name='创建用户')
    method_choice = (
        (1, 'POST'),
        (2, 'GET'),
        (3, 'DELETE'),
        (4, 'PUT'),
    )
    method = models.SmallIntegerField(choices=method_choice, verbose_name='请求方式')

    cache_field = models.CharField(verbose_name='缓存字段', max_length=128, null=True, blank=True)#null=True,可能为空 blank=True 可能不传

    check = models.CharField(verbose_name='校验点', max_length=512)
    params = models.CharField(verbose_name='请求参数', max_length=2048, null=True, blank=True)
    headers = models.CharField(verbose_name='请求头信息', max_length=2048, null=True, blank=True)
    is_json = models.BooleanField(verbose_name='参数是否是json', default=False)
    json = models.CharField(verbose_name='json类型参数', max_length=2048, null=True, blank=True)
    status_choice = (
        (1, '通过'),
        (2, '未运行'),
        (3, '运行中'),
        (999, '失败')
    )
    status = models.SmallIntegerField(choices=status_choice, verbose_name='用例状态',
                                      default=2)  # 记录上一次的状态 每次执行后需要更新下这个表的这个字段
    report_batch = models.CharField(verbose_name='最后一次执行的批次号', null=True, max_length=512, blank=True)
    def __str__(self):
        return self.name

    class Meta:
        verbose_name = '用例表'
        verbose_name_plural = verbose_name
        db_table = 'case'
        ordering = ['-id']  # 按照id倒排


class CaseCollection(BaseModel):
    '''用例集合'''
    name = models.CharField(verbose_name='集合名', max_length=100, unique=True)
    desc = models.CharField(verbose_name='描述', max_length=200, null=True)
    user = models.ForeignKey(User, on_delete=models.DO_NOTHING, db_constraint=False, verbose_name='创建者')
    project = models.ForeignKey(Project, on_delete=models.DO_NOTHING, db_constraint=False, verbose_name='归属项目')
    report_batch = models.CharField(verbose_name='最后一次执行的批次号', null=True, max_length=512, blank=True)
    status_choice = (
        (2, '未运行'),
        (3, '运行中'),
        (4, '执行完毕')
    )
    status = models.SmallIntegerField(choices=status_choice, verbose_name='用例状态',
                                      default=2)
    case = models.ManyToManyField(Case,verbose_name='集合下的用例')


    def __str__(self):
        return self.name

    class Meta:
        verbose_name = '用例集合表'
        verbose_name_plural = verbose_name
        db_table = 'case_collection'
        ordering = ['-id']  # 按照id倒排
class Report(BaseModel):
    '''用例报告表'''
    url = models.CharField(verbose_name='请求URL', max_length=1024)
    project = models.ForeignKey(Project, verbose_name='项目', on_delete=models.DO_NOTHING, db_constraint=False)
    title = models.CharField(verbose_name='用例名称', max_length=100)
    params = models.CharField(verbose_name='请求参数', max_length=2048)
    response = models.CharField(verbose_name='接口返回值结果', max_length=2048)
    case = models.ForeignKey(Case, on_delete=models.DO_NOTHING, db_constraint=False, verbose_name='结果所属用例')
    case_collection = models.ForeignKey(CaseCollection, on_delete=models.DO_NOTHING, db_constraint=False,
                                        verbose_name='结果所属集合', null=True)
    batch = models.CharField(verbose_name='批次', null=True, max_length=128)  # 用于区分运行的第几批集合的用例
    reason = models.CharField(verbose_name='失败原因', null=True, max_length=128, blank=True)
    status_choice = (
        (1, '通过'),
        (999, '失败')
    )
    duration = models.IntegerField(verbose_name='用例耗时')
    status = models.SmallIntegerField(choices=status_choice, verbose_name='用例结果状态')
    user = models.ForeignKey(User, on_delete=models.DO_NOTHING, db_constraint=False, verbose_name='运行用户')

    class Meta:
        verbose_name = '用例报告表'
        verbose_name_plural = verbose_name
        db_table = 'report'
        ordering = ['-id']
class CasePremise(BaseModel):
    '''依赖用例的关系表'''
    case = models.ForeignKey(Case, verbose_name='用例id', on_delete=models.DO_NOTHING, db_constraint=False, unique=False,related_name='case')
    premise_case = models.ForeignKey(Case, verbose_name='被依赖用例的id', on_delete=models.DO_NOTHING, db_constraint=False,
                                     unique=False,related_name='premise_case')

    def __str__(self):
        return self.case

    class Meta:
        unique_together = ('case', 'premise_case')  # 联合主键，一个case对另外一个case只能依赖一次
        verbose_name = '依赖关系表'
        verbose_name_plural = verbose_name
        db_table = 'case_premise'

生成数据库：
1、makemigrations skssystem

2、migrate skssystem

3、生成结果如图：

四、数据库test——练习

1. 在项目下创建文件model_test.py
2. 复制如下内容到文件中model_test.py

import django, os
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'earth.settings')  # 设置django的配置文件
django.setup()
from skssystem import models

练习一、外键操作练习

• user表增加一条内容，
• pycharm--database 增加数据方式

然后model_test.py 内容如下

user_obj = models.User.objects.get(id=1)
data = {
    'name':'外键联系',
    'desc':'描述',
    'host':'http://127.0.0.1:8022',
    'user':user_obj

}
models.Project.objects.create(**data)

运行后，project 表中有一条内容

练习二、正向查询

project_obj = models.Project.objects.get(id=1)
print(project_obj)#返回项目名称
print(project_obj.user.nick)

练习三、反向查询

u_obj = models.User.objects.get(id=1)
print(u_obj.project_set.all())

练习四、删除--现象：project 表数据被删除

# 外键删除
models.Project.objects.get(id=1).delete()

# 反向删除
u_obj = models.User.objects.get(id=1)
u_obj.project_set.all().delete()

练习五、外键自关联
1、使用database 中使用sql语句插入数据

2、输入内容然后执行操

3、外键操作

#  外键自关联
models.CasePremise.objects.create(case_id=1,premise_case_id=2)

# 查询
case_obj = models.Case.objects.get(id=1) # 获取id为1 的用例信息

# CasePremise
# case_obj.case.all() ==  select * from CasePremise where case_id= 1;
qs = case_obj.case.all() # all() 返回的是一个列表的qs

# [case_id为1的CasePremise数据]

for item in qs: # qs实际是CasePremise的qs
    # item 是CasePremise 依赖数据的对象
    print(item.case.title)
    print(item.premise_case.id)

多对多

# INSERT INTO `case_collection`(`id`, `is_delete`, `create_time`, `update_time`, `name`, `desc`, `report_batch`, `status`, `project_id`, `user_id`) VALUES (1, 1, '2020-02-12 22:08:04.594509', '2020-02-12 22:08:04.594617', '测试平台回归', '登录和项目的回归', 'b4a64581-5805-49d5-8991-20c34656e07b', 4, 1, 2);
# 用例集合和用例是多对多的关系
# A集合和B集合
# A用例和B用例
# A集合-- A用例和B用例
# B集合-- A用例和B用例
case_obj_A = models.Case.objects.get(id=1)#用例A
case_obj_B = models.Case.objects.get(id=2)#用例B
coll_obj_A=models.CaseCollection.objects.get(id=1)#集合A
print(case_obj_A,case_obj_B,coll_obj_A)
#通过集合中case字段创建多对多的创建
coll_obj_A.case.add(case_obj_A)#通过add()方法，创建多对多的映射关系
coll_obj_A.case.add(case_obj_B)
coll_obj=models.CaseCollection.objects.get(id=1)#集合A
coll_obj.case.add(1)#创建时通过id 的方式也可以

****case_collection_case 表格中会出现两条数据

多对多创建

case_obj_A = models.Case.objects.get(id=1) # 获取用例A
case_obj_B = models.Case.objects.get(id=2) # 获取用例B
coll_obj = models.CaseCollection.objects.get(id=1) # 获取集合
coll_obj.case.add(case_obj_B) # 通过add方法 创建多对多映射关系
coll_obj.case.add(case_obj_A) # 通过add方法 创建多对多映射关系
coll_obj.case.add(1) # 创建时 通过id创建 也可以

 

多对多--查询

case_obj_A = models.Case.objects.get(id=1) # 获取用例A
case_obj_B = models.Case.objects.get(id=2) # 获取用例B
coll_obj = models.CaseCollection.objects.get(id=1) # 获取集合
print('正向查询',case_obj_A.case.all())
print('反向查询',case_obj_A.casecollection_set.all())

删除--多对多的关系

case_obj_A = models.Case.objects.get(id=1) # 获取用例A
case_obj_B = models.Case.objects.get(id=2) # 获取用例B
coll_obj = models.CaseCollection.objects.get(id=1) # 获取集合
coll_obj.case.clear()  # 清除掉所有和集合有关的用例关系
coll_obj.case.remove(1) # 通过用例id 进行删除
coll_obj.case.remove(case_obj_B) # 通过用例id 进行删除

更新--多对多

case_obj_A = models.Case.objects.get(id=1) # 获取用例A
case_obj_B = models.Case.objects.get(id=2) # 获取用例B
coll_obj = models.CaseCollection.objects.get(id=1) # 获取集合
coll_obj.case.set([2])  # 将用例id为1和2的和集合建立关系

五、接口开发--登录--退出登录--全局参数
1、将example/view.py 的login 复制到sksystems/views.py 下，并将导入的内容都复制

import time, django_redis,pickle
from django.views import View
from utils.custom_views import NbView, BaseView, PostView, GetView
from utils.tools import model_to_dict
from . import models, forms
from utils import const
from utils.custom_response import NbResponse
from utils.tools import md5
import json

class LoginView(View):
    '''登录'''
    def post(self, request):
        user_form_obj = forms.LoginForm(request.POST)
        if user_form_obj.is_valid():
            user = user_form_obj.cleaned_data['user']
            token = '%s%s' % (user.username, time.time())
            token = md5(token)
            try:
                redis = django_redis.get_redis_connection()
            except:
                raise Exception("连接不上redis，请检查redis！")
            redis.set(const.token_prefix+token, pickle.dumps(user), const.token_expire)
            return NbResponse(token=token, user=user.username)
        else:
            return NbResponse(-1, user_form_obj.error_format)

2、sksystem/urls.py 增加登录接口的路径

from django.urls import path
from . import views
urlpatterns = [
    path('login', views.LoginView.as_view()),#登录
]

3、sksystem 目录下创建forms.py,将exampl/forms.py的登录的内容复制到sksystem/forms.py

from django.core.exceptions import ValidationError
from django.db.models import Q
from django.forms import ModelForm, Form
from django import forms

from . import models
from utils.tools import ExtendForm

class LoginForm(Form, ExtendForm):
    username = forms.CharField(min_length=5, max_length=20, required=True)
    password = forms.CharField(min_length=6, max_length=20, required=True)

    def clean(self):
        if not self.errors:  # 校验errors里面是否有错误
            username = self.cleaned_data['username']
            password = self.cleaned_data['password']
            user = models.User.objects.filter(Q(phone=username) | Q(email=username))
            if user:
                user = user.first()
                if user.check_password(password):
                    self.cleaned_data['user'] = user
                    return self.cleaned_data
                else:
                    self.add_error('password','密码错误')

            else:
                self.add_error('username', '用户不存在')

4、修改settings.py下的redis的ip和密码

•  请求接口的过程

（1）earth/urls.py 也就是api

  (2)sksystem/urls.py 也就是login

  (3)sksystem/views.py loginview

5、用postman 请求接口

 

 退出接口

（1）sksystem/views.py

class LogoutView(View):
    '''退出'''
    def post(self, request):
        redis = django_redis.get_redis_connection()
        redis.delete(const.token_prefix+request.META.get('HTTP_TOKEN'))
        return NbResponse()

  (2)sksystem/urls.py

path('logout', views.LogoutView.as_view()),#

（3）postman接口

 全局参数接口

 

（1）sksystem/views.py

1 # 全局参数的接口。
2 class ParameterView(NbView):
3     search_field = ["name"]  # 根据哪些字段来搜索
4     filter_field = []  # 根据哪些字段来搜索
5     model_class = models.Parameter  # 用哪个model类
6     form_class = forms.ParameterForm  # 用哪个form类

 

（3）sksystem/forms.py

class ParameterForm(ModelForm, ExtendForm):
    class Meta:
        model = models.Parameter
        exclude = ['is_delete']

 

（4）sksystem/urls.py

path('parameter', views.ParameterView.as_view()),#全局操作

 

  (5)postman