class TestCase10AccountCenterOverviewStock(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.account_center_page_details = AccountCenterDetailsPage(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(self.driver, self.base_url)
self.driver.set_window_max()
self.connect_sql = ConnectSql()
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.account_center_change_page = AccountCenterChangePage(self.driver, self.base_page)
self.assert_text = AssertText()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_account_center_overview_stock(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录账号
self.log_in_base.log_in()
account = self.log_in_base.get_log_in_account()
self.account_center_page_navi_bar.click_account_center_button()
# 拖拽页面到库存显示的
self.account_center_change_page.switch_kucun_dev_enable()
self.account_center_change_page.switch_to_kucun_dev_frame()
kucun_account = self.account_center_change_page.get_account_in_kuncun_frame()
self.driver.default_frame()
class TestCase020AccountCenterMsgUnread(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.account_center_page_msg_center = AccountCenterMsgCenterPage(
self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.account_center_change_page = AccountCenterChangePage(
self.driver, self.base_page)
self.assert_text = AssertText()
self.driver.set_window_max()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_account_center_msg_unread(self):
self.base_page.open_page()
self.log_in_base.log_in()
self.account_center_page_navi_bar.click_account_center_button()
# 进入消息中心
self.account_center_page_msg_center.enter_msg_center()
self.driver.wait(7)
# 进入iframe
# self.account_center_page_msg_center.message_center_iframe()
# 获取消息中心title
msg_center_title = self.account_center_page_msg_center.get_msg_center_title(
)
# 验证消息中心title是否正确显示
self.assertIn(
self.assert_text.account_center_page_message_center_text(),
msg_center_title, "消息中心title有误!")
#退出iframe
# self.driver.default_frame()
# 获取左侧栏目-消息中心-x条未读
unread_msg_num = int(
self.account_center_page_msg_center.get_unread_msg_num())
print(unread_msg_num)
if unread_msg_num > 0:
# 设置搜索条件-消息状态为“未读”，搜索出结果，统计结果列表中的未读消息共几条
self.account_center_page_msg_center.set_search_status_unread()
self.driver.wait(4)
count_unread_msg_num = self.account_center_page_msg_center.get_total_unread_logs_num(
)
# 判断消息中心左侧栏目的未读消息与搜索结果的未读消息数量是否一致
self.assertEqual(unread_msg_num, count_unread_msg_num,
"消息中心左侧栏目的未读消息与搜索结果的未读消息数量不一致")
# self.driver.default_frame()
# 退出登录
# self.account_center_page_navi_bar.usr_logout()
else:
print("当前未读消息共：" + str(unread_msg_num) + "条!")
class TestCase271AccountCenterModifyInfoException(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer()
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.account_center_page_read_csv = AccountCenterPageReadCsv()
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.base_page.open_page()
self.driver.set_window_max()
self.driver.clear_cookies()
def test_modify_info_exception(self):
"修改资料错误提示"
self.log_in_base.log_in()
self.account_center_page_navi_bar.click_account_center_button()
self.driver.wait(1)
# 点击招呼栏的修改资料
self.account_center_page_navi_bar.click_modify_usr_info()
csv_find = self.account_center_page_read_csv.read_csv(
"modify_info_exception.csv")
csv_data = csv.reader(csv_find)
for row in csv_data:
data = {
"name": row[0],
"phone": row[1],
"email": row[2],
"name_prompt": row[3],
"phone_prompt": row[4],
"email_prompt": row[5]
}
all_prompt = self.account_center_page_navi_bar.get_modify_info_exception_prompt(
data)
self.assertEqual(data["name_prompt"], all_prompt["name"],
"个人资料，客户名称错误提示语显示不一致")
self.assertEqual(data["phone_prompt"], all_prompt["phone"],
"个人资料，电话错误提示语显示不一致")
self.assertEqual(data["email_prompt"], all_prompt["email"],
"个人资料，邮箱错误提示语显示不一致")
# 验证长度
len = self.account_center_page_navi_bar.get_modifgy_info_element_len()
self.assertEqual(20, len["phone_len"], "电话号码长度显示不一致")
self.assertEqual(50, len["email_len"], "邮箱长度显示不一致")
csv_find.close()
# 关闭修改资料框
self.account_center_page_navi_bar.cancel_modify_user_info()
# 退出
# self.account_center_page_navi_bar.usr_logout()
def tearDown(self):
self.driver.quit_browser()
class TestCase118LoginWithLogoutDismiss(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer()
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.driver.set_window_max()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_login_and_logout_dismiss(self):
'''测试成功登录的用户取消退出'''
# 打开途强在线首页-登录页
self.base_page.open_page()
# 输入用户信息进行登录
self.log_in_base.log_in()
# 点账户中心
self.account_center_page_navi_bar.click_account_center_button()
# 判断登录成功后跳转页面是否正确
actual_url = self.driver.get_current_url()
expect_url = self.base_url + "/customer/toAccountCenter"
self.assertEqual(expect_url, actual_url, "登录成功后页面跳转错误")
# 成功退出系统
self.account_center_page_navi_bar.usr_logout_dismiss()
# 判断是否仍停留在当前账户首页，并未退出系统
self.assertEqual(self.base_url + "/customer/toAccountCenter",
self.driver.get_current_url(), "取消退出系统失败")
class TestCase32AccountCenterMsgEdit_Exception(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.account_center_page_msg_center = AccountCenterMsgCenterPage(
self.driver, self.base_url)
self.driver.set_window_max()
self.account_center_page_read_csv = AccountCenterPageReadCsv()
self.connect_sql = ConnectSql()
self.search_sql = SearchSql()
self.log_in_base = LogInBaseServer(self.driver, self.base_page)
self.base_page.open_page()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def test_account_center_msg_exception_prompt(self):
""" 消息中心，验证编辑中的错误提示 """
self.log_in_base.log_in()
self.account_center_page_navi_bar.click_account_center_button()
self.driver.wait(1)
# 点击进入消息中心
self.account_center_page_msg_center.enter_msg_center()
# self.account_center_page_msg_center.message_center_iframe()
# sleep(10)
sleep(25)
# 取元素长度
len = self.account_center_page_msg_center.get_message_edit_element_len(
)
# 基本信息
self.assertEqual(50, len["device_name"], "设备名称长度不相同")
self.assertEqual(20, len["sim"], "设备SIM卡号长度不相同")
self.assertEqual(500, len["remark"], "备注长度不相同")
# 客户信息
self.assertEqual(20, len["driver_name"], "司机名称长度不相同")
self.assertEqual(50, len["vehicle_number"], "车牌号长度不相同")
self.assertEqual(50, len["sn"], "SN长度不相同")
self.assertEqual(100, len["engine_number"], "电机/发动机号长度不相同")
self.assertEqual(20, len["phone"], "车架号长度不相同")
# self.assertEqual(18, len["id_card"], "电话长度不相同")
self.assertEqual(50, len["car_frame"], "身份证号长度不相同")
self.assertEqual(10, len["total_mileage"], "总里程长度不相同")
# 安装信息
self.assertEqual(100, len["install_company"], "安装公司长度不相同")
self.assertEqual(50, len["install_personnel"], "安装人员长度不相同")
self.assertEqual(200, len["install_address"], "安装地址长度不相同")
self.assertEqual(200, len["install_position"], "安装位置长度不相同")
# 退出登录
self.driver.wait()
# self.account_center_page_navi_bar.usr_logout()
def tearDown(self):
self.driver.quit_browser()
class TestCase18AccountCenterOverviewSetUpLandmark(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.account_center_page_details = AccountCenterDetailsPage(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(self.driver, self.base_url)
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.driver.set_window_max()
self.assert_text = AssertText()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_account_center_overview_set_up_landmark(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录账号
self.log_in_base.log_in()
self.account_center_page_navi_bar.click_account_center_button()
sleep(2)
account_center_handle = self.driver.get_current_window_handle()
# 点击库存
self.account_center_page_details.account_center_iframe()
self.account_center_page_details.account_overview('地标设置')
self.driver.default_frame()
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != account_center_handle:
self.driver.switch_to_window(handle)
sleep(2)
expect_url = self.driver.get_current_url()
actual_url = self.base_url + '/safearea/geozonemap?flag=1'
self.assertEqual(expect_url, actual_url, '点击地标设置后，实际的url和期望的不一样！')
sleep(2)
actual_text = self.account_center_page_details.get_actual_text_after_click_set_up_landmark()
self.assertEqual(self.assert_text.account_center_page_mark_point_text(), actual_text,
'点击地标设置后，页面没有跳转到地标设置页面上')
self.assertEqual('active',
self.driver.get_element('x,//*[@id="safemenu"]/li[2]').get_attribute('class'))
# 查看控制台告警设置能否打开
self.account_center_page_navi_bar.click_alarm_button_in_console()
# 断言
get_text = self.account_center_page_navi_bar.get_text_after_click_alarm_button()
self.assertEqual(self.assert_text.account_center_page_alarm_manager_text(), get_text)
self.account_center_page_navi_bar.close_alarm_in_console()
self.driver.close_current_page()
# 回到账户中心窗口
self.driver.switch_to_window(account_center_handle)
self.driver.wait()
class TestCase801MessageCenterSearchMassage(unittest.TestCase):
###############################################################
# # 测试 消息中心 消息搜索
###############################################################
def setUp(self):
self.driver = AutomateDriverServer()
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.message_center_page = MessageCenterPage(self.driver,
self.base_url)
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.account_center_page_read_csv = AccountCenterPageReadCsv()
self.help_page = HelpPage(self.driver, self.base_url)
self.assert_text = AssertText()
self.driver.set_window_max()
self.driver.clear_cookies()
self.base_page.open_page()
self.log_in_base.log_in()
def tearDown(self):
self.driver.close_window()
self.driver.quit_browser()
def test_case_801_message_center_search_massage(self):
user_account = self.log_in_base.get_log_in_account()
# 点击消息中心
self.message_center_page.click_message_center_button()
csv_file = self.account_center_page_read_csv.read_csv(
'message_center_search.csv')
csv_data = csv.reader(csv_file)
i = 1
is_header = True
for row in csv_data:
if is_header:
is_header = False
continue
search_data = {
'imei': row[0],
'massage_type': row[1],
'is_read': row[2]
}
print(search_data)
self.message_center_page.add_data_search_message_data(search_data)
# 获取当前用户和下级用户的所有用户id
all_user_id = self.help_page.get_all_user_id(user_account)
# 获取数据库查询的条数
sql_total = self.message_center_page.get_sql_total_search_center_massage(
search_data, all_user_id)
# 获取页面上的数据条数
web_total = self.message_center_page.get_web_total_search_center_massage(
)
print('第%s次查询的数据库总数：%s' % (i, sql_total))
print('第%s次查询的页面总数：%s' % (i, web_total))
i += 1
self.assertEqual(sql_total, web_total)
csv_file.close()
class TestCase14AccountCenterOverviewAlarm(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.account_center_page_details = AccountCenterDetailsPage(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.assert_text = AssertText()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_account_center_overview_alarm(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录账号
self.log_in_base.log_in()
self.account_center_page_navi_bar.click_account_center_button()
sleep(2)
account_center_handle = self.driver.get_current_window_handle()
# 点击围栏
self.account_center_page_details.account_center_iframe()
self.account_center_page_details.account_overview('围栏')
self.driver.default_frame()
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != account_center_handle:
self.driver.switch_to_window(handle)
sleep(2)
expect_url = self.driver.get_current_url()
actual_url = self.base_url + '/safearea/geozonemap?flag=0'
self.assertEqual(expect_url, actual_url, '点击围栏后，实际的url和期望的不一样！')
actual_text = self.account_center_page_details.get_actual_text_after_click_alarm()
self.assertEqual(self.assert_text.account_center_page_area_alarm_text(), actual_text,
'点击围栏后，页面没有跳转到围栏设置页面')
# 验证区域预警有没有被选中
value = self.account_center_page_details.click_safearea_get_vaule()
self.assertEqual('active', value)
# 查看控制台告警设置能否打开
self.account_center_page_navi_bar.click_alarm_button_in_console()
# 断言
get_text = self.account_center_page_navi_bar.get_text_after_click_alarm_button()
self.assertEqual(self.assert_text.account_center_page_alarm_manager_text(), get_text)
self.account_center_page_navi_bar.close_alarm_in_console()
self.driver.close_current_page()
# 回到账户中心窗口
self.driver.switch_to_window(account_center_handle)
self.driver.wait()
class TestCase08AccountCenterVisualAccount(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer()
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.account_center_page_visual_account = AccountCenterVisualAccountPage(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(self.driver, self.base_url)
self.driver.set_window_max()
self.account_center_page_read_csv = AccountCenterPageReadCsv()
self.log_in_base = LogInBaseServer(self.driver, self.base_page)
self.assert_text = AssertText()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_account_center_visual_account(self):
'''通过csv测试虚拟账户管理功能'''
# 打开途强在线首页-登录页
self.base_page.open_page()
sleep(2)
self.log_in_base.log_in()
self.account_center_page_navi_bar.click_account_center_button()
self.account_center_page_visual_account.enter_visual_account()
csv_file = self.account_center_page_read_csv.read_csv('add_visual_account.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
acc_to_add = {
"account": row[0],
"passwd": row[1]
}
# 登录
# 获取虚拟账户管理title
visual_account_title = self.account_center_page_visual_account.get_visual_account_title()
# 验证消息中心title是否正确显示
self.assertIn(self.assert_text.account_center_page_virtual_account_manager(), visual_account_title,
"虚拟账户管理title有误!")
# 添加虚拟账户
self.account_center_page_visual_account.add_visual_account(acc_to_add["account"], acc_to_add["passwd"])
state = self.account_center_page_visual_account.get_visual_account_limits_state()
self.assertEqual(False, state["edit_data"], "修改数据默认勾选了")
self.assertEqual(False, state["instruction"], "下发指令默认勾选了")
# 保存
self.account_center_page_visual_account.save_add_info()
# 验证是否保存成功
save_status = self.account_center_page_visual_account.get_save_status()
self.assertIn(self.assert_text.account_center_page_operation_done(), save_status, "保存成功")
self.driver.wait()
csv_file.close()
class TestCase68CustManageCustBatchTransferCustSearch(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.cust_manage_basic_info_and_add_cust_page = CustManageBasicInfoAndAddCustPage(self.driver, self.base_url)
self.cust_manage_cust_list_page = CustManageCustListPage(self.driver, self.base_url)
self.cust_manage_my_dev_page = CustManageMyDevPage(self.driver, self.base_url)
self.cust_manage_lower_account_page = CustManageLowerAccountPage(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.cust_manage_page_read_csv = CustManagePageReadCsv()
self.assert_text = AssertText()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_cust_manage_batch_transfer_cust_search(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
sleep(1)
# 进入客户管理页面
self.cust_manage_basic_info_and_add_cust_page.enter_cust_manage()
sleep(2)
self.cust_manage_basic_info_and_add_cust_page.click_first_account()
# 点击编辑用户
self.cust_manage_basic_info_and_add_cust_page.click_batch_transfer_customer()
self.cust_manage_basic_info_and_add_cust_page.click_cancel_edit()
self.cust_manage_basic_info_and_add_cust_page.click_batch_transfer_customer()
# 循环点击五次
for n in range(5):
self.cust_manage_basic_info_and_add_cust_page.locate_to_iframe()
self.driver.click_element('x,//*[@id="treeDemo2_%s_span"]' % str(n + 3))
sleep(2)
self.driver.default_frame()
# 搜索
# 1 搜索无数据的内容
self.cust_manage_basic_info_and_add_cust_page.search_cust('无数据')
get_text = self.cust_manage_basic_info_and_add_cust_page.get_search_no_data_text()
self.assertIn(self.assert_text.account_center_page_no_data_text(), get_text)
class TestCase70CustManageCustSearch(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.cust_manage_basic_info_and_add_cust_page = CustManageBasicInfoAndAddCustPage(
self.driver, self.base_url)
self.cust_manage_cust_list_page = CustManageCustListPage(
self.driver, self.base_url)
self.cust_manage_my_dev_page = CustManageMyDevPage(
self.driver, self.base_url)
self.cust_manage_lower_account_page = CustManageLowerAccountPage(
self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.cust_manage_page_read_csv = CustManagePageReadCsv()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def test_cust_manage_add_cust_search(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 进入客户管理页面
self.cust_manage_basic_info_and_add_cust_page.enter_cust_manage()
self.cust_manage_basic_info_and_add_cust_page.add_acc()
self.cust_manage_basic_info_and_add_cust_page.cancel_add_account()
self.cust_manage_basic_info_and_add_cust_page.add_acc()
# 添加客户名称、账号,点击保存
self.cust_manage_basic_info_and_add_cust_page.add_account_name("虚拟账号")
self.cust_manage_basic_info_and_add_cust_page.add_account(
"xnzh_dzl022")
self.cust_manage_basic_info_and_add_cust_page.acc_add_save()
connect = self.connect_sql.connect_tuqiang_sql()
cursor = connect.cursor()
get_account_sql = "select account from user_info where account = 'xnzh_dzl022';"
cursor.execute(get_account_sql)
user = cursor.fetchall()
print(user)
print(len(user))
self.assertEqual(0, len(user), "添加普通账号时，可成功添加虚拟账户")
def tearDown(self):
self.driver.quit_browser()
class TestCase406CustomerManagementOperationControl(unittest.TestCase):
# 测试客户管理 - 用户操作 - 控制台
def setUp(self):
self.driver = AutomateDriverServer()
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.cust_manage_basic_info_and_add_cust_page = CustManageBasicInfoAndAddCustPage(
self.driver, self.base_url)
self.cust_manage_lower_account_page = CustManageLowerAccountPage(
self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.cust_manage_page_read_csv = CustManagePageReadCsv()
self.assert_text = AssertText()
self.assert_text2 = AssertText2()
self.driver.set_window_max()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.close_window()
self.driver.quit_browser()
def test_user_operation_control(self):
self.base_page.open_page()
self.log_in_base.log_in()
current_handle = self.driver.get_current_window_handle()
self.cust_manage_basic_info_and_add_cust_page.enter_cust_manage()
self.base_page.change_windows_handle(current_handle)
# 搜索一个客户
self.cust_manage_lower_account_page.input_search_info('bbb123')
# 搜索
self.cust_manage_lower_account_page.click_search_btn()
# 点击控制台
current_handle = self.driver.get_current_window_handle()
# 点击控制台
self.cust_manage_basic_info_and_add_cust_page.click_control_button()
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != current_handle:
self.driver.switch_to_window(handle)
# 获取url
except_url = self.driver.get_current_url()
self.assertEqual(self.base_url + "/index", except_url)
class TestCase132MarkPaging(unittest.TestCase):
""" web_autotest账号，标注点页面分页功能 """
# author：邓肖斌
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.safe_area_page = SafeAreaPage(self.driver, self.base_url)
self.base_page.open_page()
self.base_page.click_chinese_button()
self.driver.set_window_max()
self.log_in_base.log_in()
self.safe_area_page.click_control_after_click_safe_area()
self.safe_area_page_read_csv = SafeAreaPageReadCsv()
def tearDown(self):
self.driver.quit_browser()
def test_case_mark_paging(self):
# 断言url
expect_url = self.base_url + "/safearea/geozonemap?flag=0"
self.assertEqual(expect_url, self.driver.get_current_url())
self.safe_area_page.click_mark_button()
sleep(2)
# 获取总页数
total_number = self.safe_area_page.get_total_page_number_mark()
if total_number == '0':
print('无数据！')
elif total_number == '1':
print('就一页！')
else:
# 下一页
self.safe_area_page.click_next_page_mark()
self.assertEqual('2', self.safe_area_page.get_current_page_number_mark())
# 点击上一页
self.safe_area_page.click_ago_page_mark()
self.assertEqual('1', self.safe_area_page.get_current_page_number_mark())
# 点击尾页
self.safe_area_page.click_last_page_mark()
self.assertEqual(self.safe_area_page.get_current_page_number_mark(),
self.safe_area_page.get_total_page_number_mark())
# 点击首页
self.safe_area_page.clcik_first_page_mark()
self.assertEqual('1', self.safe_area_page.get_current_page_number_mark())
class TestCase802MessageCenterClickUnreadMessage(unittest.TestCase):
###############################################################
# # 测试 消息中心 标记未读消息为已读
###############################################################
def setUp(self):
self.driver = AutomateDriverServer()
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.message_center_page = MessageCenterPage(self.driver, self.base_url)
self.help_page = HelpPage(self.driver, self.base_url)
self.assert_text = AssertText()
self.driver.set_window_max()
self.driver.clear_cookies()
self.base_page.open_page()
self.log_in_base.log_in()
def tearDown(self):
self.driver.close_window()
self.driver.quit_browser()
def test_case_802_message_center_click_unread_message(self):
# 获取未读消息的总数
unread_message_total_number = self.message_center_page.get_unread_message_total_number()
print(unread_message_total_number)
# 点击消息中心
self.message_center_page.click_message_center_button()
data = {
'imei': '',
'massage_type': '',
'is_read': '未读'
}
self.message_center_page.add_data_search_message_data(data)
# 获取搜索出来的未读消息的总数
search_unread_message_total_number = self.message_center_page.get_web_total_search_center_massage()
self.assertEqual(unread_message_total_number, str(search_unread_message_total_number))
if unread_message_total_number == '0':
pass
else:
# 点击其中一条未读消息
self.message_center_page.click_anyone_unread_message()
# 点击标为已读按钮
self.message_center_page.click_set_unread_message_read()
# 重新获取抬头上的未读消息数量
unread_message_total_number_01 = self.message_center_page.get_unread_message_total_number()
self.assertEqual(int(unread_message_total_number) - 1, int(unread_message_total_number_01))
class TestCase803MessageCenterClickUnreadMessageAllRead(unittest.TestCase):
###############################################################
# # 测试 消息中心 全部标记为已读
###############################################################
def setUp(self):
self.driver = AutomateDriverServer()
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.message_center_page = MessageCenterPage(self.driver,
self.base_url)
self.help_page = HelpPage(self.driver, self.base_url)
self.assert_text = AssertText()
self.driver.set_window_max()
self.driver.clear_cookies()
self.base_page.open_page()
self.log_in_base.log_in()
def tearDown(self):
self.driver.close_window()
self.driver.quit_browser()
def test_case_803_message_center_click_unread_message_all_read(self):
# 获取未读消息的总数
unread_message_total_number = self.message_center_page.get_unread_message_total_number(
)
print(unread_message_total_number)
# 点击消息中心
self.message_center_page.click_message_center_button()
sleep(10)
# 点击全部标记为已读
self.message_center_page.click_set_unread_message_all_read()
sleep(10)
unread_message_total_number_01 = self.message_center_page.get_unread_message_total_number(
)
print(unread_message_total_number_01)
self.assertEqual('0', unread_message_total_number_01)
# 搜索未读消息数量
data = {'imei': '', 'massage_type': '', 'is_read': '未读'}
self.message_center_page.add_data_search_message_data(data)
# 获取搜索出来的未读消息的总数
search_unread_message_total_number = self.message_center_page.get_web_total_search_center_massage(
)
self.assertEqual(0, search_unread_message_total_number)
class TestCase64CustManageSearch(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.cust_manage_basic_info_and_add_cust_page = CustManageBasicInfoAndAddCustPage(self.driver, self.base_url)
self.cust_manage_cust_list_page = CustManageCustListPage(self.driver, self.base_url)
self.cust_manage_my_dev_page = CustManageMyDevPage(self.driver, self.base_url)
self.cust_manage_lower_account_page = CustManageLowerAccountPage(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.cust_manage_page_read_csv = CustManagePageReadCsv()
self.connect_sql = ConnectSql()
self.assert_text = AssertText()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_cust_manage_search(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 进入客户管理页面
self.cust_manage_basic_info_and_add_cust_page.enter_cust_manage()
# 循环点击5次
for n in range(5):
self.driver.click_element('x,//*[@id="treeDemo_%s_span"]' % str(n + 2))
sleep(2)
text = self.driver.get_text('x,//*[@id="treeDemo_%s_span"]' % str(n + 2))
account_name = text.split('(')[0]
value = self.driver.get_text('x,//*[@id="user_account"]')
self.assertEqual(account_name, value)
# 搜索无数据
self.cust_manage_basic_info_and_add_cust_page.search_customer('无数据')
get_text = self.cust_manage_basic_info_and_add_cust_page.get_search_customer_no_data_text()
self.assertIn(self.assert_text.account_center_page_no_data_text(), get_text)
class TestCase33AccountCenterAddVisualEditException(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer()
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.visual_account_page = AccountCenterVisualAccountPage(
self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.account_center_page_read_csv = AccountCenterPageReadCsv()
self.log_in_base = LogInBaseServer(self.driver, self.base_page)
self.assert_text = AssertText()
self.base_page.open_page()
self.driver.set_window_max()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def test_add_visual_account_exception_validation(self):
'''添加虚拟用户验证'''
data = ["jimitest", "dzltest", "xnzh_cs01"]
# 登录
self.log_in_base.log_in()
self.account_center_page_navi_bar.click_account_center_button()
# 进入虚拟账户管理
self.visual_account_page.enter_visual_account()
# 添加虚拟账号、保存
for i in range(len(data)):
self.visual_account_page.add_visual_account(data[i], "jimi123")
self.visual_account_page.save_add_info()
self.visual_account_page.dis_save_add_info()
self.driver.wait(1)
self.assertEqual(
self.assert_text.account_center_page_account_exist(),
self.visual_account_page.get_save_status(),
"在添加虚拟账号中可以添加已存在的账号！")
self.driver.wait(1)
# 退出登录
# self.account_center_page_navi_bar.usr_logout()
def tearDown(self):
self.driver.quit_browser()
class TestCase211UserCenterLogout(unittest.TestCase):
# 测试退出登录
def setUp(self):
self.driver = AutomateDriverServer()
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.log_in_base = LogInBaseServer(self.driver, self.base_page)
self.user_center_page = UserCenterPage(self.driver, self.base_url)
self.driver.set_window_max()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_user_center_logout(self):
self.base_page.open_page()
self.log_in_base.log_in()
# 点击退出登录
self.user_center_page.click_user_center_button()
# 点击退出登录按钮
self.user_center_page.click_logout_button()
# 点击取消
self.user_center_page.click_cancel_button()
# 点击退出登录
self.user_center_page.click_user_center_button()
# 点击退出登录按钮
self.user_center_page.click_logout_button()
# 点击取消
self.user_center_page.click_close_button()
# 点击退出登录
self.user_center_page.click_user_center_button()
# 点击退出登录按钮
self.user_center_page.click_logout_button()
# 点击取消
self.user_center_page.click_ensure_button()
class TestCase119LoginWithRememberMe(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer()
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.driver.set_window_max()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_login_with_remember_me(self):
'''测试登录时勾选记住我'''
# 打开途强在线首页-登录页
self.base_page.open_page()
self.log_in_base.log_in()
# 点账户中心
self.account_center_page_navi_bar.click_account_center_button()
# 判断登录成功后跳转页面是否正确
actual_url = self.driver.get_current_url()
expect_url = self.base_url + "/customer/toAccountCenter"
self.assertEqual(expect_url, actual_url, "登录成功后页面跳转错误")
sleep(1)
# 成功退出系统
self.account_center_page_navi_bar.usr_logout()
# 判断是否成功退出系统
self.assertEqual(self.base_url + "/", self.driver.get_current_url(),
"退出系统失败")
# 验证退出系统后“记住我”是否是已勾选状态
box_status = self.login_page.check_remember_me()
self.assertEqual(True, box_status, '记住密码失败')
class TestCase410918AccountCenterRefillCardAddApply(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.account_center_page_refill_card = AccountCenterRefillCardPage(
self.driver, self.base_url)
self.log_in_base = LogInBaseServer(self.driver, self.base_page)
self.account_center_page_read_csv = AccountCenterPageReadCsv()
self.log_in_base = LogInBaseServer(self.driver, self.base_page)
self.assert_text2 = AssertText2()
self.driver.set_window_max()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_apply_refill_card(self):
'''充值卡-申请记录--申请充值卡'''
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录账号
# self.log_in_base.log_in_with_csv("dzltest", "jimi123")
self.log_in_base.log_in()
self.driver.wait(1)
self.account_center_page_navi_bar.click_account_center_button()
# 进入充值卡页面
# self.account_center_page_navi_bar.switch_to_chongzhi_card()
self.account_center_page_refill_card.click_refill_card()
csv_file = self.account_center_page_read_csv.read_csv(
'apply_refill_card.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
data = {
"year": row[0],
"lifetime": row[1],
"name": row[2],
"phone": row[3],
"payment_account": row[4]
}
# 验证页面顶部我的账号
my_account = self.account_center_page_refill_card.get_title_display_account(
)
# 取消
self.account_center_page_refill_card.apply_refill_card_cancel()
# 验证账号
self.account_center_page_refill_card.click_apply_refill_card_button(
)
apply_page_account = self.account_center_page_refill_card.get_refill_account(
)
self.assertEqual(my_account, apply_page_account, "充值账号显示不一致")
# 添加充值卡
self.account_center_page_refill_card.apply_refill_card_add(
data["year"], data["lifetime"], data["name"], data["phone"],
data["payment_account"])
information = self.account_center_page_refill_card.get_applicant_information(
)
statu = self.account_center_page_refill_card.get_operate_status()
self.assertEqual(
self.assert_text2.account_center_refill_card_apply_succeed(),
statu, "申请充值卡失败")
# 验证添加数据与申请人信息
self.assertEqual(apply_page_account,
information["applicant_account"],
"申请人信息中，充值账号显示不一致")
self.assertEqual(data["year"] + "张", information["year"],
"申请人信息中，一年充值卡张数显示不一致")
self.assertEqual(data["lifetime"] + "张", information["lifetime"],
"申请人信息中，终身充值卡张数显示不一致")
self.assertEqual(data["name"], information["name"],
"申请人信息中，付款人姓名显示不一致")
self.assertEqual(data["phone"], information["phone"],
"申请人信息中，充值联系方式显示不一致")
self.assertEqual(data["payment_account"],
information["payment_account"],
"申请人信息中，付款账号显示不一致")
csv_file.close()
class TestCase57CustManageCheckAccount(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.cust_manage_basic_info_and_add_cust_page = CustManageBasicInfoAndAddCustPage(
self.driver, self.base_url)
self.cust_manage_cust_list_page = CustManageCustListPage(
self.driver, self.base_url)
self.cust_manage_my_dev_page = CustManageMyDevPage(
self.driver, self.base_url)
self.cust_manage_lower_account_page = CustManageLowerAccountPage(
self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.connect_sql = ConnectSql()
self.cust_manage_page_read_csv = CustManagePageReadCsv()
self.assert_text = AssertText()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_cust_manage_check_account(self):
'''测试客户管理-新增用户'''
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 进入客户管理页面
self.cust_manage_basic_info_and_add_cust_page.enter_cust_manage()
csv_file = self.cust_manage_page_read_csv.read_csv(
'check_account_data.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
data = {'account': row[0]}
self.cust_manage_basic_info_and_add_cust_page.add_data_to_search_account(
data)
connect = self.connect_sql.connect_tuqiang_sql()
cursor = connect.cursor()
get_account_sql = "SELECT o.type,o.phone,o.nickName from user_info o WHERE o.account = '" + data[
'account'] + "';"
cursor.execute(get_account_sql)
get_account_user_info = cursor.fetchall()
current_user_info = []
for range1 in get_account_user_info:
for range2 in range1:
current_user_info.append(range2)
print(current_user_info)
type = self.assert_text.log_in_page_account_type(
current_user_info[0])
# 断言客户类型
account_type = self.cust_manage_basic_info_and_add_cust_page.get_account_type(
)
self.assertEqual(type, account_type)
# 断言账号
account = self.cust_manage_basic_info_and_add_cust_page.get_account(
)
self.assertEqual(data['account'], account)
# 断言电话
account_phone = self.cust_manage_basic_info_and_add_cust_page.get_account_phone(
)
if current_user_info[1] == None:
self.assertEqual("", account_phone, "手机号不一致")
else:
self.assertEqual(current_user_info[1], account_phone)
# 断言昵称
account_name = self.cust_manage_basic_info_and_add_cust_page.get_account_name(
)
if current_user_info[2] == None:
self.assertEqual("", account_name, "昵称不一致")
else:
self.assertEqual(current_user_info[2], account_name)
# 点击监控用户
current_window = self.driver.get_current_window_handle()
self.cust_manage_basic_info_and_add_cust_page.click_monitoring_account_button(
)
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != current_window:
self.driver.switch_to_window(handle)
expect_url = self.base_url + '/index'
self.assertEqual(expect_url, self.driver.get_current_url())
self.driver.close_current_page()
sleep(2)
self.driver.switch_to_window(current_window)
# 点击编辑用户
style_value = self.cust_manage_basic_info_and_add_cust_page.edit_button_style_value(
)
if style_value == 'display: inline;':
self.cust_manage_basic_info_and_add_cust_page.click_edit_account_button(
)
# 点击关闭
self.cust_manage_basic_info_and_add_cust_page.click_close_edit_accunt_button(
)
# 点击编辑
self.cust_manage_basic_info_and_add_cust_page.click_edit_account_button(
)
# 查询用户上一级信息
connect_02 = self.connect_sql.connect_tuqiang_sql()
cursor_02 = connect_02.cursor()
get_id_sql = "SELECT o.parentId from user_info o WHERE o.account = '" + account + "';"
cursor_02.execute(get_id_sql)
get_id_info = cursor_02.fetchall()
current_user = []
for range1 in get_id_info:
for range2 in range1:
current_user.append(range2)
print(current_user)
get_up_account_info_sql = "SELECT o.nickName FROM user_info o WHERE o.userId = '" + current_user[
0] + "';"
cursor_02.execute(get_up_account_info_sql)
get_up_user_info = cursor_02.fetchall()
up_user_info = []
for range1 in get_up_user_info:
for range2 in range1:
up_user_info.append(range2)
account_name = up_user_info[0]
get_web_account_name = self.cust_manage_basic_info_and_add_cust_page.get_account_name_after_click_edit(
)
self.assertEqual(account_name, get_web_account_name,
'用户上级显示错误！')
self.cust_manage_basic_info_and_add_cust_page.click_close_edit_accunt_button(
)
# 断言账号类型
cursor_02.close()
connect_02.close()
cursor.close()
connect.close()
csv_file.close()
class TestCase37AccountCenterSearchLowerClientVerify(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.account_center_page_details = AccountCenterDetailsPage(
self.driver, self.base_url)
self.assert_text = AssertText()
self.driver.set_window_max()
self.account_center_page_read_csv = AccountCenterPageReadCsv()
self.log_in_base = LogInBaseServer(self.driver, self.base_page)
self.account_center_change_page = AccountCenterChangePage(
self.driver, self.base_page)
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_search_lower_client(self):
'''通过csv测试账户详情--下级客户--查找不同账号功能'''
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录账号
self.log_in_base.log_in()
self.driver.wait(1)
self.account_center_page_navi_bar.click_account_center_button()
self.account_center_change_page.switch_fast_sale_enable()
self.account_center_change_page.switch_to_fast_sale_frame()
csv_file = self.account_center_page_read_csv.read_csv(
'search_different_account.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
search_account = {"account": row[0]}
# 查找账户
search_result = self.account_center_page_details.subordinate_account_search(
search_account["account"])
if type(search_result) is str:
self.assertIn(
self.assert_text.account_center_page_no_data_text(),
search_result, "搜索结果为暂无数据时，提示不一致")
else:
for subscript in range(len(search_result)):
text = search_result[subscript].split("(")[0]
self.assertIn(search_account["account"], text, "搜索结果不一致")
self.driver.wait()
# 直接选择用户
for user in range(8):
self.account_center_page_details.fast_sales()
self.account_center_page_details.click_list_subordinate_client(
user + 1)
# 验证enter键输入
self.account_center_page_details.fast_sales()
self.account_center_page_details.search_subordinate_client_click_enter(
"1234")
self.driver.wait()
self.driver.default_frame()
csv_file.close()
class TestCase402CustomerManagementLowerUserSearch(unittest.TestCase):
# 测试客户管理 搜索 客户
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.cust_manage_basic_info_and_add_cust_page = CustManageBasicInfoAndAddCustPage(
self.driver, self.base_url)
self.account_center_page_details = AccountCenterDetailsPage(
self.driver, self.base_url)
self.cust_manage_cust_list_page = CustManageCustListPage(
self.driver, self.base_url)
self.cust_manage_my_dev_page = CustManageMyDevPage(
self.driver, self.base_url)
self.cust_manage_lower_account_page = CustManageLowerAccountPage(
self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.cust_manage_page_read_csv = CustManagePageReadCsv()
self.search_sql = SearchSql()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.close_window()
self.driver.quit_browser()
def test_customer_management_lower_user_search(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击账户中心
# self.account_center_page_navi_bar.click_account_center_button()
# current_account = self.log_in_base.get_log_in_account()
# 进入客户管理页面
current_handle = self.driver.get_current_window_handle()
self.cust_manage_basic_info_and_add_cust_page.enter_cust_manage()
self.base_page.change_windows_handle(current_handle)
csv_file = self.cust_manage_page_read_csv.read_csv('acc_search.csv')
csv_data = csv.reader(csv_file)
is_header = True
for row in csv_data:
if is_header:
is_header = False
continue
search_data = {
'account': row[0],
"account_type": row[1],
"info": row[2]
}
print(search_data)
sleep(1)
self.cust_manage_lower_account_page.add_data_to_search_account(
search_data)
connect = self.connect_sql.connect_tuqiang_sql()
# 创建数据库游标
cur = connect.cursor()
# 执行sql脚本查询当前登录账号的userId,fullParent
get_id_sql = "select o.account,o.userId,o.fullParentId from user_info o where o.account = '" + search_data[
'account'] + "' ;"
cur.execute(get_id_sql)
# 读取数据
user_relation = cur.fetchall()
# 遍历数据
for row in user_relation:
user_relation_id = {
"account": row[0],
"userId": row[1],
"fullParent": row[2]
}
# 执行sql脚本，根据当前登录账号的userId,fullParent查询出当前账户的所有下级账户
get_lower_account_sql = "select userId from user_info where fullParentId = " + \
"'" + user_relation_id["fullParent"] + user_relation_id[
"userId"] + ",'" + ";"
cur.execute(get_lower_account_sql)
# 读取数据
lower_account = cur.fetchall()
print(lower_account)
lower_account_list = []
for range1 in lower_account:
for range2 in range1:
lower_account_list.append(range2)
lower_account_tuple = tuple(lower_account_list)
print(lower_account_tuple)
get_total_sql = self.search_sql.search_account_sql(
lower_account_tuple, search_data)
print(get_total_sql)
cur.execute(get_total_sql)
# 读取数据
total_data = cur.fetchall()
# 从数据tuple中获取最终查询记录统计条数
total_list = []
for range1 in total_data:
for range2 in range1:
total_list.append(range2)
total = len(total_list)
print('本次查询数据库的条数为：%s' % total)
web_total = self.cust_manage_lower_account_page.get_account_number(
)
print('本次查询页面的条数是：%s' % web_total)
self.assertEqual(total, web_total)
cur.close()
connect.close()
csv_file.close()
class TestCase410CustomerManagementEditUserWebLoginLimit(unittest.TestCase):
# 测试编辑客户 -- 修改用户web登录权限
def setUp(self):
self.driver = AutomateDriverServer()
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.cust_manage_basic_info_and_add_cust_page = CustManageBasicInfoAndAddCustPage(
self.driver, self.base_url)
self.cust_manage_cust_list_page = CustManageCustListPage(
self.driver, self.base_url)
self.cust_manage_my_dev_page = CustManageMyDevPage(
self.driver, self.base_url)
self.cust_manage_lower_account_page = CustManageLowerAccountPage(
self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.cust_manage_page_read_csv = CustManagePageReadCsv()
self.assert_text2 = AssertText2()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.close_window()
self.driver.quit_browser()
def test_customer_management_edit_user_web_login_limit(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 进入客户管理页面
current_handle = self.driver.get_current_window_handle()
self.cust_manage_basic_info_and_add_cust_page.enter_cust_manage()
self.base_page.change_windows_handle(current_handle)
# 搜索一个客户
self.cust_manage_lower_account_page.input_search_info('abc12344')
# 搜索
self.cust_manage_lower_account_page.click_search_btn()
user_account = self.cust_manage_basic_info_and_add_cust_page.get_user_account_in_customer_page(
)
# 点击编辑 - 取消
self.cust_manage_basic_info_and_add_cust_page.click_edit_account_buttons(
)
# 点击取消
self.cust_manage_basic_info_and_add_cust_page.click_cancel_edit()
# 点击编辑
self.cust_manage_basic_info_and_add_cust_page.click_edit_account_buttons(
)
# 获取web登录权限的
self.cust_manage_basic_info_and_add_cust_page.locate_to_iframe()
web_login_status = self.cust_manage_basic_info_and_add_cust_page.get_web_login_status(
)
self.driver.default_frame()
if web_login_status == True:
# 点击
self.cust_manage_basic_info_and_add_cust_page.locate_to_iframe()
self.cust_manage_basic_info_and_add_cust_page.click_web_login_status_ins(
)
self.driver.default_frame()
# 确定
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
# 退出登录
self.account_center_page_navi_bar.usr_logout()
# 登录刚刚的账号
self.log_in_base.log_in_with_csv(user_account, 'jimi123')
self.assertEqual(self.assert_text2.login_no_permissions(),
self.login_page.get_exception_text())
# 登录
self.log_in_base.log_in()
current_handle_01 = self.driver.get_current_window_handle()
self.cust_manage_basic_info_and_add_cust_page.enter_cust_manage()
self.base_page.change_windows_handle(current_handle_01)
# 搜索一个客户
self.cust_manage_lower_account_page.input_search_info('abc12344')
# 搜索
self.cust_manage_lower_account_page.click_search_btn()
# 点击编辑 - 取消
self.cust_manage_basic_info_and_add_cust_page.click_edit_account_buttons(
)
# 点击取消
self.cust_manage_basic_info_and_add_cust_page.click_cancel_edit()
# 点击编辑
self.cust_manage_basic_info_and_add_cust_page.click_edit_account_buttons(
)
# 点击
self.cust_manage_basic_info_and_add_cust_page.locate_to_iframe()
self.cust_manage_basic_info_and_add_cust_page.click_web_login_status_ins(
)
self.driver.default_frame()
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
# 退出登录
self.account_center_page_navi_bar.usr_logout()
# 登录刚刚的账号
self.log_in_base.log_in_with_csv(user_account, 'jimi123')
hello_usr = self.account_center_page_navi_bar.usr_info_account()
self.assertIn(user_account, hello_usr)
elif web_login_status == False:
# 点击
self.cust_manage_basic_info_and_add_cust_page.locate_to_iframe()
self.cust_manage_basic_info_and_add_cust_page.click_web_login_status_ins(
)
self.driver.default_frame()
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
# 退出登录
self.account_center_page_navi_bar.usr_logout()
# 登录刚刚的账号
self.log_in_base.log_in_with_csv(user_account, 'jimi123')
hello_usr = self.account_center_page_navi_bar.usr_info_account()
self.assertIn(user_account, hello_usr)
# 退出登录
self.account_center_page_navi_bar.usr_logout()
self.log_in_base.log_in()
current_handle_02 = self.driver.get_current_window_handle()
self.cust_manage_basic_info_and_add_cust_page.enter_cust_manage()
self.base_page.change_windows_handle(current_handle_02)
# 搜索一个客户
self.cust_manage_lower_account_page.input_search_info('abc12344')
# 搜索
self.cust_manage_lower_account_page.click_search_btn()
# 点击编辑 - 取消
self.cust_manage_basic_info_and_add_cust_page.click_edit_account_buttons(
)
# 点击取消
self.cust_manage_basic_info_and_add_cust_page.click_cancel_edit()
# 点击编辑
self.cust_manage_basic_info_and_add_cust_page.click_edit_account_buttons(
)
# 点击
self.cust_manage_basic_info_and_add_cust_page.locate_to_iframe()
self.cust_manage_basic_info_and_add_cust_page.click_web_login_status_ins(
)
self.driver.default_frame()
# 确定
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
# 退出登录
self.account_center_page_navi_bar.usr_logout()
# 登录刚刚的账号
self.log_in_base.log_in_with_csv(user_account, 'jimi123')
self.assertEqual(self.assert_text2.login_no_permissions(),
self.login_page.get_exception_text())
self.log_in_base.log_in()
current_handle_03 = self.driver.get_current_window_handle()
self.cust_manage_basic_info_and_add_cust_page.enter_cust_manage()
self.base_page.change_windows_handle(current_handle_03)
# 搜索一个客户
self.cust_manage_lower_account_page.input_search_info('abc12344')
# 搜索
self.cust_manage_lower_account_page.click_search_btn()
# 点击编辑 - 取消
self.cust_manage_basic_info_and_add_cust_page.click_edit_account_buttons(
)
# 点击取消
self.cust_manage_basic_info_and_add_cust_page.click_cancel_edit()
# 点击编辑
self.cust_manage_basic_info_and_add_cust_page.click_edit_account_buttons(
)
# 点击
self.cust_manage_basic_info_and_add_cust_page.locate_to_iframe()
self.cust_manage_basic_info_and_add_cust_page.click_web_login_status_ins(
)
self.driver.default_frame()
# 确定
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
class TestCase19AccountCenterOverviewAlarm(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.account_center_page_details = AccountCenterDetailsPage(
self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.assert_text = AssertText()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_account_center_overview_set_up_landmark(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录账号
self.log_in_base.log_in()
self.account_center_page_navi_bar.click_account_center_button()
sleep(2)
account_center_handle = self.driver.get_current_window_handle()
# 点击告警
self.account_center_page_details.account_center_iframe()
self.account_center_page_details.account_overview('告警')
self.driver.default_frame()
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != account_center_handle:
self.driver.switch_to_window(handle)
sleep(2)
expect_url = self.driver.get_current_url()
actual_url = self.base_url + '/deviceReport/statisticalReport?modularId=alarmDdetails'
self.assertEqual(expect_url, actual_url,
'点击告警后，实际的url和期望的不一样！')
sleep(2)
actual_text = self.account_center_page_details.get_actual_text_after_click_alarms(
)
self.assertEqual(
self.assert_text.account_center_page_alarm_details_text(),
actual_text, '点击告警后，页面没有跳转到告警总览页面上')
# 查看控制台告警设置能否打开
self.account_center_page_navi_bar.click_alarm_button_in_console(
)
# 断言
get_text = self.account_center_page_navi_bar.get_text_after_click_alarm_button(
)
self.assertEqual(
self.assert_text.account_center_page_alarm_manager_text(),
get_text)
self.account_center_page_navi_bar.close_alarm_in_console()
self.driver.close_current_page()
# 回到账户中心窗口
self.driver.switch_to_window(account_center_handle)
self.driver.wait()
class TestCase69CustManageAllSelect(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.cust_manage_basic_info_and_add_cust_page = CustManageBasicInfoAndAddCustPage(self.driver, self.base_url)
self.cust_manage_cust_list_page = CustManageCustListPage(self.driver, self.base_url)
self.cust_manage_my_dev_page = CustManageMyDevPage(self.driver, self.base_url)
self.cust_manage_lower_account_page = CustManageLowerAccountPage(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.cust_manage_page_read_csv = CustManagePageReadCsv()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_cust_manage_all_select(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 进入客户管理页面
self.cust_manage_basic_info_and_add_cust_page.enter_cust_manage()
sleep(2)
# 点击全选
self.cust_manage_basic_info_and_add_cust_page.click_all_select_button()
input_all_select = self.cust_manage_basic_info_and_add_cust_page.get_all_select_value()
self.assertEqual(True, input_all_select)
# 验证下面的是否被全选
# 获取本页列表的数量
list_number = self.cust_manage_basic_info_and_add_cust_page.get_per_account_number()
for n in range(list_number):
list_input_value = self.driver.get_element(
'x,//*[@id="customerlist"]/tr[%s]/td[1]/span/div/input' % str(n + 1)).is_selected()
self.assertEqual(True, list_input_value)
# 取消全选
self.cust_manage_basic_info_and_add_cust_page.click_all_select_button()
input_all_select = self.cust_manage_basic_info_and_add_cust_page.get_all_select_value()
self.assertEqual(False, input_all_select)
for n in range(list_number):
list_input_value = self.driver.get_element(
'x,//*[@id="customerlist"]/tr[%s]/td[1]/span/div/input' % str(n + 1)).is_selected()
self.assertEqual(False, list_input_value)
# 全选后取消选择其中一个
self.cust_manage_basic_info_and_add_cust_page.click_all_select_button()
self.cust_manage_basic_info_and_add_cust_page.click_cancel_select_list()
# 判断全选是否为真
self.assertEqual(False, self.cust_manage_basic_info_and_add_cust_page.get_all_select_value())
# 在一次选择上列表中的那个
self.cust_manage_basic_info_and_add_cust_page.click_cancel_select_list()
# 判断全选是否为真
self.assertEqual(True, self.cust_manage_basic_info_and_add_cust_page.get_all_select_value())
# 在选择每页显示30条
self.cust_manage_basic_info_and_add_cust_page.select_per_page_numbers()
self.assertEqual(False, self.cust_manage_basic_info_and_add_cust_page.get_all_select_value())
class TestCase131MarkOperation(unittest.TestCase):
""" web_autotest账号，标注点页面操作 """
# author：邓肖斌
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.safe_area_page = SafeAreaPage(self.driver, self.base_url)
self.base_page.open_page()
self.base_page.click_chinese_button()
self.driver.set_window_max()
self.log_in_base.log_in()
self.safe_area_page.click_control_after_click_safe_area()
self.safe_area_page_read_csv = SafeAreaPageReadCsv()
self.assert_text = AssertText()
self.connect_sql = ConnectSql()
self.search_sql = SafeAreaSearchSql()
def tearDown(self):
self.driver.quit_browser()
def test_case_mark_operation(self):
# 断言url
expect_url = self.base_url + "/safearea/geozonemap?flag=0"
self.assertEqual(expect_url, self.driver.get_current_url())
self.safe_area_page.click_mark_button()
sleep(2)
# 全选
self.safe_area_page.click_all_select_button_with_mark()
# 点击删除
self.safe_area_page.click_detele_button_with_mark()
# 点击取消
self.safe_area_page.click_cancel_detele_button()
# 点击删除
self.safe_area_page.click_detele_button_with_mark()
# 点击关闭
self.safe_area_page.click_close_detele_button()
# 点击新建按钮
self.safe_area_page.click_create_mark_point()
text = self.safe_area_page.get_text_after_create_map()
self.assertEqual(self.assert_text.safe_area_page_map_text(), text)
# 获取第一个地标的名称
mark_name = self.safe_area_page.get_first_mark_name_text()
# 点击列表的编辑
self.safe_area_page.click_edit_button_in_list()
# 点击保存
self.safe_area_page.click_ensure_edit_in_list('名称1', '描述1')
# 获取保存之后的地标名称
mark_name_after_save = self.safe_area_page.get_first_mark_name_text()
# 断言1：网页上名称的变化
self.assertNotEqual(mark_name, mark_name_after_save)
# 断言2：用修改之前的名称在数据库搜索
# 创建数据库连接
connect = self.connect_sql.connect_tuqiang_sql()
# 创建游标
cursor = connect.cursor()
get_total_count_sql = self.search_sql.search_sql_in_test_case_131(
'%s') % mark_name
print(get_total_count_sql)
cursor.execute(get_total_count_sql)
current_total = cursor.fetchall()
total_list1 = []
for range1 in current_total:
for range2 in range1:
total_list1.append(range2)
total = len(total_list1)
self.assertEqual(0, total)
# 断言3：用修改之后的名称在数据库搜索
get_total_count_sql = self.search_sql.search_sql_in_test_case_131(
'%s') % mark_name_after_save
print(get_total_count_sql)
cursor.execute(get_total_count_sql)
current_total = cursor.fetchall()
total_list2 = []
for range1 in current_total:
for range2 in range1:
total_list2.append(range2)
total = len(total_list2)
self.assertEqual(1, total)
self.assertEqual('描述1', total_list2[0])
# 点击列表的编辑
self.safe_area_page.click_edit_button_in_list()
# 点击保存
self.safe_area_page.click_ensure_edit_in_list('名称', '描述')
# 点击列表的编辑
self.safe_area_page.click_edit_button_in_list()
# 点击取消
self.safe_area_page.click_cancel_edit_in_list()
# 点击列表中的删除
self.safe_area_page.click_delete_button_in_list()
self.safe_area_page.click_cancel_detele_button()
# 点击关闭
self.safe_area_page.click_delete_button_in_list()
self.safe_area_page.click_close_detele_button()
class TestCase67CustManageCustTransferCustSearch(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.cust_manage_basic_info_and_add_cust_page = CustManageBasicInfoAndAddCustPage(
self.driver, self.base_url)
self.cust_manage_cust_list_page = CustManageCustListPage(
self.driver, self.base_url)
self.cust_manage_my_dev_page = CustManageMyDevPage(
self.driver, self.base_url)
self.cust_manage_lower_account_page = CustManageLowerAccountPage(
self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBaseServer(self.driver, self.base_url)
self.cust_manage_page_read_csv = CustManagePageReadCsv()
self.connect_sql = ConnectSql()
self.assert_text = AssertText()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_cust_manage_transfer_cust_search(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 进入客户管理页面
self.cust_manage_basic_info_and_add_cust_page.enter_cust_manage()
sleep(2)
# 点击编辑用户
self.cust_manage_basic_info_and_add_cust_page.click_transfer_customer()
self.cust_manage_basic_info_and_add_cust_page.click_cancel_edit()
self.cust_manage_basic_info_and_add_cust_page.click_transfer_customer()
# 循环点击五次
for n in range(5):
self.cust_manage_basic_info_and_add_cust_page.locate_to_iframe()
self.driver.click_element('x,//*[@id="treeDemo2_%s_span"]' %
str(n + 3))
sleep(2)
self.driver.default_frame()
# 搜索
# 1 搜索无数据的内容
"""
self.cust_manage_basic_info_and_add_cust_page.search_cust('无数据')
get_text = self.cust_manage_basic_info_and_add_cust_page.get_search_no_data_text()
self.assertIn(self.assert_text.account_center_page_no_data_text(), get_text)
"""
# 2搜索
seatch_data = ["无", "test", "yonghu222啦啦啦", "休息休息12", "#@@@ %"]
for user in range(len(seatch_data)):
search_result = self.cust_manage_basic_info_and_add_cust_page.transfer_import_account_search(
seatch_data[user])
if type(search_result) is str:
self.assertIn(
self.assert_text.account_center_page_no_data_text(),
search_result, "搜索结果为暂无数据时，提示不一致")
else:
for subscript in range(len(search_result)):
text = search_result[subscript].split("(")[0]
self.assertIn(seatch_data[user], text, "搜索结果不一致")
class TestCase09AccountCenterVisuEditAndDel(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer()
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.account_center_page_visual_account = AccountCenterVisualAccountPage(
self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.account_center_page_read_csv = AccountCenterPageReadCsv()
self.log_in_base = LogInBaseServer(self.driver, self.base_page)
self.assert_text = AssertText()
self.driver.set_window_max()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_account_center_visu_edit_and_del(self):
'''通过csv测试虚拟账户管理-编辑、删除功能'''
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
self.account_center_page_navi_bar.click_account_center_button()
# 进入虚拟账户管理
self.account_center_page_visual_account.enter_visual_account()
csv_file = self.account_center_page_read_csv.read_csv(
'add_visual_account.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
acc_to_add = {"account": row[0], "passwd": row[1]}
# 添加虚拟账户
self.account_center_page_visual_account.add_visual_account(
acc_to_add["account"], acc_to_add["passwd"])
# 取消添加
self.account_center_page_visual_account.dis_save_add_info()
self.driver.wait()
# 编辑列表中的虚拟账户
self.account_center_page_visual_account.edit_visu_account(
acc_to_add["passwd"])
# 验证是否保存成功
save_status = self.account_center_page_visual_account.get_save_status(
)
self.assertIn(
self.assert_text.account_center_page_operation_done(),
save_status, "保存成功")
self.account_center_page_visual_account.dis_edit()
self.driver.wait(1)
# 删除列表中的虚拟账户
self.account_center_page_visual_account.del_visu_account()
# 验证是否操作成功
save_status = self.account_center_page_visual_account.get_save_status(
)
self.assertIn(
self.assert_text.account_center_page_operation_done(),
save_status, "操作成功")
self.driver.wait()
csv_file.close()
class TestCase07AccountCenterMsgSearch(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriverServer(choose='chrome')
self.base_url = self.driver.base_url
self.base_page = BasePageServer(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.account_center_page_operation_log = AccountCenterOperationLogPage(
self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPage(
self.driver, self.base_url)
self.account_center_page_msg_center = AccountCenterMsgCenterPage(
self.driver, self.base_url)
self.assert_text = AssertText()
self.driver.set_window_max()
self.account_center_page_read_csv = AccountCenterPageReadCsv()
self.connect_sql = ConnectSql()
self.search_sql = SearchSql()
self.log_in_base = LogInBaseServer(self.driver, self.base_page)
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_account_center_msg_search(self):
self.base_page.open_page()
self.log_in_base.log_in()
self.account_center_page_navi_bar.click_account_center_button()
# self.driver.switch_to_frame('x,//*[@id="usercenterFrame"]')
# 获取登录账号的用户名
current_account = self.log_in_base.get_log_in_account()
#self.driver.default_frame()
# 进入消息中心
self.account_center_page_msg_center.enter_msg_center()
self.driver.wait(10)
# 进入iframe
# self.account_center_page_msg_center.message_center_iframe()
# 获取消息中心title
msg_center_title = self.account_center_page_msg_center.get_msg_center_title(
)
# 验证消息中心title是否正确显示
self.assertIn(
self.assert_text.account_center_page_message_center_text(),
msg_center_title, "消息中心title有误!")
csv_file = self.account_center_page_read_csv.read_csv(
'search_massage_data.csv')
csv_data = csv.reader(csv_file)
is_header = True
for row in csv_data:
if is_header:
is_header = False
continue
search_data = {'imei': row[0], 'type': row[1], 'status': row[2]}
# 搜索
self.account_center_page_operation_log.add_data_to_search_massages(
search_data)
connect1 = self.connect_sql.connect_tuqiang_sql()
# 创建数据库游标
cur = connect1.cursor()
# 执行sql脚本查询当前登录账号的userId,fullParent
get_id_sql = "select o.account,o.userId,o.fullParentId from user_info o where o.account = '" + current_account + "';"
cur.execute(get_id_sql)
# 读取数据
user_relation = cur.fetchall()
# 遍历数据
for row in user_relation:
user_relation_id = {
"account": row[0],
"userId": row[1],
"fullParent": row[2]
}
# 执行sql脚本，根据当前登录账号的userId,fullParent查询出当前账户的所有下级账户
get_lower_account_sql = "select userId from user_info where fullParentId like" + \
"'" + user_relation_id["fullParent"] + user_relation_id["userId"] + "%'" + ";"
cur.execute(get_lower_account_sql)
# 读取数据
lower_account = cur.fetchall()
lower_account_list = [user_relation_id["userId"]]
for range1 in lower_account:
for range2 in range1:
lower_account_list.append(range2)
self.lower_account_tuple = tuple(lower_account_list)
cur.close()
connect1.close()
connect = self.connect_sql.connect_tuqiang_sql()
# 创建数据库游标
cur = connect.cursor()
get_total_sql = self.search_sql.search_massage_sql(
self.lower_account_tuple, search_data)
print(get_total_sql)
cur.execute(get_total_sql)
# 读取数据
total_data = cur.fetchall()
# 从数据tuple中获取最终查询记录统计条数
total_list = []
for range1 in total_data:
for range2 in range1:
total_list.append(range2)
total = len(total_list)
print('本次查询数据库的条数为：%s' % total)
web_total = self.account_center_page_operation_log.get_msg_number()
print('本次查询页面的条数是：%s' % web_total)
self.assertEqual(total, web_total)
cur.close()
connect.close()
csv_file.close()
