Mercurial > dive4elements > gnv-client
changeset 269:db8920c5346d
Added further Queries for Testing Spatial-Query-Support
geo-backend/trunk@220 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Wed, 14 Oct 2009 10:58:49 +0000 |
| parents | 71b2f263f036 |
| children | 1fe93e3c80c0 |
| files | geo-backend/ChangeLog geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java geo-backend/src/test/ressources/QueryExecutorTestCase.properties |
| diffstat | 3 files changed, 42 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/geo-backend/ChangeLog Wed Oct 14 10:01:45 2009 +0000 +++ b/geo-backend/ChangeLog Wed Oct 14 10:58:49 2009 +0000 @@ -1,3 +1,9 @@ +2009-10-14 Tim Englich <tim.englich@intevation.de> + + * src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java (testSpatialQueryWithoutIntersects), + src/test/ressources/QueryExecutorTestCase.properties: + Added further Queries for Testing Spatial-Query-Support + 2009-10-14 Tim Englich <tim.englich@intevation.de> * src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java (getPosValue):
--- a/geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java Wed Oct 14 10:01:45 2009 +0000 +++ b/geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java Wed Oct 14 10:58:49 2009 +0000 @@ -59,6 +59,7 @@ public void testSpatialQueryWithoutIntersects(){ try { this.testQuery(286, "spatial_query_without_intersects", null); + this.testQuery(98, "spatial_query_without_intersects2", null); } catch (QueryException e) { log.error(e,e); fail();
--- a/geo-backend/src/test/ressources/QueryExecutorTestCase.properties Wed Oct 14 10:01:45 2009 +0000 +++ b/geo-backend/src/test/ressources/QueryExecutorTestCase.properties Wed Oct 14 10:58:49 2009 +0000 @@ -34,4 +34,38 @@ m.ZLOCATION IN (-16.843 , -15.852) AND \ MSV.PARAMETERID in (2 , 1) \ ORDER BY MSV.PARAMETERID, \ - m.ZLOCATION \ No newline at end of file + m.ZLOCATION + +spatial_query_without_intersects2 = SELECT ST_ASTEXT(SHAPE), \ + msv.DATAVALUE YORDINATE, \ + msv.PARAMETERID GROUP1, \ + msv.TIMEVALUE GROUP2, \ + MEDIAN.MESHPOINT.KPOSITION GROUP3, \ + MEDIAN.MESHPOINT.JPOSITION , \ + MEDIAN.MESHPOINT.IPOSITION \ + from MEDIAN.MESHLAYER ml, \ + MEDIAN.MESHPOINT , \ + MEDIAN.MESH m, \ + MEDIAN.MESHSCALARVALUE msv \ + where msv.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \ + ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ + ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ + m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ + m.PARTIDMIN <= msv.PARTID AND \ + m.PARTIDMAX >= msv.PARTID AND \ + msv.PARAMETERID in (2,1) AND \ + msv.TIMEVALUE in (to_date('2009.10.15 23:00:00', 'YYYY.MM.DD HH24:MI:SS')) AND \ + m.OBJECTID = 3 AND \ + MEDIAN.MESHPOINT.FEATUREID in \ + ( select FEATUREID \ + from MEDIAN.MESHPOINT mp, \ + MEDIAN.MESH m \ + where m.OBJECTID = 3 AND \ + mp.MESHID = m.MESHID AND \ + KPOSITION in ( 1 ) and \ + JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = 2003771)) \ + order by MEDIAN.MESHPOINT.KPOSITION, \ + msv.TIMEVALUE, \ + msv.PARAMETERID, \ + MEDIAN.MESHPOINT.JPOSITION , \ + MEDIAN.MESHPOINT.IPOSITION \ No newline at end of file