Mercurial > dive4elements > gnv-client
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();