def get_pay_pwd(args, key, status):
"""
获取一条用例不同场景测试数据--支付密码
:param args: 测试数路径
:param key: 测试数据对应的key-->data
:param status:
:return:
"""
pay_data = eval(get_test_data(*args).get(key))
# 支付密码为空
if status == 0:
pay_data['payPwd'] = ''
pay_data['orderNo'] = makeOrder().get_order().json(
)['result']['applyOrderNo']
return pay_data, '参数错误', '支付密码为空'
# 支付密码错误
if status == 1:
pay_data['payPwd'] = '111111111'
pay_data['orderNo'] = makeOrder().get_order().json(
)['result']['applyOrderNo']
return pay_data, '参数校验异常', '支付密码错误'
# 申请单号为空
if status == 2:
pay_data['orderNo'] = ''
return pay_data, '参数错误', '申请单号为空'
# 申请单号错误
if status == 3:
pay_data['orderNo'] = '22222222'
return pay_data, '没有待支付的申请单，确认付款方式是否为现付', '申请单号错误'
# 正常支付
if status == 4:
pay_data['orderNo'] = makeOrder().get_order().json(
)['result']['applyOrderNo']
return pay_data, 'success', '正常支付'
def get_expect(*args, keyword=None, operate=None, game_type=None, expect_name='expect'):
"""
动态获取期望值，
:param args: 元组：测试文件路径，sheet名称，数字n
:param expect_name: 表格头部key
:param keyword: 数据库查询字段
:param operate: 数据库查询字段 是否是正式账号还是运营账号
:param game_type: 查询的游戏类型
:return:
"""
expect = json.loads(get_test_data(*args).get(expect_name))
expect_list = []
if keyword == 'user_sum':
# 查询用总数
res = databaseOperations().select_member_sum(operate)
expect_list.append(res)
elif keyword == 'bet_details':
# 查询游戏注单总数
res = databaseOperations().select_bet_details()
expect_list.append(res)
elif keyword == 'register_code':
# 查询注册码总数
res = databaseOperations().register_code_nums()
expect_list.append(res)
elif keyword == 'log':
res = databaseOperations().login_log_nums()
expect_list.append(res)
elif keyword == 'member_group':
# 会员分组总数
res = databaseOperations().select_member_group()
expect_list.append(len(res))
if len(expect) > 1:
for key, value in expect.items():
expect_list.append(value)
return expect_list
def setUpClass(cls):
cls.log = Log()
cls.test_data = get_test_data('/fresh_data.xlsx', 'app', 3)
cls.url = cls.test_data.get('route')
cls.headers = eval(cls.test_data.get('header'))
cls.headers['login-token'] = getAppToken().get_token()
cls.method = cls.test_data.get('method')
def __init__(self):
self.test_data = get_test_data('test_data.xlsx', 'login', 1)
self.log = Log()
self.url = self.test_data['url']
self.method = self.test_data['method']
self.payload = self.test_data['data']
self.header = json.loads(self.test_data['header'])
def __init__(self):
self.log = Log()
self.test_data = get_test_data('bms_test_data.xlsx', 'systemManagement', 5)
self.url = get_host('test') + self.test_data['url']
self.header = json.loads(self.test_data['header'])
self.header['authorization'] = getBmsToken().get_token()
self.method = self.test_data['method']
def __init__(self):
self.log = Log()
self.test_data = get_test_data('bms_test_data.xlsx', 'memberCentre', 1)
self.url = get_host('test') + self.test_data['url']
self.payload = self.test_data['data']
self.header = json.loads(self.test_data['header'])
self.header['authorization'] = getBmsToken().get_token()
self.method = self.test_data['method']
def __init__(self, value):
self.value = value # 要解析的数据
self.log = Log() # 日志
self.test_data = get_test_data('bms_test_data.xlsx', 'common', 0)
self.url = self.test_data['url']
self.headers = self.test_data['header']
self.method = self.test_data['method']
self.payload = {'value': self.value}
def __init__(self):
self.log = Log()
self.test_data = get_test_data('bms_test_data.xlsx',
'systemManagement', 2)
self.url = get_host('test') + self.test_data['url'] + str(
databaseOperations().select_userid('admin'))
self.header = json.loads(self.test_data['header'])
self.header['authorization'] = getBmsToken().get_token()
self.method = self.test_data['method']
def __init__(self):
self.log = Log()
self.test_data = get_test_data('bms_test_data.xlsx', 'memberCentre', 2)
self.url = get_host('test') + self.test_data['url'] + str(
databaseOperations().select_userid('test10000'))
self.data = self.test_data['data']
self.header = json.loads(self.test_data['header'])
self.header['authorization'] = getBmsToken().get_token()
self.method = self.test_data['method']
def __init__(self):
self.log = Log()
self.test_data = get_test_data('bms_test_data.xlsx', 'memberCentre', 4)
self.user_id = getUserInfo().get_user_info()['data']['userId']
self.url = get_host('test') + self.test_data['url'] + str(
self.user_id) + '&passwordNew=123456'
self.data = self.test_data['data']
self.header = json.loads(self.test_data['header'])
self.header['authorization'] = getBmsToken().get_token()
self.method = self.test_data['method']
def get_token(self):
"""
获取PC登录token
:return:token
"""
try:
test_data = get_test_data('/fresh_data.xlsx', 'pc', 0)
# data_dict = dict(zip(test_data[0], test_data[1][0]))
res = get_response(test_data.get('route'), test_data.get('method'),
data=test_data.get('data'), headers=eval(test_data.get('header')))
token = res.json()['result']['loginToken']
return token
except Exception as e:
self.log.error('出现异常:{}'.format(str(e)))
def setUpClass(cls):
"""
初始化测试数据
:return:
"""
cls.log = Log()
cls.token = getPcToken().get_token()
cls.test_data = get_test_data('/space_data.xlsx', 'pc', 0)
cls.url = cls.test_data.get('route')
cls.headers = eval(cls.test_data.get('header'))
cls.headers['login-token'] = cls.token
cls.json_data = cls.test_data.get('data')
cls.method = cls.test_data.get('method')
cls.log.info('测试数据初始化完成')
def get_expect(args, expect_name, expect_key):
"""
获取期望值
:param args: 元组：测试文件路径，sheet名称，数字n
:param expect_name: 表格头部key
:param expect_key: 期望值的key
:return:
"""
expect = get_test_data(*args).get(expect_name)
expect_list = [
eval(expect).get(expect_key[0]),
eval(expect).get(expect_key[1])
]
return expect_list
def get_token(self):
"""
获取app登录token
:return:token
"""
try:
test_data = get_test_data('/fresh_data.xlsx', 'app', 0)
res = get_response(test_data['route'],
test_data['method'],
data=test_data['data'],
headers=eval(test_data['header']))
return res.json()['response']['token']
except Exception as e:
self.log.error('获取token出现异常:{}'.format(str(e)))
def test_query_quota_list(self, ):
"""
测试获取额度维护全部列表
expect: 期望值
:return:
"""
url = self.test_data.get('route')
headers = eval(self.test_data.get('header'))
headers['login-token'] = self.token
data = self.test_data.get('data')
res = get_response(url,
self.test_data.get('method'),
data=data,
headers=headers)
print(res.json())
print(get_test_data('/fresh_data.xlsx', 'pc', 1).get('expect'))
def get_key(self):
"""
获取key
:return:key
"""
try:
test_data = get_test_data('/fresh_data.xlsx', 'app', 1)
headers = eval(test_data.get('header'))
headers['login-token'] = getAppToken().get_token()
res = get_response(url=test_data.get('route'),
method=test_data.get('method'),
headers=headers)
# self.log.info('请求获取key的地址:{}'.format(data_dict.get('route')))
# self.log.info('请求方式:{}'.format(data_dict.get('method')))
# self.log.info('请求头部:{}'.format(headers))
# self.log.info('获取的key:{}'.format(res.json()['result']))
return res.json()['result']
except Exception as e:
self.log.error('出现异常:{}'.format(str(e)))
def setUp(self):
self.log = Log()
self.token = getPcToken().get_token()
self.test_data = get_test_data('/fresh_data.xlsx', 'pc', 1)
def __init__(self, file_path, sheet_name, n):
self.log = Log() # 初始化日志
self.token = getAppToken().get_token() # 获取token
self.key = getKey().get_key() # 获取key
self.test_data = get_test_data(file_path, sheet_name, n) # 初始化测试数据
