test_06_internship_manage.py
12.8 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
# -*- coding: utf-8 -*-
# ======================================
# @Software: PyCharm
# @Author : Shitou ✊
# @Time : 2023/1/13 11:22
# @FileName: test_06_internship_manage.py
# ======================================
"""
实习管理菜单
"""
import json
import os
import unittest
import requests
from jsonpath import jsonpath
from common.handle_config import conf
from common.handle_excel import Excel
from common.handle_log import HandleLog
from common.handle_path import Internship_manage
from common.myddt import data, ddt
from tools.fixture import SelectData
from tools.handle_token import LoginToken, HrLoginToken, StudentLoginToken
# ==================实习管理菜单相关用例==================
# ====================================================================
# 报名审核-待审核列表查看
# ====================================================================
@ddt
class Test01SelectApplyAuditList(unittest.TestCase):
select_apply_audit = Excel(os.path.join(Internship_manage, "test_07_apply_audit.xlsx"), "school_select_apply_audit")
select_apply_audit_case = select_apply_audit.read_excel() # 查询报名审核Excel
@classmethod
def setUpClass(cls):
# 获取token
cls.token = LoginToken.login_token()
@data(*select_apply_audit_case)
def test01select_wait_list(self, case):
# 准备数据
data = json.loads(case["data"])
expected = json.loads(case["expected"])
# 调用接口
url = conf.get("url", "url_ip") + case["url"]
herders = {}
herders["Authorization"] = self.token
request = requests.request(url=url, method=case["method"], params=data, headers=herders)
res = request.json()
print("用例入参：{}".format(data))
print("预期结果：", expected)
print("实际结果：", res)
# 断言
try:
self.assertEqual(expected['msg'], res['msg'])
self.assertEqual(expected['code'], res['code'])
except AssertionError as e:
# 写入Excel
self.select_apply_audit.write_excel(row=case["id"] + 1, column=7, value="不通过")
HandleLog.log.error("用例标题{},不通过".format(case['title']))
HandleLog.log.exception(e)
raise e
else:
self.select_apply_audit.write_excel(row=case["id"] + 1, column=7, value="通过")
# 将创建使用的数据写入到excel表格中
self.select_apply_audit.write_excel(row=case["id"] + 1, column=9, value=case["data"])
HandleLog.log.info("用例{}，执行通过".format(case["title"]))
# ====================================================================
# 报名审核-学校端-进行审核
# ====================================================================
@ddt
class Test02SchoolAudit(unittest.TestCase):
audit = Excel(os.path.join(Internship_manage, "test_07_apply_audit.xlsx"), "school_audit")
audit_case = audit.read_excel() # 查询报名审核Excel
@classmethod
def setUpClass(cls):
# 获取token
cls.token = LoginToken.login_token()
def setUp(self):
# ---获取报名审核id---待审核
select_apply_excel = Excel(os.path.join(Internship_manage, "test_07_apply_audit.xlsx"),
"school_select_apply_audit")
read_apply_excel = select_apply_excel.read_excel_location("C2")
read_apply_excel_d = select_apply_excel.read_excel_location("E2") # 读取params
apply_list = SelectData(str(read_apply_excel), json.loads(read_apply_excel_d))
apply_json = apply_list.select_list()
self.applyId = jsonpath(apply_json, "$..id")[0] # 获取待审核id
@data(*audit_case)
def test01audit(self, case):
if "#formIds#" in case["data"]:
case["data"] = case["data"].replace("#formIds#", str(self.applyId)) # 待审核id
# 准备数据
data = json.loads(case["data"])
expected = json.loads(case["expected"])
# 调用接口
url = conf.get("url", "url_ip") + case["url"]
herders = {}
herders["Authorization"] = self.token
request = requests.request(url=url, method=case["method"], json=data, headers=herders)
res = request.json()
print("用例入参：{}".format(data))
print("预期结果：", expected)
print("实际结果：", res)
# 断言
try:
self.assertEqual(expected['msg'], res['msg'])
self.assertEqual(expected['code'], res['code'])
except AssertionError as e:
# 写入Excel
self.audit.write_excel(row=case["id"] + 1, column=7, value="不通过")
HandleLog.log.error("用例标题{},不通过".format(case['title']))
HandleLog.log.exception(e)
raise e
else:
self.audit.write_excel(row=case["id"] + 1, column=7, value="通过")
# 将创建使用的数据写入到excel表格中
self.audit.write_excel(row=case["id"] + 1, column=9, value=case["data"])
HandleLog.log.info("用例{}，执行通过".format(case["title"]))
# ====================================================================
# 报名审核-hr端-待审核列表查看(实习申请列表)
# ====================================================================
@ddt
class Test03HrSelectAuditList(unittest.TestCase):
select_hr_apply_audit = Excel(os.path.join(Internship_manage, "test_07_apply_audit.xlsx"), "hr_select_apply_audit")
select_hr_apply_audit_case = select_hr_apply_audit.read_excel() # 查询报名审核Excel
@classmethod
def setUpClass(cls):
# 获取token
cls.token = HrLoginToken.login_token()
@data(*select_hr_apply_audit_case)
def test01select_hr_wait_list(self, case):
# 准备数据
data = json.loads(case["data"])
expected = json.loads(case["expected"])
# 调用接口
url = conf.get("url", "url_ip") + case["url"]
herders = {}
herders["Authorization"] = self.token
request = requests.request(url=url, method=case["method"], params=data, headers=herders)
res = request.json()
print("用例入参：{}".format(data))
print("预期结果：", expected)
print("实际结果：", res)
# 断言
try:
self.assertEqual(expected['msg'], res['msg'])
self.assertEqual(expected['code'], res['code'])
except AssertionError as e:
# 写入Excel
self.select_hr_apply_audit.write_excel(row=case["id"] + 1, column=7, value="不通过")
HandleLog.log.error("用例标题{},不通过".format(case['title']))
HandleLog.log.exception(e)
raise e
else:
self.select_hr_apply_audit.write_excel(row=case["id"] + 1, column=7, value="通过")
# 将创建使用的数据写入到excel表格中
self.select_hr_apply_audit.write_excel(row=case["id"] + 1, column=9, value=case["data"])
HandleLog.log.info("用例{}，执行通过".format(case["title"]))
# ====================================================================
# 报名审核-hr端-进行审核2022/01/16
# ====================================================================
@ddt
class Test04HrAudit(unittest.TestCase):
hr_audit = Excel(os.path.join(Internship_manage, "test_07_apply_audit.xlsx"), "hr_audit")
hr_audit_case = hr_audit.read_excel() # 查询报名审核Excel
@classmethod
def setUpClass(cls):
# 获取token
cls.token = HrLoginToken.login_token()
def setUp(self):
# ---获取报名审核id---待审核
select_hr_apply_excel = Excel(os.path.join(Internship_manage, "test_07_apply_audit.xlsx"),
"hr_select_apply_audit")
read_hr_apply_excel = select_hr_apply_excel.read_excel_location("C2")
read_hr_apply_excel_d = select_hr_apply_excel.read_excel_location("E2") # 读取params
hr_apply_list = SelectData(str(read_hr_apply_excel), json.loads(read_hr_apply_excel_d))
hr_apply_json = hr_apply_list.select_list()
self.hr_applyId = jsonpath(hr_apply_json, "$..id")[0] # 获取待审核id
@data(*hr_audit_case)
def test01hraudit(self, case):
if "#formIds#" in case["data"]:
case["data"] = case["data"].replace("#formIds#", str(self.hr_applyId)) # 待审核id
# 准备数据
data = json.loads(case["data"])
expected = json.loads(case["expected"])
# 调用接口
url = conf.get("url", "url_ip") + case["url"]
herders = {}
herders["Authorization"] = self.token
request = requests.request(url=url, method=case["method"], json=data, headers=herders)
res = request.json()
print("用例入参：{}".format(data))
print("预期结果：", expected)
print("实际结果：", res)
# 断言
try:
self.assertEqual(expected['msg'], res['msg'])
self.assertEqual(expected['code'], res['code'])
except AssertionError as e:
# 写入Excel
self.hr_audit.write_excel(row=case["id"] + 1, column=7, value="不通过")
HandleLog.log.error("用例标题{},不通过".format(case['title']))
HandleLog.log.exception(e)
raise e
else:
self.hr_audit.write_excel(row=case["id"] + 1, column=7, value="通过")
# 将创建使用的数据写入到excel表格中
self.hr_audit.write_excel(row=case["id"] + 1, column=9, value=case["data"])
HandleLog.log.info("用例{}，执行通过".format(case["title"]))
# ====================================================================
# 学生端---选择实习开始时间
# ====================================================================
@ddt
class Test05StudentIntenship(unittest.TestCase):
student_start_internship = Excel(os.path.join(Internship_manage, "test_07_apply_audit.xlsx"),
"student_start_internship")
student_start_internship_case = student_start_internship.read_excel() # 学生填写开始时间
# 登陆前置
@classmethod
def setUpClass(cls):
cls.student_token = StudentLoginToken.login_token()
def setUp(self):
# 获取学生端待实习id
student_select_intership_wait_excle = Excel(os.path.join(Internship_manage, "test_07_apply_audit.xlsx"),
"student_select_intership_wait")
read_student_intership_excel = student_select_intership_wait_excle.read_excel_location("C2")
read_student_intership_excel_d = student_select_intership_wait_excle.read_excel_location("E2") # 读取params
student_intership_list = SelectData(str(read_student_intership_excel),
json.loads(read_student_intership_excel_d))
student_intership_json = student_intership_list.student_select_list() # 正序查找
self.student_intership_id = jsonpath(student_intership_json, "$..id")[0] # 获取实习单待实习id
# 学生开始时间时间选择
@data(*student_start_internship_case)
def test01student_start_intenship_time(self, case):
if "#practice_id#" in case["data"]:
case["data"] = case["data"].replace("#practice_id#", str(self.student_intership_id))
# 准备数据
data = json.loads(case["data"])
expected = json.loads(case["expected"])
# 调用接口
url = conf.get("url", "url_ip") + case["url"]
headers = {}
headers["Authorization"] = self.student_token
request = requests.request(url=url, method=case["method"], json=data, headers=headers)
res = request.json()
print("用例入参：{}".format(data))
print("预期结果：", expected)
print("实际结果：", res)
# 断言
try:
self.assertEqual(expected['msg'], res['msg'])
self.assertEqual(expected['code'], res['code'])
except AssertionError as e:
self.student_start_internship.write_excel(row=case['id'] + 1, column=7, value="不通过")
HandleLog.log.error("用例标题{},不通过".format(case['title']))
HandleLog.log.exception(e)
raise e
else:
self.student_start_internship.write_excel(row=case["id"] + 1, column=7, value="通过")
# 将创建使用的数据写入到excel表格中
self.student_start_internship.write_excel(row=case["id"] + 1, column=9, value=case["data"])
HandleLog.log.info("用例{}，执行通过".format(case["title"]))
if __name__ == '__main__':
Test04HrAudit()
Test05StudentIntenship()