def assert_db(db_name, result, db_verify): assert_util = AssertUtil() sql = init_db(db_name) db_res = sql.fetchone(db_verify) log.debug("数据库查询结果:{}".format(str(db_res))) verify_list = dict(db_res).keys() for line in verify_list: res_line = result[line] res_db_line = dict(db_res)[line] assert_util.assert_body(res_line, res_db_line)
def assert_db(db_name, res_body, db_verify): """ 数据库验证 """ assert_util = AssertUtil() sql = init_db(db_name) db_res = sql.fetch_one(db_verify) log.debug(f"数据库查询结果:{str(db_res)}") for db_k, db_v in db_res.items(): res_line = res_body[db_k] assert_util.assert_body(res_line, db_v)
def assert_db(db_name,result,db_verify): assert_util = AssertUtil() sql = init_db(db_name) db_res = sql.fetchone(db_verify) log.debug("数据库查询结果: {}".format(str(db_res))) # 2.)---------数据库的结果与接口返回的结果验证--------- # 获取数据库结果的key verify_list = list(dict(db_res).keys()) # 根据key获取数据库结果,获取接口返回结果 for line in verify_list: res_db_line = dict(db_res)[line] res_line = result[line] # 验证 assert_util.assert_body(res_db_line, res_line)
def assert_db(db_name, result, db_verify): assert_util = AssertUtil() #sql = init_db("db_1") sql = init_db(db_name) # 2、查询sql,excel定义好的 db_res = sql.fetchone(db_verify) # 3、数据库的结果与接口返回的结果验证 # 获取数据库结果的key verify_list = list(dict(db_res).keys()) # 根据key获取数据库结果,接口结果 for line in verify_list: #res_line = res["body"][line] res_line = result[line] res_db_line = dict(db_res)[line] # 验证 assert_util.assert_body(res_line, res_db_line)
def assert_db(db_name, result, db_verify): assert_util = AssertUtil() # sql = init_db("db_1") sql = init_db("db_name") # 查询sql,excel定义好的 db_res = sql.fechone(db_verify) log.debug("数据库查询结果:{}".format(str(db_res))) # 数据库的结果与接口返回的结果验证 # 获取数据库的结果key verify_list = list(dict(db_res).keys()) # 根据key获取数据库的结果,接口的结果 for line in verify_list: # res_line = res["body"][line] res_line = result[line] res_db_line = dict(db_res)[line] # 验证 assert_util.assert_body(res_line, res_db_line)
def assert_mysqldb(excepted_db, db_res): """ mysql数据库结果与接口返回的结果验证 :param db_name: :param result: :param db_verify: :return: """ assert_util = AssertUtil() for line in excepted_db.keys(): try: excepted_line = excepted_db[line] res_db_line = dict(db_res)[line] assert_util.assert_body(excepted_line, res_db_line) return True except: my_log("DBUtil").error("数据库断言error, 数据库查询结果 is %s,期望数据库字段 is %s" % (db_res, excepted_db)) allure.attach("数据库断言error, 数据库查询结果 is %s,期望数据库字段 is %s" % (db_res, excepted_db)) raise