Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/src/test/ressources/queries.properties @ 102:994a39b084d6
Imporved JUnitTest and Bugfixing as a Result of this Improvement.
gnv-artifacts/trunk@150 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 29 Sep 2009 09:55:40 +0000 |
| parents | ce398a7a99fc |
| children | 2aae4a78e555 |
comparison
equal
deleted
inserted
replaced
| 101:e01c163ea5b0 | 102:994a39b084d6 |
|---|---|
| 75 FROM MEDIAN.TIMESERIESVALUE tv, \ | 75 FROM MEDIAN.TIMESERIESVALUE tv, \ |
| 76 MEDIAN.TIMESERIES t \ | 76 MEDIAN.TIMESERIES t \ |
| 77 WHERE tv.TIMESERIESID = t.TIMESERIESID AND \ | 77 WHERE tv.TIMESERIESID = t.TIMESERIESID AND \ |
| 78 t.PARAMETERID IN ( ? ) AND \ | 78 t.PARAMETERID IN ( ? ) AND \ |
| 79 tv.MEASUREMENTID IN ( ? ) AND \ | 79 tv.MEASUREMENTID IN ( ? ) AND \ |
| 80 tv.TIMEVALUE > TO_DATE ('?', 'YYYY.MM.DD HH24:MI:SS') AND \ | 80 tv.TIMEVALUE > ? AND \ |
| 81 tv.TIMEVALUE < TO_DATE ('?', 'YYYY.MM.DD HH24:MI:SS') \ | 81 tv.TIMEVALUE < ? \ |
| 82 ORDER BY tv.MEASUREMENTID , \ | 82 ORDER BY tv.MEASUREMENTID , \ |
| 83 tv.TIMESERIESID , \ | 83 tv.TIMESERIESID , \ |
| 84 t.PARAMETERID , \ | 84 t.PARAMETERID , \ |
| 85 tv.TIMEVALUE | 85 tv.TIMEVALUE |
| 86 | 86 |
| 151 msv.PARTID >= m.PARTIDMIN AND \ | 151 msv.PARTID >= m.PARTIDMIN AND \ |
| 152 msv.PARTID <= m.PARTIDMAX ) AND \ | 152 msv.PARTID <= m.PARTIDMAX ) AND \ |
| 153 msv.FEATUREID in ( ? ) AND \ | 153 msv.FEATUREID in ( ? ) AND \ |
| 154 msv.PARAMETERID in ( ? ) AND \ | 154 msv.PARAMETERID in ( ? ) AND \ |
| 155 mp.FEATUREID = ? AND \ | 155 mp.FEATUREID = ? AND \ |
| 156 msv.TIMEVALUE >= to_date('?', 'YYYY.MM.DD HH24:MI:SS') AND \ | 156 msv.TIMEVALUE >= ? AND \ |
| 157 msv.TIMEVALUE <= to_date('?', 'YYYY.MM.DD HH24:MI:SS') \ | 157 msv.TIMEVALUE <= ? \ |
| 158 order by msv.FEATUREID, \ | 158 order by msv.FEATUREID, \ |
| 159 msv.PARAMETERID, \ | 159 msv.PARAMETERID, \ |
| 160 msv.TIMEVALUE | 160 msv.TIMEVALUE |
| 161 | 161 |
| 162 ############################################# | 162 ############################################# |