def update_fail_num(self, if_name):
"""
更新Fail_num字段
:param if_name:
:return:
"""
type = Base.getApiType(self, if_name)
sql = "UPDATE api_pass_rate_wph SET url_target='" + url_target + "',`type`='" + type + "',fail_num=fail_num+1 WHERE if_name = '" + if_name + "';"
return Base.query(self, sql)
def update_pass_num(self, if_name):
type = Base.getApiType(self, if_name)
sql = "UPDATE api_pass_rate_wph SET url_target='" + url_target + "',`type`='" + type + "',pass_num=pass_num+1 WHERE if_name = '" + if_name + "';"
return Base.query(self, sql)
def set_test_result(cls, response, status_code, interfacename, casename, comment, result):
"""
存入测试结果
:param response:
:param status_code:
:param interfacename:
:param casename:
:param comment:
:param result:
:param main:
:return:
"""
base = Base()
tr = test_result()
tr.__init__()
status = ''
res_time = ''
main = Run.Main
type = base.getApiType(interfacename)
try:
res_time = Misc.read_from_file('res_time')[0]
status = response['succ']
cls.response_new = 'succ:%s' % response['succ']
try:
if response['succ'] != '1':
# 有可能不存在msg，try一下
cls.response_new = response['msg']
except:
pass
except:
status = status_code
cls.response_new = Base.todo_string(response)
finally:
try:
if main in 'api':
# 操作 api_pass_rate表
if result in 'Fail':
if 'xx' in url_target:
apr.update_fail_num(interfacename)
else:
aprwph.update_fail_num(interfacename)
else:
if 'xx' in url_target:
apr.update_pass_num(interfacename)
else:
aprwph.update_pass_num(interfacename)
# 操作api_performance表
if int(res_time) > 0.3:
status = 'Fail'
else:
status = 'Pass'
data = {
"if_name": interfacename,
"case_name": casename,
"res_time": res_time,
"type": type,
"status": status,
}
ap.insert_apiPerformance(data)
# 操作test_result表
data = {
"if_name": interfacename,
"case_name": casename,
"comment": comment,
"status": status,
"result": result,
"response": cls.response_new,
"url_target": url_target,
"type": type,
"main": main,
}
tr.insert_testResult(data)
except Exception as msg:
print (msg)
raise
