#====#====#====#====
#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'
