Mercurial > dive4elements > gnv-client
diff gnv-artifacts/src/test/ressources/queries.properties @ 114:d8d38a4dd965
Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
gnv-artifacts/trunk@164 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Wed, 30 Sep 2009 13:48:02 +0000 |
| parents | 2aae4a78e555 |
| children | 820238357bab |
line wrap: on
line diff
--- a/gnv-artifacts/src/test/ressources/queries.properties Wed Sep 30 13:42:51 2009 +0000 +++ b/gnv-artifacts/src/test/ressources/queries.properties Wed Sep 30 13:48:02 2009 +0000 @@ -332,4 +332,66 @@ MSV.PARAMETERID in (?) \ ORDER BY IP.TIMEVALUE, \ MSV.PARAMETERID, \ - M.ZLOCATION \ No newline at end of file + M.ZLOCATION + +############################################# +############################################# +#### Horizontalprofil InstantaneousPoint #### +############################################# +############################################# + +horizontalprofile_instantaneouspoint_cruise = SELECT \ + CRUISEID KEY , \ + NAME VALUE \ + FROM MEDIAN.CRUISE \ + WHERE NAME IS NOT NULL \ + ORDER BY NAME +horizontalprofile_instantaneouspoint_track= SELECT \ + TRACKID KEY , \ + NAME VALUE \ + FROM MEDIAN.TRACK \ + WHERE CRUISEID = ? \ + ORDER BY NAME +horizontalprofile_instantaneouspoint_surveyinfo = SELECT \ + SURVEYID KEY , \ + DESCRIPTION VALUE \ + FROM MEDIAN.SURVEYINFO \ + WHERE TRACKID = ? \ + ORDER BY DESCRIPTION +horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ + P.PARAMETERID KEY , \ + P.GERMANNAME VALUE \ + FROM MEDIAN.PARAMETER P , \ + MEDIAN.MEASUREMENT M , \ + MEDIAN.INSTANTANEOUSPOINT IP , \ + MEDIAN.MEASUREDSCALARVALUE MSV \ + WHERE P.PARAMETERID = MSV.PARAMETERID AND \ + MSV.MEASUREMENTID = M.MEASUREMENTID AND \ + M.FEATUREID = IP.FEATUREID AND \ + IP.SURVEYID = ? \ + ORDER BY P.GERMANNAME +horizontalprofile_instantaneouspoint_depth = SELECT DISTINCT \ + M.ZLOCATION KEY, \ + M.ZLOCATION VALUE \ + FROM MEDIAN.MEASUREMENT M , \ + MEDIAN.INSTANTANEOUSPOINT IP \ + WHERE M.FEATUREID = IP.FEATUREID AND \ + IP.SURVEYID = ? \ + ORDER BY M.ZLOCATION +horizontalprofile_instantaneouspoint_chart_data = SELECT M.XLOCATION XORDINATE_XCOORD , \ + M.YLOCATION XORDINATE_YCOORD , \ + MSV.DATAVALUE YORDINATE , \ + MSV.PARAMETERID GROUP1 , \ + IP.TIMEVALUE GROUP2 , \ + 1 GROUP3 \ + FROM MEDIAN.INSTANTANEOUSPOINT IP, \ + MEDIAN.MEASUREMENT M, \ + MEDIAN.MEASUREDSCALARVALUE MSV \ + WHERE IP.FEATUREID = M.FEATUREID AND \ + M.MEASUREMENTID = MSV.MEASUREMENTID AND \ + IP.SURVEYID = ? AND \ + M.ZLOCATION IN (?) AND \ + MSV.PARAMETERID in (?) \ + ORDER BY IP.TIMEVALUE, \ + MSV.PARAMETERID, \ + M.ZLOCATION