Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 113:a16f5267803e | 114:d8d38a4dd965 |
|---|---|
| 331 IP.FEATUREID = ? AND \ | 331 IP.FEATUREID = ? AND \ |
| 332 MSV.PARAMETERID in (?) \ | 332 MSV.PARAMETERID in (?) \ |
| 333 ORDER BY IP.TIMEVALUE, \ | 333 ORDER BY IP.TIMEVALUE, \ |
| 334 MSV.PARAMETERID, \ | 334 MSV.PARAMETERID, \ |
| 335 M.ZLOCATION | 335 M.ZLOCATION |
| 336 | |
| 337 ############################################# | |
| 338 ############################################# | |
| 339 #### Horizontalprofil InstantaneousPoint #### | |
| 340 ############################################# | |
| 341 ############################################# | |
| 342 | |
| 343 horizontalprofile_instantaneouspoint_cruise = SELECT \ | |
| 344 CRUISEID KEY , \ | |
| 345 NAME VALUE \ | |
| 346 FROM MEDIAN.CRUISE \ | |
| 347 WHERE NAME IS NOT NULL \ | |
| 348 ORDER BY NAME | |
| 349 horizontalprofile_instantaneouspoint_track= SELECT \ | |
| 350 TRACKID KEY , \ | |
| 351 NAME VALUE \ | |
| 352 FROM MEDIAN.TRACK \ | |
| 353 WHERE CRUISEID = ? \ | |
| 354 ORDER BY NAME | |
| 355 horizontalprofile_instantaneouspoint_surveyinfo = SELECT \ | |
| 356 SURVEYID KEY , \ | |
| 357 DESCRIPTION VALUE \ | |
| 358 FROM MEDIAN.SURVEYINFO \ | |
| 359 WHERE TRACKID = ? \ | |
| 360 ORDER BY DESCRIPTION | |
| 361 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ | |
| 362 P.PARAMETERID KEY , \ | |
| 363 P.GERMANNAME VALUE \ | |
| 364 FROM MEDIAN.PARAMETER P , \ | |
| 365 MEDIAN.MEASUREMENT M , \ | |
| 366 MEDIAN.INSTANTANEOUSPOINT IP , \ | |
| 367 MEDIAN.MEASUREDSCALARVALUE MSV \ | |
| 368 WHERE P.PARAMETERID = MSV.PARAMETERID AND \ | |
| 369 MSV.MEASUREMENTID = M.MEASUREMENTID AND \ | |
| 370 M.FEATUREID = IP.FEATUREID AND \ | |
| 371 IP.SURVEYID = ? \ | |
| 372 ORDER BY P.GERMANNAME | |
| 373 horizontalprofile_instantaneouspoint_depth = SELECT DISTINCT \ | |
| 374 M.ZLOCATION KEY, \ | |
| 375 M.ZLOCATION VALUE \ | |
| 376 FROM MEDIAN.MEASUREMENT M , \ | |
| 377 MEDIAN.INSTANTANEOUSPOINT IP \ | |
| 378 WHERE M.FEATUREID = IP.FEATUREID AND \ | |
| 379 IP.SURVEYID = ? \ | |
| 380 ORDER BY M.ZLOCATION | |
| 381 horizontalprofile_instantaneouspoint_chart_data = SELECT M.XLOCATION XORDINATE_XCOORD , \ | |
| 382 M.YLOCATION XORDINATE_YCOORD , \ | |
| 383 MSV.DATAVALUE YORDINATE , \ | |
| 384 MSV.PARAMETERID GROUP1 , \ | |
| 385 IP.TIMEVALUE GROUP2 , \ | |
| 386 1 GROUP3 \ | |
| 387 FROM MEDIAN.INSTANTANEOUSPOINT IP, \ | |
| 388 MEDIAN.MEASUREMENT M, \ | |
| 389 MEDIAN.MEASUREDSCALARVALUE MSV \ | |
| 390 WHERE IP.FEATUREID = M.FEATUREID AND \ | |
| 391 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ | |
| 392 IP.SURVEYID = ? AND \ | |
| 393 M.ZLOCATION IN (?) AND \ | |
| 394 MSV.PARAMETERID in (?) \ | |
| 395 ORDER BY IP.TIMEVALUE, \ | |
| 396 MSV.PARAMETERID, \ | |
| 397 M.ZLOCATION |