#====#====#====#==== #Author: #CreatDate: #Version: #====#====#====#==== from WoniuBoss.tools.utility import Utility from WoniuBoss.lib.student_center import StudentCenter import unittest from parameterized import parameterized # 获取测试数据 student_center_datas = Utility.get_json('..\\config\\testdata.conf') print(student_center_datas) #基本信息数据 essential_datas = Utility.get_excel_to_tuple(student_center_datas[0]) print(essential_datas) #今日考勤数据 check_datas = Utility.get_excel_to_tuple(student_center_datas[1]) #今日晨考数据 morning_datas = Utility.get_excel_to_tuple(student_center_datas[2]) #学员请假数据 vacate_datas = Utility.get_excel_to_tuple(student_center_datas[3]) # 晨考记录数据 records_datas = Utility.get_excel_to_tuple(student_center_datas[4]) #测评阶段数据 appraisal_datas = Utility.get_excel_to_tuple(student_center_datas[5]) #测试记录数据 record_datas = Utility.get_excel_to_tuple(student_center_datas[6]) #班级管理数据 class_datas = Utility.get_excel_to_tuple(student_center_datas[7])
from WoniuBoss.tools.utility import Utility from WoniuBoss.lib.job_manage import JobManage import unittest from parameterized import parameterized # 获取测试数据 job_manage_datas = Utility.get_json('..\\config\\testdata.conf') # 就业面试通过 job_manage_pass_datas = Utility.get_excel_to_tuple_url(job_manage_datas[13]) # 就业管理提交 job_manage_commit_datas = Utility.get_excel_to_tuple_url(job_manage_datas[14]) # 查询资源 job_manage_query_datas = Utility.get_excel_to_tuple(job_manage_datas[15]) # 真实面试 job_manage_interview_datas = Utility.get_excel_to_tuple(job_manage_datas[16]) # 入职情况 job_manage_status_datas = Utility.get_excel_to_tuple(job_manage_datas[17]) class TestJobManage(unittest.TestCase): def setUp(self): print("test start") def tearDown(self): print("test over") # 就业面试通过 @parameterized.expand(job_manage_pass_datas) def test_job_manage_pass(self, job_manage_pass_url, expect): job_manage_pass_resp = JobManage().creat_pass(job_manage_pass_url) actual = job_manage_pass_resp
from WoniuBoss.tools.utility import Utility from WoniuBoss.lib.market_sale import MarketPort import unittest from parameterized import parameterized # 获取测试数据 market_sale_datas = Utility.get_json('..\\config\\testdata_deng.conf') # 新增资源 market_add_datas = Utility.get_excel_to_tuple(market_sale_datas[4]) # 上传简历 market_upload_datas = Utility.get_excel_to_tuple(market_sale_datas[5]) # 查询资源 market_query_datas = Utility.get_excel_to_tuple(market_sale_datas[6]) class TestMarketSale(unittest.TestCase): def setUp(self): print("test start") def tearDown(self): print("test over") # 新增资源 @parameterized.expand(market_add_datas) def test_market_add(self, market_add_url, market_add_data, expect): market_add_resp = MarketPort().market_add(market_add_url, market_add_data) actual = market_add_resp # 断言 self.assertEqual(actual, expect)
from WoniuBoss.tools.utility import Utility from WoniuBoss.lib.report_center import ReportCenter import unittest from parameterized import parameterized # 获取测试数据 report_center_datas = Utility.get_json('..\\config\\testdata.conf') # 咨询部数据 console_datas = Utility.get_excel_to_tuple(report_center_datas[0]) # 电销部数据 sale_datas = Utility.get_excel_to_tuple(report_center_datas[1]) # 市场部数据 mark_datas = Utility.get_excel_to_tuple(report_center_datas[2]) # 就业部数据 job_datas = Utility.get_excel_to_tuple(report_center_datas[3]) class TestReportCenter(unittest.TestCase): def setUp(self): print("test start") def tearDown(self): print("test over") # 咨询部报表中心功能测试 @parameterized.expand(console_datas) def test_console_report(self, console_url, console_data, console_expect): console_report_resp = ReportCenter().console_report( console_url, console_data) actual = console_report_resp # 断言
from WoniuBoss.lib.login import Login from WoniuBoss.tools.utility import Utility import unittest from parameterized import parameterized data_config_info = Utility.get_json('..\\config\\testdata_du.conf') test_login_info = Utility.get_excel_to_tuple(data_config_info[0]) class LoginTest(unittest.TestCase): def setUp(self): self.login = Login() def tearDown(self): pass @parameterized.expand(test_login_info) def test_login(self,login_url,post,login_data,status_code,content): login_resp = self.login.do_login(login_url, login_data) if 'success' in login_resp.text: actual = 'login-pass' else: actual = 'login-fail' self.assertEqual(actual,content)
import unittest from parameterized import parameterized from WoniuBoss.lib.financial_manage import Finance from WoniuBoss.tools.utility import Utility data_config_info = Utility.get_json('..\\config\\testdata_du.conf') test_addflow_info = Utility.get_excel_to_tuple(data_config_info[1]) test_queryflow_info = Utility.get_excel_to_tuple(data_config_info[7]) test_editflow_info = Utility.get_excel_to_tuple(data_config_info[8]) class FinancialTest(unittest.TestCase): def setUp(self): self.finance = Finance() def tearDown(self): pass @parameterized.expand(test_addflow_info) def test_addflow(self, addflow_url, post, addflow_data, status_code, content): addflow_resp = self.finance.add_flow(addflow_url, addflow_data) self.assertEqual(addflow_resp.text,content) # 按条件查询 @parameterized.expand(test_queryflow_info) def test_querflow(self, query_flow_url, post, query_flow_data, status_code, content): queryflow_resp = self.finance.query_flow(query_flow_url, query_flow_data) sql_part01 = 'select count(detailed_id) from detailed_dealings where trading_time between "2018-05-29" and "2018-05-31"' part_flow_number01 = Utility.query_one('..\\config\\base.conf', sql_part01)[0] sql_part02 = 'select count(detailed_id) from detailed_dealings where trading_time between "2020-03-01" and "2020-03-31"' part_flow_number02 = Utility.query_one('..\\config\\base.conf', sql_part02)[0] sql_part03 = 'select count(detailed_id) from detailed_dealings where trading_time between "2020-04-01" and "2020-04-30"'
from WoniuBoss.tools.utility import Utility from WoniuBoss.lib.job_manage_tech import JobManageTech import unittest from parameterized import parameterized # 获取测试数据 job_manage_tech_datas = Utility.get_json('..\\config\\testdata_deng.conf') # 技术面试通过 job_manage_tech_pass_datas = Utility.get_excel_to_tuple_url( job_manage_tech_datas[10]) # 技术面试不通过 job_manage_tech_unpass_datas = Utility.get_excel_to_tuple_url( job_manage_tech_datas[11]) # 查询资源 job_manage_tech_query_datas = Utility.get_excel_to_tuple( job_manage_tech_datas[12]) class TestJobManageTech(unittest.TestCase): def setUp(self): print("test start") def tearDown(self): print("test over") # 技术面试通过 @parameterized.expand(job_manage_tech_pass_datas) def test_job_manage_tech_pass(self, job_manage_tech_pass_url, expect): job_manage_tech_pass_resp = JobManageTech().job_pass( job_manage_tech_pass_url) actual = job_manage_tech_pass_resp
import unittest from parameterized import parameterized from WoniuBoss.tools.utility import Utility from WoniuBoss.lib.training import Tran train_data = Utility.get_json('..\\config\\testAPI.conf') query_message_info = Utility.get_excel_to_tuple(train_data[0]) query_resume_info = Utility.get_excel_to_tuple(train_data[1]) Track_resources_info = Utility.get_excel_to_tuple(train_data[2]) Modify_information_info = Utility.get_excel_to_tuple(train_data[3]) add_information_info = Utility.get_excel_to_tuple(train_data[4]) Waste_resources_info = Utility.get_excel_to_tuple(train_data[5]) transfer_query_info = Utility.get_excel_to_tuple(train_data[6]) transfer_view_info = Utility.get_excel_to_tuple(train_data[7]) transfer_commit_info = Utility.get_excel_to_tuple(train_data[8]) distribution_query_info = Utility.get_excel_to_tuple(train_data[9]) Proportionate_distribution_info = Utility.get_excel_to_tuple(train_data[10]) Public_query_info = Utility.get_excel_to_tuple(train_data[11]) Public_claim_info = Utility.get_excel_to_tuple(train_data[12]) class test_train(unittest.TestCase): def setUp(self): self.train = Tran(0) #搜索功能 @parameterized.expand(query_message_info) def test_query_message(self, URL, DATA, CONTENT): query_message_url = URL query_message_data = DATA resp = self.train.query_message(query_message_url, query_message_data) #断言
import unittest from parameterized import parameterized from WoniuBoss.lib.renshi_manage import Hr from WoniuBoss.tools.utility import Utility data_config_info = Utility.get_json('..\\config\\testdata_du.conf') test_addstaff_info = Utility.get_excel_to_tuple(data_config_info[2]) test_querystaff_info = Utility.get_excel_to_tuple(data_config_info[3]) test_editstaff_info = Utility.get_excel_to_tuple(data_config_info[4]) class HrTest(unittest.TestCase): def setUp(self): self.hr = Hr() def tearDown(self): pass @parameterized.expand(test_addstaff_info) def test_addstaff(self, add_staff_url, post, add_staff_data, status_code, content): addstaff_resp = self.hr.add_staff(add_staff_url, add_staff_data) self.assertEqual(addstaff_resp.text, content) #查询0条,查询1条,查询部分,查询所有 @parameterized.expand(test_querystaff_info) def test_querystaff(self, query_staff_url, post, query_staff_data, status_code, content): querystaff_resp = self.hr.query_staff(query_staff_url, query_staff_data) sql_all = 'select count(employee_id) from employee' all_staff_number = Utility.query_one('..\\config\\base.conf',sql_all)[0] sql_part = 'select count(employee_id) from employee where region_id=3' part_staff_number = Utility.query_one('..\\config\\base.conf', sql_part)[0]
import unittest from parameterized import parameterized from WoniuBoss.lib.backstage_manage import Backstage from WoniuBoss.tools.utility import Utility data_config_info = Utility.get_json('..\\config\\testdata_du.conf') test_addrole_info = Utility.get_excel_to_tuple(data_config_info[5]) test_queryuser_info = Utility.get_excel_to_tuple(data_config_info[6]) class BackstageTest(unittest.TestCase): def setUp(self): self.backstage = Backstage() def tearDown(self): pass @parameterized.expand(test_addrole_info) def test_add_role(self, add_role_url, post, add_role_data, status_code, content): add_role_resp = self.backstage.add_role(add_role_url, add_role_data) self.assertEqual(add_role_resp.text, content) # 查询0条,查询1条,查询所有 @parameterized.expand(test_queryuser_info) def test_queryuser(self, query_user_url, post, query_user_data, status_code, content): queryuser_resp = self.backstage.query_user(query_user_url, query_user_data) sql_all = 'select count(id) from system_user'