diff geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java @ 133:56655046194f

Fix Bug setting the Filtervalues into the Statement. Further Testcases implemented. geo-backend/trunk@14 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Fri, 04 Sep 2009 08:49:50 +0000
parents 5a583cff97ea
children 9f2eaefe9dd4
line wrap: on
line diff
--- a/geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java	Fri Sep 04 08:11:30 2009 +0000
+++ b/geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java	Fri Sep 04 08:49:50 2009 +0000
@@ -58,7 +58,8 @@
                 log.error("Keine Daten erhalten");
                 fail();
             }else {
-                log.debug("Datem erhalten");
+                assertEquals(6, results.size());
+                log.debug("6 Datensätze erhalten");
                 Iterator<Result> it = results.iterator();
                 while (it.hasNext()){
                     Result tmpResult = it.next();
@@ -71,6 +72,29 @@
                     }
                 }
             }
+            
+            // Quering Data with where clause
+            results = queryExecutor.executeQuery("mesh_id", new String[]{"5"});
+            if (results == null || results.size() == 0){
+                log.error("Keine Daten erhalten");
+                fail();
+            }else {
+                assertEquals(1, results.size());
+                log.debug("1 Datensatz erhalten");
+                log.debug("Daten erhalten");
+                Iterator<Result> it = results.iterator();
+                while (it.hasNext()){
+                    Result tmpResult = it.next();
+                    ResultDescriptor resultDescriptor = tmpResult.getResultDescriptor();
+                    int columns = resultDescriptor.getColumnCount();
+                    for (int i = 0; i < columns; i++){
+                        String columnName = resultDescriptor.getColumnName(i);
+                        Object value = tmpResult.getObject(columnName);
+                        log.debug(columnName + " ==> "+value.toString());
+                    }
+                }
+            }
+            
         } catch (QueryException e) {
             log.error(e,e);
             fail();

http://dive4elements.wald.intevation.org