def test_finance(self,url,method,test_data,resp_code,resp_content,expect):
print(expect)
from common.finance import Finance
query_finance_resp = Finance().query_finance(url,test_data)
query_finance_resp_content = query_finance_resp.text
print(query_finance_resp_content)
sql=''
Utility.query_all(data_base_path,sql)
if '"totalRow":3,"pageNumber":1,"firstPage":true,"lastPage":true,"totalPage":1,"pageSize":10' \
in str(query_finance_resp_content) :
actual = 'query-success'
else:
actual = 'query-fail'
self.assertEqual(actual,expect)
def test_administrative(self, url, method, test_data, resp_code, resp_content, expect):
# 通过数据库查询数据的数量
sql = 'select count(*) from assets;'
sql_request = Utility.query_all(data_base_path, sql)
from common.administrative import Administrative
add_assets_resp =Administrative().add_assets(url, test_data)
sql = 'select count(*) from assets;'
sql_request1 = Utility.query_all(data_base_path, sql)
print(add_assets_resp.text)
if int(sql_request[0][0]) == int(sql_request1[0][0]) - 1:
actual = 'add-success'
elif add_assets_resp.text =='AlreayExistCode':
actual = 'add-alreay'
else:
actual = 'add-fail'
self.assertEqual(actual, expect)
def test_hr(self, url, method, test_data, resp_code, resp_content, expect):
# 通过数据库查询数据的数量
sql = 'select count(*) from employee;'
sql_request = Utility.query_all(data_base_path, sql)
#新增员工
from common.HR import HR
add_hr_resp = HR().add_HR(url, test_data)
# add_hr_resp_content = add_hr_resp.json()
# print(query_hr_resp_content)
# print(add_hr_resp_content['totalRow'])
sql = 'select count(*) from employee;'
sql_request1 = Utility.query_all(data_base_path, sql)
if int(sql_request[0][0]) == int(sql_request1[0][0]) - 1:
actual = 'add-success'
else:
actual = 'add-fail'
self.assertEqual(actual, expect)
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)
def test_administrative(self, url, method, test_data, resp_code, resp_content, expect):
from common.administrative import Administrative
query_borlist_resp = Administrative().query_assets(url, test_data)
query_borlist_resp_content = query_borlist_resp.json()
# print(query_hr_resp_content)
print(query_borlist_resp_content['totalRow'])
# 通过数据库查询数据的数量
sql = 'select count(*) from borrow;'
sql_request = Utility.query_all(data_base_path, sql)
print(sql_request[0][0])
if query_borlist_resp_content['totalRow'] == sql_request[0][0]:
actual = 'query-success'
else:
actual = 'query-fail'
self.assertEqual(actual, expect)
def test_hr(self, url, method, test_data, resp_code, resp_content, expect):
from common.HR import HR
query_hr_resp = HR().query_HR(url, test_data)
query_attendance_resp_content = query_hr_resp.json()
# print(query_hr_resp_content)
print(query_attendance_resp_content['totalRow'])
# 通过数据库查询数据的数量
sql = 'select count(*) from attendance;'
sql_request = Utility.query_all(data_base_path, sql)
print(sql_request[0][0])
if query_attendance_resp_content['totalRow'] == sql_request[0][0]:
actual = 'query-success'
else:
actual = 'query-fail'
self.assertEqual(actual, expect)
