def test_fenxi20(self):
"""查看全班同学综合报告结果/examManage/publishedResults"""
self.log.info(message="test04-20",
name="test01_OrcLogin.py",
line=get_run_line())
# 获取测试数据
method = self.data.get_method(self.sheet, self.row[19])
url = self.config.get_base_url() + self.data.get_url(
self.sheet, self.row[19])
headers = self.hea_data.get_header(self.sheet, self.row[19])
data = self.data.get_request_data(self.sheet, self.row[19])
expect = self.data.get_expect_result(self.sheet, self.row[19])
self.log.info(message="第一步: 获取请求数据")
self.log.info(message="请求方法：%s" % method)
self.log.info(message="请求接口：%s" % url)
self.log.info(message="请求数据：%s" % data)
self.log.info(message="期望结果：%s" % expect)
# 发送请求
status_code, header_token, res_json = self.http.http_method(
method=method, url=url, data=data, headers=headers)
dict_json = json.loads(res_json) # 把json数据转换成字典对象
self.log.info(message="第二步:发送请求，获取返回数据：")
self.log.info(message="%s" % res_json)
self.log.info(message="第三步：断言")
# 断言
self.assertEqual(status_code, 200, msg=">>>接口请求失败")
self.assertEqual(dict_json["code"],
expect["code"],
msg=">>>断言失败，实际返回结果：%s" % dict_json["code"])
self.assertEqual(dict_json["msg"],
expect["msg"],
msg=">>>断言失败，实际返回结果：%s" % dict_json["msg"])
self.log.info(message="断言结束")
def test_fenxi02(self):
"""获取已分析考试列表/AnalyzeDateEntering/findExamOfTeacher"""
self.log.info(message="test04-2",
name="test01_OrcLogin.py",
line=get_run_line())
# 获取测试数据
method = self.data.get_method(self.sheet, self.row[1])
url = self.config.get_base_url() + self.data.get_url(
self.sheet, self.row[1])
headers = self.hea_data.get_header(self.sheet, self.row[1])
# data = self.data.get_request_data(self.sheet, self.row[1])
expect = self.data.get_expect_result(self.sheet, self.row[1])
self.log.info(message="第一步: 获取请求数据")
self.log.info(message="请求方法：%s" % method)
self.log.info(message="请求接口：%s" % url)
# self.log.info(message="请求数据：%s" % data)
self.log.info(message="期望结果：%s" % expect)
# 发送请求
status_code, header_token, res_json = self.http.http_method(
method=method, url=url, data=None, headers=headers)
dict_json = json.loads(res_json) # 把json数据转换成字典对象
self.log.info(message="第二步:发送请求，获取返回数据：")
self.log.info(message="%s" % res_json)
self.log.info(message="第三步：断言")
# 断言
self.assertEqual(status_code, 200, msg=">>>接口请求失败")
self.assertEqual(dict_json["code"],
'10000',
msg=">>>断言失败，实际返回结果：%s" % dict_json["code"])
self.assertEqual(dict_json["msg"],
expect["msg"],
msg=">>>断言失败，实际返回结果：%s" % dict_json["msg"])
self.log.info(message="断言结束")
def test_fenxi03(self):
"""更新操作（点击某次考试）查看班级报告/ErrorQuestion/updateFirstNewStatus"""
self.log.info(message="test04-3",
name="test01_OrcLogin.py",
line=get_run_line())
# 获取测试数据
method = self.data.get_method(self.sheet, self.row[2])
url = self.config.get_base_url() + self.data.get_url(
self.sheet, self.row[2])
headers = self.hea_data.get_header(self.sheet, self.row[2])
data = self.data.get_request_data(self.sheet, self.row[2])
expect = self.data.get_expect_result(self.sheet, self.row[2])
self.log.info(message="第一步: 获取请求数据")
self.log.info(message="请求方法：%s" % method)
self.log.info(message="请求接口：%s" % url)
self.log.info(message="请求数据：%s" % data)
self.log.info(message="期望结果：%s" % expect)
# 发送请求
status_code, header_token, res_json = self.http.http_method(
method=method, url=url, data=data, headers=headers)
dict_json = json.loads(res_json) # 把json数据转换成字典对象
self.log.info(message="第二步:发送请求，获取返回数据：")
self.log.info(message="%s" % res_json)
self.log.info(message="第三步：断言")
# 断言
self.assertEqual(status_code, 200, msg=">>>接口请求失败")
self.assertEqual(dict_json["code"],
'10000',
msg=">>>断言失败，实际返回结果：%s" % dict_json["code"])
self.assertEqual(dict_json["msg"],
expect["msg"],
msg=">>>断言失败，实际返回结果：%s" % dict_json["msg"])
self.log.info(message="断言结束")
def test_fenxi13(self):
"""评卷课件试卷结构/讲评收藏的题目//analysisExamPic/getCollectionQuestion"""
self.log.info(message="test04-13",
name="test01_OrcLogin.py",
line=get_run_line())
# 获取测试数据
method = self.data.get_method(self.sheet, self.row[12])
url = self.config.get_base1_url() + self.data.get_url(
self.sheet, self.row[12])
headers = self.hea_data.get_header(self.sheet, self.row[12])
data = self.data.get_request_data(self.sheet, self.row[12])
expect = self.data.get_expect_result(self.sheet, self.row[12])
self.log.info(message="第一步: 获取请求数据")
self.log.info(message="请求方法：%s" % method)
self.log.info(message="请求接口：%s" % url)
self.log.info(message="请求数据：%s" % data)
self.log.info(message="期望结果：%s" % expect)
# 发送请求
status_code, header_token, res_json = self.http.http_method(
method=method, url=url, data=json.dumps(data), headers=headers)
dict_json = json.loads(res_json) # 把json数据转换成字典对象
self.log.info(message="第二步:发送请求，获取返回数据：")
self.log.info(message="%s" % res_json)
self.log.info(message="第三步：断言")
# 断言
self.assertEqual(status_code, 200, msg=">>>接口请求失败")
self.assertEqual(dict_json["code"],
expect["code"],
msg=">>>断言失败，实际返回结果：%s" % dict_json["code"])
self.assertEqual(dict_json["msg"],
expect["msg"],
msg=">>>断言失败，实际返回结果：%s" % dict_json["msg"])
self.log.info(message="断言结束")
def test_login03(self):
"""获取首页右上角信息/ErrorQuestion/getIndexBaseInfo"""
self.log.info(message="test02-2", name="test01_OrcLogin.py", line=get_run_line())
# 获取测试数据
method = self.data.get_method(self.sheet, self.row[2])
url = self.config.get_base_url() + self.data.get_url(self.sheet, self.row[2])
headers = self.hea_data.get_header(self.sheet, self.row[2])
# data = self.data.get_request_data(self.sheet, self.row[2])
expect = self.data.get_expect_result(self.sheet, self.row[2])
self.log.info(message="第一步: 获取请求数据")
self.log.info(message="请求方法：%s" % method)
self.log.info(message="请求接口：%s" % url)
# self.log.info(message="请求数据：%s" % data)
self.log.info(message="期望结果：%s" % expect)
# 发送请求
status_code,header_token, res_json = self.http.http_method(method=method, url=url, data=None, headers=headers)
dict_json = json.loads(res_json) # 把json数据转换成字典对象
self.log.info(message="第二步:发送请求，获取返回数据：")
self.log.info(message="%s" % res_json)
self.log.info(message="第三步：断言")
# 断言
self.assertEqual(status_code, 200, msg=">>>接口请求失败")
self.assertEqual(dict_json["code"],'10000', msg=">>>断言失败，实际返回结果：%s")
self.assertEqual(dict_json["data"]["schoolName"], expect["schoolName"],
msg=">>>断言失败，实际返回结果：%s" % dict_json["data"]["schoolName"])
self.log.info(message="断言结束")
def test_login01(self):
"""登录成功/userManage/signIn"""
self.log.info(message="test01-1", name="test01_OrcLogin.py", line=get_run_line())
# 获取测试数据
method = self.data.get_method(self.sheet, self.row[0])
url = self.config.get_base_url() + self.data.get_url(self.sheet, self.row[0])
headers = self.hea_data.get_header(self.sheet, self.row[0])
data = self.data.get_request_data(self.sheet, self.row[0])
self.log.info(message="第一步: 获取请求数据")
self.log.info(message="请求方法：%s" % method)
self.log.info(message="请求接口：%s" % url)
self.log.info(message="请求数据：%s" % data)
status_code,header_token,res_json = self.http.http_method(method=method, url=url, data=data)
dict_json = json.loads(res_json) # 把json数据转换成字典对象
self.log.info(message="第二步:发送请求，获取返回数据：")
self.log.info(message="%s" % res_json)
if dict_json["data"]:
orc_token = header_token["Token"] # 提取orc_token
self.log.info(message="提取token", name="test_login01")
self.log.info(message="%s" % orc_token, name="test_login01")
authorization = orc_token
# self.json.write_data(authorization, "orc_token_header", "Authorization") # 把orc_token写入json文件
self.json.write_data(authorization, "login_header_token", "Token")
self.json.write_data(authorization, "login_header_piyue", "Token")
self.json.write_data(authorization, "login_header_fenxi", "Token")
self.json.write_data(authorization, "fenxi", "Token")
# 断言
self.log.info(message="第三步：断言")
self.assertEqual(status_code, 200, msg=">>>接口请求失败")
self.assertEqual(dict_json["data"], "登录成功",msg=">>>断言失败，实际返回结果：%s" % dict_json)
self.assertEqual(dict_json["msg"], "OK",
msg=">>>断言失败，实际返回值是：%s" % dict_json["msg"])
self.log.info(message="断言结束")
def test_piyue02(self):
"""获取已批阅列表/ErrorQuestion/getAnalyAndReportExamList"""
self.log.info(message="test03-1",
name="test01_OrcLogin.py",
line=get_run_line())
# 获取测试数据
# print("kaishi")
method = self.data.get_method(self.sheet, self.row[1])
# print(method)
url = self.config.get_base_url() + self.data.get_url(
self.sheet, self.row[1])
# print(url)
headers = self.hea_data.get_header(self.sheet, self.row[1])
# print(headers)
data = self.data.get_request_data(self.sheet, self.row[1])
# print(data)
expect = self.data.get_expect_result(self.sheet, self.row[1])
# print(expect)
self.log.info(message="第一步: 获取请求数据")
self.log.info(message="请求方法：%s" % method)
self.log.info(message="请求接口：%s" % url)
self.log.info(message="请求数据：%s" % data)
self.log.info(message="期望结果：%s" % expect)
# res = requests.request(method,url,data = data,headers = headers)
# print(res.text)
# 发送请求
status_code, header_token, res_json = self.http.http_method(
method=method, url=url, data=data, headers=headers)
dict_json = json.loads(res_json) # 把json数据转换成字典对象
self.log.info(message="第二步:发送请求，获取返回数据：")
self.log.info(message="%s" % res_json)
self.log.info(message="第三步：断言")
# 断言
self.assertEqual(status_code, 200, msg=">>>接口请求失败")
self.assertEqual(dict_json["code"],
'10000',
msg=">>>断言失败，实际返回结果：%s" % dict_json["code"])
self.assertEqual(dict_json["msg"],
expect["msg"],
msg=">>>断言失败，实际返回结果：%s" % dict_json["msg"])
self.log.info(message="断言结束")
def test_piyue05(self):
"""批改学生试卷/examQuestion/updateStudentUnionExam"""
self.log.info(message="test03-6",
name="test01_OrcLogin.py",
line=get_run_line())
# 获取测试数据
sheetname = "app_test_data"
#读取excel测试数据,获取给分请求参数
get_data = ExcelData(data_path, sheetname)
datas = get_data.readExcel()
method = self.data.get_method(self.sheet, self.row[5])
url = self.config.get_base_url() + self.data.get_url(
self.sheet, self.row[5])
headers = self.hea_data.get_header(self.sheet, self.row[5])
expect = self.data.get_expect_result(self.sheet, self.row[5])
self.log.info(message="请求方法：%s" % method)
self.log.info(message="请求头：%s" % headers)
self.log.info(message="请求接口：%s" % url)
self.log.info(message="期望结果：%s" % expect)
for i in range(0, len(datas)):
data = datas[i]
self.log.info(message="第一步: 获取请求数据:%s" % data)
status_code, header_token, res_json = self.http.http_method(
method=method, url=url, data=json.dumps(data), headers=headers)
dict_json = json.loads(res_json) # 把json数据转换成字典对象
self.log.info(message="第二步:发送请求，获取返回数据：")
self.log.info(message="%s" % res_json)
self.log.info(message="第三步：断言")
self.assertEqual(status_code, 200, msg=">>>接口请求失败")
# print(dict_json["code"])
self.assertEqual(dict_json["code"],
expect["code"],
msg=">>>断言失败，实际返回结果：%s" % dict_json["code"])
self.assertEqual(dict_json["msg"],
expect["msg"],
msg=">>>断言失败，实际返回结果：%s" % dict_json["msg"])
self.log.info(message="断言结束")
def test_piyue04(self):
"""获取某提批改列表/examQuestion/getStudentNamePicAll/6272/27170"""
self.log.info(message="test03-4",
name="test01_OrcLogin.py",
line=get_run_line())
# 获取测试数据
# print("kaishi")
# t_id = self.data.get_t_id(self.sheet_id,self.row[0])
# studentId = self.data.get_studentId(self.sheet_id,self.row[0])
method = self.data.get_method(self.sheet, self.row[3])
# print(method)
url = self.config.get_base_url() + self.data.get_url(
self.sheet, self.row[3])
# print(url)
headers = self.hea_data.get_header(self.sheet, self.row[3])
# print(headers)
# data = self.data.get_request_data(self.sheet, self.row[3])
# print(data)
expect = self.data.get_expect_result(self.sheet, self.row[3])
# print(expect)
self.log.info(message="第一步: 获取请求数据")
self.log.info(message="请求方法：%s" % method)
self.log.info(message="请求接口：%s" % url)
# self.log.info(message="请求数据：%s" % data)
self.log.info(message="期望结果：%s" % expect)
# res = requests.request(method,url,data = data,headers = headers)
# print(res.text)
# 发送请求
status_code, header_token, res_json = self.http.http_method(
method=method, url=url, data=None, headers=headers)
dict_json = json.loads(res_json) # 把json数据转换成字典对象
self.log.info(message="第二步:发送请求，获取返回数据：")
self.log.info(message="%s" % res_json)
self.log.info(message="第三步：断言")
# 断言
self.assertEqual(status_code, 200, msg=">>>接口请求失败")
# print(dict_json["code"])
self.assertEqual(dict_json["code"],
expect["code"],
msg=">>>断言失败，实际返回结果：%s" % dict_json["code"])
self.assertEqual(dict_json["msg"],
expect["msg"],
msg=">>>断言失败，实际返回结果：%s" % dict_json["msg"])
id_data = dict_json["data"]
id_list = []
# studentId_list = []
score_list = []
examID_list = []
questionId_list = []
for k in range(len(id_data)):
id_list.append(id_data[k]["id"])
# studentId_list.append(id_data[k]["studentId"])
examID_list.append(6272)
# print(examID_list)
questionId_list.append(27170)
score_data = random.randint(0, 3)
score_list.append(score_data)
#把需要批改的题块的id和studentid取出来放到excel表格中，方便下一步进行批改
write_excel.write_excel_data(examID_list, id_list, questionId_list,
score_list)
self.assertEqual(status_code, 200, msg=">>>接口请求失败")
self.assertEqual(dict_json["code"],
'10000',
msg=">>>断言失败，实际返回结果：%s" % dict_json["code"])
self.assertEqual(dict_json["msg"],
expect["msg"],
msg=">>>断言失败，实际返回结果：%s" % dict_json["msg"])
self.log.info(message="断言结束")
