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 add_admin_user(self):
"""
新增bms后台管理用户
:return:
"""
if databaseOperations().select_user('sys_user', 'username'):
databaseOperations().delete_user('sys_user', 'username')
try:
resp = get_response(self.url, self.method, data=json.dumps(self.payload), headers=self.header) # 未解密接口返回
resp_str = getJsonStr(resp.json()['data']).get_json_str() # 解密接口返回数据
resp = resp.json()
resp['data'] = resp_str['data']
return resp
except Exception as e:
self.log.error('新增bms后台管理用户接口异常:{}，请检查'.format(str(e)))
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',
'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 add_member_user(self):
"""
bms-新增会员账户
:return:
"""
# 如果存在这个auto_test就先删除
if databaseOperations().select_user('sys_user', 'username'):
databaseOperations().delete_user('sys_user', 'username')
print(databaseOperations().delete_user('sys_user', 'username'))
if databaseOperations().select_user('zx_user_invite_code', 'code_val'):
databaseOperations().delete_user('zx_user_invite_code', 'code_val')
try:
resp = get_response(self.url, self.method, data=self.payload, headers=self.header) # 未解密接口返回
resp_str = getJsonStr(resp.json()['data']).get_json_str() # 解密接口返回数据
resp = resp.json()
resp['data'] = resp_str['data']
return resp
except Exception as e:
self.log.error('新增会员账户接口异常:{}，请检查'.format(str(e)))
def setUpClass(cls) -> None:
cls.log = Log()
cls.data = disableReturnPoint().test_data
cls.log.info('正在初始化数据库测试数据。。。。。。')
databaseOperations().select_return_point_status()
def tearDownClass(cls):
Log().info('正在重置数据库测试数据。。。。。。')
databaseOperations().select_operate_status_0()
def setUpClass(cls) -> None:
cls.log = Log()
cls.data = cancelIsOperate().test_data
cls.log.info('正在初始化数据库测试数据。。。。。。')
databaseOperations().select_operate_status_1()
def tearDownClass(cls):
Log().info('正在重置数据库测试数据。。。。。。')
databaseOperations().select_withdraw_status()
def setUpClass(cls) -> None:
cls.log = Log()
cls.data = disableWithdraw().test_data
cls.log.info('正在初始化数据库测试数据。。。。。。')
databaseOperations().select_withdraw_status()
def setUpClass(cls) -> None:
cls.log = Log()
cls.data = lockUser().test_data
cls.log.info('正在初始化数据库测试数据。。。。。。')
databaseOperations().user_status_0()
def tearDownClass(cls):
Log().info('正在重置数据库测试数据......')
databaseOperations().delete_user('sys_user', 'username')
def tearDownClass(cls):
Log().info('正在重置数据库(sys_user表)测试数据。。。。。。')
databaseOperations().delete_user('sys_user', 'username')
Log().info('正在重置数据库(zx_user_invite_code表)测试数据。。。。。。')
databaseOperations().delete_user('zx_user_invite_code', 'code_val')
def setUpClass(cls) -> None:
cls.log = Log()
cls.data = fundFreeze().test_data
cls.log.info('正在初始化数据库测试数据。。。。。。')
databaseOperations().select_fund_status()
def tearDownClass(cls):
Log().info('正在重置数据库测试数据。。。。。。')
databaseOperations().select_return_point_status()
def tearDownClass(cls):
Log().info('正在重置数据库测试数据。。。。。。')
databaseOperations().delete_member_group()
def tearDownClass(cls):
Log().info('正在重置数据库测试数据。。。。。。')
databaseOperations().user_status_1()
