def test_query_all(self):
self.market.query_all('..\\config\\base.conf')
if Service.is_element_present(
self.driver, By.CSS_SELECTOR,
'#netCus-table > thead:nth-child(1) > tr:nth-child(1) > th:nth-child(1) > div:nth-child(1)'
) or Service.is_element_present(self.driver, By.CSS_SELECTOR,
'.no-records-found > td:nth-child(1)'):
actual = 'query_successful'
else:
actual = 'query_failed'
# 断言
self.assertEqual(actual, 'query_successful')
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 test_addCus(self, cus_phone,cus_name, cus_email, cus_qq,cus_school,cus_major,cus_intent,cus_salary,cus_applposition,cus_age,cus_eduexp,cus_experience,cus_last_tracking,expect):
addResModel_data={'cus_phone':cus_phone,'cus_name':cus_name,'cus_email':cus_email,'cus_qq':cus_qq,
'cus_school':cus_school,'cus_major':cus_major,'cus_intent':cus_intent,'cus_salary':cus_salary,
'cus_applposition': cus_applposition, 'cus_age': cus_age,'cus_eduexp':cus_eduexp,'cus_experience':cus_experience,
'cus_last_tracking': cus_last_tracking}
self.market.addCus('..\\config\\base.conf', addResModel_data)
if Service.is_element_present(self.driver,By.CSS_SELECTOR,'div.bootbox-body').text=='保存成功，但邮件未发送成功':
actual='add_failed'
elif Service.is_element_present(self.driver,By.CSS_SELECTOR,'div.bootbox-body').text=='程序出错':
actual='add_failed'
elif Service.is_element_present(self.driver,By.CSS_SELECTOR,'div.bootbox-body').text=='该资源已存在于系统中，请填写上最后跟踪记录点击保存':
actual = 'add_failed'
else:
actual='add_successful'
#断言
self.assertEqual(actual,expect)
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',
technical_interview_data)
if Service.is_element_present(
self.driver, By.CSS_SELECTOR,
'.bootbox > div:nth-child(1) > div:nth-child(1) > div:nth-child(1) > h4:nth-child(2)'
):
time.sleep(2)
content = self.driver.find_element_by_css_selector(
'.bootbox-body').text
if '不能为空' in content:
actual = 'interview_fail'
self.driver.find_element_by_xpath(
'/html/body/div[11]/div/div/div[3]/button').click()
else:
actual = 'interview_success'
self.driver.find_element_by_xpath(
'/html/body/div[11]/div/div/div[3]/button').click()
else:
contents = self.driver.find_element_by_css_selector(
'#skill_table > tbody:nth-child(2) > tr:nth-child(1) > td:nth-child(1)'
).text
if '无符合条件' in contents:
actual = 'interview_fail'
else:
actual = 'interview_success'
self.assertEqual(actual, expect)
def test_remove_res(self):
self.management.remove_res('..\\config\\base.conf')
if Service.is_element_present(self.driver, By.ID, 'res_tree_25_span'):
actual = 'remove_successful'
else:
actual = 'remove_failed'
# 断言
self.assertEqual(actual, 'remove_successful')
def test_query_year(self):
self.report.query_year('..\\config\\base.conf')
if Service.is_element_present(self.driver, By.LINK_TEXT, '咨询师'):
actual = 'query_successful'
else:
actual = 'query_failed'
# 断言
self.assertEqual(actual, 'query_successful')
def test_start(self):
self.management.start('..\\config\\base.conf')
if Service.is_element_present(self.driver, By.LINK_TEXT, '停用'):
actual = 'start_successful'
else:
actual = 'start_failed'
# 断言
self.assertEqual(actual, 'start_successful')
def test_read_email(self):
self.market.read_email()
if Service.is_element_present(self.driver,By.CSS_SELECTOR,'p.loading-title.txt-textOneRow'):
actual = 'read_successful'
else:
actual='read_failed'
# 断言
self.assertEqual(actual, 'read_successful')
def test_edit_resource(self, res_name, expect):
edit_resource_data = {'res_name': res_name}
self.management.edit_res('..\\config\\base.conf', edit_resource_data)
if Service.is_element_present(self.driver, By.LINK_TEXT, res_name):
actual = 'edit_successful'
else:
actual = 'edit_failed'
# 断言
self.assertEqual(actual, expect)
def test_set(self, role_name, role_des, expect):
set_data = {'role_name': role_name, 'role_des': role_des}
self.management.set('..\\config\\base.conf', set_data)
if Service.is_element_present(self.driver, By.LINK_TEXT, role_name):
actual = 'set_successful'
else:
actual = 'set_failed'
# 断言
self.assertEqual(actual, expect)
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.LINK_TEXT, '咨询师'):
actual = 'query_successful'
else:
actual = 'query_failed'
# 断言
self.assertEqual(actual, expect)
def test_validateUpload(self,files_path,expect ):
upload_files_data={'files_path':files_path}
self.market.upload_files('..\\config\\base.conf',upload_files_data)
if Service.is_element_present(self.driver,By.XPATH,'/html/body/div[9]/div/div/div[2]/div').text !='总共上传:1 有效数量:1 数据库重复数量:0 存入数量1':
actual = 'upload_successful'
else:
actual='upload_failed'
# 断言
self.assertEqual(actual, expect)
def test_qureyNetCus(self,stime,etime,expect):
qureyNetCus_data = {'stime':stime,'etime':etime}
self.market.qureyNetCus('..\\config\\base.conf',qureyNetCus_data)
if Service.is_element_present(self.driver,By.CSS_SELECTOR,'.no-records-found > td:nth-child(1)').text !='无符合条件的记录':
actual = 'query_successful'
else:
actual='query_failed'
# 断言
self.assertEqual(actual, expect)
def test_query_lastweek(self):
self.report.query_lastweek('..\\config\\base.conf')
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'
# 断言
self.assertEqual(actual, 'query_successful')
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'
self.driver.find_element_by_link_text('注销').click()
else:
actual = 'fail'
self.driver.refresh()
self.assertEqual(actual,expect)
def test_add_role(self, add_role_name, add_role_des, expect):
add_role_data = {
'add_role_name': add_role_name,
'add_role_des': add_role_des
}
self.management.add_role('..\\config\\base.conf', add_role_data)
if Service.is_element_present(self.driver, By.LINK_TEXT,
add_role_name):
actual = 'add_successful'
else:
actual = 'add_failed'
# 断言
self.assertEqual(actual, expect)
def test_mock_interview(self, money, remark, expect):
mock_interview_data = {'salary': money, 'mremark': remark}
# 执行技术面试的操作
self.employ.mock_interview('..\\config\\base.conf',
mock_interview_data)
if Service.is_element_present(
self.driver, By.CSS_SELECTOR,
'#stuInfo_table1 > tbody:nth-child(2) > tr:nth-child(1) > td:nth-child(9) > button:nth-child(1)'
):
actual = 'mock_success'
else:
actual = 'mock_fail'
self.assertEqual(actual, expect)
def test_query_username(self, username, expect):
query_username_data = {'username': username}
self.management.query_username('..\\config\\base.conf',
query_username_data)
if Service.is_element_present(
self.driver, By.CSS_SELECTOR,
'#user-table > tbody:nth-child(2) > tr:nth-child(1) > td:nth-child(7) > button:nth-child(1)'
):
actual = 'query_successful'
else:
actual = 'query_failed'
# 断言
self.assertEqual(actual, expect)
def test_user_set(self, username_role, username_des, expect):
user_set_data = {
'username_role': username_role,
'username_des': username_des
}
self.management.user_set('..\\config\\base.conf', user_set_data)
if Service.is_element_present(self.driver, By.LINK_TEXT,
username_role):
actual = 'set_successful'
else:
actual = 'set_failed'
# 断言
self.assertEqual(actual, expect)
def test_dict_add(self, dict_value, dict_key, dict_sort, dict_remarks,
expect):
dict_add_data = {
'dict_value': dict_value,
'dict_key': dict_key,
'dict_sort': dict_sort,
'dict_remarks': dict_remarks
}
self.management.dict_add('..\\config\\base.conf', dict_add_data)
if Service.is_element_present(self.driver, By.LINK_TEXT, dict_value):
actual = 'add_successful'
else:
actual = 'add_failed'
# 断言
self.assertEqual(actual, expect)
def test_details_edit(self, dict_typename, dict_value, dict_sort,
dict_remarks, expect):
details_edit_data = {
'dict_typename': dict_typename,
'dict_value': dict_value,
'dict_sort': dict_sort,
'dict_remarks': dict_remarks
}
self.management.details_edit('..\\config\\base.conf',
details_edit_data)
if Service.is_element_present(self.driver, By.LINK_TEXT, '正常'):
actual = 'edit_successful'
else:
actual = 'edit_failed'
# 断言
self.assertEqual(actual, expect)
def test_query_console(self, oldpw, newpw1, newpw2, expect):
change_second_password_data = {
'oldpw': oldpw,
'newpw1': newpw1,
'newpw2': newpw2
}
self.password.change_second_password('..\\config\\base.conf',
change_second_password_data)
if Service.is_element_present(
self.driver, By.CSS_SELECTOR,
'#panel-password-success > div:nth-child(2) > button:nth-child(1)'
):
actual = 'change_successful'
else:
actual = 'change_failed'
# 断言
self.assertEqual(actual, expect)
def test_twice_decrypt(self, t_word, expect):
add_password_data = {'password': t_word}
#执行解密动作
self.financial.decrypt('..\\config\\base.conf', add_password_data)
if Service.is_element_present(
self.driver, By.CSS_SELECTOR,
'.bootbox > div:nth-child(1) > div:nth-child(1) > div:nth-child(1) > h4:nth-child(2)'
):
content = self.driver.find_element_by_xpath(
'/html/body/div[11]/div/div/div[2]/div').text
if '错误' in content:
actual = 'decrypt-fail'
else:
actual = 'no-decrypt'
else:
actual = 'decrypt-success'
self.assertEqual(actual, expect)
