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()