class TestCase06UserManageDeleteUser(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.login_page = LoginPage(self.driver, self.base_url)
self.user_center = UserCenter(self.driver, self.base_url)
self.user_management = UserManagement(self.driver, self.base_url)
self.log_in_page_read_csv = LogInPageReadCsv()
self.user_center_read_csv = UserCenterReadCsv()
self.user_management_read_csv = UserManagementReadCsv()
self.driver.set_window_max()
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_delete_user(self):
# 通过csv测试删除用户功能
csv_file = self.user_management_read_csv.read_csv('delete_user.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
delete_user = {
"account": row[0],
"passwd": row[1],
"delete_user_name": row[2],
}
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.user_login(delete_user['account'],
delete_user['passwd'])
# 点击进入角色管理
self.user_management.click_user_manage()
# 按名称查找角色
self.user_management.search_user(delete_user['delete_user_name'])
# 点击删除
self.user_management.click_delete_user()
# 跳出frame
self.user_management.switch_to_default_content()
# 点击取消
self.user_management.delete_user_dismiss()
# 切入frame
self.user_management.switch_to_1_frame()
# 点击删除
self.user_management.click_delete_user()
# 跳出frame
self.user_management.switch_to_default_content()
# 点击关闭
self.user_management.delete_user_close()
# 切入frame
self.user_management.switch_to_1_frame()
# 点击删除
self.user_management.click_delete_user()
# 跳出frame
self.user_management.switch_to_default_content()
# 点击确认
self.user_management.delete_user_accept()
# 数据库查找验证部门是否删除成功
# 数据库查找角色
user_name_after_delete = self.user_management.get_search_result_username_by_sql(
delete_user['account'], '')
self.assertNotIn(delete_user['delete_user_name'],
user_name_after_delete)
# 退出登录
self.user_center.logout()
csv_file.close()
class TestCase05UserManageSearchUser(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.login_page = LoginPage(self.driver, self.base_url)
self.user_center = UserCenter(self.driver, self.base_url)
self.user_management = UserManagement(self.driver, self.base_url)
self.log_in_page_read_csv = LogInPageReadCsv()
self.user_center_read_csv = UserCenterReadCsv()
self.user_management_read_csv = UserManagementReadCsv()
self.driver.set_window_max()
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_search_user(self):
# 通过csv测试搜索用户功能
csv_file = self.user_management_read_csv.read_csv('search_user.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
search_user = {
"account": row[0],
"password": row[1],
"search_name": row[2],
}
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.user_login(search_user['account'],
search_user['password'])
# 判断登录成功后招呼栏的用户名是否正确
username = self.user_center.get_username()
# 从数据库获取登录账号的用户名
account_info = self.user_center.get_account_info_by_sql(
search_user['account'])
print(account_info)
account_name = account_info[1]
self.assertEqual(account_name, username, '登录成功后招呼栏的用户名错误')
# 点击进入用户管理
self.user_management.click_user_manage()
# 输入搜索关键词进行搜索
self.user_management.search_user(search_user['search_name'])
# 获取搜索结果
num = int(self.user_management.get_search_result_num())
user_name = self.user_management.get_search_result_all()
# 数据库查询搜索结果
user_name_by_sql = self.user_management.get_search_result_username_by_sql(
search_user['account'], search_user['search_name'])
num_by_sql = self.user_management.get_search_result_num_by_sql(
search_user['account'], search_user['search_name'])
# 验证搜索结果是否一致
self.assertEqual(num, num_by_sql)
self.assertEqual(set(user_name), set(user_name_by_sql))
# 跳出外层frame
self.user_management.switch_to_default_content()
# 退出登录
self.user_center.logout()
csv_file.close()