class TestCase145SportStatisticalStayForm(unittest.TestCase):
'''
运动统计，停留报表
author ： zhangAo
'''
def setUp(self):
# 前置条件
# 实例化对象
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.statistical_form_page = StatisticalFormPage(self.driver, self.base_url)
self.statistical_form_page_read_csv = StatisticalFormPageReadCsv()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.connect_sql = ConnectSql()
self.search_sql = SearchSql(self.driver, self.base_url)
self.assert_text = AssertText()
# 打开页面，填写用户名、密码、点击登录
self.base_page.open_page()
self.driver.set_window_max()
self.driver.implicitly_wait(5)
self.log_in_base.log_in_jimitest()
# 登录之后点击控制台，然后点击设置
self.statistical_form_page.click_control_after_click_statistical_form_page()
sleep(3)
def tearDown(self):
# 退出浏览器
self.driver.quit_browser()
def test_case_sport_statistical_stay_form(self):
# 断言url
expect_url_after_click_statistical_form = self.base_url + '/deviceReport/statisticalReport'
self.assertEqual(expect_url_after_click_statistical_form,
self.statistical_form_page.actual_url_after_statistical_form())
# 点击停留报表
self.statistical_form_page.click_stay_form_button()
# 断言
self.assertEqual(self.assert_text.statistical_form_stay_form(),
self.statistical_form_page.actual_text_after_click_stay_form_button())
# 读数据
# 读取查询数据
csv_file = self.statistical_form_page_read_csv.read_csv('sport_statistical_stay_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 = {
'search_user': row[0],
'choose_date': row[1],
'begin_time': row[2],
'end_time': row[3]
}
self.statistical_form_page.add_data_to_search_stay_form(search_data)
all_dev = self.search_sql.search_current_account_equipment(search_data['search_user'])
# 连接另一个数据库
connect_02 = self.connect_sql.connect_tuqiang_form()
# 创建游标
cursor_02 = connect_02.cursor()
# 判断查询条件
# get_total_sql = self.search_sql.search_sport_stay_sql(all_dev, search_data)
get_total_sql_01 = self.search_sql.search_sport_stay_sql_01(all_dev, search_data)
get_total_sql_02 = self.search_sql.search_sport_stay_sql_02(all_dev, search_data)
get_total_sql_03 = self.search_sql.search_sport_stay_sql_03(all_dev, search_data)
get_total_sql_04 = self.search_sql.search_sport_stay_sql_04(all_dev, search_data)
get_total_sql_05 = self.search_sql.search_sport_stay_sql_05(all_dev, search_data)
get_total_sql_06 = self.search_sql.search_sport_stay_sql_06(all_dev, search_data)
get_total_sql_07 = self.search_sql.search_sport_stay_sql_07(all_dev, search_data)
get_total_sql_08 = self.search_sql.search_sport_stay_sql_08(all_dev, search_data)
get_total_sql_09 = self.search_sql.search_sport_stay_sql_09(all_dev, search_data)
get_total_sql_10 = self.search_sql.search_sport_stay_sql_10(all_dev, search_data)
get_total_sql_11 = self.search_sql.search_sport_stay_sql_11(all_dev, search_data)
get_total_sql_12 = self.search_sql.search_sport_stay_sql_12(all_dev, search_data)
print(get_total_sql_01)
'''cursor_02.execute(get_total_sql)
get_total = cursor_02.fetchall()
total_list = []
for range1 in get_total:
for range2 in range1:
total_list.append(range2)
# 拆分列表
total_number_list = []
total_time_list = []
for n in range(len(total_list)):
if n % 2 == 0:
total_number_list.append(total_list[n])
elif n % 2 == 1:
total_time_list.append(total_list[n])'''
cursor_02.execute(get_total_sql_01)
get_total_01 = cursor_02.fetchall()
total_list_01 = []
for range1 in get_total_01:
for range2 in range1:
total_list_01.append(range2)
# 拆分列表
total_number_list_01 = []
total_time_list_01 = []
for n in range(len(total_list_01)):
if n % 2 == 0:
total_number_list_01.append(total_list_01[n])
elif n % 2 == 1:
total_time_list_01.append(total_list_01[n])
cursor_02.execute(get_total_sql_02)
get_total_02 = cursor_02.fetchall()
total_list_02 = []
for range1 in get_total_02:
for range2 in range1:
total_list_02.append(range2)
# 拆分列表
total_number_list_02 = []
total_time_list_02 = []
for n in range(len(total_list_02)):
if n % 2 == 0:
total_number_list_02.append(total_list_02[n])
elif n % 2 == 1:
total_time_list_02.append(total_list_02[n])
cursor_02.execute(get_total_sql_03)
get_total_03 = cursor_02.fetchall()
total_list_03 = []
for range1 in get_total_03:
for range2 in range1:
total_list_03.append(range2)
# 拆分列表
total_number_list_03 = []
total_time_list_03 = []
for n in range(len(total_list_03)):
if n % 2 == 0:
total_number_list_03.append(total_list_03[n])
elif n % 2 == 1:
total_time_list_03.append(total_list_03[n])
cursor_02.execute(get_total_sql_04)
get_total_04 = cursor_02.fetchall()
total_list_04 = []
for range1 in get_total_04:
for range2 in range1:
total_list_04.append(range2)
# 拆分列表
total_number_list_04 = []
total_time_list_04 = []
for n in range(len(total_list_04)):
if n % 2 == 0:
total_number_list_04.append(total_list_04[n])
elif n % 2 == 1:
total_time_list_04.append(total_list_04[n])
cursor_02.execute(get_total_sql_05)
get_total_05 = cursor_02.fetchall()
total_list_05 = []
for range1 in get_total_05:
for range2 in range1:
total_list_05.append(range2)
# 拆分列表
total_number_list_05 = []
total_time_list_05 = []
for n in range(len(total_list_05)):
if n % 2 == 0:
total_number_list_05.append(total_list_05[n])
elif n % 2 == 1:
total_time_list_05.append(total_list_05[n])
cursor_02.execute(get_total_sql_06)
get_total_06 = cursor_02.fetchall()
total_list_06 = []
for range1 in get_total_06:
for range2 in range1:
total_list_06.append(range2)
# 拆分列表
total_number_list_06 = []
total_time_list_06 = []
for n in range(len(total_list_06)):
if n % 2 == 0:
total_number_list_06.append(total_list_06[n])
elif n % 2 == 1:
total_time_list_06.append(total_list_06[n])
cursor_02.execute(get_total_sql_07)
get_total_07 = cursor_02.fetchall()
total_list_07 = []
for range1 in get_total_07:
for range2 in range1:
total_list_07.append(range2)
# 拆分列表
total_number_list_07 = []
total_time_list_07 = []
for n in range(len(total_list_07)):
if n % 2 == 0:
total_number_list_07.append(total_list_07[n])
elif n % 2 == 1:
total_time_list_07.append(total_list_07[n])
cursor_02.execute(get_total_sql_08)
get_total_08 = cursor_02.fetchall()
total_list_08 = []
for range1 in get_total_08:
for range2 in range1:
total_list_08.append(range2)
# 拆分列表
total_number_list_08 = []
total_time_list_08 = []
for n in range(len(total_list_08)):
if n % 2 == 0:
total_number_list_08.append(total_list_08[n])
elif n % 2 == 1:
total_time_list_08.append(total_list_08[n])
cursor_02.execute(get_total_sql_09)
get_total_09 = cursor_02.fetchall()
total_list_09 = []
for range1 in get_total_09:
for range2 in range1:
total_list_09.append(range2)
# 拆分列表
total_number_list_09 = []
total_time_list_09 = []
for n in range(len(total_list_09)):
if n % 2 == 0:
total_number_list_09.append(total_list_09[n])
elif n % 2 == 1:
total_time_list_09.append(total_list_09[n])
cursor_02.execute(get_total_sql_10)
get_total_10 = cursor_02.fetchall()
total_list_10 = []
for range1 in get_total_10:
for range2 in range1:
total_list_10.append(range2)
# 拆分列表
total_number_list_10 = []
total_time_list_10 = []
for n in range(len(total_list_10)):
if n % 2 == 0:
total_number_list_10.append(total_list_10[n])
elif n % 2 == 1:
total_time_list_10.append(total_list_10[n])
cursor_02.execute(get_total_sql_11)
get_total_11 = cursor_02.fetchall()
total_list_11 = []
for range1 in get_total_11:
for range2 in range1:
total_list_11.append(range2)
# 拆分列表
total_number_list_11 = []
total_time_list_11 = []
for n in range(len(total_list_11)):
if n % 2 == 0:
total_number_list_11.append(total_list_11[n])
elif n % 2 == 1:
total_time_list_11.append(total_list_11[n])
cursor_02.execute(get_total_sql_12)
get_total_12 = cursor_02.fetchall()
total_list_12 = []
for range1 in get_total_12:
for range2 in range1:
total_list_12.append(range2)
# 拆分列表
total_number_list_12 = []
total_time_list_12 = []
for n in range(len(total_list_12)):
if n % 2 == 0:
total_number_list_12.append(total_list_12[n])
elif n % 2 == 1:
total_time_list_12.append(total_list_12[n])
# 断言查询的条
total = len(total_number_list_01) + len(total_number_list_02) + len(total_number_list_03) + len(
total_number_list_04) + len(total_number_list_05) + len(total_number_list_06) + len(
total_number_list_07) + len(total_number_list_08) + len(total_number_list_09) + len(
total_number_list_10) + len(total_number_list_11) + len(total_number_list_12)
sleep(3)
self.statistical_form_page.switch_to_stay_report_form_frame()
web_total = self.statistical_form_page.get_total_search_stay_form_number()
self.assertEqual(total, web_total)
# 断言查询的总的停留时间
total_time = sum(total_time_list_01) + sum(total_time_list_02) + sum(total_time_list_03) + sum(
total_time_list_04) + sum(total_time_list_05) + sum(total_time_list_06) + sum(total_time_list_07) + sum(
total_time_list_08) + sum(total_time_list_09) + sum(total_time_list_10) + sum(total_time_list_11) + sum(
total_time_list_12)
chang_total_time_type = self.statistical_form_page.change_sec_time(total_time)
web_total_time = self.statistical_form_page.get_total_stay_form_time()
print(web_total_time)
self.assertEqual(chang_total_time_type, web_total_time)
# 点击导出停留报表
self.driver.default_frame()
cursor_02.close()
connect_02.close()
csv_file.close()
class TestCase503FormSearchTravelSearch(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.statistical_form_page = StatisticalFormPage(self.driver, self.base_url)
self.statistical_form_page_read_csv = StatisticalFormPageReadCsv()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.connect_sql = ConnectSql()
self.assert_text = AssertText()
self.search_sql = SearchSql(self.driver, self.base_url)
# 打开页面，填写用户名、密码、点击登录
self.base_page.open_page()
self.driver.set_window_max()
self.driver.implicitly_wait(5)
self.log_in_base.log_in_jimitest()
current_handle = self.driver.get_current_window_handle()
self.statistical_form_page.click_control_after_click_statistical_form_page()
sleep(3)
self.base_page.change_windows_handle(current_handle)
def tearDown(self):
self.driver.close_window()
# 退出浏览器
self.driver.quit_browser()
def test_case_travel_search(self):
# 断言url
expect_url_after_click_statistical_form = self.base_url + '/deviceReport/statisticalReport'
self.assertEqual(expect_url_after_click_statistical_form,
self.statistical_form_page.actual_url_after_statistical_form())
# 点击里程报表
self.statistical_form_page.click_mileage_form_button()
# 断言
self.assertEqual(self.assert_text.statistical_form_tracl_form(),
self.statistical_form_page.actual_text_after_click_mileage_form_button())
# 读取查询数据
csv_file = self.statistical_form_page_read_csv.read_csv('sport_statistical_milage_form_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 = {
'search_user': row[0],
'type': row[1],
'choose_date': row[2],
'begin_time': row[3],
'end_time': row[4]
}
self.statistical_form_page.add_data_to_search_mileage_form(search_data)
self.statistical_form_page.switch_to_tracel_report_form_frame()
# 连接数据库
# 连接数据库
all_dev = self.search_sql.search_current_account_equipment(search_data['search_user'])
# 连接另一个数据库
connect_02 = self.connect_sql.connect_tuqiang_form()
# 创建游标
cursor_02 = connect_02.cursor()
# 判断查询的条件
# 判断查询条件
# get_total_sql = self.search_sql.search_sport_mile_sql(all_dev, search_data)
get_total_sql_01 = self.search_sql.search_sport_mile_sql_01(all_dev, search_data)
get_total_sql_02 = self.search_sql.search_sport_mile_sql_02(all_dev, search_data)
get_total_sql_03 = self.search_sql.search_sport_mile_sql_03(all_dev, search_data)
get_total_sql_04 = self.search_sql.search_sport_mile_sql_04(all_dev, search_data)
get_total_sql_05 = self.search_sql.search_sport_mile_sql_05(all_dev, search_data)
get_total_sql_06 = self.search_sql.search_sport_mile_sql_06(all_dev, search_data)
get_total_sql_07 = self.search_sql.search_sport_mile_sql_07(all_dev, search_data)
get_total_sql_08 = self.search_sql.search_sport_mile_sql_08(all_dev, search_data)
get_total_sql_09 = self.search_sql.search_sport_mile_sql_09(all_dev, search_data)
get_total_sql_10 = self.search_sql.search_sport_mile_sql_10(all_dev, search_data)
get_total_sql_11 = self.search_sql.search_sport_mile_sql_11(all_dev, search_data)
get_total_sql_12 = self.search_sql.search_sport_mile_sql_12(all_dev, search_data)
print(get_total_sql_01)
# 判断查询的条件
if search_data['type'] == 'mile':
# 查询的选择里程
'''cursor_02.execute(get_total_sql_01)
get_all_mlie_and_time = cursor_02.fetchall()
get_all_mlie_and_time_list = []
for range1 in get_all_mlie_and_time:
for range2 in range1:
get_all_mlie_and_time_list.append(range2)'''
cursor_02.execute(get_total_sql_01)
get_all_mlie_and_time_01 = cursor_02.fetchall()
get_all_mlie_and_time_list_01 = []
for range1 in get_all_mlie_and_time_01:
for range2 in range1:
get_all_mlie_and_time_list_01.append(range2)
cursor_02.execute(get_total_sql_02)
get_all_mlie_and_time_02 = cursor_02.fetchall()
get_all_mlie_and_time_list_02 = []
for range1 in get_all_mlie_and_time_02:
for range2 in range1:
get_all_mlie_and_time_list_02.append(range2)
cursor_02.execute(get_total_sql_03)
get_all_mlie_and_time_03 = cursor_02.fetchall()
get_all_mlie_and_time_list_03 = []
for range1 in get_all_mlie_and_time_03:
for range2 in range1:
get_all_mlie_and_time_list_03.append(range2)
cursor_02.execute(get_total_sql_04)
get_all_mlie_and_time_04 = cursor_02.fetchall()
get_all_mlie_and_time_list_04 = []
for range1 in get_all_mlie_and_time_04:
for range2 in range1:
get_all_mlie_and_time_list_04.append(range2)
cursor_02.execute(get_total_sql_05)
get_all_mlie_and_time_05 = cursor_02.fetchall()
get_all_mlie_and_time_list_05 = []
for range1 in get_all_mlie_and_time_05:
for range2 in range1:
get_all_mlie_and_time_list_05.append(range2)
cursor_02.execute(get_total_sql_06)
get_all_mlie_and_time_06 = cursor_02.fetchall()
get_all_mlie_and_time_list_06 = []
for range1 in get_all_mlie_and_time_06:
for range2 in range1:
get_all_mlie_and_time_list_06.append(range2)
cursor_02.execute(get_total_sql_07)
get_all_mlie_and_time_07 = cursor_02.fetchall()
get_all_mlie_and_time_list_07 = []
for range1 in get_all_mlie_and_time_07:
for range2 in range1:
get_all_mlie_and_time_list_07.append(range2)
cursor_02.execute(get_total_sql_08)
get_all_mlie_and_time_08 = cursor_02.fetchall()
get_all_mlie_and_time_list_08 = []
for range1 in get_all_mlie_and_time_08:
for range2 in range1:
get_all_mlie_and_time_list_08.append(range2)
cursor_02.execute(get_total_sql_09)
get_all_mlie_and_time_09 = cursor_02.fetchall()
get_all_mlie_and_time_list_09 = []
for range1 in get_all_mlie_and_time_09:
for range2 in range1:
get_all_mlie_and_time_list_09.append(range2)
cursor_02.execute(get_total_sql_10)
get_all_mlie_and_time_10 = cursor_02.fetchall()
get_all_mlie_and_time_list_10 = []
for range1 in get_all_mlie_and_time_10:
for range2 in range1:
get_all_mlie_and_time_list_10.append(range2)
cursor_02.execute(get_total_sql_11)
get_all_mlie_and_time_11 = cursor_02.fetchall()
get_all_mlie_and_time_list_11 = []
for range1 in get_all_mlie_and_time_11:
for range2 in range1:
get_all_mlie_and_time_list_11.append(range2)
cursor_02.execute(get_total_sql_12)
get_all_mlie_and_time_12 = cursor_02.fetchall()
get_all_mlie_and_time_list_12 = []
for range1 in get_all_mlie_and_time_12:
for range2 in range1:
get_all_mlie_and_time_list_12.append(range2)
total = len(get_all_mlie_and_time_list_01) / 2 + len(
get_all_mlie_and_time_list_02) / 2 + len(get_all_mlie_and_time_list_03) / 2 + len(
get_all_mlie_and_time_list_04) / 2 + len(get_all_mlie_and_time_list_05) / 2 + len(
get_all_mlie_and_time_list_06) / 2 + len(get_all_mlie_and_time_list_07) / 2 + len(
get_all_mlie_and_time_list_08) / 2 + len(get_all_mlie_and_time_list_09) / 2 + len(
get_all_mlie_and_time_list_10) / 2 + len(get_all_mlie_and_time_list_11) / 2 + len(
get_all_mlie_and_time_list_12) / 2
web_total = self.statistical_form_page.get_total_search_mileage_form()
self.assertEqual(total, web_total)
# 拆分列表
all_mile_list = []
all_time_list = []
'''for n in range(len(get_all_mlie_and_time_list)):
if n % 2 == 0:
all_mile_list.append(get_all_mlie_and_time_list[n])
elif n % 2 == 1:
all_time_list.append(get_all_mlie_and_time_list[n])'''
# 拆分列表
all_mile_list_01 = []
all_time_list_01 = []
for n in range(len(get_all_mlie_and_time_list_01)):
if n % 2 == 0:
all_mile_list_01.append(get_all_mlie_and_time_list_01[n])
elif n % 2 == 1:
all_time_list_01.append(get_all_mlie_and_time_list_01[n])
# 拆分列表
all_mile_list_02 = []
all_time_list_02 = []
for n in range(len(get_all_mlie_and_time_list_02)):
if n % 2 == 0:
all_mile_list_02.append(get_all_mlie_and_time_list_02[n])
elif n % 2 == 1:
all_time_list_02.append(get_all_mlie_and_time_list_02[n])
# 拆分列表
all_mile_list_03 = []
all_time_list_03 = []
for n in range(len(get_all_mlie_and_time_list_03)):
if n % 2 == 0:
all_mile_list_03.append(get_all_mlie_and_time_list_03[n])
elif n % 2 == 1:
all_time_list_03.append(get_all_mlie_and_time_list_03[n])
# 拆分列表
all_mile_list_04 = []
all_time_list_04 = []
for n in range(len(get_all_mlie_and_time_list_04)):
if n % 2 == 0:
all_mile_list_04.append(get_all_mlie_and_time_list_04[n])
elif n % 2 == 1:
all_time_list_04.append(get_all_mlie_and_time_list_04[n])
# 拆分列表
all_mile_list_05 = []
all_time_list_05 = []
for n in range(len(get_all_mlie_and_time_list_05)):
if n % 2 == 0:
all_mile_list_05.append(get_all_mlie_and_time_list_05[n])
elif n % 2 == 1:
all_time_list_05.append(get_all_mlie_and_time_list_05[n])
# 拆分列表
all_mile_list_06 = []
all_time_list_06 = []
for n in range(len(get_all_mlie_and_time_list_06)):
if n % 2 == 0:
all_mile_list_06.append(get_all_mlie_and_time_list_06[n])
elif n % 2 == 1:
all_time_list_06.append(get_all_mlie_and_time_list_06[n])
# 拆分列表
all_mile_list_07 = []
all_time_list_07 = []
for n in range(len(get_all_mlie_and_time_list_07)):
if n % 2 == 0:
all_mile_list_07.append(get_all_mlie_and_time_list_07[n])
elif n % 2 == 1:
all_time_list_07.append(get_all_mlie_and_time_list_07[n])
# 拆分列表
all_mile_list_08 = []
all_time_list_08 = []
for n in range(len(get_all_mlie_and_time_list_08)):
if n % 2 == 0:
all_mile_list_08.append(get_all_mlie_and_time_list_08[n])
elif n % 2 == 1:
all_time_list_08.append(get_all_mlie_and_time_list_08[n])
# 拆分列表
all_mile_list_09 = []
all_time_list_09 = []
for n in range(len(get_all_mlie_and_time_list_09)):
if n % 2 == 0:
all_mile_list_09.append(get_all_mlie_and_time_list_09[n])
elif n % 2 == 1:
all_time_list_09.append(get_all_mlie_and_time_list_09[n])
# 拆分列表
all_mile_list_10 = []
all_time_list_10 = []
for n in range(len(get_all_mlie_and_time_list_10)):
if n % 2 == 0:
all_mile_list_10.append(get_all_mlie_and_time_list_10[n])
elif n % 2 == 1:
all_time_list_10.append(get_all_mlie_and_time_list_10[n])
# 拆分列表
all_mile_list_11 = []
all_time_list_11 = []
for n in range(len(get_all_mlie_and_time_list_11)):
if n % 2 == 0:
all_mile_list_11.append(get_all_mlie_and_time_list_11[n])
elif n % 2 == 1:
all_time_list_11.append(get_all_mlie_and_time_list_11[n])
# 拆分列表
all_mile_list_12 = []
all_time_list_12 = []
for n in range(len(get_all_mlie_and_time_list_12)):
if n % 2 == 0:
all_mile_list_12.append(get_all_mlie_and_time_list_12[n])
elif n % 2 == 1:
all_time_list_12.append(get_all_mlie_and_time_list_12[n])
# 计算总里程 和 总时间
total_mile = sum(all_mile_list) + sum(all_mile_list_01) + sum(all_mile_list_02) + sum(
all_mile_list_03) + sum(all_mile_list_04) + sum(all_mile_list_05) + sum(all_mile_list_06) + sum(
all_mile_list_07) + sum(all_mile_list_08) + sum(all_mile_list_09) + sum(all_mile_list_10) + sum(
all_mile_list_11) + sum(all_mile_list_12)
total_time = sum(all_time_list) + sum(all_time_list_01) + sum(all_time_list_02) + sum(
all_time_list_03) + sum(all_time_list_04) + sum(all_time_list_05) + sum(all_time_list_06) + sum(
all_time_list_07) + sum(all_time_list_08) + sum(all_time_list_09) + sum(all_time_list_10) + sum(
all_time_list_11) + sum(all_time_list_12)
# 断言总时间和总里程，总油耗
web_total_mile = self.statistical_form_page.get_mileage_all_mile()
self.assertAlmostEqual(total_mile / 1000, float(web_total_mile))
web_total_time = self.statistical_form_page.get_mileage_all_time()
chang_total_time_type = self.statistical_form_page.change_sec_time(total_time)
self.assertEqual(chang_total_time_type, web_total_time)
# 计算总油耗
if total_mile == 0:
self.assertEqual('0', self.statistical_form_page.get_mileage_total_oil())
else:
if self.statistical_form_page.get_mileage_total_oil() == '0':
pass
else:
get_total_oil = total_mile / 1000 / 100 * 8
total_oil = '%.2f' % get_total_oil
self.assertEqual(str(total_oil), self.statistical_form_page.get_mileage_total_oil())
# 点击导出
self.driver.default_frame()
cursor_02.close()
connect_02.close()
csv_file.close()
class TestCase506FormSearchAccSearch(unittest.TestCase):
# 测试 报表 acc报表搜索功能
def setUp(self):
# 前置条件
# 实例化对象
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.statistical_form_page = StatisticalFormPage(
self.driver, self.base_url)
self.statistical_form_page_read_csv = StatisticalFormPageReadCsv()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.connect_sql = ConnectSql()
self.assert_text = AssertText()
self.search_sql = SearchSql(self.driver, self.base_url)
# 打开页面，填写用户名、密码、点击登录
self.base_page.open_page()
self.driver.set_window_max()
self.driver.implicitly_wait(5)
self.log_in_base.log_in_jimitest()
current_handle = self.driver.get_current_window_handle()
self.statistical_form_page.click_control_after_click_statistical_form_page(
)
sleep(3)
self.base_page.change_windows_handle(current_handle)
def tearDown(self):
self.driver.close_window()
# 退出浏览器
self.driver.quit_browser()
def test_case_acc_search(self):
# 断言url
expect_url_after_click_statistical_form = self.base_url + '/deviceReport/statisticalReport'
self.assertEqual(
expect_url_after_click_statistical_form,
self.statistical_form_page.actual_url_after_statistical_form())
# 点击停留报表
self.statistical_form_page.click_acc_form_button()
# 断言
self.assertEqual(
self.assert_text.statistical_form_acc_form(),
self.statistical_form_page.actual_text_after_click_acc_button())
# 读数据
# 读取查询数据
csv_file = self.statistical_form_page_read_csv.read_csv(
'sport_statistical_acc_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 = {
'search_user': row[0],
'status': row[1],
'choose_date': row[2],
'begin_time': row[3],
'end_time': row[4]
}
self.statistical_form_page.add_data_to_search_acc_form(search_data)
self.statistical_form_page.switch_to_acc_report_form_frame()
all_dev = self.search_sql.search_current_account_equipment(
search_data['search_user'])
# 连接另一个数据库
connect_02 = self.connect_sql.connect_tuqiang_form()
# 创建游标
cursor_02 = connect_02.cursor()
# get_total_sql = self.search_sql.search_acc_sql(all_dev, search_data)
get_total_sql_01 = self.search_sql.search_acc_sql_01(
all_dev, search_data)
get_total_sql_02 = self.search_sql.search_acc_sql_02(
all_dev, search_data)
get_total_sql_03 = self.search_sql.search_acc_sql_03(
all_dev, search_data)
get_total_sql_04 = self.search_sql.search_acc_sql_04(
all_dev, search_data)
get_total_sql_05 = self.search_sql.search_acc_sql_05(
all_dev, search_data)
get_total_sql_06 = self.search_sql.search_acc_sql_06(
all_dev, search_data)
get_total_sql_07 = self.search_sql.search_acc_sql_07(
all_dev, search_data)
get_total_sql_08 = self.search_sql.search_acc_sql_08(
all_dev, search_data)
get_total_sql_09 = self.search_sql.search_acc_sql_09(
all_dev, search_data)
get_total_sql_10 = self.search_sql.search_acc_sql_10(
all_dev, search_data)
get_total_sql_11 = self.search_sql.search_acc_sql_11(
all_dev, search_data)
get_total_sql_12 = self.search_sql.search_acc_sql_12(
all_dev, search_data)
print(get_total_sql_01)
cursor_02.execute(get_total_sql_01)
get_total_01 = cursor_02.fetchall()
total_list_01 = []
for range1 in get_total_01:
for range2 in range1:
total_list_01.append(range2)
get_total_list_01 = []
acc_open_list_01 = []
acc_close_list_01 = []
all_time_list_01 = []
for n in range(len(total_list_01)):
if n % 3 == 0:
get_total_list_01.append(total_list_01[n])
elif n % 3 == 1:
if total_list_01[n] == 1:
acc_open_list_01.append(total_list_01[n])
elif total_list_01[n] == 0:
acc_close_list_01.append(total_list_01[n])
elif n % 3 == 2:
all_time_list_01.append(total_list_01[n])
cursor_02.execute(get_total_sql_02)
get_total_02 = cursor_02.fetchall()
total_list_02 = []
for range1 in get_total_02:
for range2 in range1:
total_list_02.append(range2)
get_total_list_02 = []
acc_open_list_02 = []
acc_close_list_02 = []
all_time_list_02 = []
for n in range(len(total_list_02)):
if n % 3 == 0:
get_total_list_02.append(total_list_02[n])
elif n % 3 == 1:
if total_list_02[n] == 1:
acc_open_list_02.append(total_list_02[n])
elif total_list_02[n] == 0:
acc_close_list_02.append(total_list_02[n])
elif n % 3 == 2:
all_time_list_02.append(total_list_02[n])
cursor_02.execute(get_total_sql_03)
get_total_03 = cursor_02.fetchall()
total_list_03 = []
for range1 in get_total_03:
for range2 in range1:
total_list_03.append(range2)
get_total_list_03 = []
acc_open_list_03 = []
acc_close_list_03 = []
all_time_list_03 = []
for n in range(len(total_list_03)):
if n % 3 == 0:
get_total_list_03.append(total_list_03[n])
elif n % 3 == 1:
if total_list_03[n] == 1:
acc_open_list_03.append(total_list_03[n])
elif total_list_03[n] == 0:
acc_close_list_03.append(total_list_03[n])
elif n % 3 == 2:
all_time_list_03.append(total_list_03[n])
cursor_02.execute(get_total_sql_04)
get_total_04 = cursor_02.fetchall()
total_list_04 = []
for range1 in get_total_04:
for range2 in range1:
total_list_04.append(range2)
get_total_list_04 = []
acc_open_list_04 = []
acc_close_list_04 = []
all_time_list_04 = []
for n in range(len(total_list_04)):
if n % 3 == 0:
get_total_list_04.append(total_list_04[n])
elif n % 3 == 1:
if total_list_04[n] == 1:
acc_open_list_04.append(total_list_04[n])
elif total_list_04[n] == 0:
acc_close_list_04.append(total_list_04[n])
elif n % 3 == 2:
all_time_list_04.append(total_list_04[n])
cursor_02.execute(get_total_sql_05)
get_total_05 = cursor_02.fetchall()
total_list_05 = []
for range1 in get_total_05:
for range2 in range1:
total_list_05.append(range2)
get_total_list_05 = []
acc_open_list_05 = []
acc_close_list_05 = []
all_time_list_05 = []
for n in range(len(total_list_05)):
if n % 3 == 0:
get_total_list_05.append(total_list_05[n])
elif n % 3 == 1:
if total_list_05[n] == 1:
acc_open_list_05.append(total_list_05[n])
elif total_list_05[n] == 0:
acc_close_list_05.append(total_list_05[n])
elif n % 3 == 2:
all_time_list_05.append(total_list_05[n])
cursor_02.execute(get_total_sql_06)
get_total_06 = cursor_02.fetchall()
total_list_06 = []
for range1 in get_total_06:
for range2 in range1:
total_list_06.append(range2)
get_total_list_06 = []
acc_open_list_06 = []
acc_close_list_06 = []
all_time_list_06 = []
for n in range(len(total_list_06)):
if n % 3 == 0:
get_total_list_06.append(total_list_06[n])
elif n % 3 == 1:
if total_list_06[n] == 1:
acc_open_list_06.append(total_list_06[n])
elif total_list_06[n] == 0:
acc_close_list_06.append(total_list_06[n])
elif n % 3 == 2:
all_time_list_06.append(total_list_06[n])
cursor_02.execute(get_total_sql_07)
get_total_07 = cursor_02.fetchall()
total_list_07 = []
for range1 in get_total_07:
for range2 in range1:
total_list_07.append(range2)
get_total_list_07 = []
acc_open_list_07 = []
acc_close_list_07 = []
all_time_list_07 = []
for n in range(len(total_list_07)):
if n % 3 == 0:
get_total_list_07.append(total_list_07[n])
elif n % 3 == 1:
if total_list_07[n] == 1:
acc_open_list_07.append(total_list_07[n])
elif total_list_07[n] == 0:
acc_close_list_07.append(total_list_07[n])
elif n % 3 == 2:
all_time_list_07.append(total_list_07[n])
cursor_02.execute(get_total_sql_08)
get_total_08 = cursor_02.fetchall()
total_list_08 = []
for range1 in get_total_08:
for range2 in range1:
total_list_08.append(range2)
get_total_list_08 = []
acc_open_list_08 = []
acc_close_list_08 = []
all_time_list_08 = []
for n in range(len(total_list_08)):
if n % 3 == 0:
get_total_list_08.append(total_list_08[n])
elif n % 3 == 1:
if total_list_08[n] == 1:
acc_open_list_08.append(total_list_08[n])
elif total_list_08[n] == 0:
acc_close_list_08.append(total_list_08[n])
elif n % 3 == 2:
all_time_list_08.append(total_list_08[n])
cursor_02.execute(get_total_sql_09)
get_total_09 = cursor_02.fetchall()
total_list_09 = []
for range1 in get_total_09:
for range2 in range1:
total_list_09.append(range2)
get_total_list_09 = []
acc_open_list_09 = []
acc_close_list_09 = []
all_time_list_09 = []
for n in range(len(total_list_09)):
if n % 3 == 0:
get_total_list_09.append(total_list_09[n])
elif n % 3 == 1:
if total_list_09[n] == 1:
acc_open_list_09.append(total_list_09[n])
elif total_list_09[n] == 0:
acc_close_list_09.append(total_list_09[n])
elif n % 3 == 2:
all_time_list_09.append(total_list_09[n])
cursor_02.execute(get_total_sql_10)
get_total_10 = cursor_02.fetchall()
total_list_10 = []
for range1 in get_total_10:
for range2 in range1:
total_list_10.append(range2)
get_total_list_10 = []
acc_open_list_10 = []
acc_close_list_10 = []
all_time_list_10 = []
for n in range(len(total_list_10)):
if n % 3 == 0:
get_total_list_10.append(total_list_10[n])
elif n % 3 == 1:
if total_list_10[n] == 1:
acc_open_list_10.append(total_list_10[n])
elif total_list_10[n] == 0:
acc_close_list_10.append(total_list_10[n])
elif n % 3 == 2:
all_time_list_10.append(total_list_10[n])
cursor_02.execute(get_total_sql_11)
get_total_11 = cursor_02.fetchall()
total_list_11 = []
for range1 in get_total_11:
for range2 in range1:
total_list_11.append(range2)
get_total_list_11 = []
acc_open_list_11 = []
acc_close_list_11 = []
all_time_list_11 = []
for n in range(len(total_list_11)):
if n % 3 == 0:
get_total_list_11.append(total_list_11[n])
elif n % 3 == 1:
if total_list_11[n] == 1:
acc_open_list_11.append(total_list_11[n])
elif total_list_11[n] == 0:
acc_close_list_11.append(total_list_11[n])
elif n % 3 == 2:
all_time_list_11.append(total_list_11[n])
cursor_02.execute(get_total_sql_12)
get_total_12 = cursor_02.fetchall()
total_list_12 = []
for range1 in get_total_12:
for range2 in range1:
total_list_12.append(range2)
get_total_list_12 = []
acc_open_list_12 = []
acc_close_list_12 = []
all_time_list_12 = []
for n in range(len(total_list_12)):
if n % 3 == 0:
get_total_list_12.append(total_list_12[n])
elif n % 3 == 1:
if total_list_12[n] == 1:
acc_open_list_12.append(total_list_12[n])
elif total_list_12[n] == 0:
acc_close_list_12.append(total_list_12[n])
elif n % 3 == 2:
all_time_list_12.append(total_list_12[n])
total = len(get_total_list_01) + len(get_total_list_02) + len(
get_total_list_03) + len(get_total_list_04) + len(
get_total_list_05) + len(get_total_list_06) + len(
get_total_list_07) + len(get_total_list_08) + len(
get_total_list_10) + len(get_total_list_11) + len(
get_total_list_12)
total_acc_open = len(acc_open_list_01) + len(
acc_open_list_02) + len(acc_open_list_03) + len(
acc_open_list_04) + len(acc_open_list_05) + len(
acc_open_list_06) + len(acc_open_list_07) + len(
acc_open_list_08) + len(acc_open_list_10) + len(
acc_open_list_11) + len(acc_open_list_12)
total_acc_close = len(acc_close_list_01) + len(
acc_close_list_02) + len(acc_close_list_03) + len(
acc_close_list_04) + len(acc_close_list_05) + len(
acc_close_list_06) + len(acc_close_list_07) + len(
acc_close_list_08) + len(acc_close_list_10) + len(
acc_close_list_11) + len(acc_close_list_12)
total_time = sum(all_time_list_01) + sum(all_time_list_02) + sum(
all_time_list_03) + sum(all_time_list_04) + sum(
all_time_list_05) + sum(all_time_list_06) + sum(
all_time_list_07) + sum(all_time_list_08) + sum(
all_time_list_10) + sum(all_time_list_11) + sum(
all_time_list_12)
# 断言总条数
web_total = self.statistical_form_page.get_total_search_acc_form_number(
)
self.assertEqual(total, web_total)
# 断言acc打开几次
web_acc_open_total = self.statistical_form_page.get_total_search_acc_open(
)
self.assertEqual(str(total_acc_open), web_acc_open_total)
# 断言acc关闭几次
web_acc_close_total = self.statistical_form_page.get_total_search_acc_close(
)
self.assertEqual(str(total_acc_close), web_acc_close_total)
# 断言总时间
total_times = self.statistical_form_page.change_sec_time(
total_time)
web_all_time_total = self.statistical_form_page.get_total_search_all_time(
)
self.assertEqual(total_times, web_all_time_total)
# 点击导出报表
self.driver.default_frame()
cursor_02.close()
connect_02.close()
csv_file.close()
