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