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_refill_card = AccountCenterRefillCardPage( self.driver, self.base_url) self.log_in_base = LogInBaseServer(self.driver, self.base_page) self.account_center_page_read_csv = AccountCenterPageReadCsv() self.log_in_base = LogInBaseServer(self.driver, self.base_page) self.assert_text2 = AssertText2() self.driver.set_window_max() self.driver.wait(1) self.driver.clear_cookies() self.driver.wait(1)
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.connect_sql = ConnectSql() self.search_sql = SearchSql() self.assert_text = AssertText() 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 TestCase410918AccountCenterRefillCardAddApply(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_refill_card = AccountCenterRefillCardPage( self.driver, self.base_url) self.log_in_base = LogInBaseServer(self.driver, self.base_page) self.account_center_page_read_csv = AccountCenterPageReadCsv() self.log_in_base = LogInBaseServer(self.driver, self.base_page) self.assert_text2 = AssertText2() self.driver.set_window_max() self.driver.wait(1) self.driver.clear_cookies() self.driver.wait(1) def tearDown(self): self.driver.quit_browser() def test_apply_refill_card(self): '''充值卡-申请记录--申请充值卡''' # 打开途强在线首页-登录页 self.base_page.open_page() # 登录账号 # self.log_in_base.log_in_with_csv("dzltest", "jimi123") self.log_in_base.log_in() self.driver.wait(1) self.account_center_page_navi_bar.click_account_center_button() # 进入充值卡页面 # self.account_center_page_navi_bar.switch_to_chongzhi_card() self.account_center_page_refill_card.click_refill_card() csv_file = self.account_center_page_read_csv.read_csv( 'apply_refill_card.csv') csv_data = csv.reader(csv_file) for row in csv_data: data = { "year": row[0], "lifetime": row[1], "name": row[2], "phone": row[3], "payment_account": row[4] } # 验证页面顶部我的账号 my_account = self.account_center_page_refill_card.get_title_display_account( ) # 取消 self.account_center_page_refill_card.apply_refill_card_cancel() # 验证账号 self.account_center_page_refill_card.click_apply_refill_card_button( ) apply_page_account = self.account_center_page_refill_card.get_refill_account( ) self.assertEqual(my_account, apply_page_account, "充值账号显示不一致") # 添加充值卡 self.account_center_page_refill_card.apply_refill_card_add( data["year"], data["lifetime"], data["name"], data["phone"], data["payment_account"]) information = self.account_center_page_refill_card.get_applicant_information( ) statu = self.account_center_page_refill_card.get_operate_status() self.assertEqual( self.assert_text2.account_center_refill_card_apply_succeed(), statu, "申请充值卡失败") # 验证添加数据与申请人信息 self.assertEqual(apply_page_account, information["applicant_account"], "申请人信息中,充值账号显示不一致") self.assertEqual(data["year"] + "张", information["year"], "申请人信息中,一年充值卡张数显示不一致") self.assertEqual(data["lifetime"] + "张", information["lifetime"], "申请人信息中,终身充值卡张数显示不一致") self.assertEqual(data["name"], information["name"], "申请人信息中,付款人姓名显示不一致") self.assertEqual(data["phone"], information["phone"], "申请人信息中,充值联系方式显示不一致") self.assertEqual(data["payment_account"], information["payment_account"], "申请人信息中,付款账号显示不一致") csv_file.close()
class TestCase450919AccountCenterRefillCardRefillRecordSearch(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.connect_sql = ConnectSql() self.search_sql = SearchSql() self.assert_text = AssertText() 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_refill_record_search(self): '''充值卡-充值记录--搜索''' csv_file = self.account_center_page_read_csv.read_csv('search_refill_record_data.csv') csv_data = csv.reader(csv_file) # 打开途强在线首页-登录页 self.base_page.open_page() # 登录账号 self.log_in_base.log_in() self.driver.wait(1) self.account_center_page_navi_bar.click_account_center_button() # 进入充值卡页面 # self.account_center_page_navi_bar.switch_to_chongzhi_card() self.account_center_page_refill_card.click_refill_card() # 验证页面顶部我的账号 my_account = self.account_center_page_refill_card.get_title_display_account() self.assertIn(self.account_center_page_refill_card.get_current_login_account(), my_account, "登录账号显示一致") for row in csv_data: data = { "refill_type": row[0], "device_imei": row[1] } # 点击充值记录 self.account_center_page_refill_card.click_refill_record() # 搜索 count = self.account_center_page_refill_card.refill_record_search_data(data["refill_type"], data["device_imei"]) # 验证imei计数 self.assertEqual(count["import_count"], int(count["add_count"]), "输入框中imei的计数显示错误") # 获取页面列表条数 page_number = self.account_center_page_refill_card.get_refill_record_number() # 获取当前账号id sql_data = self.search_sql.search_current_account_data(my_account) connect1 = self.connect_sql.connect_tuqiang_sql() # 创建数据库游标 cur = connect1.cursor() # 获取数据库条数 get_sql = self.search_sql.search_refill_record_sql(sql_data[0], data) print(get_sql) cur.execute(get_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) # 获取数据库条数 self.assertEqual(total, page_number, "转移记录中,平台与sql搜索出来的数据条数不一致") # 点击充值记录 self.account_center_page_refill_card.click_refill_record() # 获取设备有多少个分页 total_page = self.account_center_page_refill_card.get_total_page_number_search_refill_record() print(total_page) if total_page[0] == 0: text = self.account_center_page_refill_card.get_refill_record_page_no_data_text() self.assertIn(self.assert_text.account_center_page_no_data_text(), text) elif total_page[0] == 1: up_page_class = self.account_center_page_refill_card.get_up_page_class_active_in_refill_search() self.assertEqual('active', up_page_class) else: for n in range(total_page[0]): self.account_center_page_refill_card.click_per_page(n) get_per_first_number = self.account_center_page_refill_card.get_per_frist_number_in_refill_search() self.assertEqual(get_per_first_number, str(10 * (n + 1) - 9)) # 点击每页20条 list = [20, 30, 50, 100] for m in list: self.account_center_page_refill_card.click_per_page_number_refill_record() page_number = self.account_center_page_refill_card.get_page_number_in_refill_record_search() print(page_number) self.assertEqual(int(total_page[1] / m) + 1, page_number) csv_file.close()
class TestCase430918AccountCenterRefillCardApplyException(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.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_apply_refill_card_exception_verify(self): '''充值卡-申请记录--申请充值卡-异常验证''' # 打开途强在线首页-登录页 self.base_page.open_page() # 登录账号 self.log_in_base.log_in() self.driver.wait(1) self.account_center_page_navi_bar.click_account_center_button() # 进入充值卡页面 # self.account_center_page_navi_bar.switch_to_chongzhi_card() self.account_center_page_refill_card.click_refill_card() # 点申请充值卡 self.account_center_page_refill_card.click_apply_refill_card_button() csv_file = self.account_center_page_read_csv.read_csv( 'apply_refill_card_exception.csv') csv_data = csv.reader(csv_file) for row in csv_data: data = { "year": row[0], "lifetime": row[1], "name": row[2], "phone": row[3], "payment_account": row[4], "year_prompt1": row[5], "lifetime_prompt1": row[6], "name_prompt1": row[7], "phone_prompt1": row[8], "account_prompt1": row[9] } # 获取提示 prompt = self.account_center_page_refill_card.get_apply_refill_card_exception_hint( data["year"], data["lifetime"], data["name"], data["phone"], data["payment_account"]) self.assertIn(data["year_prompt1"], prompt["year_prompt2"], "一年充值卡提示不一致") self.assertIn(data["lifetime_prompt1"], prompt["lifetimet_prompt2"], "终身充值卡提示不一致") self.assertEqual(data["name_prompt1"], prompt["name_prompt2"], "付款姓名提示不一致") self.assertEqual(data["phone_prompt1"], prompt["phone_prompt2"], "付款手机号卡提示不一致") self.assertEqual(data["account_prompt1"], prompt["account_prompt2"], "付款账号提示不一致") # 长度 length = self.account_center_page_refill_card.get_apply_refill_card_len( ) self.assertEqual(5, length["year_len"], "一年充值卡长度不一致") self.assertEqual(5, length["lifetime_len"], "终身充值卡长度不一致") self.assertEqual(20, length["name_len"], "姓名长度不一致") self.assertEqual(20, length["phone_len"], "手机号长度不一致") self.assertEqual(200, length["account_len"], "付款账号长度不一致")
class TestCase460918AccountCenterRefillCardTransfer(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.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_transfer_refill_card_succeed(self): '''充值卡--充值卡转移成功''' # 打开途强在线首页-登录页 self.base_page.open_page() # 登录账号 self.log_in_base.log_in() # self.log_in_base.log_in_with_csv("kankan111", "jimi123") self.driver.wait(1) self.account_center_page_navi_bar.click_account_center_button() self.account_center_page_navi_bar.switch_to_chongzhi_card() self.account_center_page_refill_card.click_refill_card() csv_file = self.account_center_page_read_csv.read_csv( 'transfer_refill_card.csv') csv_data = csv.reader(csv_file) for row in csv_data: data = { "account": row[0], "year_number": row[1], "lifetime_number": row[2], "username": row[3] } #获取头部数量 top_quantity = self.account_center_page_refill_card.get_refill_card_page_top_quantity( ) #点转移 self.account_center_page_refill_card.click_refill_card_transfer_button( ) #获取数量 transfer_quantity = self.account_center_page_refill_card.get_refill_card_transfer_quantity( ) self.assertEqual(top_quantity["year_number"], transfer_quantity["year_quantity"] + "张", "页面顶部与转移中显示的年卡不一致") self.assertEqual(top_quantity["lifetime_number"], transfer_quantity["lifetime_quantity"] + "张", "页面顶部与转移中显示的终身卡不一致") #充值卡转移-取消 self.account_center_page_refill_card.refill_card_transfer_cancel() self.account_center_page_refill_card.click_refill_card_transfer_button( ) # 充值卡转移 self.account_center_page_refill_card.refill_card_transfer( data["account"], data["year_number"], data["lifetime_number"]) # 获取转移提示 information = self.account_center_page_refill_card.get_refill_card_transfer_data_information( ) statu = self.account_center_page_refill_card.get_operate_status() self.assertEqual( self.assert_text2.account_center_refill_card_transfer_succeed( ), statu, "充值卡转移失败") # 验证转移数据与转移提示中的信息 self.assertEqual(data["username"], information["target_user"], "转移提示中,目标账号显示不一致") self.assertEqual(data["year_number"] + " 张", information["year_number"], "转移提示中,一年充值卡显示不一致") self.assertEqual(data["lifetime_number"] + " 张", information["lifetime_number"], "转移提示中,终身充值卡显示不一致") csv_file.close()