def get_data_001():
# [("123","123"),("hello","hello"),("#!!","#!!")]
# with open("C:\\Users\\bob1994\\Desktop\\homework\\data\\data_001.yml", "r", encoding="utf-8") as f:
send_expect_data = []
data = GetData().get_data("data_001.yml").get("TestSmsData")
for i in data.values():
send_expect_data.append((i.get("send"), i.get("expect")))
return send_expect_data
def get_login_data():
data = GetData().get_yaml_data('login_data_1.yml')
"""
{'login_data': {'test_num1': {'username': 13606463805, 'password': '******', 'exp': '我的收藏'}}}
"""
data_values = data.get('login_data')
data_list = []
for i in data_values.keys():
data_list.append((i, data_values.get(i).get('username'),
data_values.get(i).get('password'),
data_values.get(i).get('exp')))
return data_list
def get_login_suc_data():
"""获取测试用例数据"""
data = GetData().get_yaml_data('login_test_data_2.yml')
data_suc_list = []
data_dis_list = []
for i in data:
if data.get(i).get('toast') is None:
data_suc_list.append(
(i, data.get(i).get('username'), data.get(i).get('password'), data.get(i).get('exp_data')))
else:
data_dis_list.append((i, data.get(i).get('username'), data.get(i).get('password'), data.get(i).get('toast'),
data.get(i).get('exp_data')))
return data_suc_list
def login_data():
login_data_info = GetData().get_yaml_data('login_test_data_2.yml')
suc_data_list = []
dis_data_list = []
for i in login_data_info:
if login_data_info.get(i).get('toast'):
dis_data_list.append((i, login_data_info.get(i).get('username'),
login_data_info.get(i).get('password'),
login_data_info.get(i).get('toast'),
login_data_info.get(i).get('exp_data')))
else:
suc_data_list.append((i, login_data_info.get(i).get('username'),
login_data_info.get(i).get('password'),
login_data_info.get(i).get('exp_data')))
return {'suc': suc_data_list, 'dis': dis_data_list}
class Runtest:
def __init__(self):
self.data=GetData()
self.request=MyRequests()
self.path="C:\\Learn\\Interface_test\\mooc\\dataconfig\\"
self.new_file="interface"+time.strftime("%y-%m-%d %H-%M-%S")+".xls"
self.file_name="interface.xlsx"
def run_test(self):
read=xlrd.open_workbook(self.path+self.file_name)
write_data=copy(read)
write_sheet=write_data.get_sheet(0)
rows=self.data.get_excel_lines()
for i in range(1,rows):
case_id=self.data.get_test_id(i)
print(case_id)
url=self.data.get_url(i)
data=self.data.get_request_data(i)
method=self.data.get_methon(i)
header=self.data.get_header(i)
expect=self.data.get_expect(i)
depends_id=self.data.get_depends_id(i)
depends_on=self.data.get_depends_on(i)
if self.data.get_is_run(i):
if depends_id!="":
dp=DependsData(depends_id)
res_data=dp.get_data_for_key(i)
data[depends_on]=res_data
res=self.request.run_main(url,method,data,header)
print("实际结果为："+res)
print("预期结果为："+expect)
if is_contain(expect,res):
write_sheet.write(i,11,"pass")
else:
write_sheet.write(i,11,"Fail")
write_data.save(self.path+self.new_file)
class DependsData:
def __init__(self,caseid):
self.data=GetData()
self.excel=OperationExcel()
self.caseid=caseid
def run_depend_case(self):
resquet=MyRequests()
i=self.excel.get_row_num(self.caseid)
url=self.data.get_url(i)
data=self.data.get_request_data(i)
method=self.data.get_methon(i)
header=self.data.get_header(i)
res=resquet.run_main(url,method,data,header)
return json.loads(res)
#╗ы╚Аих╗пох
def get_data_for_key(self,row):
depend_data=self.data.get_depends_key(row)
response_data=self.run_depend_case()
json_exe=parse(depend_data)
madle=json_exe.find(response_data)
return [math.value for math in madle][0]
class RunTest:
def __init__(self):
self.runmethod = RunMethod()
self.data = GetData()
# 程序执行
def go_on_run(self):
rows_count = self.data.get_case_lines()
for i in range(1,rows_count):
url = self.data.get_url(i)
method = self.data.get_run_method(i)
is_run = self.data.get_is_run(i)
data = self.data.get_data_for_json()
header = self.data.get_is_header(i)
if is_run:
res = self.runmethod.run_main(method,url,header,data)
return res
class GetLoginData(object):
"""获取login数据类"""
data = GetData().get_yaml_data('login_test_data_2.yml')
data_suc_list = []
data_dis_list = []
for i in data:
if data.get(i).get('toast') is None:
data_suc_list.append(
(i, data.get(i).get('username'), data.get(i).get('password'),
data.get(i).get('exp_data')))
else:
data_dis_list.append(
(i, data.get(i).get('username'), data.get(i).get('password'),
data.get(i).get('toast'), data.get(i).get('exp_data')))
def get_login_suc_data(self):
"""获取正向测试用例数据"""
return self.data_suc_list
def get_login_dis_data(self):
"""获取逆向测试用例数据"""
return self.data_dis_list
def __init__(self):
self.runmethod = RunMethod()
self.data = GetData()
def __init__(self):
self.data=GetData()
self.request=MyRequests()
self.path="C:\\Learn\\Interface_test\\mooc\\dataconfig\\"
self.new_file="interface"+time.strftime("%y-%m-%d %H-%M-%S")+".xls"
self.file_name="interface.xlsx"
def __init__(self):
self.run_method = RunMethod()
self.data = GetData()
self.com_util = CommonUtil()
class RunTest():
def __init__(self):
self.run_method = RunMethod()
self.data = GetData()
self.com_util = CommonUtil()
# 程序执行
def go_on_run(self):
res = None
rows_count = self.data.get_case_line()
for i in range(1, rows_count):
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)
request_data = self.data.get_data_for_json(i)
expect = self.data.get_expcet_data(i)
header = self.data.is_header(i)
depend_case = self.data.is_depend(i)
res = self.run_method.run_main(method, url, data, header)
if depend_case != None:
self.dependent_data = DependdentData()
depend_response_data = self.depend_data.get_data_for_key(i)
if self.com_util.is_contain(expect, res):
self.data.write_result(i, 'pass')
else:
self.data.write_result(i, 'fail')
def __init__(self,caseid):
self.data=GetData()
self.excel=OperationExcel()
self.caseid=caseid