class TestCase100GlobAccountSearch(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.global_dev_search_page = GlobalDevSearchPage(self.driver, self.base_url) self.account_center_page_navi_bar = AccountCenterNaviBarPages(self.driver, self.base_url) self.driver.set_window_max() self.global_account_search_page = GlobalAccountSearchPage(self.driver, self.base_url) self.log_in_base = LogInBase(self.driver, self.base_url) self.global_search_page_read_csv = GlobleSearchPageReadCsv() self.search_sql = SearchSql() self.driver.wait(1) self.connect_sql = ConnectSql() self.driver.clear_cookies() self.driver.wait(1) def tearDown(self): self.driver.quit_browser() def test_global_account_search(self): # 打开途强在线首页-登录页 self.base_page.open_page() self.log_in_base.log_in() self.log_in_base.click_account_center_button() current_account = self.log_in_base.get_log_in_account() self.global_dev_search_page.click_easy_search() # 关闭 self.global_dev_search_page.close_search() sleep(2) self.global_dev_search_page.click_easy_search() # self.global_dev_search_page.click_account_search() # 度数据 csv_file = self.global_search_page_read_csv.read_csv('global_search_account_data.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_info': row[0] } self.global_dev_search_page.swith_to_search_frame() self.global_dev_search_page.account_easy_search(search_data) connect = self.connect_sql.connect_tuqiang_sql() # 创建数据库游标 cur = connect.cursor() # 执行sql脚本查询当前登录账号的userId,fullParent get_id_sql = "select o.account,o.userId,o.fullParentId from user_info o where o.account = '" + current_account + "' ;" cur.execute(get_id_sql) # 读取数据 user_relation = cur.fetchall() # 遍历数据 for row in user_relation: user_relation_id = { "account": row[0], "userId": row[1], "fullParent": row[2] } # 执行sql脚本,根据当前登录账号的userId,fullParent查询出当前账户的所有下级账户 get_lower_account_sql = "select userId from user_info where fullParentId like" + \ "'" + user_relation_id["fullParent"] + user_relation_id["userId"] + "%'" + ";" cur.execute(get_lower_account_sql) # 读取数据 lower_account = cur.fetchall() lower_account_list = [user_relation_id["userId"]] for range1 in lower_account: for range2 in range1: lower_account_list.append(range2) lower_account_tuple = tuple(lower_account_list) get_total_sql = self.search_sql.search_account_sqls(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.global_account_search_page.easy_search_results() print('本次查询页面的条数是:%s' % web_total) self.assertEqual(total, web_total) self.driver.default_frame() cur.close() connect.close() csv_file.close() self.global_dev_search_page.close_search()
class TestCase102GlobComplexSearchByAllCondi(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.global_dev_search_page = GlobalDevSearchPage( self.driver, self.base_url) self.account_center_page_navi_bar = AccountCenterNaviBarPages( self.driver, self.base_url) self.driver.set_window_max() self.global_account_search_page = GlobalAccountSearchPage( self.driver, self.base_url) self.log_in_base = LogInBase(self.driver, self.base_url) self.global_search_page_read_csv = GlobleSearchPageReadCsv() self.search_sql = SearchSql() self.global_complex_search_page = GlobalComplexSearchPage( self.driver, self.base_url) self.driver.wait(1) self.connect_sql = ConnectSql() self.driver.clear_cookies() self.driver.wait(1) def tearDown(self): self.driver.quit_browser() def test_glob_complex_search_complex_search(self): # 打开途强在线首页-登录页 self.base_page.open_page() # 登录 self.log_in_base.log_in() self.log_in_base.click_account_center_button() # 点击全局搜索栏-高级搜素按钮 # 关闭 self.global_dev_search_page.click_easy_search() self.global_dev_search_page.close_search() sleep(2) self.global_dev_search_page.click_easy_search() # self.global_dev_search_page.click_dev_searchs() self.global_dev_search_page.click_senior_search_button() csv_file = self.global_search_page_read_csv.read_csv( 'complex_search_data.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], 'base_info': row[1], 'info': row[2], 'date_type': row[3], 'date': row[4], 'is_date': row[5], 'arrearage': row[6], 'no_active': row[7] } self.global_dev_search_page.swith_to_search_frame() self.global_dev_search_page.add_data_to_search_complex(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] } get_total_sql = self.search_sql.search_complex_sql( user_relation_id['userId'], 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.global_dev_search_page.easy_search_result() print('本次查询页面的条数是:%s' % web_total) self.assertEqual(total, web_total) self.driver.default_frame() cur.close() connect.close() csv_file.close()
class TestCase128DevAdvancedSearchWithDeleteUser(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.global_dev_search_page = GlobalDevSearchPage( self.driver, self.base_url) self.account_center_page_navi_bar = AccountCenterNaviBarPages( self.driver, self.base_url) self.driver.set_window_max() self.global_account_search_page = GlobalAccountSearchPage( self.driver, self.base_url) self.log_in_base = LogInBase(self.driver, self.base_url) self.global_search_page_read_csv = GlobleSearchPageReadCsv() self.search_sql = SearchSql() self.driver.wait(1) self.connect_sql = ConnectSql() self.assert_text = AssertText() self.driver.clear_cookies() self.driver.wait(1) def tearDown(self): self.driver.quit_browser() def test_case_dev_advanced_search_with_delete_user(self): # 打开途强在线首页-登录页 self.base_page.open_page() self.log_in_base.log_in() self.global_account_search_page.click_cust_manager_button() csv_file = self.global_search_page_read_csv.read_csv( 'new_user_info.csv') csv_data = csv.reader(csv_file) is_header = True for row in csv_data: if is_header: is_header = False continue add_data = { 'account_type': row[0], 'account_name': row[1], 'account': row[2] } self.global_account_search_page.click_add_new_user_button() self.global_account_search_page.click_close_add_user_page() self.global_account_search_page.click_add_new_user_button() self.global_dev_search_page.swith_to_search_frames() self.global_account_search_page.add_data_to_add_new_user(add_data) # 删除 self.global_account_search_page.search_user_by_account_in_cust_manage( add_data['account']) self.log_in_base.click_account_center_button() self.global_dev_search_page.click_easy_search() # 关闭 self.global_dev_search_page.close_search() sleep(2) self.global_dev_search_page.click_easy_search() # 选择设备搜索--高级搜索 self.global_dev_search_page.swith_to_search_frame() self.global_dev_search_page.click_advanced_search_button() # 搜索已经删除的用户名称 self.global_dev_search_page.click_search_button_in_dev_advanced_search_page( ) # 输入删除的用户名称搜索 self.global_dev_search_page.add_user_name_to_search_in_dev_advanced_search_page( add_data['account']) get_text = self.global_dev_search_page.get_text_after_click_search_button_in_dev_advanced_search_page( ) self.assertIn(self.assert_text.account_center_page_no_data_text(), get_text) break csv_file.close()
class TestCase112UserSearchByDeleteUser(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.global_dev_search_page = GlobalDevSearchPage( self.driver, self.base_url) self.account_center_page_navi_bar = AccountCenterNaviBarPages( self.driver, self.base_url) self.driver.set_window_max() self.global_account_search_page = GlobalAccountSearchPage( self.driver, self.base_url) self.log_in_base = LogInBase(self.driver, self.base_url) self.global_search_page_read_csv = GlobleSearchPageReadCsv() self.search_sql = SearchSql() self.assert_text = AssertText() self.driver.wait(1) self.connect_sql = ConnectSql() self.driver.clear_cookies() self.driver.wait(1) def tearDown(self): self.driver.quit_browser() def test_user_search_by_delete_user(self): # 打开途强在线首页-登录页 self.base_page.open_page() self.log_in_base.log_in() # 分别新建 销售、代理商、用户并删除,然后搜索 # 点击客户管理 self.global_account_search_page.click_cust_manager_button() csv_file = self.global_search_page_read_csv.read_csv( 'new_user_info.csv') csv_data = csv.reader(csv_file) is_header = True for row in csv_data: if is_header: is_header = False continue add_data = { 'account_type': row[0], 'account_name': row[1], 'account': row[2] } self.global_account_search_page.click_add_new_user_button() self.global_account_search_page.click_close_add_user_page() self.global_account_search_page.click_add_new_user_button() self.global_dev_search_page.swith_to_search_frames() self.global_account_search_page.add_data_to_add_new_user(add_data) # 先搜索 self.global_account_search_page.click_global_search_button() self.global_account_search_page.click_close_add_user_page() self.global_account_search_page.click_global_search_button() self.global_dev_search_page.swith_to_search_frames() self.global_account_search_page.search_user_by_account_in_global_search( add_data['account']) get_user_account = self.global_account_search_page.get_user_account_after_search( ) self.assertEqual(get_user_account, add_data['account']) self.driver.default_frame() self.global_account_search_page.click_close_add_user_page() # 删除 self.global_account_search_page.search_user_by_account_in_cust_manage( add_data['account']) # 打开全局搜索,搜索用户 self.global_account_search_page.click_global_search_button() self.global_account_search_page.click_close_add_user_page() self.global_account_search_page.click_global_search_button() self.global_dev_search_page.swith_to_search_frames() self.global_account_search_page.search_user_by_account_in_global_search( add_data['account']) get_text = self.global_account_search_page.get_text_after_search() self.assertIn(self.assert_text.account_center_page_no_data_text(), get_text) self.driver.default_frame() self.global_account_search_page.click_close_add_user_page() csv_file.close()