def test_credit_code(self): """统一社会信用代码字段查询功能验证""" driver = self.driver driver.get(self.base_url) try: sheet = file_read.open_fie( "F:\\workplace\\GitWork\\python_project\\test_data\\查询条件.xlsx", "中小企业共享库") user_info = sheet.cell(4, 3).value username, password = user_info.split(",") # 调用登陆函数进行登陆 login.login(self, username, password) # 打开企业档案功能 public_module.open_business_library(self) # 获取测试数据 for i in range(10, 14): credit_code = str(sheet.cell(i, 3).value).rstrip() if credit_code == "null" or credit_code == "None": credit_code = "" driver.find_element_by_name("tyshxydm").clear() driver.find_element_by_name("tyshxydm").send_keys(credit_code) # time.sleep(2) driver.find_element_by_link_text(u"搜索").click() time.sleep(2) check_data.check_date(self) time.sleep(2) # 调用退出函数 login.logout(self) except Exception as e: print(e) raise Exception
def test_batches_search(self): """批次条件查询功能验证""" driver = self.driver driver.get(self.base_url) try: sheet = file_read.open_fie("F:\\workplace\\GitWork\\python_project\\test_data\\查询条件.xlsx", "企业白名单") user_info = sheet.cell(4, 3).value username, password = user_info.split(",") # 调用登陆函数进行登陆 login.login(self, username, password) # 打开菜单选项 public_module.open_business_white_list_import(self) # 获取测试数据 for i in range(6, 10): batch = str(sheet.cell(i, 3).value).rstrip() if batch == "null" or batch == "None": batch = "" try: # 进行条件检索 driver.find_element_by_name("batch").clear() driver.find_element_by_name("batch").send_keys(batch) driver.find_element_by_link_text(u"搜索").click() time.sleep(2) check_data.check_date(self) time.sleep(2) except Exception as e: print(e) login.logout(self) except Exception as e: print(e) raise Exception
def test_company_name(self): """企业名称字段查询功能验证""" driver = self.driver driver.get(self.base_url) try: sheet = file_read.open_fie("F:\\workplace\\GitWork\\python_project\\test_data\\查询条件.xlsx", "企业白名单") user_info = sheet.cell(4, 3).value username, password = user_info.split(",") # 调用登陆函数进行登陆 login.login(self, username, password) # 打开企业白名单导入功能 public_module.open_business_white_list_import(self) # 获取测试数据 for i in range(10, 14): enterprise_name = str(sheet.cell(i, 3).value).rstrip() if enterprise_name == "null" or enterprise_name == "None": enterprise_name = "" driver.find_element_by_name("enterpriseName").clear() driver.find_element_by_name("enterpriseName").send_keys(enterprise_name) # time.sleep(2) driver.find_element_by_link_text(u"搜索").click() time.sleep(2) check_data.check_date(self) time.sleep(2) # 调用退出函数 login.logout(self) except Exception as e: print(e) raise Exception
def test_error(self): """验证用户名和密码输入错误,登陆失败,系统进行提示""" driver = self.driver driver.get(self.base_url) driver.maximize_window() username = file_read.user_info(7)[0] password = file_read.user_info(7)[1] # 调用登陆函数 login.login(self, username, password) text = driver.find_element_by_xpath("/html/body/div[2]/div").text self.assertEqual(text, u"用户不存在/密码错误", "用户名或密码错误")
def test_user_null(self): """用户名输入为空,密码输入正确,用户登陆失败,系统进行提示。""" driver = self.driver driver.get(self.base_url) driver.maximize_window() username = file_read.user_info(6)[0] password = file_read.user_info(6)[1] # 调用登陆函数 login.login(self, username, password) text = driver.find_element_by_id("username-error").text self.assertEqual(text, u"请输入您的用户名", "用户名错误")
def test_password_null(self): """输入正确的用户名,密码输入为空,用户登陆失败,系统进行提示。""" driver = self.driver driver.get(self.base_url) driver.maximize_window() username = file_read.user_info(5)[0] password = file_read.user_info(5)[1] # 调用登陆函数 login.login(self, username, password) text = driver.find_element_by_id("password-error").text self.assertEqual(text, "请输入您的密码", "密码错误")
def test_login(self): """用户输入正确的用户名和密码,可正常登陆""" driver = self.driver driver.get(self.base_url) driver.maximize_window() # 调用登陆函数 login.login(self, "admin", "admin123") # 获取断言 # iframe = driver.find_element_by_name("iframe0") iframe = driver.find_element(By.name, 'iframe0') driver.switch_to.frame(iframe) time.sleep(3) # text = driver.find_element_by_xpath("/html/body/div[1]/div").text text = driver.find_element(By.xpath, "/html/body/div[1]/div").text self.assertEqual(text, "欢迎使用全国中小企业融资综合信用服务平台", "用户登陆失败") # 调用退出函数 login.logout(self)
def test_export_function(self): """导出功能验证""" driver = self.driver driver.get(self.base_url) try: sheet = file_read.open_fie("F:\\workplace\\GitWork\\python_project\\test_data\\查询条件.xlsx", "企业白名单") user_info = sheet.cell(4, 3).value username, password = user_info.split(",") # 调用登陆函数进行登陆 login.login(self, username, password) # 打开企业白名单导入功能 public_module.open_business_white_list_import(self) # 进行数据导出 public_module.export_work(self) # time.sleep(3) # 调用退出函数 login.logout(self) except Exception as e: print(e) raise Exception