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 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 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 TestCase401CustomerManagementCheckAccount(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.close_window()
self.driver.quit_browser()
def test_customer_management_check_account(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)
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 TestCase122LoginEnterThirdWebsite(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.driver.set_window_max()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_third_website(self):
'''测试登录页底部第三方链接'''
websites = ["可信网站", "网络警察", "公共信息网络安全监察", "不良信息举报中心", "工商网监"]
# 打开途强在线首页-登录页
self.base_page.open_page()
# 获取网站个数
url = self.base_url
count = self.login_page.get_login_page_website_count(url)
# 获取当前窗口句柄
tuqiang_handle = self.driver.get_current_window_handle()
try:
# 点击底部第三方链接-可信网站
expect_url_00 = "https://ss.knet.cn/verifyseal.dll?sn=e16112844030065399aooh000000&ct=df&a=1&pa=0.5438364866062911"
self.login_page.enter_third_party_website(websites[0], count)
self.driver.wait()
# 获取当前所有窗口句柄
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != tuqiang_handle:
self.driver.switch_to_window(handle)
self.driver.wait(1)
web_url_00 = self.driver.get_current_url()
# 判断当前第三方链接跳转是否正确
self.assertEqual(expect_url_00, web_url_00, "当前第三方链接跳转错误")
self.driver.close_window()
self.driver.switch_to_window(tuqiang_handle)
print("有可信网站")
except:
print("没有可信网站############")
# 点击底部第三方链接-01
expect_url_01 = "http://www.cyberpolice.cn/wfjb/"
self.login_page.enter_third_party_website(websites[1], count)
self.driver.wait()
# 获取当前所有窗口句柄
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != tuqiang_handle:
self.driver.switch_to_window(handle)
self.driver.wait(1)
web_url_01 = self.driver.get_current_url()
# 判断当前第三方链接跳转是否正确
self.assertEqual(expect_url_01, web_url_01, "当前第三方链接跳转错误")
self.driver.wait()
self.driver.close_window()
self.driver.switch_to_window(tuqiang_handle)
# 点击底部第三方链接-02
self.driver.switch_to_window(tuqiang_handle)
self.assertEqual(self.base_url + "/", self.driver.get_current_url(),
"回到原窗口失败")
expect_url_02 = "http://www.500wan.com/pages/info/about/wangan/index.htm"
self.login_page.enter_third_party_website(websites[2], count)
self.driver.wait()
# 获取当前所有窗口句柄
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != tuqiang_handle:
self.driver.switch_to_window(handle)
self.driver.wait(1)
web_url_02 = self.driver.get_current_url()
# 判断当前第三方链接跳转是否正确
self.assertEqual(expect_url_02, web_url_02, "当前第三方链接跳转错误")
self.driver.wait()
self.driver.close_window()
self.driver.switch_to_window(tuqiang_handle)
# 点击底部第三方链接-03
self.driver.switch_to_window(tuqiang_handle)
self.assertEqual(self.base_url + "/", self.driver.get_current_url(),
"回到原窗口失败")
expect_url_03 = "http://www.12377.cn/"
self.login_page.enter_third_party_website(websites[3], count)
self.driver.wait()
# 获取当前所有窗口句柄
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != tuqiang_handle:
self.driver.switch_to_window(handle)
self.driver.wait(1)
web_url_03 = self.driver.get_current_url()
# 判断当前第三方链接跳转是否正确
self.assertEqual(expect_url_03, web_url_03, "当前第三方链接跳转错误")
self.driver.wait()
self.driver.close_window()
self.driver.switch_to_window(tuqiang_handle)
self.driver.switch_to_window(tuqiang_handle)
self.assertEqual(self.base_url + "/", self.driver.get_current_url(),
"回到原窗口失败")
expect_url_04 = "http://szcert.ebs.org.cn/2a950f00-00fb-495c-8e30-5a04100f9b17"
self.login_page.enter_third_party_website(websites[4], count)
self.driver.wait()
# 获取当前所有窗口句柄
all_handles = self.driver.get_all_window_handles()
for handle in all_handles:
if handle != tuqiang_handle:
self.driver.switch_to_window(handle)
self.driver.wait(1)
web_url_04 = self.driver.get_current_url()
# 判断当前第三方链接跳转是否正确
self.assertEqual(expect_url_04, web_url_04, "当前第三方链接跳转错误")
self.driver.wait()
self.driver.close_window()
self.driver.switch_to_window(tuqiang_handle)
self.driver.switch_to_window(tuqiang_handle)
self.assertEqual(self.base_url + "/", self.driver.get_current_url(),
"回到原窗口失败")
class TestCase405CustomerManagementAddUserCommandLimit(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_add_user_command_limit_verify(self):
'''测试客户管理-指令权限验证'''
self.base_page.open_page()
csv_file = self.cust_manage_page_read_csv.read_csv('add_user_command_limit_data.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
info = {
"keyword": row[0],
"type": row[1],
"name": row[2],
"account": row[3],
"passwd": row[4],
"phone": row[5],
"email": row[6],
"conn": row[7],
"com": row[8],
"command": row[9],
"working_mode": row[10]
}
# 登录
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()
sleep(1)
self.base_page.change_windows_handle(current_handle)
self.cust_manage_basic_info_and_add_cust_page.add_acc()
self.cust_manage_basic_info_and_add_cust_page.close_add_account()
self.cust_manage_basic_info_and_add_cust_page.add_acc()
self.cust_manage_basic_info_and_add_cust_page.locate_to_iframe()
self.cust_manage_basic_info_and_add_cust_page.add_acc_input_info_edit(info["name"], info["account"],
info["passwd"],
info["phone"], info["email"],
info["conn"], info["com"])
# 是或否批量下发指令 和批量下发工作模式
command_status = self.cust_manage_basic_info_and_add_cust_page.setting_command_permissions(info["command"])
working_mode_status = self.cust_manage_basic_info_and_add_cust_page.setting_working_mode_permissions(
info["working_mode"])
self.assertEqual(info["command"], str(command_status), "勾选状态与期望不一致")
self.assertEqual(info["working_mode"], str(working_mode_status), "勾选状态与期望不一致")
self.driver.default_frame()
sleep(2)
self.cust_manage_basic_info_and_add_cust_page.acc_add_save()
sleep(1)
# 退出登录
self.account_center_page_navi_bar.usr_logout()
self.log_in_base.log_in_with_csv(info["account"], info["passwd"])
hello_usr = self.account_center_page_navi_bar.usr_info_account()
self.assertIn(info["account"], hello_usr, "登录成功后招呼栏账户名显示错误")
sleep(1)
# 进入设备管理/指令管理页面，获取功能按钮
current_handle_02 = self.driver.get_current_window_handle()
self.cust_manage_basic_info_and_add_cust_page.click_dev_management_button()
self.base_page.change_windows_handle(current_handle_02)
facility_manage_data = self.cust_manage_basic_info_and_add_cust_page.get_facility_manage_page_function_button()
sleep(3)
# command_manage_data = self.cust_manage_basic_info_and_add_cust_page.get_command_page_module()
# 获取中文，依次是：选中发送指令、本次查询全部发送指令、选中设置工作模式、本次查询全部设置工作模式
# 工作模式模板管理, 下发工作模式任务管理, 下发工作模式管理, 下发指令任务管理, 下发指令管理
send_command = self.assert_text2.dev_manage_select_send_command()
all_send_command = self.assert_text2.dev_manage_select_all_send_command()
working_mode = self.assert_text2.dev_manage_setting_working_mode()
all_working_mode = self.assert_text2.dev_manage_setting_all_working_mode()
template_manage = self.assert_text.command_manager_page_work_type_template_management()
working_mode_task_manage = self.assert_text2.comm_manage_send_working_mode_task_manage()
working_mode_manage = self.assert_text2.comm_manage_send_working_mode_manage()
task_manage = self.assert_text2.comm_manage_command_task_manage()
comm_manager = self.assert_text.command_manager_page_issued_command_manager()
command_list = []
working_mode_list = []
# 循环设备管理页面的数据
for b in facility_manage_data:
# 选中发送指令 和 本次查询全部发送指令
if send_command in b or all_send_command in b:
command_list.append(b)
# 选中设置工作模式 和 本次查询全部设置工作模式
elif working_mode in b or all_working_mode in b:
working_mode_list.append(b)
# 循环指令管理页面的数据
'''for c in command_manage_data:
# 下发指令任务管理 和 下发指令管理
if task_manage in c or comm_manager in c:
command_list.append(c)
# 工作模式模板管理, 下发工作模式任务管理, 下发工作模式管理
elif template_manage in c or working_mode_task_manage in c or working_mode_manage in c:
working_mode_list.append(c)'''
print("指令", command_list)
print("工作模式", working_mode_list)
# 验证设备、指令管理页面功能按钮
if command_status == True and working_mode_status == True:
# 指令（设备页+指令管理页）
self.assertEqual(send_command, command_list[0])
self.assertEqual(all_send_command, command_list[1])
self.assertEqual(task_manage, command_list[2])
self.assertEqual(comm_manager, command_list[3])
# 工作模式（设备页+指令管理页）
self.assertEqual(working_mode, working_mode_list[0])
self.assertEqual(all_working_mode, working_mode_list[1])
self.assertEqual(template_manage, working_mode_list[2])
self.assertEqual(working_mode_task_manage, working_mode_list[3])
self.assertEqual(working_mode_manage, working_mode_list[4])
elif command_status == False and working_mode_status == False:
# self.assertEqual(comm_manager, command_list[0])
self.assertEqual(0, len(working_mode_list))
elif command_status == True and working_mode_status == False:
self.assertEqual(send_command, command_list[0])
self.assertEqual(all_send_command, command_list[1])
self.assertEqual(task_manage, command_list[2])
self.assertEqual(comm_manager, command_list[3])
self.assertEqual(0, len(working_mode_list))
elif command_status == False and working_mode_status == True:
self.assertEqual(comm_manager, command_list[0])
self.assertEqual(working_mode, working_mode_list[0])
self.assertEqual(all_working_mode, working_mode_list[1])
self.assertEqual(template_manage, working_mode_list[2])
self.assertEqual(working_mode_task_manage, working_mode_list[3])
self.assertEqual(working_mode_manage, working_mode_list[4])
sleep(1)
self.account_center_page_navi_bar.usr_logout()
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(info["account"])
# 搜索
self.cust_manage_lower_account_page.click_search_btn()
# 删除该新增客户
self.cust_manage_lower_account_page.delete_acc()
self.cust_manage_lower_account_page.delete_acc_ensure()
# 获取删除操作状态
del_status = self.cust_manage_lower_account_page.get_del_status()
self.assertIn(self.assert_text.account_center_page_operation_done(), del_status, "操作失败")
# 退出登录
sleep(1)
self.account_center_page_navi_bar.usr_logout()
csv_file.close()
class TestCase403CustomerManagementAddUser(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_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.assert_text2 = AssertText2()
self.search_sql = SearchSql()
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.close_window()
self.driver.quit_browser()
def test_cust_manage_add_acc(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_basic_info_and_add_cust_page.add_acc()
self.cust_manage_basic_info_and_add_cust_page.close_add_account()
csv_file = self.cust_manage_page_read_csv.read_csv('acc_add.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
add_info = {
"keyword": row[0],
"acc_type": row[1],
"acc_name": row[2],
"account": row[3],
"passwd": row[4],
"phone": row[5],
"email": row[6],
"conn": row[7],
"com": row[8],
"search_user": row[9]
}
# 左侧客户列表搜索并选中唯一客户
self.cust_manage_cust_list_page.acc_exact_search(
add_info["keyword"])
# 点击新增用户
self.cust_manage_basic_info_and_add_cust_page.add_acc()
sleep(2)
# 验证所选中的上级用户类型来显示可创建的下级类型
user_list = add_info["search_user"].split("/")
for type in user_list:
self.cust_manage_basic_info_and_add_cust_page.acc_search(type)
type_list = self.cust_manage_basic_info_and_add_cust_page.get_acc_user_type_list(
)
sql_data = self.search_sql.search_current_account_data(type)
user_type = self.assert_text.log_in_page_account_type(
sql_data[2])
print(user_type)
if user_type == "销售":
self.assertEqual(3, type_list["length"])
self.assertIn(
self.assert_text.log_in_page_account_type(11),
type_list["sale"])
self.assertIn(self.assert_text.log_in_page_account_type(8),
type_list["distributor"])
self.assertIn(self.assert_text.log_in_page_account_type(9),
type_list["user"])
elif user_type == "代理商":
self.assertEqual(2, type_list["length"])
self.assertIn(self.assert_text.log_in_page_account_type(8),
type_list["distributor"])
self.assertIn(self.assert_text.log_in_page_account_type(9),
type_list["user"])
elif user_type == "用户":
self.assertNotEqual(1, type_list["length"])
# self.assertIn(self.assert_text.log_in_page_account_type(9),type_list["user"])
sleep(1)
# 添加用户类型获取提示
self.cust_manage_basic_info_and_add_cust_page.acc_search(
"yonghu222")
sleep(2)
self.cust_manage_basic_info_and_add_cust_page.locate_to_iframe()
self.driver.default_frame()
# 右侧搜索栏中搜索并选中作为上级用户
self.cust_manage_basic_info_and_add_cust_page.acc_search(
add_info["keyword"])
# 选择客户类型
self.cust_manage_basic_info_and_add_cust_page.locate_to_iframe()
self.cust_manage_basic_info_and_add_cust_page.acc_type_choose(
add_info["acc_type"])
# 编辑用户输入框信息
self.cust_manage_basic_info_and_add_cust_page.add_acc_input_info_edit(
add_info["acc_name"], add_info["account"], add_info["passwd"],
add_info["phone"], add_info["email"], add_info["conn"],
add_info["com"])
# 修改用户登录权限
self.cust_manage_basic_info_and_add_cust_page.acc_login_limit_modi(
)
self.driver.default_frame()
self.cust_manage_basic_info_and_add_cust_page.acc_add_save()
# 获取保存操作状态
status = self.cust_manage_basic_info_and_add_cust_page.acc_info_save_status(
)
# 验证是否操作成功
self.assertIn(
self.assert_text.account_center_page_operation_done(), status,
"操作失败")
# 搜索新增客户
sleep(4)
self.cust_manage_lower_account_page.input_search_info(
add_info["account"])
# 搜索
self.cust_manage_lower_account_page.click_search_btn()
# 删除该新增客户
self.cust_manage_lower_account_page.delete_acc()
# 确定删除
self.cust_manage_lower_account_page.delete_acc_ensure()
# 获取删除操作状态
del_status = self.cust_manage_lower_account_page.get_del_status()
# 验证是否操作成功
self.assertIn(
self.assert_text.account_center_page_operation_done(),
del_status, "操作失败")
csv_file.close()
class TestCase407CustomerManagementOperationEditUser(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_edit_user(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)
csv_file = self.cust_manage_page_read_csv.read_csv(
'edit_user_data.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
info = {
"user_name": row[0],
"phone": row[1],
"email": row[2],
"conn": row[3],
"com": row[4]
}
# 搜索一个客户
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(
)
user_type = self.cust_manage_basic_info_and_add_cust_page.get_user_type_in_customer_page(
)
user_name = self.cust_manage_basic_info_and_add_cust_page.get_user_name_in_customer_page(
)
user_phone = self.cust_manage_basic_info_and_add_cust_page.get_user_phone_in_customer_page(
)
user_contact = self.cust_manage_basic_info_and_add_cust_page.get_user_contact_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(
)
self.cust_manage_basic_info_and_add_cust_page.locate_to_iframe()
self.cust_manage_basic_info_and_add_cust_page.add_data_to_edit_user(
info)
# 点击取消
self.driver.default_frame()
self.cust_manage_basic_info_and_add_cust_page.click_cancel_edit()
user_account_01 = self.cust_manage_basic_info_and_add_cust_page.get_user_account_in_customer_page(
)
user_type_01 = self.cust_manage_basic_info_and_add_cust_page.get_user_type_in_customer_page(
)
user_name_01 = self.cust_manage_basic_info_and_add_cust_page.get_user_name_in_customer_page(
)
user_phone_01 = self.cust_manage_basic_info_and_add_cust_page.get_user_phone_in_customer_page(
)
user_contact_01 = self.cust_manage_basic_info_and_add_cust_page.get_user_contact_in_customer_page(
)
self.assertEqual(user_account, user_account_01)
self.assertEqual(user_type, user_type_01)
self.assertEqual(user_name, user_name_01)
self.assertEqual(user_phone, user_phone_01)
self.assertEqual(user_contact, user_contact_01)
# 点击编辑 - 取消
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.add_data_to_edit_user(
info)
# 点击关闭
self.driver.default_frame()
self.cust_manage_basic_info_and_add_cust_page.click_close_edit_accunt_button(
)
user_account_02 = self.cust_manage_basic_info_and_add_cust_page.get_user_account_in_customer_page(
)
user_type_02 = self.cust_manage_basic_info_and_add_cust_page.get_user_type_in_customer_page(
)
user_name_02 = self.cust_manage_basic_info_and_add_cust_page.get_user_name_in_customer_page(
)
user_phone_02 = self.cust_manage_basic_info_and_add_cust_page.get_user_phone_in_customer_page(
)
user_contact_02 = self.cust_manage_basic_info_and_add_cust_page.get_user_contact_in_customer_page(
)
self.assertEqual(user_account, user_account_02)
self.assertEqual(user_type, user_type_02)
self.assertEqual(user_name, user_name_02)
self.assertEqual(user_phone, user_phone_02)
self.assertEqual(user_contact, user_contact_02)
# 点击编辑 - 取消
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.add_data_to_edit_user(
info)
# 点击关闭
self.driver.default_frame()
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
user_account_03 = self.cust_manage_basic_info_and_add_cust_page.get_user_account_in_customer_page(
)
user_type_03 = self.cust_manage_basic_info_and_add_cust_page.get_user_type_in_customer_page(
)
user_name_03 = self.cust_manage_basic_info_and_add_cust_page.get_user_name_in_customer_page(
)
user_phone_03 = self.cust_manage_basic_info_and_add_cust_page.get_user_phone_in_customer_page(
)
user_contact_03 = self.cust_manage_basic_info_and_add_cust_page.get_user_contact_in_customer_page(
)
self.assertEqual(user_account, user_account_03)
self.assertEqual(user_type, user_type_03)
self.assertEqual(info['user_name'], user_name_03)
self.assertEqual(info['phone'], user_phone_03)
self.assertEqual(info['conn'], user_contact_03)
csv_file.close()
class TestCase415CustomerManagementEditUserResetPassword(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_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_reset_password(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 进入客户管理页面
sleep(2)
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)
account = "bbb123"
# 搜索一个客户
self.cust_manage_lower_account_page.input_search_info(account)
# 搜索
self.cust_manage_lower_account_page.click_search_btn()
# 点击重置密码
self.cust_manage_basic_info_and_add_cust_page.click_reset_password_button(
)
# 点击取消
self.cust_manage_basic_info_and_add_cust_page.click_cancel_edit()
# 退出登录
self.account_center_page_navi_bar.usr_logout()
self.log_in_base.log_in_with_csv(account, 'jimi123')
sleep(2)
hello_usr = self.account_center_page_navi_bar.usr_info_account()
self.assertIn(account, hello_usr)
# 退出登录
self.account_center_page_navi_bar.usr_logout()
# 登录
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(account)
# 搜索
self.cust_manage_lower_account_page.click_search_btn()
# 点击重置密码
self.cust_manage_basic_info_and_add_cust_page.click_reset_password_button(
)
# 点击取消
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(account, '888888')
# 输入新的密码 ，
self.cust_manage_basic_info_and_add_cust_page.click_new_password(
'jimi123')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
self.cust_manage_basic_info_and_add_cust_page.click_ensuress()
sleep(4)
self.log_in_base.log_in_with_csv(account, 'jimi123')
sleep(2)
hello_usr = self.account_center_page_navi_bar.usr_info_account()
self.assertIn(account, hello_usr)
# 退出登录
self.account_center_page_navi_bar.usr_logout()
class TestCase414CustomerManagementEditDelete(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_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_delete(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()
user_type = self.cust_manage_basic_info_and_add_cust_page.get_user_type_in_customer_page()
user_name = self.cust_manage_basic_info_and_add_cust_page.get_user_name_in_customer_page()
user_phone = self.cust_manage_basic_info_and_add_cust_page.get_user_phone_in_customer_page()
user_contact = self.cust_manage_basic_info_and_add_cust_page.get_user_contact_in_customer_page()
# 点击删除
self.cust_manage_basic_info_and_add_cust_page.click_delete_user_button()
# 点击取消
self.cust_manage_basic_info_and_add_cust_page.click_cancel_edit()
user_account_01 = self.cust_manage_basic_info_and_add_cust_page.get_user_account_in_customer_page()
user_type_01 = self.cust_manage_basic_info_and_add_cust_page.get_user_type_in_customer_page()
user_name_01 = self.cust_manage_basic_info_and_add_cust_page.get_user_name_in_customer_page()
user_phone_01 = self.cust_manage_basic_info_and_add_cust_page.get_user_phone_in_customer_page()
user_contact_01 = self.cust_manage_basic_info_and_add_cust_page.get_user_contact_in_customer_page()
self.assertEqual(user_account, user_account_01)
self.assertEqual(user_type, user_type_01)
self.assertEqual(user_name, user_name_01)
self.assertEqual(user_phone, user_phone_01)
self.assertEqual(user_contact, user_contact_01)
# 点击删除
self.cust_manage_basic_info_and_add_cust_page.click_delete_user_button()
# 点击取消
self.cust_manage_basic_info_and_add_cust_page.click_close_edit_accunt_button()
user_account_02 = self.cust_manage_basic_info_and_add_cust_page.get_user_account_in_customer_page()
user_type_02 = self.cust_manage_basic_info_and_add_cust_page.get_user_type_in_customer_page()
user_name_02 = self.cust_manage_basic_info_and_add_cust_page.get_user_name_in_customer_page()
user_phone_02 = self.cust_manage_basic_info_and_add_cust_page.get_user_phone_in_customer_page()
user_contact_02 = self.cust_manage_basic_info_and_add_cust_page.get_user_contact_in_customer_page()
self.assertEqual(user_account, user_account_02)
self.assertEqual(user_type, user_type_02)
self.assertEqual(user_name, user_name_02)
self.assertEqual(user_phone, user_phone_02)
self.assertEqual(user_contact, user_contact_02)
class TestCase404CustomerManagementAddAUserWebLimit(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_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_add_user_web_limit_verify(self):
'''测试客户管理-web权限验证'''
self.base_page.open_page()
csv_file = self.cust_manage_page_read_csv.read_csv(
'add_user_web_limit_data.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
info = {
"keyword": row[0],
"type": row[1],
"name": row[2],
"account": row[3],
"passwd": row[4],
"phone": row[5],
"email": row[6],
"conn": row[7],
"com": row[8],
"web_setting": row[9],
"app_setting": row[10]
}
# 登录
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_basic_info_and_add_cust_page.add_acc()
self.cust_manage_basic_info_and_add_cust_page.close_add_account()
self.cust_manage_basic_info_and_add_cust_page.add_acc()
self.cust_manage_basic_info_and_add_cust_page.locate_to_iframe()
self.cust_manage_basic_info_and_add_cust_page.add_acc_input_info_edit(
info["name"], info["account"], info["passwd"], info["phone"],
info["email"], info["conn"], info["com"])
# 是或否勾选web和app登录权限
web_status = self.cust_manage_basic_info_and_add_cust_page.setting_web_login_permissions(
info["web_setting"])
app_status = self.cust_manage_basic_info_and_add_cust_page.setting_app_login_permissions(
info["app_setting"])
self.assertEqual(info["web_setting"], str(web_status),
"勾选状态与期望不一致")
self.assertEqual(info["app_setting"], str(app_status),
"勾选状态与期望不一致")
self.driver.default_frame()
sleep(2)
self.cust_manage_basic_info_and_add_cust_page.acc_add_save()
sleep(1)
self.account_center_page_navi_bar.usr_logout()
# 没有web登录权限验证
if web_status == False:
self.log_in_base.log_in_with_csv(info["account"],
info["passwd"])
self.assertEqual(self.assert_text2.login_no_permissions(),
self.login_page.get_exception_text(),
"没有获取到没有权限登录的提示")
# 有web登录权限验证
elif web_status == True:
self.log_in_base.log_in_with_csv(info["account"],
info["passwd"])
sleep(2)
hello_usr = self.account_center_page_navi_bar.usr_info_account(
)
self.assertIn(info["account"], hello_usr, "登录成功后招呼栏账户名显示错误")
sleep(1)
self.log_in_base.click_account_center_button()
self.account_center_page_navi_bar.usr_logout()
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(
info["account"])
# 搜索
self.cust_manage_lower_account_page.click_search_btn()
# 删除该新增客户
self.cust_manage_lower_account_page.delete_acc()
self.cust_manage_lower_account_page.delete_acc_ensure()
# 获取删除操作状态
del_status = self.cust_manage_lower_account_page.get_del_status()
self.assertIn(
self.assert_text.account_center_page_operation_done(),
del_status, "操作失败")
# 退出登录
sleep(1)
self.account_center_page_navi_bar.usr_logout()
csv_file.close()
class TestCase408CustomerManagementAddUserExpection(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.close_window()
self.driver.quit_browser()
def test_customer_management_add_user_exception(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_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()
# 验证上级客户input的属性是否为readonly
readonly_value = self.cust_manage_basic_info_and_add_cust_page.get_up_account_value(
)
self.assertEqual('true', readonly_value)
# 验证新增客户的名称
# 1 为空
self.cust_manage_basic_info_and_add_cust_page.add_account_name('')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
text = self.cust_manage_basic_info_and_add_cust_page.get_add_account_name_exception_text(
)
self.assertEqual(self.assert_text.cust_page_user_name_not_null(), text)
# 2 长度小于三位
self.cust_manage_basic_info_and_add_cust_page.add_account_name('1')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
text = self.cust_manage_basic_info_and_add_cust_page.get_add_account_name_exception_text(
)
self.assertEqual(self.assert_text.cust_page_user_name_more_than_3(),
text)
# 3 验证最大长度
max_len = self.cust_manage_basic_info_and_add_cust_page.get_account_name_max_len(
)
self.assertEqual('50', max_len)
# 验证新增客户账号
# 1 为空
self.cust_manage_basic_info_and_add_cust_page.add_account('')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
text = self.cust_manage_basic_info_and_add_cust_page.get_add_account_exception_text(
)
self.assertEqual(self.assert_text.cust_page_user_account_not_null(),
text)
# 2 长度小于3位
self.cust_manage_basic_info_and_add_cust_page.add_account('1')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
text = self.cust_manage_basic_info_and_add_cust_page.get_add_account_exception_text(
)
self.assertEqual(self.assert_text.cust_page_user_account_len(), text)
# 3 验证最大长度
account_max_len = self.cust_manage_basic_info_and_add_cust_page.get_account_max_len(
)
self.assertEqual('30', account_max_len)
# 验证密码
# 1 为空
self.cust_manage_basic_info_and_add_cust_page.add_password_first('')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
get_password_first_text = self.cust_manage_basic_info_and_add_cust_page.get_text_first_password(
)
self.assertEqual(self.assert_text.cust_page_user_password_not_null(),
get_password_first_text)
# 2 小于6位
self.cust_manage_basic_info_and_add_cust_page.add_password_first('12e')
self.cust_manage_basic_info_and_add_cust_page.add_password_second(
'12e')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
get_password_first_text = self.cust_manage_basic_info_and_add_cust_page.get_text_first_password(
)
self.assertEqual(self.assert_text.cust_page_user_password_len(),
get_password_first_text)
# 3 全字母
self.cust_manage_basic_info_and_add_cust_page.add_password_first(
'abcdefg')
self.cust_manage_basic_info_and_add_cust_page.add_password_second(
'abcdefg')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
get_password_first_text = self.cust_manage_basic_info_and_add_cust_page.get_text_first_password(
)
self.assertEqual(self.assert_text.cust_page_user_password_formate(),
get_password_first_text)
# 4 全数字
self.cust_manage_basic_info_and_add_cust_page.add_password_first(
'123456')
self.cust_manage_basic_info_and_add_cust_page.add_password_second(
'123456')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
get_password_first_text = self.cust_manage_basic_info_and_add_cust_page.get_text_first_password(
)
self.assertEqual(self.assert_text.cust_page_user_password_formate(),
get_password_first_text)
# 5 只输入确认密码
self.cust_manage_basic_info_and_add_cust_page.add_password_first('')
self.cust_manage_basic_info_and_add_cust_page.add_password_second(
'a123456')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
get_password_first_text = self.cust_manage_basic_info_and_add_cust_page.get_text_second_password(
)
self.assertEqual(self.assert_text.cust_page_password_unlike(),
get_password_first_text)
# 6两次密码不一致
self.cust_manage_basic_info_and_add_cust_page.add_password_first(
'123456ee')
self.cust_manage_basic_info_and_add_cust_page.add_password_second(
'123456ff')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
get_password_first_text = self.cust_manage_basic_info_and_add_cust_page.get_text_second_password(
)
self.assertEqual(self.assert_text.cust_page_password_unlike(),
get_password_first_text)
# 验证电话、邮箱、联系人、公司名的最大长度
phone_max_len = self.cust_manage_basic_info_and_add_cust_page.get_phone_max_len(
)
self.assertEqual('20', phone_max_len)
email_max_len = self.cust_manage_basic_info_and_add_cust_page.get_email_max_len(
)
self.assertEqual('50', email_max_len)
# 验证邮箱格式
self.cust_manage_basic_info_and_add_cust_page.add_email_format(
'123123')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
get_text_email = self.cust_manage_basic_info_and_add_cust_page.get_text_email_text(
)
self.assertEqual(self.assert_text.cust_page_user_email_formate_error(),
get_text_email)
connect_max_len = self.cust_manage_basic_info_and_add_cust_page.get_connect_max_len(
)
self.assertEqual('50', connect_max_len)
comp_max_len = self.cust_manage_basic_info_and_add_cust_page.get_comp_max_len(
)
self.assertEqual('50', comp_max_len)
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 TestCase412CustomerManagementEditUserSendWorkTemplateLimit(
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_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_send_work_template_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(
)
# 获取批量下发指令的状态
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_send_work_template_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_send_work_template_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')
# 进入设备管理 获取设备管理页面操的文本
current_handle_01 = self.driver.get_current_window_handle()
self.cust_manage_basic_info_and_add_cust_page.click_dev_management_button(
)
self.base_page.change_windows_handle(current_handle_01)
dev_operation_text = self.cust_manage_basic_info_and_add_cust_page.get_facility_manage_page_function_button(
)
working_mode = self.assert_text2.dev_manage_setting_working_mode()
all_working_mode = self.assert_text2.dev_manage_setting_all_working_mode(
)
self.assertNotIn(working_mode, dev_operation_text)
self.assertNotIn(all_working_mode, dev_operation_text)
# 登录
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_send_work_template_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)
# 进入设备管理 获取设备管理页面操的文本
current_handle_03 = self.driver.get_current_window_handle()
self.cust_manage_basic_info_and_add_cust_page.click_dev_management_button(
)
self.base_page.change_windows_handle(current_handle_03)
dev_operation_text = self.cust_manage_basic_info_and_add_cust_page.get_facility_manage_page_function_button(
)
working_mode = self.assert_text2.dev_manage_setting_working_mode()
all_working_mode = self.assert_text2.dev_manage_setting_all_working_mode(
)
self.assertIn(working_mode, dev_operation_text)
self.assertIn(all_working_mode, dev_operation_text)
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_send_work_template_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)
# 进入设备管理 获取设备管理页面操的文本
current_handle_04 = self.driver.get_current_window_handle()
self.cust_manage_basic_info_and_add_cust_page.click_dev_management_button(
)
self.base_page.change_windows_handle(current_handle_04)
dev_operation_text = self.cust_manage_basic_info_and_add_cust_page.get_facility_manage_page_function_button(
)
working_mode = self.assert_text2.dev_manage_setting_working_mode()
all_working_mode = self.assert_text2.dev_manage_setting_all_working_mode(
)
self.assertIn(working_mode, dev_operation_text)
self.assertIn(all_working_mode, dev_operation_text)
# 退出登录
self.account_center_page_navi_bar.usr_logout()
self.log_in_base.log_in()
current_handle_05 = 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_05)
# 搜索一个客户
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_send_work_template_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')
# 进入设备管理 获取设备管理页面操的文本
current_handle_06 = self.driver.get_current_window_handle()
self.cust_manage_basic_info_and_add_cust_page.click_dev_management_button(
)
self.base_page.change_windows_handle(current_handle_06)
dev_operation_text = self.cust_manage_basic_info_and_add_cust_page.get_facility_manage_page_function_button(
)
working_mode = self.assert_text2.dev_manage_setting_working_mode()
all_working_mode = self.assert_text2.dev_manage_setting_all_working_mode(
)
self.assertNotIn(working_mode, dev_operation_text)
self.assertNotIn(all_working_mode, dev_operation_text)
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 TestCase409CustomerManagementEditUserExpection(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.close_window()
self.driver.quit_browser()
def test_customer_management_add_user_exception(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()
# 点击编辑 - 取消
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(
)
# 验证上级客户input的属性是否为readonly
readonly_value = self.cust_manage_basic_info_and_add_cust_page.get_up_account_value(
)
self.assertEqual('true', readonly_value)
# 验证新增客户的名称
# 1 为空
self.cust_manage_basic_info_and_add_cust_page.add_account_name('')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
text = self.cust_manage_basic_info_and_add_cust_page.get_add_account_name_exception_text(
)
self.assertEqual(self.assert_text.cust_page_user_name_not_null(), text)
# 2 长度小于三位
self.cust_manage_basic_info_and_add_cust_page.add_account_name('1')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
text = self.cust_manage_basic_info_and_add_cust_page.get_add_account_name_exception_text(
)
self.assertEqual(self.assert_text.cust_page_user_name_more_than_3(),
text)
# 3 验证最大长度
max_len = self.cust_manage_basic_info_and_add_cust_page.get_account_name_max_len(
)
self.assertEqual('50', max_len)
# 验证电话、邮箱、联系人、公司名的最大长度
phone_max_len = self.cust_manage_basic_info_and_add_cust_page.get_phone_max_len(
)
self.assertEqual('20', phone_max_len)
email_max_len = self.cust_manage_basic_info_and_add_cust_page.get_email_max_len(
)
self.assertEqual('50', email_max_len)
# 验证邮箱格式
self.cust_manage_basic_info_and_add_cust_page.add_email_format(
'123123')
self.cust_manage_basic_info_and_add_cust_page.click_ensure()
get_text_email = self.cust_manage_basic_info_and_add_cust_page.get_text_email_text(
)
self.assertEqual(self.assert_text.cust_page_user_email_formate_error(),
get_text_email)
connect_max_len = self.cust_manage_basic_info_and_add_cust_page.get_connect_max_len(
)
self.assertEqual('50', connect_max_len)
comp_max_len = self.cust_manage_basic_info_and_add_cust_page.get_comp_max_len(
)
self.assertEqual('50', comp_max_len)
