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()