def test_cases(self, case): #把每一条用例（字典）存放到case里面
global TestResult #全局变量
method = case['Method']
url = case['Url']
param = eval(case['Params'])
# 发起测试
my_log.info('正在测试{}模块里的第{}条测试用例:{}'.format(case['Module'],
case['CaseId'],
case['Title']))
resp = HttpRequest().http_request(method=method,
url=url,
data=param,
cookies=None) #调用这个类来发送请求
try: #监控断言
self.assertEqual(eval(case['ExpectedResult']),
resp.json()) #对比最好用json字典
TestResult = 'Pass'
except Exception as e: #断言错误的话就会处理错误
TestResult = 'Failed'
my_log.error('http请求测试用例出错了,错误是:{}'.format(e))
raise e #抛出异常，不抛出的话用例全是成功，没有失败
finally:
t = DoExcel(project_path.case_path, 'test_case')
t.write_back(file_name, sheet_name, case['CaseId'] + 1, 8,
str(resp.json()))
t.write_back(file_name, sheet_name, case['CaseId'] + 1, 9,
TestResult)
my_log.info('实际结果:{}'.format(resp.json())) # http发送请求拿到实际返回值
def test_cases(self, case): #把每一条用例（字典）存放到case里面
# global COOKIES #
global TestResult #全局变量
method = case['Method']
url = case['Url']
param = eval(case['Params'])
if case['Sql'] is not None:
before_amount = Do_Mysql().do_mysql(eval(case['Sql'])['sql'])[0]
# 发起测试
my_log.info('正在测试{}模块里的第{}条测试用例:{}'.format(case['Module'],
case['CaseId'],
case['Title']))
resp = HttpRequest().http_request(method=method,
url=url,
data=param,
cookies=getattr(
GetData, 'COOKIE')) #调用这个类来发送请求
if resp.cookies: # 判断请求的cookies是否为空 不为空就是true
setattr(GetData, 'COOKIE', resp.cookies)
try: #监控断言
if case['Sql'] is not None: # 如果SQL不为NONE，那就要进行数据库的查询操作
after_amount = Do_Mysql().do_mysql(
eval(case['Sql'])['sql'], 1)[0] # 返回的是元组
recharge_amount = eval(case['Params'])['amount']
expect_amount = before_amount + int(
recharge_amount) # 两种不同数据类型
self.assertEqual(expect_amount, after_amount)
if case['ExpectedResult'].find('expect_amount') != -1:
# replace不是替换值，是生成一个替换值后的字符串，所以需要定义字符串
case['ExpectedResult'] = case['ExpectedResult'].replace(
'expect_amount', str(expect_amount))
print('替换后的值为{}', case['ExpectedResult'])
self.assertEqual(eval(case['ExpectedResult']),
resp.json()) #对比最好用json字典,eval()里面放字典的话会报错
TestResult = 'Pass'
except Exception as e: #断言错误的话就会处理错误
TestResult = 'Failed'
my_log.error('http请求测试用例出错了,错误是:{}'.format(e))
raise e #抛出异常，不抛出的话用例全是成功，没有失败
finally:
t = DoExcel(project_path.case_path, 'test_case')
t.write_back(file_name, sheet_name, case['CaseId'] + 1, 9,
str(resp.json()))
t.write_back(file_name, sheet_name, case['CaseId'] + 1, 10,
TestResult)
my_log.info('实际结果:{}'.format(resp.json())) # http发送请求拿到实际返回值
def test_cases(self, case): #把每一条用例（字典）存放到case里面
# global COOKIES #
global TestResult #全局变量
method = case['Method']
url = case['Url']
# if case['Params'].find('loanid')!=-1:
# print(getattr(GetData,'LOAN_ID'))
# param =eval(case['Params'].replace('loanid',str(getattr(GetData,'LOAN_ID'))))#拿到的数据类型是int,replace只能替换字符串，要转一下
# else:
# param =eval(case['Params'])
# params = eval(learn_re.replace(case['Params']))
params = eval(GetData().replace(case['Params'])) #类实例化的话类里面没有参数就不用加括号
# 发起测试
my_log.info('正在测试{}模块里的第{}条测试用例:{}'.format(case['Module'],
case['CaseId'],
case['Title']))
resp = HttpRequest().http_request(method=method,
url=url,
data=params,
cookies=getattr(
GetData, 'COOKIE')) #调用这个类来发送请求
if case['Sql'] != None: #如果SQL不为NONE，那就要进行数据库的查询操作
load_id = Do_Mysql().do_mysql(eval(case['Sql'])['sql'], 1) #返回的是元组
setattr(GetData, 'loanid', str(load_id[0])) #因为数据库拿到的是元组，所以要索引一下取值
if resp.cookies: # 判断请求的cookies是否为空 不为空就是true
setattr(GetData, 'COOKIE', resp.cookies)
try: #监控断言
self.assertEqual(eval(case['ExpectedResult']),
resp.json()) #对比最好用json字典
TestResult = 'Pass'
except Exception as e: #断言错误的话就会处理错误,Exception是抛出全部错误
TestResult = 'Failed'
my_log.error('http请求测试用例出错了,错误是:{}'.format(e))
raise e #抛出异常，不抛出的话用例全是成功，没有失败
finally:
t = DoExcel(project_path.case_path, 'test_case')
t.write_back(file_name, sheet_name, case['CaseId'] + 1, 9,
str(resp.json()))
t.write_back(file_name, sheet_name, case['CaseId'] + 1, 10,
TestResult)
my_log.info('实际结果:{}'.format(resp.json())) # http发送请求拿到实际返回值
import unittest
import warnings
from ddt import ddt, data
from chao.work.project.common.do_excel import DoExcel
from chao.work.project.common.http_request import HttpRequest
from chao.work.project.common import project_path
from chao.work.project.common.my_log import MyLog
from chao.work.project.common.get_data import GetData
from chao.work.project.common.learn_mysql import Do_Mysql
#测试数据
file_name = project_path.case_path
sheet_name = 'invest'
test_data = DoExcel(project_path.case_path,
sheet_name).read_data('test_recharge')
my_log = MyLog()
print(test_data)
COOKIES = None
@ddt #装饰类
class testCases(unittest.TestCase):
def setUp(self):
print('测试开始') #执行用例之前要做的事情放进来
warnings.simplefilter('ignore', ResourceWarning)
def tearDown(self):
print('测试结束') #执行用例之后要做的事情放进来
import unittest
from ddt import ddt, data
from chao.work.project.common.do_excel import DoExcel
from chao.work.project.common.http_request import HttpRequest
from chao.work.project.common import project_path
from chao.work.project.common.my_log import MyLog
#测试数据
file_name = project_path.case_path
sheet_name = 'register'
test_data = DoExcel(project_path.case_path,
'register').read_data('test_register')
my_log = MyLog()
print(test_data)
@ddt #装饰类
class testCases(unittest.TestCase):
def setUp(self):
print('测试开始') #执行用例之前要做的事情放进来
def tearDown(self):
print('测试结束') #执行用例之后要做的事情放进来
#写用例
@data(*test_data) #装饰用例*号脱外套,把测试数据放进来跑
def test_cases(self, case): #把每一条用例（字典）存放到case里面
global TestResult #全局变量