def test_query_comprehensive(self, URL, METHOD, DATA, CODE, CONTENT,
expect):
query_comprehensive_infos = {'URL': URL, 'DATA': DATA}
resp = student().query_comprehensive(query_comprehensive_infos)
result = resp.json()
if result['totalRow'] == CONTENT:
auctual = 'query_sucess'
else:
auctual = 'query_fail'
self.assertEqual(auctual, expect)
def test_query_student(self, URL, METHOD, DATA, CODE, CONTENT, expect):
files = {
'stu.student_id': (None, '8'),
'stu.student_name': (None, '王二'),
'stu.student_no': (None, 'WNSH202004008'),
'class_no': (None, 'WNSHC099'),
'stu.tel': (None, '0'),
'stu.sex': (None, '女'),
'stu.status': (None, '02'),
'stu.need_fee': (None, '01'),
'stu.QQ': (None, ''),
'stu.source': (None, '04'),
'stu.emergency_person': (None, ''),
'stu.emergency_tel': (None, ''),
'stu.school': (None, ''),
'stu.education': (None, '03'),
'stu.major': (None, ''),
'stu.IDnumber': (None, ''),
'stu.graduation_time': (None, ''),
'stu.age': (None, '')
}
edit_infos = {'URL': URL, 'files': files}
resp = student().edit_student(edit_infos)
def test_query_student(self, URL, METHOD, DATA, CODE, CONTENT, expect):
query_infos = {'URL': URL, 'DATA': DATA}
resp = student().query_student(query_infos)
result = resp.json()
#按班级查询
if DATA['stuClass'] != '':
SQL = "select s.student_name FROM student AS s,class AS c WHERE s.student_class_id = c.class_id AND c.class_no ='{}'".format(
DATA['stuClass'])
DBresult = Utility.query_all('..\\config\\base.conf', SQL)
#按学生姓名查询
else:
SQL = "select * FROM student AS s,class AS c WHERE s.student_class_id = c.class_id AND s.student_name ='{}'".format(
DATA['stuName'])
DBresult = Utility.query_all('..\\config\\base.conf', SQL)
print(len(DBresult), result['totalRow'])
if int(result['totalRow']) == len(
DBresult) and result['totalRow'] != 0:
auctual = 'query_sucess'
else:
auctual = 'query_fail'
#断言
self.assert_(auctual, expect)
from common import student as stu std = stu.student() std.Title = "fengdaqing" print(std.getStart())
def test_upload_phaseExam(self, URL, METHOD, DATA, CODE, CONTENT, expect):
upload_phaseexam_infos = {'URL': URL, 'DATA': DATA}
resp = student().upload_phaseexam(upload_phaseexam_infos)
#断言
self.assert_(resp.text, CONTENT)
def test_Mornexam_homework(self, URL, METHOD, DATA, CODE, CONTENT, expect):
testinfos = {'URL': URL, 'DATA': DATA}
resp = student().Mornexam_homework(testinfos)
#断言
self.assert_(resp.text, CONTENT)