在modes.py建立模型
from django.db import models from django.contrib.auth.models import User # 关联参数表 class Parameters(models.Model): parameter = models.CharField(max_length=500, default="") # 参数 param_value = models.CharField(max_length=500, default="") # 参数对应值 update_time = models.DateTimeField(auto_now=True) create_time = models.DateTimeField(auto_now_add=True) def __str__(self): return self.parameter
执行命令建表:
> python manage.py makemigrations
python manage.py makemigrations --empty yourappname # 清缓存的时候使用
> python manage.py migrate
python manage.py createsuperuser # 建管理员用户
查询:
url = Case.objects.values('api').filter(id=case_id)
values = Step.objects.values_list('step_name', 'method', 'params', 'expect_params', 'headers', 'case_id', 'database_id', 'expect_db').filter(id=step)
或者:
step = Step.objects.get(id=step_id)
step_name = step.step_name
插入:
res = ResultDetail(step_id=step, step_name=step_name, api_result=result, expect_params=expect, actual_params=actual, expect_db=expect_db, actual_db=actual_db, db_result=db_result)
res.save()
或者:
res = ResultDetail()
res.actual_params = actual
res.save()
更新:
Parameters.objects.filter(parameter=key).update(param_value=value)
或者:
step = Step.objects.get(id=step_id)
step.status = 3
step.save()
删除:
models.UserInfo.objects.filter(user='yangmv').delete()
ResultDetail.objects.all().delete()