def get_mobile(self):
"""读取 get_mobile.json 里面的 手机号码"""
# get_mobile = self.phone_code_generator()
use_json = UseJson("../data_config/get_mobile.json")
# use_json.write_data(get_mobile)
get_mobile = use_json.read_data()
return get_mobile
def run_dependent(self):
"""执行依赖测试，获取结果"""
row_num = self.use_excel.get_row_num(self.case_id)
# request_data = self.data.get_data_values(row_num)
request_data = self.data.get_request_excel_data(row_num) # 直接读取 excel 中的 data
if request_data.find("${mobile}") != -1:
# request_data = request_data.replace("${mobile}", '18888881937')
request_data = request_data.replace("${mobile}", self.tool.get_mobile())
elif request_data.find("${borrowerCode}") != -1:
use_json = UseJson("../data_config/borrowerCode.json")
borrowerCode = use_json.get_data("borrowerCode")
request_data = request_data.replace("${borrowerCode}", borrowerCode)
elif request_data.find("${write_borrowerCode}") != -1:
self.use_mysql.select_borrowercode()
use_json = UseJson("../data_config/borrowerCode.json")
borrowerCode = use_json.get_data("borrowerCode")
request_data = request_data.replace("${write_borrowerCode}", borrowerCode)
# request_data = eval(request_data)
header = self.data.get_request_header(row_num)
if header == 'get_cookie,31G':
use_json = UseJson("../data_config/config_header.json")
cookie_value = use_json.get_data("Cookie")
header = {"Content-Type": "application/json", "Product": "31G", "Cookie": cookie_value}
else:
header = eval(header)
method = self.data.get_request_method(row_num)
url = self.data.get_request_url(row_num)
res = self.run_method.run_main(method, url, data=request_data, header=header, params=request_data)
return res
def select_borrowercode(self):
"""根据手机号查询sc_borrower.code"""
# mobile = 18888884356
use_json = UseJson("../data_config/get_mobile.json")
mobile = use_json.read_data()
str = "SELECT * FROM supplychain.`sc_borrower` WHERE mobile={}".format(
mobile)
result = self.select_db(str)
code = result[0][1] # 放回的是一个元组，通过下标访问元组
use_json = UseJson("../data_config/borrowerCode.json")
use_json.write_data({"borrowerCode": "{}".format(code)})
def base_run(self):
res = None
pass_count = []
fail_count = []
no_run_count = []
rows_count = self.data.get_case_rows()
log_file = "../log/interface-demo03.log" # 每次执行用例前，将log日志文件清空数据
with open(log_file, "w") as lf:
lf.seek(
0, 0
) # 加上lf.seek(0)，把文件定位到position 0；若没有这句话，文件是定位到数据最后，truncate也是从最后这里删除。
lf.truncate()
if self.excel.sheet_name == 0:
self.tool.write_mobile() # 向get_mobile.json 中写入手机号码
# self.__mobile__ = self.tool.phone_code_generator()
for i in range(1, rows_count):
try:
is_run = self.data.get_is_run(i)
if is_run:
url = self.data.get_request_url(i)
method = self.data.get_request_method(i)
# data = self.data.get_request_data(i) # 获取excel 中的 data
data = self.data.get_request_excel_data(
i) # 直接读取 excel 中的 data
# 获取依赖单元格
depend_case = self.data.is_depend(i)
if depend_case != None:
self.depend_data = DependentData(depend_case)
depend_response_data = self.depend_data.get_value_for_key(
i) # 获取 依赖字段的 响应数据
# depend_key = self.data.get_depend_field(i) # 获取 请求依赖的 key
# data[depend_key] = depend_response_data # 将依赖case的响应返回中某个字段的value赋值给该接口请求中某个参数
if data.find("${mobile}") != -1:
# data = data.replace("${mobile}", self.__mobile__)
data = data.replace("${mobile}",
self.tool.get_mobile())
elif data.find("${idCardNumber}") & data.find(
"${name}") != -1:
data = data.replace("${idCardNumber}",
self.tool.getRandomIdCard())
name = "雨点" + self.tool.num_chinese(
self.tool.get_mobile()[-4:])
data = data.replace("${name}", name)
elif data.find("${businessLicenseNumber}") != -1:
data = data.replace("${businessLicenseNumber}",
self.tool.license_no())
elif data.find("${write_borrowerCode}") != -1:
self.use_mysql.select_borrowercode()
use_json = UseJson("../data_config/borrowerCode.json")
borrowerCode = use_json.get_data("borrowerCode")
data = data.replace("${write_borrowerCode}",
borrowerCode)
elif data.find("${borrowerCode}") != -1:
use_json = UseJson("../data_config/borrowerCode.json")
borrowerCode = use_json.get_data("borrowerCode")
data = data.replace("${borrowerCode}", borrowerCode)
elif data.find("${creditApplyCode}") != -1:
use_json = UseJson(
"../data_config/credit_apply_code.json")
code = use_json.get_data("code")
# code = use_json.read_data()
data = data.replace("${creditApplyCode}", code)
now = time.strftime("%Y-%m-%d 08:%M:%S")
data = data.replace("${nowdate}", now)
elif data.find("${nowdate}") != -1:
now = time.strftime("%Y-%m-%d 08:%M:%S")
data = data.replace("${nowdate}", now)
# data = self.data.get_request_excel_data_wrapper(i, self.mobile) # 直接读取 excel 中的 data
# data = self.data.get_data_values(i)
# data = self.data.get_data_values_wrapper(i, self.mobile)
header = self.data.get_request_header(
i) # 获取 excel 中的 header 关键字
# header_json = self.data.get_header_value(i) # 获取 json 中的 header_key 对应的头文件数据
expect_data = self.data.get_expect_data(i)
expect = json.loads(expect_data)
# # 获取依赖单元格
# depend_case = self.data.is_depend(i)
# if depend_case != None:
# self.depend_data = DependentData(depend_case)
# depend_response_data = self.depend_data.get_value_for_key(i) # 获取 依赖字段的 响应数据
# # depend_key = self.data.get_depend_field(i) # 获取 请求依赖的 key
# # data[depend_key] = depend_response_data # 将依赖case的响应返回中某个字段的value赋值给该接口请求中某个参数
if header == '{"Content-Type":"application/json"}':
header1 = eval(header)
# header1 = {"Content-Type": "application/json"}
# data = json.dumps(data)
# res = self.run_method.run_main(method, url, data, header=header_json, params=data)
res = self.run_method.run_main(method,
url,
data,
header=header1,
params=data)
elif header == '{"Content-Type": "application/json", "Product": "31G"}':
header1 = eval(header)
res = self.run_method.run_main(method,
url,
data,
header=header1,
params=data)
elif header == '{"Content-Type":"multipart/form-data"}':
# data = {"imageType": "ID_CARD_FRONT_IMAGE"}
data = eval(data) # 把 str 转成 dict
with open("H:/wahh.jpg", "rb") as f: # 打开上传文件
r = f.read()
files = {"file": ("wahh.jpg", r, "image/jpeg")}
use_json = UseJson("../data_config/config_header.json")
header_json = use_json.read_data()
# header_json = { # "Content-Type": "multipart/form-data", # 不要画蛇添足写这一句
# "Cookie": "SESSION=NGExN2Y0MzUtNjVhNy00MDRkLWIyZjItMGFjZWVlMDFiZjM5"}
response = requests.post(url=url,
data=data,
files=files,
headers=header_json) # 获取返回请求
res = response.text
# res = self.run_method.run_main(method, url, data, header=header_json, params=data)
elif header == 'get_cookie':
use_json = UseJson("../data_config/config_header.json")
cookie_value = use_json.get_data("Cookie")
# a = json.dumps(cookie1)
# cookie = re.findall(r'{(.*?)}', a)
# cookie_value = cookie1['Cookie']
header_json = {
"Content-Type": "application/json",
"Cookie": cookie_value
}
res = self.run_method.run_main(method,
url,
data,
header=header_json,
params=data)
elif header == 'get_cookie,31G':
use_json = UseJson("../data_config/config_header.json")
cookie_value = use_json.get_data("Cookie")
# a = json.dumps(cookie1)
# cookie = re.findall(r'{(.*?)}', a)
# cookie_value = cookie1['Cookie']
header_json = {
"Content-Type": "application/json",
"Product": "31G",
"Cookie": cookie_value
}
res = self.run_method.run_main(method,
url,
data,
header=header_json,
params=data)
elif header == "write_Cookie1":
# res = self.run_method.run_main(method, url, data, header=header_json, params=data)
use_header = UseHeader(res)
use_header.write_cookie()
elif header == "get_Cookie1":
use_json = UseJson("../data_config/cookie.json")
cookie = use_json.get_data("apsid")
cookies = {"apsid": cookie}
res = self.run_method.run_main(method,
url,
data=data,
header=cookies,
params=data)
else:
res = self.run_method.run_main(method,
url,
data,
header,
params=data)
if self.tool.is_contain(expect, res):
self.data.write_actual(
i, json.dumps(res,
ensure_ascii=False)) # 返回值为中文时，不乱码
self.data.write_result(i, "PASS")
pass_count.append(i)
else:
self.data.write_actual(
i, json.dumps(res, ensure_ascii=False))
self.data.write_result(i, "FAIL")
with open(log_file, "a", encoding="utf-8") as lf:
lf.write("\n第{}条用例实际结果与期望结果不一致:\n".format(i))
lf.write("期望结果：{}\n实际结果：{}\n".format(expect, res))
fail_count.append(i)
else:
no_run_count.append(i)
except Exception as e:
self.data.write_result(i, str(e))
with open(log_file, "a", encoding="utf-8") as lf:
lf.write("\n第%s条用例报错：\n" % i)
initLogging(log_file, e)
fail_count.append(i)
def get_data_values(self, row):
"""通过获取请求关键字拿到data数据"""
use_json = UseJson('../data_config/request_data.json')
request_data = use_json.get_data(self.get_request_data(row))
return request_data
def get_header_value(self, row):
"""获取头关键字 拿到data数据"""
use_json = UseJson('../data_config/request_header.json')
request_header = use_json.get_data(self.get_request_header(row))
return request_header
def base_run(self):
res = None
pass_count = []
fail_count = []
no_run_count = []
rows_count = self.data.get_case_rows()
log_file = "../log/interface-demo02.log" # 每次执行用例前，将log日志文件清空数据
with open(log_file, "w") as lf:
lf.seek(
0, 0
) # 加上lf.seek(0)，把文件定位到position 0；若没有这句话，文件是定位到数据最后，truncate也是从最后这里删除。
lf.truncate()
self.tool.write_mobile() # 向get_mobile.json 中写入手机号码
for i in range(1, rows_count):
try:
is_run = self.data.get_is_run(i)
if is_run:
url = self.data.get_request_url(i)
method = self.data.get_request_method(i)
data = self.data.get_request_excel_data(
i) # 直接读取 excel 中的 data
if data.find("${mobile}") != -1:
data = data.replace("${mobile}",
self.tool.get_mobile())
elif data.find("${idCardNumber}") & data.find(
"${name}") != -1:
data = data.replace("${idCardNumber}",
self.tool.getRandomIdCard())
name = "雨点" + self.tool.num_chinese(
self.tool.get_mobile()[-4:])
data = data.replace("${name}", name)
elif data.find("${businessLicenseNumber}") != -1:
data = data.replace("${businessLicenseNumber}",
self.tool.license_no())
header = self.data.get_request_header(
i) # 获取 excel 中的 header 关键字
expect_data = self.data.get_expect_data(i)
expect = json.loads(expect_data)
depend_case = self.data.is_depend(i)
if depend_case != None:
self.depend_data = DependentData(depend_case)
depend_response_data = self.depend_data.get_value_for_key(
i) # 获取 依赖字段的 响应数据
if header == '{"Content-Type":"application/json"}':
header_json = eval(header)
res = self.run_method.run_main(method,
url,
data,
header=header_json,
params=data)
elif header == '{"Content-Type":"multipart/form-data"}':
data = eval(data) # 把 str 转成 dict
with open("H:/wahh.jpg", "rb") as f: # 打开上传文件
r = f.read()
files = {"file": ("wahh.jpg", r, "image/jpeg")}
use_json = UseJson("../data_config/config_header.json")
header_json = use_json.read_data()
# header_json = { # "Content-Type": "multipart/form-data", # 不要画蛇添足写这一句
# "Cookie": "SESSION=NGExN2Y0MzUtNjVhNy00MDRkLWIyZjItMGFjZWVlMDFiZjM5"}
response = requests.post(url=url,
data=data,
files=files,
headers=header_json) # 获取返回请求
res = response.text
elif header == 'get_cookie':
use_json = UseJson("../data_config/config_header.json")
cookie_value = use_json.get_data("Cookie")
header_json = {
"Content-Type": "application/json",
"Cookie": cookie_value
}
res = self.run_method.run_main(method,
url,
data,
header=header_json,
params=data)
elif header == "write_Cookie1":
use_header = UseHeader(res)
use_header.write_cookie()
elif header == "get_Cookie1":
use_json = UseJson("../data_config/config_cookie.json")
cookie = use_json.get_data("apsid")
cookies = {"apsid": cookie}
res = self.run_method.run_main(method,
url,
data=data,
header=cookies,
params=data)
else:
res = self.run_method.run_main(method,
url,
data,
header,
params=data)
if self.tool.is_contain(expect, res):
self.data.write_result(i, "pass")
pass_count.append(i)
else:
self.data.write_result(i, json.dumps(res))
with open(log_file, "a", encoding="utf-8") as lf:
lf.write("\n第%s条用例实际结果与期望结果不一致:\n" % i)
lf.write("期望结果：%s\n实际结果：%s\n" % (expect, res))
fail_count.append(i)
else:
no_run_count.append(i)
except Exception as e:
self.data.write_result(i, str(e))
with open(log_file, "a", encoding="utf-8") as lf:
lf.write("\n第%s条用例报错：\n" % i)
initLogging(log_file, e)
fail_count.append(i)
def write_mobile(self):
"""写入 get_mobile.json 手机号码"""
get_mobile = self.phone_code_generator()
use_json = UseJson("../data_config/get_mobile.json")
use_json.write_data(get_mobile)
def write_cookie(self):
cookie = requests.utils.dict_from_cookiejar(self.get_cookie())
usejson = UseJson()
usejson.write_data(cookie)