def test_4_llfd_y(self): '''实时状态监控 > 发电量曲线 > 理论发电量''' driver = self.driver driver.maximize_window() start(driver, 'http://192.168.60.21:8080/SPPS/weatherInfo/temCurveAction.action') click_list = ['实时状态监控', '发电量曲线'] # 点击菜单 menu(driver, click_list) if now_time()[0] != 1: print("waiting 70") time.sleep(70) set_date_one(driver,yes_date()) driver.find_element_by_id('search').click() # 搜索 time.sleep(2) hang = '/html/body/div/div[2]/div[2]/div[2]/div[2]/div[2]/table/tbody/tr' global list_heng list_heng = get_heng(driver, hang) # 获取表格数据 list_llfd_yuan = get_col_two(list_heng, 2).copy() # 将表格数据生成列表 list_llfd = del_list_tup(list_llfd_yuan, ' ') if list_llfd == []: print("列表查询数据为空,无法比较") else: sql_kk = "SELECT a.FOCA_TIME,a.THEORY_GENER_NUM \ FROM GF_SPPS_PROD_THEORY a WHERE a.FOCA_DATE='now_date()' and mod(to_char(to_date(a.foca_time,'HH24:mi:ss'),'mi'),15)=0 ORDER BY a.FOCA_TIME asc" sql = sql_kk.replace("now_date()", yes_date()) list_sql = get_oracle_h(sql, 2) # 查询数据库 print('理论发电量表格数据为:', list_llfd) print('理论发电量sql数据为', list_sql) print('\n') self.assertEqual(list_llfd, list_sql)
def test_6_sjgl(self): '''功率曲线展示 > 短期上报曲线 > 实际功率>2天''' driver = self.driver driver.maximize_window() start( driver, 'http://192.168.60.21:8080/SPPS/weatherInfo/temCurveAction.action') click_list = ['功率曲线展示', '上报曲线'] # 点击菜单 menu(driver, click_list) if now_time()[0] != 1: print("waiting 70") time.sleep(70) set_date(driver, yes_date(), now_date()) driver.find_element_by_id('search').click() # 搜索 time.sleep(2) hang = '/html/body/div/div[2]/div[2]/div[2]/div[2]/div[2]/table/tbody/tr' global list_heng list_heng = get_heng(driver, hang) # 获取表格数据 list_sjgl_yuan = get_col(list_heng, 3).copy() # 将表格数据生成列表 list_sjgl = del_list_tup(list_sjgl_yuan, ' ') if list_sjgl == []: print("列表查询数据为空,无法比较") else: sql_kk = "SELECT a.GATHER_DATE,a.GATHER_TIME,a.POWER_VALUE FROM GF_SPPS_POWER_HIS a \ WHERE a.GATHER_DATE in ('yes_date()','now_date()') ORDER BY a.GATHER_DATE,a.GATHER_TIME asc" sql = sql_kk.replace("now_date()", now_date()) sql = sql.replace("yes_date()", yes_date()) list_sql = get_oracle_h(sql, 2) # 查询数据库 print('实际功率表格数据为:', list_sjgl) print('实际功率sql数据为', list_sql) print('\n') self.assertEqual(list_sjgl, list_sql)
def test_4_cdq(self): '''实时状态监控 > 预测理论功率曲线 > 超短期 > 两天''' driver = self.driver driver.maximize_window() start( driver, 'http://192.168.60.21:8080/SPPS/weatherInfo/temCurveAction.action') click_list = ['实时状态监控', '预测理论功率曲线'] #点击菜单 menu(driver, click_list) if now_time()[0] != 1: print("waiting 70") time.sleep(70) set_date(driver, yes_date(), now_date()) driver.find_element_by_id('search').click() #搜索 time.sleep(2) hang = '/html/body/div/div[2]/div[2]/div[2]/div[2]/div[2]/table/tbody/tr' global list_heng list_heng = get_heng(driver, hang) #获取表格数据 list_cdq_yuan = get_col_two(list_heng, 2).copy() # 将表格数据生成列表 list_cdq = del_list_tup(list_cdq_yuan, ' ') if list_cdq == []: print("列表查询数据为空,无法比较") else: sql_kk = "SELECT a.PRE_TIME,a.PRE_POWER FROM SPPS_PREDICT_CDQ_DEAL a WHERE PRE_DATE" \ " in('yes_date()','now_date()') ORDER BY a.PRE_DATE,a.PRE_TIME" sql = sql_kk.replace("now_date()", now_date()) sql = sql.replace("yes_date()", yes_date()) list_sql = get_oracle_h(sql, 2) # 查询数据库 print('超短期表格数据为:', list_cdq) print('超短期sql数据为', list_sql) print('\n') self.assertEqual(list_cdq, list_sql)
def test_6_rlj_y(self): '''实时状态监控 > 发电量曲线 > 日累计发电量''' list_rlj_yuan = get_col_two(list_heng, 4) list_rlj = del_list_tup(list_rlj_yuan, ' ') if list_rlj == []: print("列表查询数据为空,无法比较") else: sql_kk = "SELECT a.FOCA_TIME,a.POWER_GENERATION \ FROM GF_SPPS_PROD_THEORY a WHERE a.FOCA_DATE='now_date()' and mod(to_char(to_date(a.foca_time,'HH24:mi:ss'),'mi'),15)=0 ORDER BY a.FOCA_TIME asc" sql = sql_kk.replace("now_date()", yes_date()) list_rlj_sql = get_oracle_h(sql, 2) print('日累计发电量表格数据为:', list_rlj) print('日累计发电量sql数据为', list_rlj_sql) print('\n') self.assertEqual(list_rlj, list_rlj_sql)
def test_7_zyg_two(self): '''实时状态监控 > 理论功率曲线 > 总有功>两天''' list_zyg_yuan = get_col_two(list_heng, 5) list_zyg = del_list_tup(list_zyg_yuan, ' ') if list_zyg == []: print("列表查询数据为空,无法比较") else: sql_kk = "SELECT a.GATHER_TIME,a.POWER_VALUE FROM GF_SPPS_POWER_HIS a WHERE a.GATHER_DATE in('yes_date()','now_date()') ORDER BY a.GATHER_DATE,a.GATHER_TIME" sql = sql_kk.replace("now_date()", now_date()) sql = sql.replace("yes_date()", yes_date()) list_zyg_sql = get_oracle_h(sql, 2) print('总有功表格数据为:', list_zyg) print('总有功sql数据为', list_zyg_sql) print('\n') self.assertEqual(list_zyg, list_zyg_sql)
def test_8_qg_two(self): '''实时状态监控 > 理论功率曲线 > 弃光功率 >两天''' list_qg_yuan = get_col_two(list_heng, 4) list_qg = del_list_tup(list_qg_yuan, ' ') if list_qg == []: print("列表查询数据为空,无法比较") else: sql_kk = "SELECT a.FOCA_TIME,a.ABAN_NUM FROM GF_SPPS_PROD_THEORY a \ WHERE a.FOCA_DATE in('yes_date()','now_date()') and mod(to_char(to_date(a.foca_time,'HH24:mi:ss'),'mi'),15)=0 ORDER BY a.FOCA_DATE,a.FOCA_TIME asc" sql = sql_kk.replace("now_date()", now_date()) sql = sql.replace("yes_date()", yes_date()) list_qg_sql = get_oracle_h(sql, 2) print('弃光功率表格数据为:', list_qg) print('弃光功率sql数据为', list_qg_sql) print('\n') self.assertEqual(list_qg, list_qg_sql)
def test_9_0_4h(self): '''功率曲线展示 > 短期上报曲线 > 4h预测功率>2天''' list_4h_yuan = get_col(list_heng, 7) list_4h = del_list_tup(list_4h_yuan, ' ') if list_4h == []: print("列表查询数据为空,无法比较") else: sql_kk = "SELECT a.PRE_DATE,a.PRE_TIME,a.PRE_POWER \ FROM SPPS_PREDICT_CDQ_HIS a WHERE POINT='240' AND PRE_DATE in ('yes_date()','now_date()') ORDER BY a.PRE_DATE,a.PRE_TIME asc" sql = sql_kk.replace("now_date()", now_date()) sql = sql.replace("yes_date()", yes_date()) list_4h_sql = get_oracle_h(sql, 2) print('4h理论功率表格数据为:', list_4h) print('4h理论功率sql数据为', list_4h_sql) print('\n') self.assertEqual(list_4h, list_4h_sql)
def test_7_llgl(self): '''功率曲线展示 > 短期上报曲线 > 理论功率>2天''' list_llgl_yuan = get_col(list_heng, 4) list_llgl = del_list_tup(list_llgl_yuan, ' ') if list_llgl == []: print("列表查询数据为空,无法比较") else: sql_kk = "SELECT a.FOCA_DATE,a.FOCA_TIME,a.THEORY_NUM FROM GF_SPPS_PROD_THEORY a \ WHERE a.FOCA_DATE in ('yes_date()','now_date()') and mod(to_char(to_date(a.foca_time,'HH24:mi:ss'),'mi'),15)=0 ORDER BY a.FOCA_DATE,a.FOCA_TIME asc" sql = sql_kk.replace("now_date()", now_date()) sql = sql.replace("yes_date()", yes_date()) list_llgl_sql = get_oracle_h(sql, 2) print('理论功率表格数据为:', list_llgl) print('理论功率sql数据为', list_llgl_sql) print('\n') self.assertEqual(list_llgl, list_llgl_sql)
def test_5_ycll(self): '''实时状态监控 > 预测理论功率曲线 > 预测理论功率 > 两天''' list_ycll_yuan = get_col_two(list_heng, 3) list_ycll = del_list_tup(list_ycll_yuan, ' ') if list_ycll == []: print("列表查询数据为空,无法比较") else: sql_kk = "SELECT a.PRE_TIME,a.PRE_POWER \ FROM SPPS_PREDICT_CDQ_DEAL_PH a WHERE PRE_DATE in('yes_date()','now_date()') ORDER BY a.PRE_DATE,a.PRE_TIME" sql = sql_kk.replace("now_date()", now_date()) sql = sql.replace("yes_date()", yes_date()) list_ycll_sql = get_oracle_h(sql, 2) print('预测理论功率表格数据为:', list_ycll) print('预测理论功率sql数据为', list_ycll_sql) print('\n') self.assertEqual(list_ycll, list_ycll_sql)