Mercurial > dive4elements > gnv-client
comparison geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java @ 379:31595c0a1a33
Revert Changes of the commit of Revision 377 which was unintended
geo-backend/trunk@380 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 27 Nov 2009 13:13:34 +0000 |
| parents | 6a585e87c18b |
| children | 1c3efbd2fc5a |
comparison
equal
deleted
inserted
replaced
| 378:9ed654c21f9b | 379:31595c0a1a33 |
|---|---|
| 80 } | 80 } |
| 81 | 81 |
| 82 | 82 |
| 83 public void testChooseFis(){ | 83 public void testChooseFis(){ |
| 84 try { | 84 try { |
| 85 this.testQuery(4, "choose_fis_query", null); | 85 this.testQuery(1, "choose_fis_query", null); |
| 86 } catch (QueryException e) { | |
| 87 log.error(e, e); | |
| 88 //fail(); | |
| 89 } | |
| 90 try { | |
| 91 this.testQuery(33, "choose_fis_query_2", null); | |
| 92 } catch (QueryException e) { | |
| 93 log.error(e, e); | |
| 94 //fail(); | |
| 95 } | |
| 96 try { | |
| 97 this.testQuery(4, "choose_fis_query_3", null); | |
| 98 } catch (QueryException e) { | |
| 99 log.error(e, e); | |
| 100 //fail(); | |
| 101 } | |
| 102 } | |
| 103 | |
| 104 public void testChooseFisAttributeFirst(){ | |
| 105 try { | |
| 106 this.testQuery(33, "choose_fis_query", null); | |
| 107 } catch (QueryException e) { | |
| 108 log.error(e, e); | |
| 109 //fail(); | |
| 110 } | |
| 111 } | |
| 112 | |
| 113 | |
| 114 public void testAreaFilterInstPoint(){ | |
| 115 try { | |
| 116 //this.testQuery(2, "test_vehicle_orig", null); | |
| 117 this.testQuery(4, "test_track_area", null); | |
| 118 } catch (QueryException e) { | |
| 119 log.error(e, e); | |
| 120 //fail(); | |
| 121 } | |
| 122 } | |
| 123 | |
| 124 public void testChooseFisSpatialFirst(){ | |
| 125 try { | |
| 126 this.testQuery(4, "choose_fis_query", null); | |
| 127 } catch (QueryException e) { | |
| 128 log.error(e, e); | |
| 129 //fail(); | |
| 130 } | |
| 131 } | |
| 132 | |
| 133 public void testODVQueries(){ | |
| 134 try { | |
| 135 //this.testQuery(47875, "query_odv_data_timeseriespoint", null); | |
| 136 //this.testQuery(5, "query_odv_data_vp_timeseriespoint", null); | |
| 137 //this.testQuery(672, "query_odv_data_mesh", null); | |
| 138 this.testQuery(8, "query_odv_data_vp_mesh", null); | |
| 139 | |
| 140 } catch (QueryException e) { | 86 } catch (QueryException e) { |
| 141 log.error(e, e); | 87 log.error(e, e); |
| 142 fail(); | 88 fail(); |
| 143 } | 89 } |
| 144 } | 90 } |
| 205 ResultDescriptor resultDescriptor = tmpResult.getResultDescriptor(); | 151 ResultDescriptor resultDescriptor = tmpResult.getResultDescriptor(); |
| 206 int columns = resultDescriptor.getColumnCount(); | 152 int columns = resultDescriptor.getColumnCount(); |
| 207 for (int i = 0; i < columns; i++){ | 153 for (int i = 0; i < columns; i++){ |
| 208 String columnName = resultDescriptor.getColumnName(i); | 154 String columnName = resultDescriptor.getColumnName(i); |
| 209 Object value = tmpResult.getString(columnName); | 155 Object value = tmpResult.getString(columnName); |
| 210 if (value != null) | |
| 211 log.debug(columnName + " ==> "+value.toString()); | 156 log.debug(columnName + " ==> "+value.toString()); |
| 212 } | 157 } |
| 213 } | 158 } |
| 214 // } | 159 // } |
| 215 log.debug("Query dauerte: "+(System.currentTimeMillis()-start) +"ms"); | 160 log.debug("Query dauerte: "+(System.currentTimeMillis()-start) +"ms"); |