def test_add_flow(self, money, countparty, record, expect):
add_flow_data = {
'moneyNo': money,
'counterpartyName': countparty,
'textarea': record
}
#新增之前检查流水的总数
sql = 'select count(detailed_id) from detailed_dealings'
old_flow_count = Utility.query_one('..\\config\\base.conf', sql)
# 执行添加流水的操作
self.financial.add_flow('..\\config\\base.conf', add_flow_data)
# 对添加动作的结果进行验证
if Service.is_element_present(self.driver, By.CSS_SELECTOR,
'button.btn:nth-child(10)'):
time.sleep(2)
# 用于获取弹出页面的文本内容
content = self.driver.find_element_by_xpath(
'/html/body/div[7]/div[3]/div/div/div/div[1]/div[4]/div[1]/div[2]/div[2]/table/tbody/tr[1]/td[13]/button'
).text
if '修改' in content:
actual = 'add-success'
else:
actual = 'add-fail'
else:
# 判断表中的记录数是否增加
new_flow_count = Utility.query_one('..\\config\\base.conf', sql)
if new_flow_count[0] - old_flow_count[0] == 1:
actual = 'add-success'
else:
actual = 'add-fail'
self.assertEqual(actual, expect)
def get_driver(cls,base_config_path): contents = Utility.get_json(base_config_path) from selenium import webdriver driver = getattr(webdriver, contents['BROWSER'])() driver.implicitly_wait(10) driver.maximize_window() return driver
def miss_login(cls, driver, base_config_path):
cls.open_page(driver, base_config_path)
# 通过字典方式传递cookie信息
contents = Utility.get_json(base_config_path)
driver.add_cookie({'name': 'username', 'value': contents['username']})
driver.add_cookie({'name': 'password', 'value': contents['password']})
driver.add_cookie({'name':'token','value':contents['token']})
driver.add_cookie({'name':'workId','value':contents['workId']})
cls.open_page(driver, base_config_path)
def start(self):
from HTMLTestRunner import HTMLTestRunner
ts = unittest.TestSuite()
loader = unittest.TestLoader()
testcase_names = Utility.trans_str('..\\config\\test.conf')
tests = loader.loadTestsFromNames(testcase_names)
ts.addTests(tests)
# 测试报告文件名称的格式为：xxxx-xx-xx_xx_xx_xx_report.html
import time
ctime = time.strftime('%Y-%m-%d_%H-%M-%S', time.localtime())
with open('..\\report\\%s_report.html' % (ctime), 'w') as file:
runner = HTMLTestRunner(stream=file, verbosity=2)
runner.run(ts)
def miss_login(cls, driver, base_config_path):
cls.open_page(driver, base_config_path)
# 通过字典方式传递cookie信息
contents = Utility.get_json(base_config_path)
driver.add_cookie({'name': 'username', 'value': contents['username']})
driver.add_cookie({'name': 'password', 'value': contents['password']})
driver.add_cookie({
'name': 'JSESSIONID',
'value': contents['JSESSIONID']
})
driver.add_cookie({
'name': 'rememberMe',
'value': contents['rememberMe']
})
cls.open_page(driver, base_config_path)
def open_page(cls, driver, base_config_path): contents = Utility.get_json(base_config_path) URL = 'http://%s:%s/%s' % (contents['HOSTNAME'], contents['PORT'], contents['AURL']) driver.get(URL)
from selenium.webdriver.common.by import By
from woniuboss.tools.service import Service
from woniuboss.tools.utility import Utility
import unittest
from parameterized import parameterized
# 获取测试数据
data_config_info = Utility.get_json('..\\config\\testdata.conf')
# 查询资源
test_qureyNetCus_info = Utility.get_excel_to_tuple(data_config_info[1])
# 新增资源
test_addCus_info = Utility.get_excel_to_tuple(data_config_info[2])
# 上传简历
test_validateUpload_info = Utility.get_excel_to_tuple(data_config_info[3])
class TestMarket(unittest.TestCase):
@classmethod
def setUp(cls):
cls.driver = Service.get_driver('..\\config\\base.conf')
from woniuboss.lib.market import Market
cls.market = Market(cls.driver)
@classmethod
def tearDown(cls):
cls.driver.quit()
# 查询资源
# @parameterized.expand(test_qureyNetCus_info)
# def test_qureyNetCus(self,stime,etime,expect):
import time
import unittest
from parameterized import parameterized
from selenium.webdriver.common.by import By
from woniuboss.lib.employment_manage import EmployManage
from woniuboss.tools.service import Service
from woniuboss.tools.utility import Utility
test_config_info = Utility.get_json('..\\config\\testdata.conf')
technical_interview_info = Utility.get_excel_to_tuple(test_config_info[7])
mock_interview_info = Utility.get_excel_to_tuple(test_config_info[8])
search__info = Utility.get_excel_to_tuple(test_config_info[10])
class EmployTest(unittest.TestCase):
def setUp(self):
self.driver = Service.get_driver('..\\config\\base.conf')
self.employ = EmployManage(self.driver)
def tearDown(self):
self.driver.quit()
@parameterized.expand(technical_interview_info)
def test_technical_interview(self, q_content, e_content, expect):
technical_interview_data = {
'question_content': q_content,
'evalute_content': e_content
}
# 执行技术面试的操作
self.employ.technical_interview('..\\config\\base.conf',
import time,unittest
from parameterized import parameterized
# 获取登录用的测试信息
from woniuboss.lib.login import Login
from woniuboss.tools.service import Service
from woniuboss.tools.utility import Utility
test_config_info = Utility.get_json('..\\config\\testdata.conf')
login_info = Utility.get_excel_to_tuple(test_config_info[0])
class LoginTest(unittest.TestCase):
@classmethod
def setUpClass(cls):
cls.driver = Service.get_driver('..\\config\\base.conf')
cls.login = Login(cls.driver)
@classmethod
def tearDownClass(cls):
cls.driver.quit()
@parameterized.expand(login_info)
def test_login(self,uname,upass,vfcode,expect):
# 将参数重新组织成字典
login_data = {'username':uname,'password':upass,'verification':vfcode}
self.login.do_login('..\\config\\base.conf',login_data)
from selenium.webdriver.common.by import By
if Service.is_element_present(self.driver,By.LINK_TEXT,'注销'):
actual = 'success'
from selenium.webdriver.common.by import By
from woniuboss.tools.service import Service
from woniuboss.tools.utility import Utility
import unittest
from parameterized import parameterized
# 获取测试数据
data_config_info = Utility.get_json('..\\config\\testdata.conf')
# 咨询部数据
test_query_console_info = Utility.get_excel_to_tuple(data_config_info[5])
class TestReport(unittest.TestCase):
@classmethod
def setUp(cls):
cls.driver = Service.get_driver('..\\config\\base.conf')
from woniuboss.lib.report import Report
cls.report = Report(cls.driver)
@classmethod
def tearDown(cls):
cls.driver.quit()
# # 咨询部报表中心功能测试
# @parameterized.expand(test_query_console_info)
# def test_query_console(self,stime,etime,expect):
# query_console_data = {'stime': stime, 'etime': etime}
# self.report.query_console('..\\config\\base.conf', query_console_data)
# if Service.is_element_present(self.driver, By.CSS_SELECTOR, '#成都 > thead:nth-child(1) > tr:nth-child(1) > th:nth-child(1)'):
# actual = 'query_successful'
# else:
# actual = 'query_failed'
import time
import unittest
from parameterized import parameterized
from selenium.webdriver.common.by import By
from woniuboss.lib.financial_manage import FinancialManage
from woniuboss.tools.service import Service
from woniuboss.tools.utility import Utility
test_config_info = Utility.get_json('..\\config\\testdata.conf')
add_flow_info = Utility.get_excel_to_tuple(test_config_info[1])
add_password_info = Utility.get_excel_to_tuple(test_config_info[9])
class FinancialTest(unittest.TestCase):
def setUp(self):
self.driver = Service.get_driver('..\\config\\base.conf')
self.financial = FinancialManage(self.driver)
def tearDown(self):
self.driver.quit()
@parameterized.expand(add_flow_info)
def test_add_flow(self, money, countparty, record, expect):
add_flow_data = {
'moneyNo': money,
'counterpartyName': countparty,
'textarea': record
}
#新增之前检查流水的总数
sql = 'select count(detailed_id) from detailed_dealings'
from selenium.webdriver.common.by import By
from woniuboss.tools.service import Service
from woniuboss.tools.utility import Utility
import unittest
from parameterized import parameterized
# 获取测试数据
data_config_info = Utility.get_json('..\\config\\testdata.conf')
# 咨询部数据
test_add_resource_info = Utility.get_excel_to_tuple(data_config_info[8])
test_edit_resource_info = Utility.get_excel_to_tuple(data_config_info[9])
test_set_info = Utility.get_excel_to_tuple(data_config_info[10])
test_add_role_info = Utility.get_excel_to_tuple(data_config_info[11])
test_edit_role_info = Utility.get_excel_to_tuple(data_config_info[12])
test_query_username_info = Utility.get_excel_to_tuple(data_config_info[13])
test_user_set_info = Utility.get_excel_to_tuple(data_config_info[14])
test_dict_add_info = Utility.get_excel_to_tuple(data_config_info[15])
test_details_edit_info = Utility.get_excel_to_tuple(data_config_info[16])
class TestManagement(unittest.TestCase):
@classmethod
def setUp(cls):
cls.driver = Service.get_driver('..\\config\\base.conf')
from woniuboss.lib.management import Management
cls.management = Management(cls.driver)
@classmethod
def tearDown(cls):
cls.driver.quit()
from selenium.webdriver.common.by import By
from woniuboss.tools.service import Service
from woniuboss.tools.utility import Utility
import unittest
from parameterized import parameterized
# 获取测试数据
data_config_info = Utility.get_json('..\\config\\testdata.conf')
# 登录密码数据
test_change_login_password_info = Utility.get_excel_to_tuple(
data_config_info[6])
# 二级密码数据
test_change_second_password_info = Utility.get_excel_to_tuple(
data_config_info[7])
class TestPassword(unittest.TestCase):
@classmethod
def setUp(cls):
cls.driver = Service.get_driver('..\\config\\base.conf')
from woniuboss.lib.password import Password
cls.password = Password(cls.driver)
@classmethod
def tearDown(cls):
cls.driver.quit()
# 修改登录密码功能测试
@parameterized.expand(test_change_login_password_info)
def test_query_console(self, oldpw, newpw1, newpw2, expect):
change_login_password_data = {