def test_add_source(self, marketing_query_info):
# 点击新增
Service.get_ele_location_method(
self.driver, 'css',
'#queryDiv > div:nth-child(2) > button:nth-child(9)').click()
# 调用新增操作
Marketing.marketing_add(self.driver, marketing_query_info)
# 判断出现保存成功框
commit_window_ele = Service.is_Element_present(
self.driver, By.CSS_SELECTOR,
"body > div.bootbox.modal.fade.mydialog.in > "
"div > div > div.modal-footer > button")
if commit_window_ele:
actual = "add-customer-success"
commit_window_ele.click()
else:
actual = "add-customer-fail"
# 预期不符，截图
if actual != marketing_query_info["expect"]:
file_name = "add_error" + Service.format_date() + '.png'
self.driver.get_screenshot_as_file(
"C:\\Users\wang\Desktop\woniuboss4.0\gui\error\\'%s'" %
(file_name))
# 断言
self.assertEqual(actual, marketing_query_info["expect"])
def test_class_manager_add(self, add_info):
# 新增按钮
Service.get_ele_location_method(
self.driver, "xpath", "//*[@id='cmDiv']/div[1]/button").click()
# 调用新增班级
ClassManager.class_manager_add(self.driver, add_info)
true_window_ele = Service.is_Element_present(
self.driver, By.CSS_SELECTOR,
"body > div.bootbox.modal.fade.mydialog.in > div > div > div.modal-footer > button"
)
if true_window_ele:
actual = "add-class-success"
true_window_ele.click()
else:
actual = "add-class-fail"
# 预期不符，截图
Service.get_screen(self.driver, actual, add_info["expect"],
"/add_class",
"C:/Users/wang/Desktop/woniuboss4.0/gui/error")
self.assertEqual(actual, add_info["expect"])
def test_open_page(self, expect):
open_page_url = self.url
Login.open_page(self.driver, open_page_url)
if Service.is_Element_present(
self.driver, By.CSS_SELECTOR,
"#form-login > div > div > div.modal-header.text-center"):
actual = "open-page-pass"
else:
actual = "open_page-fail"
self.assertEqual(actual, expect)
self.driver.quit()
def test_login(self, login_data, expect):
# 每次用例执行，强制等待1s
time.sleep(1)
login_url = self.url
Login.login(self.driver, login_url, login_data)
if Service.is_Element_present(self.driver, By.PARTIAL_LINK_TEXT, "注销"):
actual = "login-pass"
else:
actual = "login-fail"
self.assertEqual(actual, expect)
# 退出
self.driver.quit()
def verification_check_result(self, check_ele, check_path):
Service.get_tier_ele(check_ele, By.CSS_SELECTOR, check_path).click()
# 判断 查看功能
if Service.is_Element_present(self.driver, By.CSS_SELECTOR,
"#seeStuInfo-modal > div > div"):
# 关闭页面
Service.get_ele(
self.driver, By.CSS_SELECTOR,
"#seeStuInfo-modal > div > div > div.modal-header > button > span:nth-child(1)"
).click()
else:
print("查看功能出错")
self.driver.quit()
def test_training_resource(self, training_resource_info, expect):
# 获取sql
def joint_sql():
time_base_sql = ' and create_time between "%s" and "%s" and type="下载"' % (
training_resource_info['date1'],
training_resource_info['date2'])
if training_resource_info['poolSelect']=="全部" and training_resource_info['empNameSelect']=="全部" and\
training_resource_info['statusSelect']=="全部" and training_resource_info['sourceSelect']=="全部" and\
training_resource_info['date1']=="" and training_resource_info['date2']!="":
sql = 'select count(customer_id) from customer where pool_type != "public"' + time_base_sql
return sql
if training_resource_info['poolSelect']=="全部" and training_resource_info['empNameSelect']=="全部" and\
training_resource_info['statusSelect']=="全部" and training_resource_info['sourceSelect']!="全部":
sql = 'select count(customer_id) from customer where source = "%s" and pool_type != "public"'\
%training_resource_info['sourceSelect']+time_base_sql
return sql
elif training_resource_info['poolSelect']!="全部" and training_resource_info['empNameSelect']=="全部" and\
training_resource_info['statusSelect']=="全部" and training_resource_info['sourceSelect']!="全部":
sql = 'select count(customer_id) from customer where source = "%s" and pool_type = "%s"' \
% (training_resource_info['sourceSelect'],training_resource_info['poolSelect'])+time_base_sql
return sql
elif training_resource_info['poolSelect']!="全部" and training_resource_info['empNameSelect']=="全部" and\
training_resource_info['statusSelect']!="全部" and training_resource_info['sourceSelect']!="全部":
sql = 'select count(customer_id) from customer where source = "%s" and pool_type = "%s" and last_status="%s"' \
% (training_resource_info['sourceSelect'],training_resource_info['poolSelect'],
training_resource_info['statusSelect'])+time_base_sql
return sql
# 获取cookie
self.training_resource_init()
# 选择加载资源模块
Service.get_ele(
self.driver, By.CSS_SELECTOR,
"#content > div.row.con-margin.con-body-header > div:nth-child(1) > ul > li.active > a"
).click()
TrainingResource.training_resource(self.driver, training_resource_info)
# 系统提示搜索条件
if Service.is_Element_present(
self.driver, By.CSS_SELECTOR,
"body > div.bootbox.modal.fade.mydialog.in > div > div > "
"div.modal-footer > button"):
actual = "query-fail"
self.assertEqual(actual, expect)
# 关闭
self.driver.quit()
else:
# 判断是否查询出数据
training_resource_query_result = Service.get_ele(
self.driver, By.CSS_SELECTOR,
"table#personal-table tbody").text
# 市场营销有上传过数据
if training_resource_query_result != "无符合条件的记录":
# 前端页面显示数据数，根据状态（不同状态数量不同）
query_count_result = Service.get_ele(
self.driver, By.CSS_SELECTOR, "span.pagination-info").text
result = re.match('^显示.*，总.*?(\d+)', query_count_result)
print(result.group(1))
sql = joint_sql()
print(sql)
if sql:
query_connect_count = Utility.get_connect_one(
sql, "../config/data_base")
print(query_connect_count)
if int(result.group(1)) == int(query_connect_count[0]):
actual = 'query-pass'
else:
actual = 'query-fail'
self.assertEqual(actual, expect)
else:
print("查询结果为空")
self.driver.close()
