def addproduct():
'''
新增产品
{
"product":"Nahsor自动化测试平台",
"explain":"一个接口自动化测试平台，功能强大，很厉害就是了。",
"leader":"浪晋",
"remark":"这是例子"
}
'''
dictdata = request.get_json()
product = dictdata["product"]
explain = dictdata["explain"]
leader = dictdata["leader"]
remark = dictdata["remark"]
now = common.get_current_time()
sql = "insert into t_product " \
"values(null,'%s','%s','%s','%s','%s',null);" \
% (product,explain,leader,remark, now)
print(sql)
res = dbfucs.excute(sql)
response = {}
response["code"] = 200
response["data"] = res
response["msg"] = "新增成功！！！"
return jsonify(response)
def addmodule():
'''
新增模块
{
"projectid":"所属项目id",
"module":"模块名称",
"explain":"描述",
"leader":"责任人",
"remark":"备注"
}
'''
dictdata = request.get_json()
projectid = dictdata["projectid"]
module = dictdata["module"]
explain = dictdata["explain"]
leader = dictdata["leader"]
remark = dictdata["remark"]
sql = "insert into " \
"t_modules " \
"values(null,'%s','%s','%s','%s','%s','%s',null);" \
% (projectid, module, explain, leader, remark, common.get_current_time())
res = dbfucs.excute(sql)
response = {}
response["code"] = 200
response["data"] = res
response["msg"] = "新增成功！！！"
return jsonify(response)
def updatamodule():
'''
更新模块信息
{
"pid":4,
"projectid":2,
"module":"模块名称",
"explain":"描述",
"leader":"责任人",
"remark":"备注"
}
'''
dictdata = request.get_json()
pid = dictdata["pid"]
projectid = dictdata["projectid"]
module = dictdata["module"]
explain = dictdata["explain"]
leader = dictdata["leader"]
remark = dictdata["remark"]
sql = "UPDATE `t_modules`\
SET `projectid` = '%s',\
`modules` = '%s',\
`explain` = '%s',\
`leader` = '%s',\
`remark` = '%s', \
`updatatime` = '%s'\
WHERE (`id` = '%s')" % (projectid, module, explain, leader, remark,
common.get_current_time(), pid)
res = dbfucs.excute(sql)
response = {}
response["code"] = 200
response["data"] = res
response["msg"] = "更新成功！！！"
return jsonify(response)
def addproject():
'''
新增项目
{
"productid":"5",
"project":"Nahsor自动化测试平台WEB端",
"explain":"功能强大，厉害的不行",
"leader":"浪晋",
"remark":"没有备注"
}
'''
dictdata = request.get_json()
productid = dictdata["productid"]
project = dictdata["project"]
explain = dictdata["explain"]
leader = dictdata["leader"]
remark = dictdata["remark"]
now = common.get_current_time()
sql = "insert into t_project " \
"values(null,'%s','%s','%s','%s','%s','%s',null);" \
% (productid,project,explain,leader,remark,now)
res = dbfucs.excute(sql)
response = {}
response["code"] = 200
response["data"] = res
response["msg"] = "新增成功！！！"
return jsonify(response)
def add_comment(args, result):
id = args[0]
phone_num = args[1]
comment = args[2]
article = Article.objects(_id=id).first()
user = User.objects(phone_num=phone_num).first()
if article and user:
tmp_comment = dict()
tmp_comment['comment_id'] = str(uuid.uuid1()).replace('-', '')
tmp_comment['account'] = user.account
tmp_comment['comment'] = comment
tmp_comment['time'] = get_current_time()
comment_list = article.comment_list
comment_list.append(tmp_comment)
article.save()
result['status'] = 'success'
else:
result['status'] = 'fail'
result['msg'] = 'article or user not exist'
def uploadtestcase():
file = request.files['file']
filetype = file.filename.split(".")[1]
if filetype != "har":
filetype = "postman"
# 上传并解析
if _upload_files(file):
testcases = validate_req_by_file(file_path=os.path.join(
"./app/uploads/", file.filename),
type=filetype)
# 需要对应的postman和har的请求中包含以下字段
failed, success = 0, 0
for case in testcases:
moduleid = case.get("moduleid")
testname = case.get("testname")
testtype = case.get("testtype")
explain = case.get("explain")
requests = case.get("request")
validate = case.get("validate")
extract = case.get("extract")
leader = case.get("leader")
remark = case.get("remark")
# 插入sql数据
sql = "insert into t_testcass \
(`moduleid`, `testname`, `testtype`, `explain`, \
`request`, `validate`, `extract`, `leader`, `remark`, `createtime`) \
values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s');\
" % (moduleid, testname, testtype, explain, requests, validate,
extract, leader, remark, get_current_time())
if excute(sql):
success += 1
else:
failed += 1
res = {"code": 200, "msg": "执行成功,成功导入%s个,失败%s个" % (success, failed)}
return jsonify(res)
else:
return jsonify({"code": -100, "msg": "上传失败"})
def insert_test_result(cassid,
status="成功",
runtime="",
result="",
validate="",
version=-1):
'''
将测试结果存入到数据库
'''
from app.utils.common import get_current_time
sql = "INSERT INTO `t_reports` " \
"(`cassid`, `status`, `runtime`, `result`, `validate`, `createtime`, `version`) " \
"VALUES ('%s', '%s', '%s', '%s', '%s', '%s', %d)" % (cassid,status,runtime,result,validate, get_current_time(), version)
dbres = excute(sql)
if dbres != True:
Logger.error("保存测试结果到数据库出错，错误信息 --> %s" % dbres)