def test_employed_empty(self): """添加员工-是否雇员为空-红框提示,保存失败""" page = AddStuffPage(self.driver) readExcel = ReadExcel(self.file_dir) excel_data = readExcel.get_value_by_row(0, 4) page.add_stuff_base(excel_data) result = page.has_danger_is_show() self.assertEqual(result, 1)
def test_empty_name(self): account_page = AccountPage(self.driver) danger_page = DangerPage(self.driver) readExcel = ReadExcel(self.account_test_data_dir) account_test_data = readExcel.get_value_by_row(0,3) account_page.test_add_bank_account(account_test_data) # self.driver.switch_to_alert() text_danger_msg = danger_page.get_text_danger_msg() self.assertEqual(text_danger_msg, account_test_data[6])
def test_same_name(self): account_page = AccountPage(self.driver) alert_page = AlertPage(self.driver) readExcel = ReadExcel(self.account_test_data_dir) account_test_data = readExcel.get_value_by_row(0,2) account_page.test_add_bank_account(account_test_data) # self.driver.switch_to_alert() alert_danger_msg = alert_page.get_alert_msg() self.assertEqual(alert_danger_msg, account_test_data[6])
def test_verify_add_labour(self): """添加员工-添加一位非雇员-添加成功""" page = AddStuffPage(self.driver) readExcel = ReadExcel(self.file_dir) excel_data = readExcel.get_value_by_row(0, 6) page.add_stuff_base(excel_data) time.sleep(5) page_url = self.driver.current_url print('page_url=>', page_url) self.assertIn('stuff-list', page_url)
def test_create_comp_empty_legal_person(self): """创建帐套-公司性质为空,红框提醒,保存失败""" page = CreateCompPage(self.driver) publicPage = PublicPage(self.driver) readExcel = ReadExcel(self.create_comp_data_dir) excel_date = readExcel.get_value_by_row('创建帐套测试数据', 3) for comp_data in excel_date: page.set_comp_base_info(comp_data) result = publicPage.has_danger_is_show() self.assertEqual(result, 1) self.assertNotIn('company-list', self.driver.current_url)
def test_create_comp_not_type_comp_detail_info(self): """创建帐套-帐套详细信息不填写,保存失败,红框提醒""" page = CreateCompPage(self.driver) publicPage = PublicPage(self.driver) read_excel = ReadExcel(self.create_comp_data_dir) excel_data = read_excel.get_value_by_row('创建帐套测试数据', 4) for comp_data in excel_data: page.set_comp_base_info(comp_data) page.set_comp_detail_info(comp_data) result = publicPage.has_danger_is_show() self.assertEqual(result, 1) self.assertNotIn('company-list', self.driver.current_url)
def test_tax_num_empty(self): """纳税人识别号为空,提示‘请填写纳税人识别号’,保存失败""" settingPage = SettingPage(self.driver) page = CompBillingPage(self.driver) dangerPage = DangerPage(self.driver) settingPage.go_to_setting_page(CompInfo.BASE_URL) read_excel = ReadExcel(self.modify_accounting_book_info_data_dir) accounting_book_info_data = read_excel.get_value_by_row(0, 3) page.modify_comp_info(accounting_book_info_data) text_danger_msg = dangerPage.get_text_danger_msg() self.assertEqual(text_danger_msg, accounting_book_info_data[10])
def test_actual_paid_empty_valid(self): """测试 实缴金额为空,保存成功""" page = PartnersetPage(self.driver) alertPage = AlertPage(self.driver) readExcel = ReadExcel(self.partnerset_test_data_dir) partnerset_test_data = readExcel.get_value_by_row(0, 2) page.add_partnerset(partnerset_test_data) page.submit('save') time.sleep(1) result = alertPage.get_alert_msg() self.assertEqual(result, partnerset_test_data[3])
def test_partset_name_repeat_invalid(self): """测试 股东名称重复,保存失败,提示‘股东名称不能重复’""" page = PartnersetPage(self.driver) alertPage = AlertPage(self.driver) readExcel = ReadExcel(self.partnerset_test_data_dir) partnerset_test_data = readExcel.get_value_by_row(0, 3) page.add_partnerset(partnerset_test_data) page.submit('save') time.sleep(1) result = alertPage.get_alert_msg() self.assertEqual(result, partnerset_test_data[3])
def test_partnerset_empty_invalid(self): """测试 股东名称为空,保存失败,提示‘请填写名称’""" page = PartnersetPage(self.driver) dangerPage = DangerPage(self.driver) readExcel = ReadExcel(self.partnerset_test_data_dir) partnerset_test_data = readExcel.get_value_by_row(0, 1) page.add_partnerset(partnerset_test_data) page.submit('save') time.sleep(1) result = dangerPage.get_text_danger_msg() self.assertEqual(result, partnerset_test_data[3])
def test_edit_partnerset_valid(self): """测试 编辑股东,编辑成功,提示‘编辑股东成功!'""" page = PartnersetPage(self.driver) alertPage = AlertPage(self.driver) readExcel = ReadExcel(self.partnerset_test_data_dir) partnerset_edit_test_data = readExcel.get_value_by_row(1, 1) page.eidt_partnerset(partnerset_edit_test_data) page.edit_item('//*[@id="departmentName"]') page.submit('save') time.sleep(1) result = alertPage.get_alert_msg() self.assertEqual(result, partnerset_edit_test_data[3])
def test_name_empty(self): """2.往来信息-测试往来名称为空,保存失败""" settingPage = SettingPage(self.driver, CompInfo.BASE_URL) page = ContactPage(self.driver) readExcel = ReadExcel(self.add_contact_data_dir) dangerPage = DangerPage(self.driver) settingPage.go_to_contact_page() add_contact_data = readExcel.get_value_by_row(0, 1) page.add_contact(add_contact_data) page.submit('save') result = dangerPage.get_text_danger_msg() self.assertEqual(result, add_contact_data[7]) print('result=>', result)
def test_name_repeat(self): """8.往来信息-测试往来名称重复,保存失败""" settingPage = SettingPage(self.driver, CompInfo.BASE_URL) page = ContactPage(self.driver) readExcel = ReadExcel(self.add_contact_data_dir) alertPage = AlertPage(self.driver) settingPage.go_to_contact_page() add_contact_data = readExcel.get_value_by_row(0, 7) page.add_contact(add_contact_data) page.submit('save') result = alertPage.get_alert_msg() self.assertEqual(result, add_contact_data[7]) print('result=>', result)
def test_contact_property_is_personal(self): """6.往来信息-测试 添加一个性质为个人的往来,添加成功""" settingPage = SettingPage(self.driver, CompInfo.BASE_URL) page = ContactPage(self.driver) alertPage = AlertPage(self.driver) readExcel = ReadExcel(self.add_contact_data_dir) settingPage.go_to_contact_page() add_contact_data = readExcel.get_value_by_row(0, 5) page.add_contact(add_contact_data) page.submit('save') result = alertPage.get_alert_msg() self.assertEqual(result, add_contact_data[7]) print('result=>', result)
def test_verify_edit_comp_info(self): """编辑帐套信息,编辑成功""" settingPage = SettingPage(self.driver) page = CompBillingPage(self.driver) settingPage.go_to_setting_page(CompInfo.BASE_URL) read_excel = ReadExcel(self.modify_accounting_book_info_data_dir) try: accounting_book_info_data = read_excel.get_value_by_row(0, 4) page.modify_comp_info(accounting_book_info_data) next_comp_name = page.get_comp_name() self.assertEqual(next_comp_name, accounting_book_info_data[0]) except NoSuchElementException as e: logging.error('查找的页面元素不存在,异常堆栈信息:' + str(traceback.format_exc())) except AssertionError as e: logging.info('编辑帐套信息失败,')
def test_phone_num_typeError(self): """3.往来信息-手机号格式不正确,提示‘手机格式不正确’,保存失败""" settingPage = SettingPage(self.driver, CompInfo.BASE_URL) page = ContactPage(self.driver) dangerPage = DangerPage(self.driver) readExcel = ReadExcel(self.add_contact_data_dir) settingPage.go_to_contact_page() add_contact_data = readExcel.get_value_by_row(0, 2) page.add_contact(add_contact_data) page.submit('save') result = dangerPage.get_text_danger_msg() self.assertEqual(result, add_contact_data[7]) print('result=>', result)
def test_empty_password(self): """ 登录测试-密码为空 """ login_page = LoginPage(CompInfo.BASE_URL, self.driver) read_excel = ReadExcel(self.login_test_data_dir) if 'dev' in CompInfo.BASE_URL: sheet_name = 0 elif 'stage' in CompInfo.BASE_URL: sheet_name = 1 elif 'firms' in CompInfo.BASE_URL: sheet_name = 2 login_test_data = read_excel.get_value_by_row(sheet_name, 5) login_page.login(login_test_data) input_alert_msg = login_page.get_input_error('password') self.assertEqual(input_alert_msg, login_test_data[3], msg='登录测试-密码为空,失败!')
def test_empty_username(self): """ 登录测试-用户名为空 """ login_page = LoginPage(CompInfo.BASE_URL, self.driver) danger_page = DangerPage(self.driver) read_excel = ReadExcel(self.login_test_data_dir) if 'dev' in CompInfo.BASE_URL: sheet_name = 0 elif 'stage' in CompInfo.BASE_URL: sheet_name = 1 elif 'firms' in CompInfo.BASE_URL: sheet_name = 2 login_test_data = read_excel.get_value_by_row(sheet_name, 4) login_page.login(login_test_data) input_alert_msg = danger_page.get_input_alert_msg() self.assertEqual(input_alert_msg, login_test_data[3], msg='登录测试-用户名为空,失败!')
def test_wrong_password(self): """ 登录测试-密码不正确 """ login_page = LoginPage(CompInfo.BASE_URL, self.driver) danger_page = DangerPage(self.driver) read_excel = ReadExcel(self.login_test_data_dir) if 'dev' in CompInfo.BASE_URL: sheet_name = 0 elif 'stage' in CompInfo.BASE_URL: sheet_name = 1 elif 'firms' in CompInfo.BASE_URL: sheet_name = 2 login_test_data = read_excel.get_value_by_row(sheet_name, 3) login_page.login(login_test_data) error_msg = danger_page.get_error_msg() self.assertEqual(error_msg, login_test_data[3], msg='登录测试-密码不正确,失败!')
def test_add_a_partner_valid(self): """测试 添加一名股东,添加成功,提示‘新增股东成功!’""" page = PartnersetPage(self.driver) alertPage = AlertPage(self.driver) readExcel = ReadExcel(self.partnerset_test_data_dir) settingPage = SettingPage(self.driver, CompInfo.BASE_URL) settingPage.go_to_partnerset_page() time.sleep(2) partnerset_test_data = readExcel.get_value_by_row(0, 4) page.add_partnerset(partnerset_test_data) page.submit('save') time.sleep(1) result = alertPage.get_alert_msg() self.assertEqual(result, partnerset_test_data[3])
def test_contact_input_show(self): """4.往来信息-测试性质为单位时-联系人输入框 显示""" settingPage = SettingPage(self.driver, CompInfo.BASE_URL) page = ContactPage(self.driver) publicPage = PublicPage(self.driver) readExcel = ReadExcel(self.add_contact_data_dir) settingPage.go_to_contact_page() add_contact_data = readExcel.get_value_by_row(0, 3) page.add_contact(add_contact_data) page.submit('save') contact_loc = self.driver.find_element_by_id(contact_elem) result = publicPage.is_element_present(contact_loc) self.assertEqual(result, 1) print('result=>', result)
def test_verify_create_comp(self): """确认创建帐套功能,创建成功""" page = CreateCompPage(self.driver) readExcel = ReadExcel(self.create_comp_data_dir) comp_data = readExcel.get_value_by_row('创建帐套测试数据', 1) compLisPage = CompListPage(self.driver) comp_name_list_len = len(compLisPage.get_comp_name_list()) compLisPage.go_to_create_comp_page() if 'create-company' in self.driver.current_url: page.set_comp_base_info(comp_data) page.set_comp_detail_info(comp_data) time.sleep(2) new_comp_name_list_len = len(compLisPage.get_comp_name_list()) self.assertIn('company-list', self.driver.current_url) self.assertEqual(comp_name_list_len + 1, new_comp_name_list_len) else: print('去创建帐套失败!') self.assertEqual(0, 1)
def test_verify_login(self): """登录管有帐""" login_page = LoginPage(CompInfo.BASE_URL, self.driver) if 'dev' in CompInfo.BASE_URL: sheet_name = 'dev' elif 'stage' in CompInfo.BASE_URL: sheet_name = 'stage' elif 'firms' in CompInfo.BASE_URL: sheet_name = 'pro' read_excel = ReadExcel(self.login_test_data_dir) login_test_data = read_excel.get_value_by_row(sheet_name, 1) print('login_test_data=>', login_test_data) login_page.login(login_test_data) page_url = self.driver.current_url print('page_url=>', page_url) self.assertIn('/app/company-list', page_url, msg='登录验证失败!')
def test_create_comp_empty_comp_name(self): """创建帐套-帐套名称为空,红框提醒保存失败""" page = CreateCompPage(self.driver) dangerPage = DangerPage(self.driver) compLisPage = CompListPage(self.driver) readExcel = ReadExcel(self.create_comp_data_dir) comp_data = readExcel.get_value_by_row('创建帐套测试数据', 2) compLisPage.go_to_create_comp_page() if 'create-company' in self.driver.current_url: page.set_comp_base_info(comp_data) page.submit(comp_data[17]) alert_danger_msg = dangerPage.get_alert_danger_msg() self.assertEqual(alert_danger_msg, comp_data[19]) time.sleep(2) self.assertNotIn('company-list', self.driver.current_url) else: print('去创建帐套失败!') self.assertEqual(0, 1)
def test_input_comp_name_jump_to_create_page(self): # create_ways_page_url = CompInfo.BASE_URL + '/create-ways' try: create_ways_page_url = CompInfo.BASE_URL + '/create-ways' self.driver.get(create_ways_page_url) if not PublicPage(self.driver).wait_until_loader_disapeared(): print('创建帐套方式页面!') readExcel = ReadExcel(self.test_data_dir) test_data = readExcel.get_value_by_row('创建帐套方式', 1) createWaysPage = CreateWaysPage(self.driver) for comp_name in test_data: createWaysPage.set_comp_name(comp_name) createWaysPage.confirm_enter() time.sleep(2) self.assertIn('/create-company', self.driver.current_url) else: print('---去创建帐套方式页面失败!') exit() except AssertionError as e: logging.info('---测试输入帐套名称点击回车键跳转至创建帐套页面失败,或请求超时!')
def test_addaccount_1(self): account_page = AccountPage(self.driver) readExcel = ReadExcel(self.account_test_data_dir) account_test_data = readExcel.get_value_by_row(0, 1) account_page.test_add_bank_account(account_test_data)
def test_addaccount_2(self): account_page = AccountPage(self.driver) readExcel = ReadExcel(self.account_test_data_dir) account_test_data_1 = readExcel.get_value_by_row(1, 1) account_page.test_add_WeChat_account(account_test_data_1)
def test_addaccount_3(self): account_page = AccountPage(self.driver) readExcel = ReadExcel(self.account_test_data_dir) account_test_data_2 = readExcel.get_value_by_row(2, 1) account_page.test_add_Alipay_account(account_test_data_2)
def test_edit_bank_account(self): account_page = AccountPage(self.driver) # danger_page = DangerPage(self.driver) readExcel = ReadExcel(self.account_test_data_dir) account_test_data = readExcel.get_value_by_row(0,3) account_page.test_add_bank_account(account_test_data)