diff geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java @ 377:6a585e87c18b

Added RegionFilter-Support to HorizontalProfile InstantaneousPoint geo-backend/trunk@377 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Fri, 27 Nov 2009 12:59:04 +0000
parents 9063c5fcebf7
children 31595c0a1a33
line wrap: on
line diff
--- a/geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java	Fri Nov 13 18:21:31 2009 +0000
+++ b/geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java	Fri Nov 27 12:59:04 2009 +0000
@@ -82,7 +82,61 @@
     
     public void  testChooseFis(){
         try {
-            this.testQuery(1, "choose_fis_query", null);
+            this.testQuery(4, "choose_fis_query", null);
+        } catch (QueryException e) {
+            log.error(e, e);
+            //fail();
+        }
+        try {
+            this.testQuery(33, "choose_fis_query_2", null);
+        } catch (QueryException e) {
+            log.error(e, e);
+            //fail();
+        }
+        try {
+            this.testQuery(4, "choose_fis_query_3", null);
+        } catch (QueryException e) {
+            log.error(e, e);
+            //fail();
+        }
+    }
+    
+    public void  testChooseFisAttributeFirst(){
+        try {
+            this.testQuery(33, "choose_fis_query", null);
+        } catch (QueryException e) {
+            log.error(e, e);
+            //fail();
+        }
+    }
+    
+    
+    public void  testAreaFilterInstPoint(){
+        try {
+            //this.testQuery(2, "test_vehicle_orig", null);
+            this.testQuery(4, "test_track_area", null);
+        } catch (QueryException e) {
+            log.error(e, e);
+            //fail();
+        }
+    }
+    
+    public void  testChooseFisSpatialFirst(){
+        try {
+            this.testQuery(4, "choose_fis_query", null);
+        } catch (QueryException e) {
+            log.error(e, e);
+            //fail();
+        }
+    }
+    
+    public void  testODVQueries(){
+        try {
+            //this.testQuery(47875, "query_odv_data_timeseriespoint", null);
+            //this.testQuery(5, "query_odv_data_vp_timeseriespoint", null);
+            //this.testQuery(672, "query_odv_data_mesh", null);
+            this.testQuery(8, "query_odv_data_vp_mesh", null);
+            
         } catch (QueryException e) {
             log.error(e, e);
             fail();
@@ -153,6 +207,7 @@
                 for (int i = 0; i < columns; i++){
                     String columnName = resultDescriptor.getColumnName(i);
                     Object value = tmpResult.getString(columnName);
+                    if (value != null)
                     log.debug(columnName + " ==> "+value.toString());
                 }
             }

http://dive4elements.wald.intevation.org