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)