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)
class TestCase02UserManageAddUserException1(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)
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.test_user_login()
def tearDown(self):
self.driver.quit_browser()
def test_add_user_exception1(self):
# 通过csv测试新增用户功能异常情况
# 获取当前登录账户
log_in_account = self.user_center.get_login_account()
print(log_in_account)
csv_file = self.user_management_read_csv.read_csv('add_user_exception1.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
add_user_exception = {
"add_user_name": row[0],
"add_login_user": row[1],
"add_login_passwd": row[2],
"add_user_phone": row[3],
"add_user_role":row[4],
"exception_text": row[5],
}
# 点击进入用户管理
self.user_management.click_user_manage()
# 点击新增用户
self.user_management.click_add_user()
# 切入内层frame
self.user_management.switch_to_2_frame()
# 输入新增用户名
self.user_management.input_add_user_name(add_user_exception['add_user_name'])
# 输入登陆账号
self.user_management.input_add_login_user(add_user_exception['add_login_user'])
# 输入登录密码
self.user_management.input_add_login_passwd(add_user_exception['add_login_passwd'])
# 输入手机号码
self.user_management.input_add_user_phone(add_user_exception['add_user_phone'])
# 判断分配用户角色
if add_user_exception['add_user_role'] == '1':
self.user_management.input_add_user_role()
# 选择所属公司部门
self.user_management.choose_add_user_org()
# 点击保存按钮
self.user_management.click_add_user_save()
# 获取异常提示
text = self.user_management.get_add_user_exception1()
self.assertEqual(add_user_exception['exception_text'], text)
# 关闭新增用户框
self.user_management.click_add_user_close()
# 跳出最外层frame
self.user_management.switch_to_default_content()
# 从数据库查询验证新增失败
new_user_name = self.user_management.get_add_user_by_sql(log_in_account)
self.assertNotEqual(new_user_name, add_user_exception['add_user_name'])
self.driver.wait(1)
csv_file.close()
# 退出登录
self.user_center.logout()
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 TestCase01UserManageAddUser(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_add_user(self):
# 通过csv测试新增用户功能
csv_file = self.user_management_read_csv.read_csv('add_user.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
add_user = {
"account": row[0],
"password": row[1],
"add_user_name": row[2],
"add_login_user": row[3],
"add_login_passwd": row[4],
"add_user_phone": row[5],
}
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.user_login(add_user['account'], add_user['password'])
# 判断登录成功后招呼栏的用户名是否正确
username = self.user_center.get_username()
# 从数据库获取登录账号的用户名
account_info = self.user_center.get_account_info_by_sql(add_user['account'])
print(account_info)
account_name = account_info[1]
self.assertEqual(account_name, username, '登录成功后招呼栏的用户名错误')
# 点击进入用户管理
self.user_management.click_user_manage()
# 点击新增用户
self.user_management.click_add_user()
# 切入内层frame
self.user_management.switch_to_2_frame()
# 输入新增用户名
self.user_management.input_add_user_name(add_user['add_user_name'])
# 输入登陆账号
self.user_management.input_add_login_user(add_user['add_login_user'])
# 输入登录密码
self.user_management.input_add_login_passwd(add_user['add_login_passwd'])
# 输入手机号码
self.user_management.input_add_user_phone(add_user['add_user_phone'])
# 分配角色
self.user_management.input_add_user_role()
# 选择所属公司部门
self.user_management.choose_add_user_org()
# 点击取消
self.user_management.click_add_user_dismiss()
# 从数据库查询验证角色未创建成功
new_user_account_01 = self.user_management.get_add_user_by_sql(add_user['account'])
self.assertNotEqual(new_user_account_01, add_user['add_login_user'])
self.driver.wait(1)
# 点击新增用户
self.user_management.click_add_user()
# 切入内层frame
self.user_management.switch_to_2_frame()
# 输入新增用户名
self.user_management.input_add_user_name(add_user['add_user_name'])
# 输入登陆账号
self.user_management.input_add_login_user(add_user['add_login_user'])
# 输入登录密码
self.user_management.input_add_login_passwd(add_user['add_login_passwd'])
# 输入手机号码
self.user_management.input_add_user_phone(add_user['add_user_phone'])
# 分配角色
self.user_management.input_add_user_role()
# 选择所属公司部门
self.user_management.choose_add_user_org()
# 点击关闭按钮
self.user_management.click_add_user_close()
# 从数据库查询验证角色未创建成功
new_user_account_02 = self.user_management.get_add_user_by_sql(add_user['account'])
self.assertNotEqual(new_user_account_02, add_user['add_login_user'])
self.driver.wait(1)
# 点击新增用户
self.user_management.click_add_user()
# 切入内层frame
self.user_management.switch_to_2_frame()
# 输入新增用户名
self.user_management.input_add_user_name(add_user['add_user_name'])
# 输入登陆账号
self.user_management.input_add_login_user(add_user['add_login_user'])
# 输入登录密码
self.user_management.input_add_login_passwd(add_user['add_login_passwd'])
# 输入手机号码
self.user_management.input_add_user_phone(add_user['add_user_phone'])
# 分配角色
self.user_management.input_add_user_role()
# 选择所属公司部门
self.user_management.choose_add_user_org()
# 点击保存按钮
self.user_management.click_add_user_save()
# 跳出最外层frame
self.user_management.switch_to_default_content()
# 从数据库查询验证角色创建成功
new_add_account_03 = self.user_management.get_add_user_by_sql(add_user['account'])
self.assertEqual(new_add_account_03, add_user['add_login_user'])
self.driver.wait(1)
# 退出登录
self.user_center.logout()
csv_file.close()
class TestCase04UserManageEditUser(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_edit_user(self):
# 通过csv测试修改用户功能
csv_file = self.user_management_read_csv.read_csv('edit_user_info.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
edit_user_info = {
"account": row[0],
"password": row[1],
"search_key": row[2],
"edit_user_name": row[3],
"edit_user_phone": row[4],
}
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.user_login(edit_user_info['account'], edit_user_info['password'])
# 判断登录成功后招呼栏的用户名是否正确
username = self.user_center.get_username()
# 从数据库获取登录账号的用户名
account_info = self.user_center.get_account_info_by_sql(edit_user_info['account'])
print(account_info)
account_name = account_info[1]
self.assertEqual(account_name, username, '登录成功后招呼栏的用户名错误')
# 点击进入用户管理
self.user_management.click_user_manage()
# 查找用户testAddUser2
self.user_management.search_user(edit_user_info['search_key'])
# 获取页面查找结果
search_user_name_01 = self.user_management.get_search_result_one()
# 查询数据库获取搜索结果
user_info_00 = self.user_management.get_search_result_by_sql(edit_user_info['account'],
edit_user_info['search_key'])
user_name_00 = user_info_00[0]
user_tel_00 = user_info_00[1]
self.assertEqual(search_user_name_01, user_name_00)
# 点击修改
self.user_management.click_edit_user()
# 切入内层frame
self.user_management.switch_to_2_frame()
# 获取当前显示的用户名称是否与未修改前一致
current_user_name_01 = self.user_management.get_current_user_name()
self.assertEqual(search_user_name_01, current_user_name_01)
# 获取显示的用户手机号码是否与未修改前一致
current_user_tel_01 = self.user_management.get_current_user_tel()
self.assertEqual(user_tel_00, current_user_tel_01)
# 输入用户名称
self.user_management.input_add_user_name(edit_user_info['edit_user_name'])
# 输入用户手机号码
self.user_management.input_add_user_phone(edit_user_info['edit_user_phone'])
# 点击取消
self.user_management.click_add_user_dismiss()
# 数据库查询是否修改失败
user_info_01 = self.user_management.get_search_result_by_sql(edit_user_info['account'],
edit_user_info['search_key'])
user_name_01 = user_info_01[0]
user_tel_01 = user_info_01[1]
self.assertEqual(user_name_00, user_name_01)
self.assertEqual(user_tel_00, user_tel_01)
# 点击修改
self.user_management.click_edit_user()
# 切入内层frame
self.user_management.switch_to_2_frame()
# 获取当前显示的角色名称是否与未修改前一致
current_user_name_02 = self.user_management.get_current_user_name()
self.assertEqual(search_user_name_01, current_user_name_02)
# 获取显示的角色描述是否与未修改前一致
current_user_tel_02 = self.user_management.get_current_user_tel()
self.assertEqual(user_tel_00, current_user_tel_02)
# 输入用户名称
self.user_management.input_add_user_name(edit_user_info['edit_user_name'])
# 输入用户手机号码
self.user_management.input_add_user_phone(edit_user_info['edit_user_phone'])
# 点击关闭按钮
self.user_management.click_add_user_close()
# 数据库查询是否修改失败
user_info_02 = self.user_management.get_search_result_by_sql(edit_user_info['account'],
edit_user_info['search_key'])
user_name_02 = user_info_02[0]
user_tel_02 = user_info_02[1]
self.assertEqual(user_name_00, user_name_02)
self.assertEqual(user_tel_00, user_tel_02)
# 点击修改
self.user_management.click_edit_user()
# 切入内层frame
self.user_management.switch_to_2_frame()
# 获取当前显示的角色名称是否与未修改前一致
current_user_name_03 = self.user_management.get_current_user_name()
self.assertEqual(search_user_name_01, current_user_name_03)
# 获取显示的角色描述是否与未修改前一致
current_user_tel_03 = self.user_management.get_current_user_tel()
self.assertEqual(user_tel_00, current_user_tel_03)
# 输入用户名称
self.user_management.input_add_user_name(edit_user_info['edit_user_name'])
# 输入用户手机号码
self.user_management.input_add_user_phone(edit_user_info['edit_user_phone'])
# 点击保存按钮
self.user_management.click_add_user_save()
# 数据库查询是否修改成功
user_info_03 = self.user_management.get_search_result_by_sql(edit_user_info['account'],
edit_user_info['edit_user_name'])
user_name_03 = user_info_03[0]
user_tel_03 = user_info_03[1]
self.assertNotEqual(user_name_00, user_name_03)
self.assertNotEqual(user_tel_00, user_tel_03)
# 跳出外层frame
self.user_management.switch_to_default_content()
# 退出登录
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()