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.account_center_page_navi_bar = AccountCenterNaviBarPage( self.driver, self.base_url) self.account_center_page_details = AccountCenterDetailsPage( self.driver, self.base_url) self.account_center_page_refill_card = AccountCenterRefillCardPage( self.driver, self.base_url) self.log_in_base = LogInBaseServer(self.driver, self.base_page) self.account_center_page = AccountCenterPage(self.driver, self.base_url) self.search_sql = SearchSql() self.assert_text = AssertText() self.assert_text2 = AssertText2() self.driver.set_window_max() self.account_center_page_read_csv = AccountCenterPageReadCsv() self.log_in_base = LogInBaseServer(self.driver, self.base_page) self.driver.wait(1) self.driver.clear_cookies() self.driver.wait(1)
class TestCase51AccountCenterManageAndTelephoneAlarm(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.account_center_page_navi_bar = AccountCenterNaviBarPage( self.driver, self.base_url) self.account_center_page_details = AccountCenterDetailsPage( self.driver, self.base_url) self.account_center_page_refill_card = AccountCenterRefillCardPage( self.driver, self.base_url) self.log_in_base = LogInBaseServer(self.driver, self.base_page) self.account_center_page = AccountCenterPage(self.driver, self.base_url) self.search_sql = SearchSql() self.assert_text = AssertText() self.assert_text2 = AssertText2() self.driver.set_window_max() self.account_center_page_read_csv = AccountCenterPageReadCsv() self.log_in_base = LogInBaseServer(self.driver, self.base_page) self.driver.wait(1) self.driver.clear_cookies() self.driver.wait(1) def tearDown(self): self.driver.quit_browser() def test_case_account_center_manage_and_telephone_alarm(self): # 打开途强在线首页-登录页 self.base_page.open_page() # 登录账号 self.log_in_base.log_in_jimitest() self.account_center_page_navi_bar.click_account_center_button() account = self.log_in_base.get_log_in_account() # 点击订单管理 self.account_center_page.clcik_massage_and_telephone_alarm_button_in_account_info_page( ) ## 进入账号详情的frame self.account_center_page.switch_to_massage_and_telephone_alarm_frame() csv_file = self.account_center_page_read_csv.read_csv( 'massage_and_telephone_alarm.csv') csv_data = csv.reader(csv_file) is_header = True for row in csv_data: if is_header: is_header = False continue search_data = {'alarm_name': row[0], 'alarm_type': row[1]} self.account_center_page.add_data_to_search_massage_and_telephone_alarm_in_set_page( search_data) ## 获取数据库查询的条数 sql_number = self.account_center_page.get_sql_number_after_click_massage_and_telephone_alarm_set_search_button( account, search_data) # 获取页面上的条数 web_number = self.account_center_page.get_web_number_after_click_massage_and_telephone_alarm_search_button( ) self.assertEqual(sql_number, web_number) csv_file.close() self.driver.default_frame()
class TestCase49AccountCenterBillList(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.account_center_page_navi_bar = AccountCenterNaviBarPage( self.driver, self.base_url) self.account_center_page_details = AccountCenterDetailsPage( self.driver, self.base_url) self.account_center_page_refill_card = AccountCenterRefillCardPage( self.driver, self.base_url) self.log_in_base = LogInBaseServer(self.driver, self.base_page) self.account_center_page = AccountCenterPage(self.driver, self.base_url) self.search_sql = SearchSql() self.assert_text = AssertText() self.assert_text2 = AssertText2() self.driver.set_window_max() self.account_center_page_read_csv = AccountCenterPageReadCsv() self.log_in_base = LogInBaseServer(self.driver, self.base_page) self.driver.wait(1) self.driver.clear_cookies() self.driver.wait(1) def tearDown(self): self.driver.quit_browser() def test_case_account_center_bill_list(self): # 打开途强在线首页-登录页 self.base_page.open_page() # 登录账号 self.log_in_base.log_in_jimitest() self.account_center_page_navi_bar.click_account_center_button() account = self.log_in_base.get_log_in_account() # 点击账单按钮 self.account_center_page_navi_bar.switch_to_chongzhi_card() self.account_center_page.clcik_bill_button_in_account_info_page() csv_file = self.account_center_page_read_csv.read_csv('bill_list.csv') csv_data = csv.reader(csv_file) is_header = True for row in csv_data: if is_header: is_header = False continue search_data = { 'date_type': row[0], 'begin_time': row[1], 'end_time': row[2], 'imei': row[3], 'telephone': row[4], 'alarm_type': row[5], 'result': row[6] } self.account_center_page.add_data_to_search_bill_list_in_bill_list_page( search_data) ## 获取数据库查询的条数 sql_number = self.account_center_page.get_sql_number_after_click_search_button( account, search_data) # 获取页面上的条数 web_number = self.account_center_page.get_web_number_after_click_search_button( ) self.assertEqual(sql_number, web_number) csv_file.close()
class TestCase48AccountCenterVerifyInfo(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.account_center_page_navi_bar = AccountCenterNaviBarPage( self.driver, self.base_url) self.account_center_page_details = AccountCenterDetailsPage( self.driver, self.base_url) self.account_center_page_refill_card = AccountCenterRefillCardPage( self.driver, self.base_url) self.log_in_base = LogInBaseServer(self.driver, self.base_page) self.account_center_page = AccountCenterPage(self.driver, self.base_url) self.search_sql = SearchSql() self.assert_text = AssertText() self.assert_text2 = AssertText2() self.driver.set_window_max() self.account_center_page_read_csv = AccountCenterPageReadCsv() self.log_in_base = LogInBaseServer(self.driver, self.base_page) self.driver.wait(1) self.driver.clear_cookies() self.driver.wait(1) def tearDown(self): self.driver.quit_browser() def test_account_center_verify_info(self): # 打开途强在线首页-登录页 self.base_page.open_page() # 登录账号 self.log_in_base.log_in_jimitest() self.account_center_page_navi_bar.click_account_center_button() ## 进入账号详情的frame self.account_center_page.switch_to_account_info_frame() ## 获取到登录账号的信息 account = self.account_center_page.get_account_in_account_info_page() account_type = self.account_center_page.get_account_type_in_account_info_page( ) account_telephone = self.account_center_page.get_account_telephone_in_account_info_page( ) ## 获取最下方客户信息 account_01 = self.account_center_page.get_account_01_in_account_info_page( ) account_type_01 = self.account_center_page.get_account_type_01_in_account_info_page( ) account_telephone_01 = self.account_center_page.get_account_telephone_01_in_account_info_page( ) ## 断言 self.assertEqual(account, account_01) self.assertEqual(account_type, account_type_01) self.assertEqual(account_telephone, account_telephone_01) ## 获取电话、短信告警总数信息 telephone_alarm_number = self.account_center_page.get_telephone_alarm_number_in_account_info_page( ) massage_alarm_number = self.account_center_page.get_massage_alarm_number_in_account_info_page( ) ## 获取数据库剩余电话短信的条数 telephone_and_massage_alarm_number_in_mysql = self.account_center_page.get_telephone_and_massage_alarm_number_in_mysql( account) try: telephone_alarm_number_01 = str( telephone_and_massage_alarm_number_in_mysql[0][0]) massage_alarm_number_01 = str( telephone_and_massage_alarm_number_in_mysql[0][1]) self.assertEqual(telephone_alarm_number, telephone_alarm_number_01) self.assertEqual(massage_alarm_number, massage_alarm_number_01) except: self.assertEqual(telephone_alarm_number, '0') self.assertEqual(massage_alarm_number, '0') ## 获取充值卡剩余数量 year_card_number = self.account_center_page.get_year_card_number_in_account_info_page( ) life_card_number = self.account_center_page.get_life_card_number_in_account_info_page( ) ## 获取数据库剩余充值卡数量 try: year_and_life_card_number_in_mysql = self.account_center_page.get_year_and_life_card_number_in_mysql( account) year_card_number_01 = str(year_and_life_card_number_in_mysql[0][0]) life_card_number_01 = str(year_and_life_card_number_in_mysql[0][1]) self.assertEqual(year_card_number, year_card_number_01) self.assertEqual(life_card_number, life_card_number_01) except: self.assertEqual(year_card_number, '0') self.assertEqual(life_card_number, '0') ## 获取昨天消费统计数 consume_massage_alarm_number = self.account_center_page.get_consume_massage_alarm_number_in_account_info_page( ) consume_telephone_alarm_number = self.account_center_page.get_consume_telephone_alarm_number_in_account_info_page( ) consume_year_card_number = self.account_center_page.get_consume_year_card_number_in_account_info_page( ) consume_life_card_number = self.account_center_page.get_consume_life_card_number_in_account_info_page( ) # 分别获取昨天的短信、电话、年卡、终生卡消费情况 begin_time = self.account_center_page.get_bengin_time('昨天') end_time = self.account_center_page.get_end_time('昨天') try: consume_number = self.account_center_page.get_consume_number_in_mysql( begin_time, end_time, account) self.assertEqual(consume_massage_alarm_number, consume_number[0]) self.assertEqual(consume_telephone_alarm_number, consume_number[1]) self.assertEqual(consume_year_card_number, consume_number[2]) self.assertEqual(consume_life_card_number, consume_number[3]) except: self.assertEqual(consume_massage_alarm_number, '0') self.assertEqual(consume_telephone_alarm_number, '0') self.assertEqual(consume_year_card_number, '0') self.assertEqual(consume_life_card_number, '0') # 点击当月 self.account_center_page.click_this_month_in_account_page() ## 获取当月消费统计数 consume_massage_alarm_number = self.account_center_page.get_consume_massage_alarm_number_in_account_info_page_this_month( ) consume_telephone_alarm_number = self.account_center_page.get_consume_telephone_alarm_number_in_account_info_page_this_month( ) consume_year_card_number = self.account_center_page.get_consume_year_card_number_in_account_info_page_this_month( ) consume_life_card_number = self.account_center_page.get_consume_life_card_number_in_account_info_page_this_month( ) # 分别获取昨天的短信、电话、年卡、终生卡消费情况 begin_time = self.account_center_page.get_bengin_time('本月') end_time = self.account_center_page.get_end_time('本月') try: consume_number = self.account_center_page.get_consume_number_in_mysql( begin_time, end_time, account) self.assertEqual(consume_massage_alarm_number, consume_number[0]) self.assertEqual(consume_telephone_alarm_number, consume_number[1]) self.assertEqual(consume_year_card_number, consume_number[2]) self.assertEqual(consume_life_card_number, consume_number[3]) except: self.assertEqual(consume_massage_alarm_number, '0') self.assertEqual(consume_telephone_alarm_number, '0') self.assertEqual(consume_year_card_number, '0') self.assertEqual(consume_life_card_number, '0') # 点击上月 self.account_center_page.click_last_month_in_account_page() ## 获取上月消费统计数 consume_massage_alarm_number = self.account_center_page.get_consume_massage_alarm_number_in_account_info_page_last_month( ) consume_telephone_alarm_number = self.account_center_page.get_consume_telephone_alarm_number_in_account_info_page_last_month( ) consume_year_card_number = self.account_center_page.get_consume_year_card_number_in_account_info_page_last_month( ) consume_life_card_number = self.account_center_page.get_consume_life_card_number_in_account_info_page_last_month( ) # 分别获取昨天的短信、电话、年卡、终生卡消费情况 begin_time = self.account_center_page.get_bengin_time('上月') end_time = self.account_center_page.get_end_time('上月') try: consume_number = self.account_center_page.get_consume_number_in_mysql( begin_time, end_time, account) self.assertEqual(consume_massage_alarm_number, consume_number[0]) self.assertEqual(consume_telephone_alarm_number, consume_number[1]) self.assertEqual(consume_year_card_number, consume_number[2]) self.assertEqual(consume_life_card_number, consume_number[3]) except: self.assertEqual(consume_massage_alarm_number, '0') self.assertEqual(consume_telephone_alarm_number, '0') self.assertEqual(consume_year_card_number, '0') self.assertEqual(consume_life_card_number, '0') self.driver.default_frame()