def run_case(self):
rows = excel_data.get_rows()
for i in range(rows):
data = excel_data.get_rows_value(i + 2)
is_run = data[2]
if is_run == 'yes':
method = data[5]
url = data[4]
data1 = data[6]
request.send_post(method, url, data1)
def run_case(self):
rows = excel_data.get_rows()
for i in range(rows):
# i是从0开始的，excel中第一行内容的行号是i=2
data = excel_data.get_rows_value(i + 2)
#['imooc_001', '登录', 'yes', 'create_user', '/login/', 'post', '{"username":"******"}', 'yes', 'message', None]
is_run = data[2]
except_method = data[10]
except_result = data[11]
if is_run == "yes":
url = data[5]
method = data[6]
data1 = data[7]
res = request.run_main(method, url, data1)
#int和str无法比较，需要强转一下
code = str(res['errorCode'])
desc = res['errorDesc']
#如果预期结果方式为mec：message+errorcode
if except_method == "mec":
config_message = handle_result(url, code)
if desc == config_message:
excel_data.excel_write_data(i + 2, 12, "通过")
print("case通过")
else:
excel_data.excel_write_data(i + 2, 12, "失败")
excel_data.excel_write_data(i + 2, 13, json.dumps(res))
print("case失败")
if except_method == "errorcode":
if except_result == code:
excel_data.excel_write_data(i + 2, 12, "通过")
print("case通过")
else:
excel_data.excel_write_data(i + 2, 12, "失败")
excel_data.excel_write_data(i + 2, 13, json.dumps(res))
print("case失败")
# 如果预期结果方式为json格式
if except_method == "json":
if code == 1000:
status_str = "sucess"
else:
status_str = "error"
except_result_json = get_result_json(url, status_str)
# print(res,'-------',except_result_json)
result = handle_result_json(res, except_result_json)
if result:
excel_data.excel_write_data(i + 2, 12, "通过")
print("case通过")
else:
excel_data.excel_write_data(i + 2, 12, "失败")
excel_data.excel_write_data(i + 2, 13, json.dumps(res))
print("case失败")
def run_case(self):
rows = excel_data.get_rows()
for i in range(rows - 1):
data = excel_data.get_rows_value(i + 2)
is_run = data[2]
if is_run == 'yes':
method = data[5]
url = data[4]
data1 = data[6]
res = request_base.run_main(method, url, data1)
print(method)
print(url)
print(data1)
print(res)
def run_case(self):
rows = excel_data.get_rows()
for i in range(rows):
get_cookie = None
cookie = None
header = None
data = excel_data.get_rows_value(i + 2)
is_run = data[2]
if is_run == "yes":
method = data[5]
# アクセスのapi
url = data[4]
data1 = data[6]
is_header = data[8]
# 予想結果判断の方法
excepect_method = data[9]
# 予想結果
excepect_result = data[10]
# クッキーの操作
cookie_method = data[7]
if cookie_method == "yes":
cookie = get_cookie_value("app")
if cookie_method == "write":
"""
cookie取得後書き込む
"""
get_cookie = {"is_cookie": "app"}
if is_header == "yes":
header = get_header()
res = request.run_main(method, url, data1, cookie, get_cookie, header)
# print(res)
# 結果と予想結果を比較する
# サーバーのerrorCode
code = str(res["errorCode"])
message = res["errorDesc"]
if excepect_method == "mec":
config_message = handel_result(url, str(code))
if message == config_message:
excel_data.excel_write_data(i+2, 12, "成功")
print("テスト成功")
else:
excel_data.excel_write_data(i + 2, 12, "失敗")
# 失敗する場合は結果値も記入
excel_data.excel_write_data(i + 2, 13, json.dumps(res))
print("case失敗")
elif excepect_method == "errorcode":
if excepect_result == code:
excel_data.excel_write_data(i + 2, 12, "成功")
print("テスト成功")
else:
excel_data.excel_write_data(i + 2, 12, "失敗")
# 失敗する場合は結果値も記入
excel_data.excel_write_data(i + 2, 13, json.dumps(res))
print("case失敗")
elif excepect_method == "json":
# err_codeに基づいての判断
if code == "1000":
status_str = "success"
else:
status_str = "error"
excepect_result = get_result_json(url, status_str)
# サーバーからのリスポンスとjsonデータ比較
result = handel_result_json(res, excepect_result)
if result:
excel_data.excel_write_data(i + 2, 12, "成功")
print("テスト成功")
else:
excel_data.excel_write_data(i + 2, 12, "失敗")
# 失敗する場合は結果値も記入
excel_data.excel_write_data(i + 2, 13, json.dumps(res))
print("case失敗")
def run_case(self):
rows = excel_data.get_rows()
for i in range(rows):
cookie=None
get_cookie = None
header = None
depend_data = None
data = excel_data.get_rows_value(i+2)
is_run = data[2]
if is_run == 'yes':
is_depend = data[3]
data1 = json.loads(data[7])
if is_depend:
'''
获取依赖数据
'''
depend_key = data[4]
depend_data = get_data(is_depend)
#print(depend_data)
data1[depend_key] = depend_data
method = data[6]
url = data[5]
is_header = data[9]
excepect_method = data[10]
excepect_result = data[11]
cookie_method = data[8]
if cookie_method == 'yes':
cookie = get_cookie_value('app')
if cookie_method == 'write':
'''
必须是获取到cookie
'''
get_cookie={"is_cookie":"app"}
if is_header == 'yes':
header = get_header()
res = request.run_main(method,url,data1,cookie,get_cookie,header)
#print(res)
code = str(res['errorCode'])
message = res['errorDesc']
if excepect_method == 'mec':
config_message = handle_result(url,code)
if message == config_message:
excel_data.excel_write_data(i+2,13,"通过")
else:
excel_data.excel_write_data(i+2,13,"失败")
excel_data.excel_write_data(i+2,14,json.dumps(res))
if excepect_method == 'errorcode':
if excepect_result == code:
excel_data.excel_write_data(i+2,14,"通过")
else:
excel_data.excel_write_data(i+2,13,"失败")
excel_data.excel_write_data(i+2,14,json.dumps(res))
if excepect_method == 'json':
if code == 1000:
status_str='sucess'
else:
status_str='error'
excepect_result = get_result_json(url,status_str)
result = handle_result_json(res,excepect_result)
if result:
excel_data.excel_write_data(i+2,13,"通过")
else:
excel_data.excel_write_data(i+2,13,"失败")
excel_data.excel_write_data(i+2,14,json.dumps(res))