def test_addhierarchy_07(self):
"""
用例描述：name字段传空
"""
# 写log
with allure.step("写入Log"):
log = Log.MyLog()
log.info('文件已经开始执行')
conf = Config()
data = AddHierarchy()
# 获取请求域名
host = conf.host_debug
req_url = 'http://' + host
# 获取请求参数
urls = data.url[4]
header = data.header[4]
param = data.data[4]
env = conf.environment
responsecode = data.responsecode[4]
responsesql = data.responsesql[4]
selectsql = data.selectsql[4]
errorcode = data.errorcode[4]
print(param[0])
# 请求接口
api_url = req_url + urls
print(api_url)
# post请求
request = Request.Request()
with allure.step("开始请求接口,RUL: {0},header:{1},request:{2}".format(
api_url, header, param[0])):
response = request.post_request(api_url, json.dumps(param[0]),
header)
print(response)
# 增加断言
with allure.step("接口返回结果：{0}".format(response)):
if response['code'] == responsecode:
assert response['body']
assertbody = Assertions()
assertbody.assert_text(response['header']['X-Api-Error-Code'],
errorcode)
def test_addhierarchy_02(self):
"""
用例描述：创建三级组织
"""
#写log
with allure.step("写入Log"):
log = Log.MyLog()
log.info('文件已开始执行')
conf = Config()
data = AddHierarchy()
#获取请求域名
host = conf.host_debug
req_url = 'http://' + host
# 获取请求参数
urls = data.url[1]
header = data.header[1]
param = data.data[1]
env = conf.environment
responsecode = data.responsecode[1]
responsesql = data.responsesql[1]
selectsql = data.selectsql[1]
print(param[0])
parentid = SqlResult(selectsql, env).get_sqlresult()
# 参数化请求参数
with allure.step("获取输入参数值"):
try:
param[0]['name'] = '国联信息' + str(int(time.time()))
param[0]['parent_id'] = parentid['id']
except:
log.info("获取参数失败：{0}".format(param[0]))
#请求接口
api_url = req_url + urls
print(api_url)
#post请求
request = Request.Request()
with allure.step("开始请求接口,RUL: {0},header:{1},request:{2}".format(
api_url, header, param[0])):
response = request.post_request(api_url, json.dumps(param[0]),
header)
print(response)
# 数据库查询结果
try:
responsesql = str(responsesql).replace('@sqlresult',
str(parentid['id']))
responsesqlresult = SqlResult(responsesql,
env).get_sqlresult_list()
with allure.step("获取预期结果值成功，查询Sql：{0},查询结果：{1}".format(
responsesql, responsesqlresult)):
log.info('查询结果数据库成功：' + responsesql)
except:
log.info('查询结果数据库失败：' + responsesql)
actual = []
for i in range(len(responsesqlresult)):
for k, v in responsesqlresult[i].items():
actual.append(responsesqlresult[i][k])
# 增加断言
assertbody = Assertions()
with allure.step("接口返回结果：{0}".format(response)):
assertbody.assert_text(str(response['code']), str(responsecode))
if response['code'] == responsecode:
assert param[0]['name'] in actual
def test_addhierarchy_09(self):
"""
用例描述：同一层级不同上级name重复
"""
# 写log
with allure.step("写入Log"):
log = Log.MyLog()
log.info('文件已经开始执行')
conf = Config()
data = AddHierarchy()
# 获取请求域名
host = conf.host_debug
req_url = 'http://' + host
# 获取请求参数
urls = data.url[6]
header = data.header[6]
param = data.data[6]
env = conf.environment
responsecode = data.responsecode[6]
responsesql = data.responsesql[6]
sqlparentid = data.sqlpid[6]
sqlname = data.sqlname[6]
selectsql = data.selectsql[6]
parentid = SqlResult(selectsql, env).get_sqlresult()
# 参数化请求参数
with allure.step("获取输入参数值"):
try:
param[0]['parent_id'] = parentid['id']
param[0]['name'] = '同层级不同上级' + str(int(time.time()))
except:
log.info("获取参数失败：{0}".format(param[0]))
# 请求接口
api_url = req_url + urls
print(api_url)
print(param[0])
request = Request.Request()
addname = request.post_request(api_url, json.dumps(param[0]), header)
# dsqlname = str(sqlname).replace('@sqlresult', str(parentid['id']))
sqlid = str(sqlparentid).replace('@sqlresult', str(parentid['id']))
# param[0]['name'] = SqlResult(dsqlname, env).get_sqlresult()['name']
param[0]['parent_id'] = SqlResult(sqlid, env).get_sqlresult()['id']
############################
print(param[0])
# post请求
with allure.step("开始请求接口,RUL: {0},header:{1},request:{2}".format(
api_url, header, param[0])):
response = request.post_request(api_url, json.dumps(param[0]),
header)
print(response)
# 增加断言
with allure.step("接口返回结果：{0}".format(response)):
if response['code'] == responsecode:
assertbody = Assertions()
assertbody.assert_text(response['body'], True)