def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
class TestCase98DevManagePagingFunction(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_dev_manager_paging_function(self):
'''测试设备管理-设备搜索-by imei'''
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in_jimitest()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 全部设备_分页默认显示每页20条
# get_paging_text = self.dev_manage_page.get_paging_text()
# self.assertEqual(self.assert_text.per_20_page(), get_paging_text)
# 获取总共有多少页
total_page_number = self.dev_manage_page.get_total_page_number_in_dev_manager()
if total_page_number == 1:
get_up_page_state = self.dev_manage_page.get_up_page_state()
self.assertEqual('active', get_up_page_state)
get_next_page_state = self.dev_manage_page.get_next_page_state()
self.assertEqual('active', get_next_page_state)
elif total_page_number == 0:
text = self.dev_manage_page.get_search_no_dev_name_text()
self.assertIn(self.assert_text.account_center_page_no_data_text(), text)
else:
for n in range(total_page_number):
self.dev_manage_page.click_per_page(n + 1)
if total_page_number != 0:
self.dev_manage_page.click_per_number()
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPages(
self.driver, self.base_url)
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.connect_sql = ConnectSql()
self.search_sql = SearchSql()
self.driver.set_window_max()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.assert_text = AssertText()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
class TestCase84DevManageBatchIssuedCommand(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.assert_text = AssertText()
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_case_dev_manage_batch_issued_command(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 点击批量
self.dev_manage_page.click_batch_issued_command_button()
self.dev_manage_page.click_close_batch_batch_issued_command_button()
self.dev_manage_page.click_batch_issued_command_button()
# 获取选中的设备数量
'''dev_number = self.dev_manage_page.get_dev_number_after_click_issued_command()
dev_number_count = self.dev_manage_page.get_count_number_after_click_issued_command()
self.assertEqual(str(dev_number), dev_number_count)'''
# 获取提示语
text = self.dev_manage_page.get_text_after_click_all_issued_command()
self.assertEqual(self.assert_text.dev_type_is_different(), text)
class TestCase93DevManageUnbundleDev(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_case_dev_manage_unbundle_dev(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in_jimitest()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 搜索绑定的设备
self.dev_manage_page.search_bundle_dev()
# 获取第一个设备的imei
imei_in_list = self.dev_manage_page.get_imei_in_list()
# 点击解绑
self.dev_manage_page.click_unbundle_dev()
imei_in_list_again = self.dev_manage_page.get_imei_in_list()
self.assertNotEqual(imei_in_list, imei_in_list_again, '解绑失败')
class TestCase80DevManageSearchCustomer(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_case_dev_manage_search_customer(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 循环点击5次
for n in range(5):
self.driver.click_element(
'x,//*[@id="treeDemo_deviceManage_%s_span"]' % str(n + 2))
sleep(2)
# 判断数量
get_account_dev_number = self.driver.get_text(
'x,//*[@id="treeDemo_deviceManage_%s_span"]' % str(n + 2))
number = get_account_dev_number.split('(')[1].split('/')[0]
dev_number = self.dev_manage_page.get_dev_number()
self.assertEqual(number, str(dev_number))
# 搜索无数据
self.dev_manage_page.search_customer('无数据')
get_text = self.dev_manage_page.get_search_customer_no_data_text()
self.assertIn(self.assert_text.account_center_page_no_data_text(),
get_text)
class TestCase96DevManageCheckAccountInfo(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_case_dev_manage_check_account_info(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 循环点击
for n in range(5):
self.dev_manage_page.click_per_account_in_dev_manage_page(n)
# 获取点击后的用户账号
user_account = self.dev_manage_page.get_per_user_account_in_dev_manage_page(
)
# 连接数据库，获取该账号的信息
get_account_info = self.dev_manage_page.get_account_info(
user_account)
# 断言用户信息
get_user_nickname_in_page = self.dev_manage_page.get_user_nickname_in_page(
)
get_user_type_in_page = self.dev_manage_page.get_user_type_in_page(
)
get_user_phone_in_page = self.dev_manage_page.get_user_phone_in_page(
)
self.assertEqual(get_account_info['nickname'],
get_user_nickname_in_page)
if get_account_info['phone'] == None:
self.assertEqual('', get_user_phone_in_page)
else:
self.assertEqual(get_account_info['phone'],
get_user_phone_in_page)
type = self.assert_text.log_in_page_account_type(
get_account_info['type'])
self.assertEqual(get_user_type_in_page, type)
get_account_nickname_in_cust_tree = self.dev_manage_page.get_account_nickname_in_cust_tree(
n)
self.assertEqual(get_user_nickname_in_page,
get_account_nickname_in_cust_tree)
# 点击监控用户
current_handle = self.driver.get_current_window_handle()
self.dev_manage_page.click_control_account_button()
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != current_handle:
self.driver.switch_to_window(handle)
expect_url = self.driver.base_url + '/index'
self.assertEqual(self.driver.get_current_url(), expect_url)
self.driver.close_current_page()
self.driver.switch_to_window(current_handle)
# 点击编辑用户
edit_style = self.dev_manage_page.get_edit_style_in_dev_page()
if edit_style == 'display: inline;':
self.dev_manage_page.click_edit_account_button()
self.dev_manage_page.click_close_edit_button()
self.dev_manage_page.click_edit_account_button()
self.dev_manage_page.switch_to_dev_edit_frame()
# 验证打开的信息是否正确
# 分别获取上级客户、客户类型、客户名称、登录账号、电话
up_user = self.dev_manage_page.get_up_user_edit_user_in_dev_page(
)
user_type = self.dev_manage_page.get_user_type_edit_user_in_dev_page(
)
user_name = self.dev_manage_page.get_user_name_edit_user_in_dev_page(
)
account = self.dev_manage_page.get_user_account_edit_in_dev_page(
)
user_phone = self.dev_manage_page.get_user_phone_edit_in_dev_page(
)
# 断言
self.assertEqual(type, user_type)
self.assertEqual(user_name, get_user_nickname_in_page)
self.assertEqual(account, user_account)
if get_account_info['phone'] == None:
self.assertEqual(user_phone, '')
else:
# self.assertEqual(user_phone, get_account_info['phone'])
pass
self.driver.default_frame()
self.dev_manage_page.click_close_edit_button()
class TestCase87DevManageEditDev(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_case_dev_manage_edit_dev(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
imei_in_list = self.dev_manage_page.get_imei_in_list()
active_time_in_list = self.dev_manage_page.get_active_time_in_list()
expire_time_in_list = self.dev_manage_page.get_expire_time_in_list()
dev_type_in_list = self.dev_manage_page.get_dev_type_in_list()
dev_name_in_list = self.dev_manage_page.get_dev_name_in_list()
dev_sim_in_list = self.dev_manage_page.get_dev_sim_in_list()
dev_group_in_list = self.dev_manage_page.get_dev_group_in_list()
# 点击批量
self.dev_manage_page.click_edit_button()
self.dev_manage_page.click_close_edit_button()
self.dev_manage_page.click_edit_button()
# 判断打开的编辑信息是否正确
imei_in_detail = self.dev_manage_page.get_imei_in_detail()
self.assertEqual(imei_in_list, imei_in_detail)
active_time_in_detail = self.dev_manage_page.get_active_time_in_detail(
)
self.assertEqual(active_time_in_list, active_time_in_detail)
expire_time_in_detail = self.dev_manage_page.get_expire_time_in_detail(
)
self.assertIn(expire_time_in_detail, expire_time_in_list)
dev_type_in_detail = self.dev_manage_page.get_dev_type_in_detail()
self.assertEqual(dev_type_in_list, dev_type_in_detail)
dev_name_in_detail = self.dev_manage_page.get_dev_name_in_detail()
self.assertEqual(dev_name_in_list, dev_name_in_detail)
dev_sim_in_detail = self.dev_manage_page.get_dev_sim_in_detail()
self.assertEqual(dev_sim_in_list, dev_sim_in_detail)
dev_group_in_detail = self.dev_manage_page.get_dev_group_in_detail()
self.assertEqual(dev_group_in_list, dev_group_in_detail)
# 判断 设备imei、设备类型、激活时间、平台到期时间、iccid、imsi是不可以编辑的
imei_input = self.dev_manage_page.get_imei_input_value()
self.assertEqual('true', imei_input)
dev_type_input = self.dev_manage_page.get_dev_type_input_value()
self.assertEqual('true', dev_type_input)
active_time_input = self.dev_manage_page.get_active_time_input_value()
self.assertEqual('true', active_time_input)
expire_time_value = self.dev_manage_page.get_expire_time_value()
self.assertEqual('true', expire_time_value)
iccid_value = self.dev_manage_page.get_iccid_value()
self.assertEqual('true', iccid_value)
imsi_value = self.dev_manage_page.get_imsi_value()
self.assertEqual('true', imsi_value)
# 验证输入框的最大长度
dev_name_max_len = self.dev_manage_page.get_dev_name_max_len()
self.assertEqual('50', dev_name_max_len)
dev_sim_max_len = self.dev_manage_page.get_dev_sim_max_len()
self.assertEqual('20', dev_sim_max_len)
dev_remark_max_len = self.dev_manage_page.get_dev_remark_max_len()
self.assertEqual('500', dev_remark_max_len)
# 点击客户信息
self.dev_manage_page.click_cust_info_button()
# 验证输入框的最大长度
driver_name_max_len = self.dev_manage_page.get_driver_name_max_len()
self.assertEqual('20', driver_name_max_len)
driver_phone_max_len = self.dev_manage_page.click_driver_phone_max_len(
)
self.assertEqual('20', driver_phone_max_len)
driver_vehicle_number_max_len = self.dev_manage_page.driver_vehicle_number_max_len(
)
self.assertEqual('50', driver_vehicle_number_max_len)
driver_sn_max_len = self.dev_manage_page.get_driver_sn_max_len()
self.assertEqual('50', driver_sn_max_len)
driver_car_frame_max_len = self.dev_manage_page.driver_car_frame_max_len(
)
self.assertEqual('50', driver_car_frame_max_len)
driver_engine_number_max_len = self.dev_manage_page.get_driver_engine_number_max_len(
)
self.assertEqual('100', driver_engine_number_max_len)
dev_install_address_max_len = self.dev_manage_page.get_dev_install_address_max_len(
)
self.assertEqual('200', dev_install_address_max_len)
dev_install_company_max_len = self.dev_manage_page.get_dev_install_company_max_len(
)
self.assertEqual('100', dev_install_company_max_len)
dev_install_position_max_len = self.dev_manage_page.get_dev_install_position_max_len(
)
self.assertEqual('200', dev_install_position_max_len)
dev_install_personnel_max_len = self.dev_manage_page.get_dev_install_personnel_max_len(
)
self.assertEqual('50', dev_install_personnel_max_len)
dev_color_max_len = self.dev_manage_page.get_color_max_len()
self.assertEqual('50', dev_color_max_len)
class TestCase85DevManageSelectSetUpWorkCommand(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.assert_text = AssertText()
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_case_dev_manage_select_set_up_work_command(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
imei_in_list = self.dev_manage_page.get_imei_in_list()
dev_type_in_list = self.dev_manage_page.get_dev_type_in_list()
self.dev_manage_page.click_dev_in_list()
# 判断是否选中
input_value = self.dev_manage_page.check_input_value()
self.assertEqual(True, input_value)
# 点击选中设置工作模式
# self.dev_manage_page.click_select_set_up_work_command()
# 点击关闭设置工作模式
#self.dev_manage_page.click_close_set_up_work_command()
# 点击选中设置工作模式
# self.dev_manage_page.click_select_set_up_work_command()
# 点击关闭设置工作模式
# self.dev_manage_page.click_cancel_set_up_work_command()
# 点击选中设置工作模式
self.dev_manage_page.click_select_set_up_work_command()
try:
# 判断数量
get_dev_number = self.dev_manage_page.get_dev_number_in_work_command(
)
self.assertEqual(1, get_dev_number)
get_dev_count = self.dev_manage_page.get_dev_count_number_in_work_command(
)
self.assertEqual(str(get_dev_number), get_dev_count)
# 判断 下发工作模式中
get_imei = self.dev_manage_page.get_imei_in_set_up_work_command()
self.assertEqual(imei_in_list, get_imei)
get_dev_type = self.dev_manage_page.get_dev_type_in_work_command()
self.assertEqual(dev_type_in_list, get_dev_type)
get_dev_user = self.dev_manage_page.get_dev_user_in_work_command()
connect = self.connect_sql.connect_tuqiang_sql()
cursor = connect.cursor()
get_account_sql = "select o.account from equipment_mostly e inner join user_info o on e.userId = o.userId where e.imei = '%s';" % imei_in_list
cursor.execute(get_account_sql)
account_data = cursor.fetchall()
account = account_data[0][0]
cursor.close()
connect.close()
self.assertEqual(get_dev_user, account)
# 点击删除
self.dev_manage_page.delete_dev()
# 点击发送指令
self.dev_manage_page.click_issued_command_button()
except:
text = self.dev_manage_page.get_text_after_click_issued_work_template(
)
self.assertEqual(self.assert_text.no_dev_to_issued_command(), text)
class TestCase97DevManageEditAccount(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_case_dev_manage_edit_account(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 点击下级用户
self.dev_manage_page.click_next_user_in_dev_page()
# 点击编辑用户
self.dev_manage_page.click_edit_account_button()
self.dev_manage_page.click_close_edit_button()
self.dev_manage_page.click_edit_account_button()
self.dev_manage_page.switch_to_dev_edit_frame()
# 搜索用户
self.dev_manage_page.search_account_in_edit_user()
get_user_name_after_search = self.dev_manage_page.get_user_name_after_search_in_edit_user(
)
up_user = self.dev_manage_page.get_up_user_edit_user_in_dev_page()
self.assertIn(up_user, get_user_name_after_search)
# 循环点击
for n in range(5):
self.dev_manage_page.click_user_to_search_up_user_in_edit_user(n)
up_user = self.dev_manage_page.get_up_user_edit_user_in_dev_page()
get_user_name_after_search = self.dev_manage_page.get_user_name_after_search_in_edit_user(
)
self.assertIn(up_user, get_user_name_after_search)
self.driver.default_frame()
class TestCase86DevManageAllSetUpWorkCommand(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.assert_text = AssertText()
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_case_dev_manage_all_set_up_work_command(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 点击本次查询全部设置工作模式
# self.dev_manage_page.click_all_set_up_work_command()
# 点击关闭
# self.dev_manage_page.click_close_all_set_up_work_command()
# 点击本次查询全部设置工作模式
# self.dev_manage_page.click_all_set_up_work_command()
# 点击取消
# self.dev_manage_page.click_cancel_all_set_up_work_command()
# 点击本次查询全部设置工作模式
self.dev_manage_page.click_all_set_up_work_command()
try:
# 检查数量
get_list_number = self.dev_manage_page.get_list_number()
get_count_number = self.dev_manage_page.get_count_number()
self.assertEqual(str(get_list_number), get_count_number)
# 循环点击删除
for n in range(get_list_number):
self.dev_manage_page.delete_dev()
# 点击发送指令
self.dev_manage_page.click_issued_command_button()
except:
# 获取提示语
text = self.dev_manage_page.get_text_after_click_all_issued_command(
)
self.assertEqual(self.assert_text.dev_type_is_different(), text)
class TestCase101DevManageBatchSetOverdueTime(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_dev_manage_search_dev_after_issued_work_type(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in_jimitest()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
imei_in_list = self.dev_manage_page.get_imei_in_list()
# 点击批量设置用户到期时间
self.dev_manage_page.click_batch_set_user_overdue_time_button()
# 点击关闭
self.dev_manage_page.click_close_set_user_overdue_time_button()
# 点击批量设置用户到期时间
self.dev_manage_page.click_batch_set_user_overdue_time_button()
# 点击关闭
self.dev_manage_page.click_clance_set_user_overdue_time_button()
# 点击批量设置用户到期时间
self.dev_manage_page.click_batch_set_user_overdue_time_button()
# 验证界面
text = self.dev_manage_page.get_text_after_click_set_user_overdue_time_button()
self.assertEqual(self.assert_text.batch_set_user_overdue_time_text(), text)
# 点击添加imei
self.dev_manage_page.click_add_imei_to_set_user_overdue_time('不存在')
# 获取失败的状态和原因
fail_status = self.dev_manage_page.get_fail_status_after_clcik_ensure()
self.assertEqual(self.assert_text.dev_page_fail_text(), fail_status)
fail_reason = self.dev_manage_page.get_fail_reason_after_click_ensure()
self.assertEqual(self.assert_text.dev_page_inexistence_text(), fail_reason)
# 点击关闭
self.dev_manage_page.click_close_fails()
# 点击添加imei
self.dev_manage_page.click_add_imei_to_set_user_overdue_time(imei_in_list)
self.dev_manage_page.click_add_imei_to_set_user_overdue_time(imei_in_list)
# 获取失败的状态和原因
fail_status = self.dev_manage_page.get_fail_status_after_clcik_ensure()
self.assertEqual(self.assert_text.dev_page_fail_text(), fail_status)
fail_reason = self.dev_manage_page.get_fail_reason_after_click_ensure()
self.assertEqual(self.assert_text.dev_page_repetition_text(), fail_reason)
# 点击关闭
self.dev_manage_page.click_close_fails()
class TestCase83DevManageSelectIssuedCommand(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_case_dev_manage_select_issued_command(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
imei_in_list = self.dev_manage_page.get_imei_in_list()
dev_type_in_list = self.dev_manage_page.get_dev_type_in_list()
# 选中一个列表中的设备
self.dev_manage_page.click_dev_in_list()
# 判断是否选中
input_value = self.dev_manage_page.check_input_value()
self.assertEqual(True, input_value)
# 点击选中发送指令
self.dev_manage_page.click_select_send_command()
# 点击关闭
self.dev_manage_page.click_close_select_send_command()
# 点击选中发送指令
self.dev_manage_page.click_select_send_command()
# 点击取消
self.dev_manage_page.click_cancel_select_send_command()
# 点击选中发送指令
self.dev_manage_page.click_select_send_command()
# 判断数量
get_dev_number = self.dev_manage_page.get_dev_number_in_send_command()
self.assertEqual(1, get_dev_number)
get_dev_count = self.dev_manage_page.get_dev_count_number_in_send_command(
)
self.assertEqual(str(get_dev_number), get_dev_count)
# 验证设备信息
get_imei = self.dev_manage_page.get_imei_in_send_command()
self.assertEqual(imei_in_list, get_imei)
get_dev_type = self.dev_manage_page.get_dev_type_in_send_command()
self.assertEqual(dev_type_in_list, get_dev_type)
get_dev_user = self.dev_manage_page.get_dev_user_in_send_command()
connect = self.connect_sql.connect_tuqiang_sql()
cursor = connect.cursor()
get_account_sql = "select o.account from equipment_mostly e inner join user_info o on e.userId = o.userId where e.imei = '%s';" % imei_in_list
cursor.execute(get_account_sql)
account_data = cursor.fetchall()
account = account_data[0][0]
cursor.close()
connect.close()
self.assertEqual(get_dev_user, account)
# 点击删除设备
self.dev_manage_page.click_detele_dev_in_send_command()
self.dev_manage_page.click_send_command_in_send_command()
class TestCase88DevManageSaleInList(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_case_dev_manage_sale_in_list(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
imei_in_list = self.dev_manage_page.get_imei_in_list()
dev_type_in_list = self.dev_manage_page.get_dev_type_in_list()
# 点击批量
self.dev_manage_page.click_sale_in_list_button()
self.dev_manage_page.click_close_sale_in_list_button()
self.dev_manage_page.click_sale_in_list_button()
# 点击销售
self.dev_manage_page.click_sale_button()
# 获取打开销售之后的imei和设备类型
imei_in_sale = self.dev_manage_page.get_imei_in_sale()
self.assertEqual(imei_in_list, imei_in_sale)
dev_type_in_sale = self.dev_manage_page.get_dev_type_in_sale()
self.assertEqual(dev_type_in_list, dev_type_in_sale)
dev_account_name = self.dev_manage_page.get_dev_account_name()
connect = self.connect_sql.connect_tuqiang_sql()
cursor = connect.cursor()
get_account_sql = "select o.account from equipment_mostly e inner join user_info o on e.userId = o.userId where e.imei = '%s';" % imei_in_list
cursor.execute(get_account_sql)
account_data = cursor.fetchall()
account = account_data[0][0]
cursor.close()
connect.close()
self.assertEqual(dev_account_name, account)
# 搜索右侧客户树
# 循环点击5次
for n in range(5):
self.driver.click_element(
'x,//*[@id="treeDemo_device_sale_id_%s_span"]' % str(n + 1))
sleep(2)
# 判断数量
get_account_dev_number = self.driver.get_text(
'x,//*[@id="treeDemo_device_sale_id_%s_span"]' % str(n + 1))
name = self.dev_manage_page.get_select_account_name()
self.assertEqual(get_account_dev_number, name)
# 搜索无数据
self.dev_manage_page.search_customer_after_click_batch_sale_dev('无数据')
get_text = self.dev_manage_page.get_search_customer_no_data_text_after_batch_sale_dev(
)
self.assertIn(self.assert_text.account_center_page_no_data_text(),
get_text)
# 获取选中设备的数量
dev_number = self.dev_manage_page.get_select_dev_number()
# 获取抬头设备统计的数量
dev_numbers_count = self.dev_manage_page.get_dev_numbers()
self.assertEqual(str(dev_number), dev_numbers_count)
# 删除设备后 点击销售
self.dev_manage_page.click_detele_dev()
self.dev_manage_page.click_sale_button()
### 添加设备
# 成功添加的
self.dev_manage_page.add_dev_to_sale(imei_in_list)
# 添加重复的
self.dev_manage_page.add_dev_to_sale(imei_in_list)
# 获取失败后的imei
imei_after_add_fail = self.dev_manage_page.get_imei_after_add_fail()
self.assertEqual(imei_in_list, imei_after_add_fail)
status = self.dev_manage_page.get_status_after_add_fail()
self.assertEqual(self.assert_text.dev_page_fail_text(), status)
fail_reason = self.dev_manage_page.get_fail_reason()
self.assertEqual(self.assert_text.dev_page_repetition_text(),
fail_reason)
self.dev_manage_page.click_close_fails()
# 添加不存在的imei
self.dev_manage_page.add_dev_to_sale('我就是要添加不存在的')
# 获取失败后的imei
imei_after_add_fail = self.dev_manage_page.get_imei_after_add_fail()
self.assertEqual('我就是要添加不存在的', imei_after_add_fail)
status = self.dev_manage_page.get_status_after_add_fail()
self.assertEqual(self.assert_text.dev_page_fail_text(), status)
fail_reason = self.dev_manage_page.get_fail_reason()
self.assertEqual(self.assert_text.dev_page_inexistence_text(),
fail_reason)
self.dev_manage_page.click_close_fails()
class TestCase95DevManageBatchSaleByNoDev(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.driver.wait(1)
self.driver.clear_cookies()
self.assert_text = AssertText()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_case_dev_manage_batch_sale_by_no_dev(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 点击批量
self.dev_manage_page.click_batch_sale_button()
self.dev_manage_page.click_close_batch_sale_button()
self.dev_manage_page.click_batch_sale_button()
# 验证界面
get_sale_title = self.dev_manage_page.get_sale_title_text_in_sale_dev()
self.assertEqual(self.assert_text.batch_sale_text(), get_sale_title)
# 搜索框输入多个设备IMEI，点击添加（设备之间用enter键、逗号隔开）
self.dev_manage_page.add_imei_in_sale_dev_page(
'121201234567889,867597011453591')
get_dev_in_list_number = self.dev_manage_page.get_dev_in_list_number()
self.assertEqual(2, get_dev_in_list_number)
# 搜索框输入多个设备IMEI，点击添加（设备之间不用enter键、逗号隔开，而用空格隔开）
self.dev_manage_page.add_imei_in_sale_dev_page(
'121201234567889867597011453591')
add_dev_state = self.dev_manage_page.add_dev_after_fail_state()
self.assertEqual(self.assert_text.dev_page_fail_text(), add_dev_state)
add_dev_reason = self.dev_manage_page.add_dev_after_fail_reason()
self.assertEqual(self.assert_text.dev_page_inexistence_text(),
add_dev_reason)
self.dev_manage_page.click_close_fails()
# 不选择销售对象进行销售
self.dev_manage_page.click_sale_button()
# text = self.dev_manage_page.get_error_text_after_ensure()
# self.assertEqual(self.assert_text.glob_search_please_add_account_text(), text)
# 点击重置的按钮
self.dev_manage_page.click_clear_button_in_dev_sale()
get_dev_in_list_number = self.dev_manage_page.get_dev_in_list_number()
self.assertEqual(0, get_dev_in_list_number)
class TestCase99DevManageSearchDevAfterIssuedCommand(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_dev_manager_search_dev_after_issued_command(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in_jimitest()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 搜索 包含下级 加 平台即将到期
self.dev_manage_page.search_platform_expire_and_contain_next_in_dev_page(
)
# 获取查询的页数
page_number = self.dev_manage_page.get_total_page_number_in_dev_manager(
)
if page_number == 0:
# 断言暂无数据
text = self.dev_manage_page.get_no_data_text_after_search_in_dev_page(
)
self.assertIn(self.assert_text.account_center_page_no_data_text(),
text)
# 点击本次查询全部发送指令
self.dev_manage_page.click_batch_issued_command_button()
# 断言数据为零
self.assertEqual(
'',
self.dev_manage_page.get_total_number_in_issued_command_page())
self.assertEqual(
0,
self.dev_manage_page.
get_total_number_list_in_issued_command_page())
elif page_number == 1:
# 查询本页的条数
number = self.dev_manage_page.get_total_number_per_page_in_dev_manager(
)
# 获取到查询到的所有imei
search_imei = []
for n in range(number):
imei = self.dev_manage_page.get_per_imei_in_dev_page(n)
search_imei.append(imei)
# 点击本次查询全部发送指令
self.dev_manage_page.click_batch_issued_command_button()
# 获取全部下发指令页面 统计的总数和列表中设备的总数
check_number = self.dev_manage_page.get_total_number_in_issued_command_page(
)
check_list_number = self.dev_manage_page.get_total_number_list_in_issued_command_page(
)
a = (number - int(check_number)) >= 0
self.assertEqual(True, a)
b = (number - check_list_number) >= 0
self.assertEqual(True, b)
# 获取下发指令页面的所有imei
issued_imei = []
for m in range(check_list_number):
imei = self.dev_manage_page.get_per_imei_in_issued_command(m)
issued_imei.append(imei)
# 断言下发指令页面的设备都在查询的里面
for dev in issued_imei:
self.assertIn(dev, search_imei)
else:
search_imei = []
for x in range(page_number):
self.dev_manage_page.click_per_page(x + 1)
# 查询本页的条数
number = self.dev_manage_page.get_total_number_per_page_in_dev_manager(
)
# 获取到查询到的所有imei
for y in range(number):
imei = self.dev_manage_page.get_per_imei_in_dev_page(y)
search_imei.append(imei)
# 点击本次查询全部发送指令
self.dev_manage_page.click_batch_issued_command_button()
# 获取全部下发指令页面 统计的总数和列表中设备的总数
check_number = self.dev_manage_page.get_total_number_in_issued_command_page(
)
check_list_number = self.dev_manage_page.get_total_number_list_in_issued_command_page(
)
a = (len(search_imei) - int(check_number)) >= 0
self.assertEqual(True, a)
b = (len(search_imei) - check_list_number) >= 0
self.assertEqual(True, b)
# 获取下发指令页面的所有imei
issued_imei = []
for m in range(check_list_number):
imei = self.dev_manage_page.get_per_imei_in_issued_command(m)
issued_imei.append(imei)
# 断言下发指令页面的设备都在查询的里面
for dev in issued_imei:
self.assertIn(dev, search_imei)
class TestCase90DevManageStartingUp(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_case_dev_manage_starting_up(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 测试选中停机
self.dev_manage_page.click_dev_in_list()
# 点击选中停机
self.dev_manage_page.click_select_starting_up()
# 点击确定
self.dev_manage_page.click_ensure()
get_dev_status = self.dev_manage_page.get_dev_status_in_list()
self.assertEqual(self.assert_text.dev_page_starting_up(),
get_dev_status)
# 点击选中停机
self.dev_manage_page.click_dev_in_list()
self.dev_manage_page.click_select_starting_up()
# 点击取消
self.dev_manage_page.click_cancel()
get_dev_status = self.dev_manage_page.get_dev_status_in_list()
self.assertEqual(self.assert_text.dev_page_starting_up(),
get_dev_status)
# 点击选中停机
self.dev_manage_page.click_select_starting_up()
# 点击关闭
self.dev_manage_page.click_close()
get_dev_status = self.dev_manage_page.get_dev_status_in_list()
self.assertEqual(self.assert_text.dev_page_starting_up(),
get_dev_status)
# 点击本次查询全部停机
self.dev_manage_page.click_all_starting_up()
self.dev_manage_page.click_ensure()
# 断言
get_all_page = self.dev_manage_page.get_all_pages()
if get_all_page == 0:
pass
elif get_all_page == 1:
per_number = self.dev_manage_page.get_per_number()
for m in range(per_number):
text = self.dev_manage_page.get_text_dev_status(m + 1)
self.assertEqual(self.assert_text.dev_page_starting_up(), text)
else:
for n in range(get_all_page):
self.dev_manage_page.click_per_page(n + 1)
sleep(2)
# 获取当前页面有多少条
per_number = self.dev_manage_page.get_per_number()
for m in range(per_number):
text = self.dev_manage_page.get_text_dev_status(m + 1)
self.assertEqual(self.assert_text.dev_page_starting_up(),
text)
class TestCase71DevManageDevSearchByIMEI(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.assert_text = AssertText()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
def tearDown(self):
self.driver.quit_browser()
def test_dev_manage_dev_search_by_imei(self):
'''测试设备管理-设备搜索-by imei'''
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
csv_file = self.dev_manage_page_read_csv.read_csv(
'single_search_info.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
search_info = {
"imei": row[0],
"dev_name": row[1],
"login_user_dev_type": row[2],
"user_select": row[3],
"select_user_dev_type": row[4],
"vehicle_number": row[5],
"car_frame": row[6],
"SIM": row[7],
"active_start_time": row[8],
"active_end_time": row[9],
"plat_expired_start_time": row[10],
"plat_expired_end_time": row[11],
"dev_use_range": row[12]
}
# 输入imei
self.dev_manage_page.input_imei(search_info["imei"])
# 搜索
self.dev_manage_page.click_search_btn()
# 获取搜索结果的imei号
imei = self.dev_manage_page.get_search_result_imei()
# 验证搜索结果imei与输入的imei是否一致
self.assertEqual(search_info["imei"], imei, "搜索结果imei与输入的imei不一致")
csv_file.close()
'''# 设备IMEI输入框输入选中用户的多个设备IMEI（以enter键隔开），点击搜索，点击导出
class TestCase79DevManageDevOperationActiveAndStart(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPages(
self.driver, self.base_url)
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.connect_sql = ConnectSql()
self.search_sql = SearchSql()
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_dev_manage_dev_operation_active_and_start(self):
'''测试设备管理-设备搜索-by imei+设备名称+设备型号+车牌号+车架号+SIM'''
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
self.dev_manage_page.enter_dev_manage()
# 选择已激活和开机的设备
self.dev_manage_page.choose_dev_active_and_statr()
self.dev_manage_page.click_ensure()
imei = self.dev_manage_page.get_imei_number()
self.dev_manage_page.click_edit_button()
self.dev_manage_page.click_close_edit_button()
self.dev_manage_page.click_edit_button()
csv_file = self.dev_manage_page_read_csv.read_csv(
'dev_operation_data.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
self.data = {
'dev_name': row[0],
'sim': row[1],
'mark': row[2],
'd_name': row[3],
'd_phone': row[4],
'plate_numbers': row[5],
'iccid': row[6],
'sn': row[7],
'vin': row[8],
'engine_number': row[9],
'install_time': row[10],
'install_adress': row[11],
'install_comp': row[12],
'install_preson': row[13]
}
self.dev_manage_page.add_data_to_edit_dev_detila(self.data)
# 验证是否修改成功
sleep(3)
text = self.dev_manage_page.get_dev_name()
self.assertEqual(self.data['dev_name'], text)
csv_file.close()
# 点击查看位置
current_handle = self.driver.get_current_window_handle()
self.dev_manage_page.click_look_place_button()
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != current_handle:
self.driver.switch_to_window(handle)
sleep(2)
expect_url = self.base_url + "/console"
self.assertEqual(expect_url, self.driver.get_current_url())
# dev_name = self.dev_manage_page.get_dev_name_after_click_console()
# self.assertEqual(self.data['dev_name'], dev_name)
self.driver.close_current_page()
self.driver.switch_to_window(current_handle)
sleep(2)
# 点击轨迹回放
self.dev_manage_page.click_track_playback_button()
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != current_handle:
self.driver.switch_to_window(handle)
sleep(2)
expect_url = self.base_url + "/trackreplay/locus?imei=%s" % imei
self.assertEqual(expect_url, self.driver.get_current_url())
text = self.dev_manage_page.click_track_playback_get_text()
self.assertEqual(self.assert_text.dev_page_track_replay_text(),
text)
self.driver.close_current_page()
self.driver.switch_to_window(current_handle)
sleep(2)
# 点行车记录
self.dev_manage_page.click_driving_recond_button()
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != current_handle:
self.driver.switch_to_window(handle)
sleep(2)
expect_url = self.base_url + "/drivingrecord/driving?imei=%s" % imei
self.assertEqual(expect_url, self.driver.get_current_url())
text = self.dev_manage_page.click_driving_recond_get_text()
self.assertEqual(
self.assert_text.dev_page_driving_record_text(), text)
self.driver.close_current_page()
self.driver.switch_to_window(current_handle)
sleep(2)
# 点街景
self.dev_manage_page.click_street_scape_button()
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != current_handle:
self.driver.switch_to_window(handle)
sleep(2)
expect_url = self.base_url + "/trackpreset/tracking/%s?isTracking=1" % imei
self.assertEqual(expect_url, self.driver.get_current_url())
text = self.dev_manage_page.click_street_scape_get_text()
self.assertIn(self.assert_text.dev_page_track_preset_text(),
text)
self.driver.close_current_page()
self.driver.switch_to_window(current_handle)
sleep(2)
# 点查看告警
self.dev_manage_page.click_look_alarm_button()
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != current_handle:
self.driver.switch_to_window(handle)
sleep(2)
expect_url = self.base_url + "/deviceReport/statisticalReport"
self.assertEqual(expect_url, self.driver.get_current_url())
text = self.dev_manage_page.click_look_alarm_get_text()
self.assertEqual(
self.assert_text.account_center_page_alarm_details_text(),
text)
self.driver.close_current_page()
self.driver.switch_to_window(current_handle)
sleep(2)
class TestCase82DevManageBatchSale(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.driver.wait(1)
self.driver.clear_cookies()
self.assert_text = AssertText()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_case_dev_manage_batch_sale(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 选择一个设备点击批量销售
self.dev_manage_page.choose_one_dev_to_search()
get_first_imei = self.dev_manage_page.get_first_imei_in_list()
get_dev_type = self.dev_manage_page.get_dev_type_in_list()
# 点击批量
self.dev_manage_page.click_batch_sale_button()
self.dev_manage_page.click_close_batch_sale_button()
self.dev_manage_page.click_batch_sale_button()
'''# 搜索右侧客户树
# 循环点击5次
for n in range(5):
self.driver.click_element('x,//*[@id="treeDemo_device_sale_id_%s_span"]' % str(n + 1))
sleep(2)
# 判断数量
get_account_dev_number = self.driver.get_text('x,//*[@id="treeDemo_device_sale_id_%s_span"]' % str(n + 1))
name = self.dev_manage_page.get_select_account_name()
self.assertEqual(get_account_dev_number, name)
# 搜索无数据
self.dev_manage_page.search_customer_after_click_batch_sale_dev('无数据')
get_text = self.dev_manage_page.get_search_customer_no_data_text_after_batch_sale_dev()
self.assertIn(self.assert_text.account_center_page_no_data_text(), get_text)
# 获取选中设备的数量
dev_number = self.dev_manage_page.get_select_dev_number()
# 获取抬头设备统计的数量
dev_numbers_count = self.dev_manage_page.get_dev_numbers()
self.assertEqual(str(dev_number), dev_numbers_count)'''
# 验证界面
get_sale_title = self.dev_manage_page.get_sale_title_text_in_sale_dev()
self.assertEqual(self.assert_text.batch_sale_text(), get_sale_title)
get_imei_in_sale = self.dev_manage_page.get_batch_sale_imei_in_sale_dev()
self.assertEqual(get_first_imei, get_imei_in_sale)
get_dev_type_in_sale = self.dev_manage_page.get_dev_type_in_sale()
self.assertEqual(get_dev_type, get_dev_type_in_sale)
get_dev_number = self.dev_manage_page.get_dev_number_in_sale_dev()
self.assertEqual('1', get_dev_number)
get_dev_account = self.dev_manage_page.get_dev_account_name()
connect_sql = ConnectSql()
connect = connect_sql.connect_tuqiang_sql()
cursor = connect.cursor()
sql = "select m.account from equipment_mostly m where m.imei = '%s';" % get_first_imei
cursor.execute(sql)
data = cursor.fetchall()
cursor.close()
connect.close()
sql_account = data[0][0]
self.assertEqual(get_dev_account, sql_account)
# 输入不存在的IMEI号进行添加
self.dev_manage_page.add_imei_in_sale_dev_page('bucunzai')
add_dev_state = self.dev_manage_page.add_dev_after_fail_state()
self.assertEqual(self.assert_text.dev_page_fail_text(), add_dev_state)
add_dev_reason = self.dev_manage_page.add_dev_after_fail_reason()
self.assertEqual(self.assert_text.dev_page_inexistence_text(), add_dev_reason)
self.dev_manage_page.click_close_fails()
# 添加不属于当前登陆账号设备总进货数中的设备
self.dev_manage_page.add_imei_in_sale_dev_page('863666010079196')
add_dev_state = self.dev_manage_page.add_dev_after_fail_state()
self.assertEqual(self.assert_text.dev_page_fail_text(), add_dev_state)
add_dev_reason = self.dev_manage_page.add_dev_after_fail_reason()
self.assertEqual(self.assert_text.dev_page_inexistence_text(), add_dev_reason)
self.dev_manage_page.click_close_fails()
# 添加与设备列表中重复的设备
self.dev_manage_page.add_imei_in_sale_dev_page(get_first_imei)
add_dev_state = self.dev_manage_page.add_dev_after_fail_state()
self.assertEqual(self.assert_text.dev_page_fail_text(), add_dev_state)
add_dev_reason = self.dev_manage_page.add_dev_after_fail_reason()
self.assertEqual(self.assert_text.dev_page_repetition_text(), add_dev_reason)
self.dev_manage_page.click_close_fails()
# 搜索右侧客户树
# 循环点击5次
for n in range(5):
self.driver.click_element('x,//*[@id="treeDemo_device_sale_id_%s_span"]' % str(n + 1))
sleep(2)
# 判断数量
get_account_dev_number = self.driver.get_text('x,//*[@id="treeDemo_device_sale_id_%s_span"]' % str(n + 1))
name = self.dev_manage_page.get_select_account_name()
self.assertEqual(get_account_dev_number, name)
# 搜索无数据
self.dev_manage_page.search_customer_after_click_batch_sale_dev('无数据')
get_text = self.dev_manage_page.get_search_customer_no_data_text_after_batch_sale_dev()
self.assertIn(self.assert_text.account_center_page_no_data_text(), get_text)
# 获取选中设备的数量
dev_number = self.dev_manage_page.get_select_dev_number()
# 获取抬头设备统计的数量
dev_numbers_count = self.dev_manage_page.get_dev_numbers()
self.assertEqual(str(dev_number), dev_numbers_count)
class TestCase94DevManageBatchSaleByMoreDev(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.driver.wait(1)
self.driver.clear_cookies()
self.assert_text = AssertText()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_case_dev_manage_batch_sale_by_more_dev(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 选择多个设备点击批量销售
self.dev_manage_page.choose_one_dev_to_search()
self.dev_manage_page.choose_more_dev_to_search()
# 点击批量
self.dev_manage_page.click_batch_sale_button()
self.dev_manage_page.click_close_batch_sale_button()
self.dev_manage_page.click_batch_sale_button()
# 验证界面
get_sale_title = self.dev_manage_page.get_sale_title_text_in_sale_dev()
self.assertEqual(self.assert_text.batch_sale_text(), get_sale_title)
# 获取统计的数量和列表中的总数
get_dev_number = self.dev_manage_page.get_dev_number_in_sale_dev()
get_dev_in_list_number = self.dev_manage_page.get_dev_in_list_number()
self.assertEqual(get_dev_number, str(get_dev_in_list_number))
# 删除一个设备列表已添加的设备
self.dev_manage_page.delete_one_dev_in_dev_list()
get_dev_number = self.dev_manage_page.get_dev_number_in_sale_dev()
get_dev_in_list_number = self.dev_manage_page.get_dev_in_list_number()
self.assertEqual(get_dev_number, str(get_dev_in_list_number))
# 输入所选账号下存在的未添加到已选设备列表的设备和已添加到已选设备列表的设备以及不存在的设备，121201234567889
self.dev_manage_page.add_imei_in_sale_dev_page('121201234567889')
sleep(2)
get_dev_number = self.dev_manage_page.get_dev_number_in_sale_dev()
get_dev_in_list_number = self.dev_manage_page.get_dev_in_list_number()
self.assertEqual(get_dev_number, str(get_dev_in_list_number))
# 删除一个设备列表已添加的设备后再添加该设备
self.dev_manage_page.delete_one_devs_in_dev_list()
get_dev_number = self.dev_manage_page.get_dev_number_in_sale_dev()
get_dev_in_list_number = self.dev_manage_page.get_dev_in_list_number()
self.assertEqual(get_dev_number, str(get_dev_in_list_number))
self.dev_manage_page.add_imei_in_sale_dev_page('121201234567889')
sleep(2)
get_dev_number = self.dev_manage_page.get_dev_number_in_sale_dev()
get_dev_in_list_number = self.dev_manage_page.get_dev_in_list_number()
self.assertEqual(get_dev_number, str(get_dev_in_list_number))
class TestCase103DevManageDevFence(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_case_103_dev_manage_dev_fence(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 搜索设备564123456789567
self.dev_manage_page.search_dev_in_dev_manage_page('121201234567889')
self.dev_manage_page.click_look_dev_fence_in_dev_page()
# 判断进出围栏是否勾选
in_fence = self.dev_manage_page.get_in_fence_select_in_look_fence_page(
)
out_fence = self.dev_manage_page.get_out_fence_select_in_look_fence_page(
)
if in_fence == True:
self.dev_manage_page.click_in_fence_input_checkbox()
in_fence = self.dev_manage_page.get_in_fence_select_in_look_fence_page(
)
self.assertEqual(False, in_fence)
else:
self.dev_manage_page.click_in_fence_input_checkbox()
in_fence = self.dev_manage_page.get_in_fence_select_in_look_fence_page(
)
self.assertEqual(True, in_fence)
if out_fence == True:
self.dev_manage_page.click_out_fence_input_checkbox()
out_fence = self.dev_manage_page.get_out_fence_select_in_look_fence_page(
)
self.assertEqual(False, out_fence)
else:
self.dev_manage_page.click_out_fence_input_checkbox()
out_fence = self.dev_manage_page.get_out_fence_select_in_look_fence_page(
)
self.assertEqual(True, out_fence)
# 点击保存
# self.dev_manage_page.click_ensure()
# 点击取消
self.dev_manage_page.click_cancels()
class TestCase75DevManageDevComplexSearch(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPages(
self.driver, self.base_url)
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.connect_sql = ConnectSql()
self.search_sql = SearchSql()
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_dev_manage_dev_complex_search(self):
'''测试设备管理-设备搜索-by imei+设备名称+设备型号+车牌号+车架号+SIM'''
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
self.dev_manage_page.click_account_center_button()
current_account = self.log_in_base.get_log_in_account()
self.dev_manage_page.enter_dev_manage()
self.dev_manage_page.click_more_button()
csv_file = self.dev_manage_page_read_csv.read_csv(
'dev_search_info.csv')
csv_data = csv.reader(csv_file)
is_header = True
for row in csv_data:
if is_header:
is_header = False
continue
search_data = {
'dev_name': row[0],
'dev_type': row[1],
'past_due': row[2],
'plate_numbers': row[3],
'frame_number': row[4],
'sim': row[5],
'active': row[6],
'choose_time': row[7],
'begin_time': row[8],
'end_time': row[9],
'next': row[10],
'band_status': row[11],
'dev_mold': row[12],
'dev_group': row[13],
'sn': row[14]
}
self.dev_manage_page.add_data_to_search_dev(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 = '" + 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)
lower_account_tuple = tuple(lower_account_list)
get_total_sql = self.search_sql.search_dev_sql(
user_relation_id['userId'], 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.dev_manage_page.get_dev_number()
print('本次查询页面的条数是：%s' % web_total)
self.assertEqual(total, web_total)
cur.close()
connect.close()
csv_file.close()
class TestCase81DevManageBatchUploadPictures(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_case_dev_manage_batch_upload_pictures(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 点击批量
self.dev_manage_page.click_batch_upload_pictures_button()
self.dev_manage_page.click_close_batch_upload_pictures_button()
self.dev_manage_page.click_batch_upload_pictures_button()
self.dev_manage_page.click_cancel_batch_upload_pictures_button()
self.dev_manage_page.click_batch_upload_pictures_button()
self.dev_manage_page.click_ensure_upload()
class TestCase74DevManageDevSearch(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_dev_manage_dev_search(self):
'''测试设备管理-设备搜索-by imei'''
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
self.dev_manage_page.click_more_button()
# 过期状态选择平台即将过期，点击搜索，点击导出
self.dev_manage_page.choose_platform_soon_expire_time()
self.dev_manage_page.click_search_btn()
# 获取查询出来的条数
number = self.dev_manage_page.get_total_page_number_in_dev_manager()
if number == 0:
text = self.dev_manage_page.get_search_no_dev_name_text()
self.assertIn(self.assert_text.account_center_page_no_data_texts(),
text)
else:
for n in range(number):
platform_time = self.dev_manage_page.get_platform_time_after_search(
n)
platform_time_strptime = time.strptime(
platform_time.split('(')[0], '%Y-%m-%d')
new_times = time.strftime('%Y-%m-%d')
new_time = time.strptime(new_times, '%Y-%m-%d')
a = new_time < platform_time_strptime
self.assertEqual(True, a)
expire_time_platform = int(
platform_time.split('(')[1].split('天')[0])
b = expire_time_platform > 0
c = expire_time_platform < 30
self.assertEqual(True, b)
self.assertEqual(True, c)
# 过期状态选择平台已过期，点击搜索，点击导出出
self.dev_manage_page.choose_platform_expire_time()
self.dev_manage_page.click_search_btn()
# 获取查询出来的条数
number = self.dev_manage_page.get_total_page_number_in_dev_manager()
if number == 0:
text = self.dev_manage_page.get_search_no_dev_name_text()
self.assertIn(self.assert_text.account_center_page_no_data_texts(),
text)
else:
for n in range(number):
platform_time = self.dev_manage_page.get_platform_time_after_search(
n)
self.assertEqual(
self.assert_text.account_center_page_expired_text() + ' ',
platform_time)
# 过期状态选择用户即将过期，点击搜索
self.dev_manage_page.choose_user_soon_expire_time()
self.dev_manage_page.click_search_btn()
# 获取查询出来的条数
number = self.dev_manage_page.get_total_page_number_in_dev_manager()
if number == 0:
text = self.dev_manage_page.get_search_no_dev_name_text()
self.assertIn(self.assert_text.account_center_page_no_data_texts(),
text)
else:
for n in range(number):
user_time = self.dev_manage_page.get_user_time_after_search(n)
user_time_strptime = time.strptime(
user_time.split('(')[0], '%Y-%m-%d')
new_times = time.strftime('%Y-%m-%d')
new_time = time.strptime(new_times, '%Y-%m-%d')
a = new_time < user_time_strptime
self.assertEqual(True, a)
expire_time_user = int(user_time.split('(')[1].split('天')[0])
b = expire_time_user > 0
c = expire_time_user < 30
self.assertEqual(True, b)
self.assertEqual(True, c)
# 过期状态选择用户已过期，点击搜索，点击导出
self.dev_manage_page.choose_user_expire_time()
self.dev_manage_page.click_search_btn()
# 获取查询出来的条数
number = self.dev_manage_page.get_total_page_number_in_dev_manager()
if number == 0:
text = self.dev_manage_page.get_search_no_dev_name_text()
self.assertIn(self.assert_text.account_center_page_no_data_texts(),
text)
else:
for n in range(number):
user_time = self.dev_manage_page.get_user_time_after_search(n)
self.assertEqual(
self.assert_text.account_center_page_expired_text(),
user_time)
# 激活状态选择已激活，点击搜索，点击导出
self.dev_manage_page.no_choose_expire_time()
self.dev_manage_page.choose_active_dev()
self.dev_manage_page.click_search_btn()
# 获取查询出来的条数
number = self.dev_manage_page.get_total_page_number_in_dev_manager()
if number == 0:
text = self.dev_manage_page.get_search_no_dev_name_text()
self.assertIn(self.assert_text.account_center_page_no_data_texts(),
text)
else:
for n in range(number):
active_state = self.dev_manage_page.get_active_state_after_search(
n)
self.assertNotEqual(
self.assert_text.account_center_page_activing_text(),
active_state)
# 激活状态选择未激活，点击搜索，点击导出
self.dev_manage_page.choose_noactive_dev()
self.dev_manage_page.click_search_btn()
# 获取查询出来的条数
number = self.dev_manage_page.get_total_page_number_in_dev_manager()
if number == 0:
text = self.dev_manage_page.get_search_no_dev_name_text()
self.assertIn(self.assert_text.account_center_page_no_data_texts(),
text)
else:
for n in range(number):
active_state = self.dev_manage_page.get_active_state_after_search(
n)
self.assertEqual(
self.assert_text.account_center_page_activing_text(),
active_state)
# 绑定状态选择已绑定，点击搜索，点击导出
self.dev_manage_page.no_choose_active_state_dev()
self.dev_manage_page.choose_band_dev()
self.dev_manage_page.click_search_btn()
# 获取查询出来的条数
number = self.dev_manage_page.get_total_page_number_in_dev_manager()
if number == 0:
text = self.dev_manage_page.get_search_no_dev_name_text()
self.assertIn(self.assert_text.account_center_page_no_data_texts(),
text)
else:
for n in range(number):
band_state = self.dev_manage_page.get_band_state_after_search(
n)
self.assertNotEqual('', band_state)
# 绑定状态选择未绑定，点击搜索，点击导出
self.dev_manage_page.choose_no_band_dev()
self.dev_manage_page.click_search_btn()
# 获取查询出来的条数
number = self.dev_manage_page.get_total_page_number_in_dev_manager()
if number == 0:
text = self.dev_manage_page.get_search_no_dev_name_text()
self.assertIn(self.assert_text.account_center_page_no_data_texts(),
text)
else:
for n in range(number):
band_state = self.dev_manage_page.get_band_state_after_search(
n)
self.assertEqual('', band_state)
# 所有分组选择选中用户的一个分组，点击搜索，点击导出
self.dev_manage_page.no_choose_band_state_dev()
self.dev_manage_page.choose_user_group_to_search()
self.dev_manage_page.click_search_btn()
# 获取查询出来的条数
number = self.dev_manage_page.get_total_page_number_in_dev_manager()
if number == 0:
text = self.dev_manage_page.get_search_no_dev_name_text()
self.assertIn(self.assert_text.account_center_page_no_data_texts(),
text)
else:
for n in range(number):
get_choose_group_name = self.dev_manage_page.get_choose_group_name(
)
get_group_name_in_list = self.dev_manage_page.get_group_name_in_list(
n)
self.assertEqual(get_choose_group_name, get_group_name_in_list)
class TestCase72DevManageDevSearchByInputData(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_dev_manage_dev_search_by_input_data(self):
'''测试设备管理-设备搜索-by imei'''
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
self.dev_manage_page.click_more_button()
# 车牌号输入框输入选中用户的设备车牌号包含的字符，点击搜索，点击导出
dev_vehicle_number = '12'
self.dev_manage_page.inpui_dev_vehicle_number_to_search(
dev_vehicle_number)
self.dev_manage_page.click_search_btn()
connect_sql = ConnectSql()
connect = connect_sql.connect_tuqiang_sql()
cursor = connect.cursor()
# 获取查询出来的条数
number = self.dev_manage_page.get_total_page_number_in_dev_manager()
for n in range(number):
imei = self.dev_manage_page.get_imei_after_search(n)
sql = "SELECT d.vehicleNumber FROM equipment_detail d WHERE d.imei = '%s';" % imei
cursor.execute(sql)
data = cursor.fetchall()
vehicle_number = data[0][0]
self.assertIn(dev_vehicle_number, vehicle_number)
# 车牌号输入框输入选中用户的设备车牌号不包含的字符，点击搜索，点击导出
dev_vehicle_number = '不存在的'
self.dev_manage_page.inpui_dev_vehicle_number_to_search(
dev_vehicle_number)
self.dev_manage_page.click_search_btn()
text = self.dev_manage_page.get_search_no_dev_name_text()
self.assertIn(self.assert_text.account_center_page_no_data_texts(),
text)
# 车架号输入框输入选中用户的设备车架号包含的字符，点击搜索，点击导出
self.dev_manage_page.inpui_dev_vehicle_number_to_search('')
dev_car_frame = '12'
self.dev_manage_page.input_dev_car_frame_to_search(dev_car_frame)
self.dev_manage_page.click_search_btn()
sleep(2)
# 获取查询出来的条数
number = self.dev_manage_page.get_total_page_number_in_dev_manager()
for n in range(number):
imei = self.dev_manage_page.get_imei_after_search(n)
sql = "SELECT d.carFrame FROM equipment_detail d WHERE d.imei = '%s';" % imei
cursor.execute(sql)
data = cursor.fetchall()
vehicle_number = data[0][0]
self.assertIn(dev_car_frame, vehicle_number)
# 车架号输入框输入选中用户的设备车架号不包含的字符，点击搜索，点击导出
dev_vehicle_number = '不存在的'
self.dev_manage_page.input_dev_car_frame_to_search(dev_vehicle_number)
self.dev_manage_page.click_search_btn()
text = self.dev_manage_page.get_search_no_dev_name_text()
self.assertIn(self.assert_text.account_center_page_no_data_texts(),
text)
# SIM卡号输入框输入选中用户的设备车牌号包含的字符，点击搜索，点击导出
self.dev_manage_page.input_dev_car_frame_to_search('')
dev_sim = '12'
self.dev_manage_page.input_dev_sim_to_search(dev_sim)
self.dev_manage_page.click_search_btn()
sleep(2)
# 获取查询出来的条数
number = self.dev_manage_page.get_total_page_number_in_dev_manager()
for n in range(number):
imei = self.dev_manage_page.get_imei_after_search(n)
sql = "SELECT d.sim FROM equipment_mostly d WHERE d.imei = '%s';" % imei
cursor.execute(sql)
data = cursor.fetchall()
sim_number = data[0][0]
self.assertIn(dev_sim, sim_number)
# SIM卡号输入框输入选中用户的设备车牌号不包含的字符，点击搜索，点击导出
dev_sim_number = '不存在的'
self.dev_manage_page.input_dev_sim_to_search(dev_sim_number)
self.dev_manage_page.click_search_btn()
text = self.dev_manage_page.get_search_no_dev_name_text()
self.assertIn(self.assert_text.account_center_page_no_data_texts(),
text)
# SN码输入框输入选中用户的设备车架号包含的字符，点击搜索，点击导出
self.dev_manage_page.input_dev_sim_to_search('')
dev_sn = '12'
self.dev_manage_page.input_dev_sn_to_search(dev_sn)
self.dev_manage_page.click_search_btn()
sleep(2)
# 获取查询出来的条数
number = self.dev_manage_page.get_total_page_number_in_dev_manager()
for n in range(number):
imei = self.dev_manage_page.get_imei_after_search(n)
sql = "SELECT d.sn FROM equipment_detail d WHERE d.imei = '%s';" % imei
cursor.execute(sql)
data = cursor.fetchall()
sn_number = data[0][0]
self.assertIn(dev_sn, sn_number)
# SN码输入框输入选中用户的设备车架号不包含的字符，点击搜索，点击导出
dev_sn_number = '不存在的'
self.dev_manage_page.input_dev_sn_to_search(dev_sn_number)
self.dev_manage_page.click_search_btn()
text = self.dev_manage_page.get_search_no_dev_name_text()
self.assertIn(self.assert_text.account_center_page_no_data_texts(),
text)
class TestCase76DevManageDevOperationNOActiveAndStop(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPages(
self.driver, self.base_url)
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.connect_sql = ConnectSql()
self.search_sql = SearchSql()
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_dev_manage_dev_operation_noactive_and_stop(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
self.dev_manage_page.enter_dev_manage()
# 选择已激活和开机的设备
self.dev_manage_page.choose_dev_noactive_and_stop()
self.dev_manage_page.click_ensure()
sleep(4)
imei = self.dev_manage_page.get_imei_number()
self.dev_manage_page.click_edit_button()
self.dev_manage_page.click_close_edit_button()
self.dev_manage_page.click_edit_button()
csv_file = self.dev_manage_page_read_csv.read_csv(
'dev_operation_data.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
self.data = {
'dev_name': row[0],
'sim': row[1],
'mark': row[2],
'd_name': row[3],
'd_phone': row[4],
'plate_numbers': row[5],
'iccid': row[6],
'sn': row[7],
'vin': row[8],
'engine_number': row[9],
'install_time': row[10],
'install_adress': row[11],
'install_comp': row[12],
'install_preson': row[13]
}
self.dev_manage_page.add_data_to_edit_dev_detila(self.data)
# 验证是否修改成功
sleep(4)
text = self.dev_manage_page.get_dev_name()
self.assertEqual(self.data['dev_name'], text)
csv_file.close()
# 点击查看位置
current_handle = self.driver.get_current_window_handle()
self.dev_manage_page.click_look_place_button()
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != current_handle:
self.driver.switch_to_window(handle)
sleep(2)
expect_url = self.base_url + "/console"
self.assertEqual(expect_url, self.driver.get_current_url())
# dev_name = self.dev_manage_page.get_dev_name_after_click_console()
# self.assertEqual(self.data['dev_name'], dev_name)
self.driver.close_current_page()
self.driver.switch_to_window(current_handle)
sleep(2)
class TestCase91DevManageShutDownByNextUser(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_case_dev_manage_shut_down_by_next_user(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 搜索下级客户
csv_file = self.dev_manage_page_read_csv.read_csv("search_account.csv")
csv_data = csv.reader(csv_file)
for row in csv_data:
self.data = {'acc': row[0]}
# 输入用户名搜索
self.dev_manage_page.search_account(self.data['acc'])
# 勾选包含下级，搜索
self.dev_manage_page.search_dev()
# 测试选中停机
self.dev_manage_page.click_dev_in_list()
# 点击选中停机
self.dev_manage_page.click_select_shut_down()
# 点击确定
self.dev_manage_page.click_ensure()
sleep(4)
get_dev_status = self.dev_manage_page.get_dev_status_in_list()
self.assertEqual(self.assert_text.dev_page_closing_down(),
get_dev_status)
# 点击选中停机
self.dev_manage_page.click_dev_in_list()
self.dev_manage_page.click_select_shut_down()
# 点击取消
self.dev_manage_page.click_cancel()
get_dev_status = self.dev_manage_page.get_dev_status_in_list()
self.assertEqual(self.assert_text.dev_page_closing_down(),
get_dev_status)
# 点击选中停机
self.dev_manage_page.click_select_shut_down()
# 点击关闭
self.dev_manage_page.click_close()
get_dev_status = self.dev_manage_page.get_dev_status_in_list()
self.assertEqual(self.assert_text.dev_page_closing_down(),
get_dev_status)
# 点击本次查询全部停机
self.dev_manage_page.click_all_shut_down()
self.dev_manage_page.click_ensure()
sleep(4)
# 断言
get_all_page = self.dev_manage_page.get_all_pages()
if get_all_page == 0:
pass
elif get_all_page == 1:
per_number = self.dev_manage_page.get_per_number()
for m in range(per_number):
text = self.dev_manage_page.get_text_dev_status(m + 1)
self.assertEqual(self.assert_text.dev_page_closing_down(),
text)
else:
for n in range(get_all_page):
self.dev_manage_page.click_per_page(n + 1)
sleep(2)
# 获取当前页面有多少条
per_number = self.dev_manage_page.get_per_number()
for m in range(per_number):
text = self.dev_manage_page.get_text_dev_status(m + 1)
self.assertEqual(self.assert_text.dev_page_closing_down(),
text)
class TestCase102DevManageDevDetailDevMileage(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
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_case_dev_manage_dev_detail_dev_mileage(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
self.dev_manage_page.click_edit_button()
self.dev_manage_page.click_close_edit_button()
self.dev_manage_page.click_edit_button()
# 点击客户信息
self.dev_manage_page.click_cust_info_button()
# 获取总里程的最大长度
dev_total_mileage_max_len = self.dev_manage_page.get_dev_total_mileage_max_len(
)
self.assertEqual('10', dev_total_mileage_max_len)
# 输入非数字
self.dev_manage_page.input_dev_total_mileage_in_dev_detail('1we23')
# 获取异常的文字
text = self.assert_text.dev_total_mileage_text1()
self.dev_manage_page.click_ensure()
web_text = self.dev_manage_page.get_text_after_input_dev_total_mileage(
)
self.assertEqual(text, web_text)
# 输入大于999999
self.dev_manage_page.input_dev_total_mileage_in_dev_detail(
'1000000000')
# 获取异常的文字
text = self.assert_text.dev_total_mileage_text2()
self.dev_manage_page.click_ensure()
web_text = self.dev_manage_page.get_text_after_input_dev_total_mileage(
)
self.assertEqual(text, web_text)
