Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 132:5a583cff97ea | 133:56655046194f |
|---|---|
| 56 Collection<Result> results = queryExecutor.executeQuery("mesh", null); | 56 Collection<Result> results = queryExecutor.executeQuery("mesh", null); |
| 57 if (results == null || results.size() == 0){ | 57 if (results == null || results.size() == 0){ |
| 58 log.error("Keine Daten erhalten"); | 58 log.error("Keine Daten erhalten"); |
| 59 fail(); | 59 fail(); |
| 60 }else { | 60 }else { |
| 61 log.debug("Datem erhalten"); | 61 assertEquals(6, results.size()); |
| 62 log.debug("6 Datensätze erhalten"); | |
| 62 Iterator<Result> it = results.iterator(); | 63 Iterator<Result> it = results.iterator(); |
| 63 while (it.hasNext()){ | 64 while (it.hasNext()){ |
| 64 Result tmpResult = it.next(); | 65 Result tmpResult = it.next(); |
| 65 ResultDescriptor resultDescriptor = tmpResult.getResultDescriptor(); | 66 ResultDescriptor resultDescriptor = tmpResult.getResultDescriptor(); |
| 66 int columns = resultDescriptor.getColumnCount(); | 67 int columns = resultDescriptor.getColumnCount(); |
| 69 Object value = tmpResult.getObject(columnName); | 70 Object value = tmpResult.getObject(columnName); |
| 70 log.debug(columnName + " ==> "+value.toString()); | 71 log.debug(columnName + " ==> "+value.toString()); |
| 71 } | 72 } |
| 72 } | 73 } |
| 73 } | 74 } |
| 75 | |
| 76 // Quering Data with where clause | |
| 77 results = queryExecutor.executeQuery("mesh_id", new String[]{"5"}); | |
| 78 if (results == null || results.size() == 0){ | |
| 79 log.error("Keine Daten erhalten"); | |
| 80 fail(); | |
| 81 }else { | |
| 82 assertEquals(1, results.size()); | |
| 83 log.debug("1 Datensatz erhalten"); | |
| 84 log.debug("Daten erhalten"); | |
| 85 Iterator<Result> it = results.iterator(); | |
| 86 while (it.hasNext()){ | |
| 87 Result tmpResult = it.next(); | |
| 88 ResultDescriptor resultDescriptor = tmpResult.getResultDescriptor(); | |
| 89 int columns = resultDescriptor.getColumnCount(); | |
| 90 for (int i = 0; i < columns; i++){ | |
| 91 String columnName = resultDescriptor.getColumnName(i); | |
| 92 Object value = tmpResult.getObject(columnName); | |
| 93 log.debug(columnName + " ==> "+value.toString()); | |
| 94 } | |
| 95 } | |
| 96 } | |
| 97 | |
| 74 } catch (QueryException e) { | 98 } catch (QueryException e) { |
| 75 log.error(e,e); | 99 log.error(e,e); |
| 76 fail(); | 100 fail(); |
| 77 } | 101 } |
| 78 } | 102 } |