def test_1_tianqi(self): '''气象信息展示 > 温度曲线 >天气预报''' self.driver = choose('firefox') driver = self.driver driver.maximize_window() start( driver, 'http://192.168.60.36:8080/SPPS/weatherInfo/temCurveAction.action') click_list = ['气象信息展示', '温度曲线'] #点击菜单 menu(driver, click_list) set_date(driver) 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_wen_yuan = get_col(list_heng, 3).copy() #将表格数据生成列表 list_wen = del_list_tup(list_wen_yuan, ' ') if list_wen == []: print("列表查询数据为空,无法比较") else: list_wen.pop() list_sql = get_oracle_h('192.168.60.36', "SELECT a.PRE_DATE,a.PRE_TIME,a.ARI_TEM \ FROM GF_SPPS_NWP_DEAL a WHERE PRE_DATE='2017-09-06' ORDER BY PRE_TIME asc", 2) #查询数据库 print('表格数据为:', list_wen) print('sql查询值为', list_sql) print('\n') self.assertEqual(list_wen, list_sql)
def gf_liuchen(click_list, datelist, its_xpath): #浏览器,菜单列表,是否点日历,日历列表,xpath,数据库列表 driver = choose("firefox") driver.maximize_window() start(driver) # click_list = ['气象信息展示', '温度曲线'] #点击菜单 menu(driver, click_list) if datelist[0] == 1: set_date(driver, datelist[1], datelist[2]) else: pass driver.find_element_by_id('search').click() #搜索 time.sleep(2) hang = its_xpath # hang='/html/body/div/div[2]/div[2]/div[2]/div[2]/div[2]/table/tbody/tr' list_heng = get_heng(driver, hang).copy() #获取表格数据 list_wen = get_col(list_heng, n).copy() #将表格数据生成列表 # list_sql=get_oracle_h('192.168.60.36',"SELECT a.PRE_DATE,a.PRE_TIME,a.ARI_TEM \ # FROM GF_SPPS_NWP_DEAL a WHERE PRE_DATE='2017-08-08' ORDER BY PRE_TIME asc", 2)#查询数据库 list_sql = get_oracle_h(list_oracle[0], list_oracle[1], list_oracle[2]) print(list_wen) print(list_sql) list_wen.pop() return list_wen, list_sql, driver
def setUp(self): self.driver = choose('firefox')