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
