功能测试
1.测试值班记录表,构成的状态数组
select * from (
select observer_date,observer_time,isopen,rownum
from aoc_cinrad.cinrad_onwatch
where stationnum=‘Z9555‘
and observer_date = ‘20070305‘
order by observer_time desc
)
where rownum = 1;
select Observer_Date,Observer_Time,IsOpen
from AOC_CINRAD.CINRAD_ONWATCH
where StationNum=‘Z9555‘
and Observer_Date = ‘20070101‘
order by Observer_Time;
测试站点 测试日期 测试结果
Z9551 20070215 OK
Z9551 20070301 OK
Z9551 20070228 OK
Z9555 20070216 OK
Z9555 20070228 OK
Z9555 20070306 OK
2.状态表数组\状态记录表
Z9555 cc 38所
测试站点 测试日期 测试结果
Z9555 20070216 OK
Z9555 20070228 OK
Z9555 20070306 OK
Z9555 20070101 OK
Z9555 20070215 OK
select distinct(substr(STATUS_TIME,1,3))
from CINRAD_HIS_38_STATUS
where STATIONNUM = ‘Z9555‘
and STATUS_DATE = ‘20070216‘
order by substr(STATUS_TIME,1,3);
测试站点 测试日期 测试结果
Z9551 20070215 OK
Z9551 20070301 OK
Z9551 20070228 OK
select distinct(substr(STATUS_TIME,1,3))
from CINRAD_HIS_MS_STATUS
where RADAR_STATION_ID = ‘Z9551‘
and STATUS_DATA = ‘20070228‘
order by substr(STATUS_TIME,1,3);
测试站点 测试日期 测试结果
Z9834 20070215 OK
Z9834 20070301 OK
Z9834 20070101 OK
select distinct(substr(STATUS_TIME,1,3))
from CINRAD_HIS_784_STATUS
where STATIONNUM = ‘Z9834‘
and STATUS_DATE = ‘20070101‘
order by substr(STATUS_TIME,1,3);
3.报警记录
Z9555 cc 38所
测试站点 测试日期 测试结果
Z9555 20070216 OK
Z9555 20070228 OK
Z9555 20070306 OK
Z9555 20070101 OK
Z9555 20070215 OK
select STATUS+1,Status_time
from V_CINRAD_HIS_38_ALARM
where Stationnum = ‘Z9555‘
and Status_date = ‘20070101‘
order by status_time;
测试站点 测试日期 测试结果
Z9551 20070215 OK
Z9551 20070301 OK
Z9551 20070228 OK
select Status_time,STATUS
from V_CINRAD_HIS_MST_ALARM
where Stationnum = ‘Z9551‘
and Status_date = ‘20070228‘
order by Status_time;
###
编辑修改后功能
select Status_time,decode(STATUS,‘MR‘,2,‘MM‘,3,‘IN‘,4,‘N/A‘,2,0) as STATUSS
from V_CINRAD_HIS_MST_ALARM
where Stationnum = ‘Z9551‘
and Status_date like ‘20070108‘
order by Status_time;
测试站点 测试日期 测试结果
Z9834 20070215 OK
Z9834 20070301 OK
Z9834 20070101 OK
select distinct(substr(STATUS_TIME,1,3))
from V_CINRAD_HIS_784_ALARM
where Stationnum = ‘Z9859‘
and Status_date = ‘20070101‘
order by substr(STATUS_TIME,1,3);
4.状态汇总
测试站点 测试日期 测试结果
Z9555 20070216 OK
Z9555 20070228 OK
Z9555 20070306 OK
Z9555 20070101 OK
Z9555 20070215 OK
测试站点 测试日期 测试结果
Z9551 20070215 OK
Z9551 20070301 OK
Z9551 20070228 OK
测试站点 测试日期 测试结果
Z9834 20070215 OK
Z9834 20070301 OK
Z9834 20070101 OK
########################################
值班记录表
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。