# HG changeset patch
# User Tim Englich <tim.englich@intevation.de>
# Date 1255517929 0
# Node ID db8920c5346db792593b72cced916ae1eebe0164
# Parent  71b2f263f0365997340140f3f1b7bc744bfbe0bd
Added further Queries for Testing Spatial-Query-Support

geo-backend/trunk@220 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 71b2f263f036 -r db8920c5346d geo-backend/ChangeLog
--- 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): 
diff -r 71b2f263f036 -r db8920c5346d geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java
--- 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();
diff -r 71b2f263f036 -r db8920c5346d geo-backend/src/test/ressources/QueryExecutorTestCase.properties
--- 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