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