Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
279:3c38ef20d622 | 377:6a585e87c18b |
---|---|
80 } | 80 } |
81 | 81 |
82 | 82 |
83 public void testChooseFis(){ | 83 public void testChooseFis(){ |
84 try { | 84 try { |
85 this.testQuery(1, "choose_fis_query", null); | 85 this.testQuery(4, "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 | |
86 } catch (QueryException e) { | 140 } catch (QueryException e) { |
87 log.error(e, e); | 141 log.error(e, e); |
88 fail(); | 142 fail(); |
89 } | 143 } |
90 } | 144 } |
151 ResultDescriptor resultDescriptor = tmpResult.getResultDescriptor(); | 205 ResultDescriptor resultDescriptor = tmpResult.getResultDescriptor(); |
152 int columns = resultDescriptor.getColumnCount(); | 206 int columns = resultDescriptor.getColumnCount(); |
153 for (int i = 0; i < columns; i++){ | 207 for (int i = 0; i < columns; i++){ |
154 String columnName = resultDescriptor.getColumnName(i); | 208 String columnName = resultDescriptor.getColumnName(i); |
155 Object value = tmpResult.getString(columnName); | 209 Object value = tmpResult.getString(columnName); |
210 if (value != null) | |
156 log.debug(columnName + " ==> "+value.toString()); | 211 log.debug(columnName + " ==> "+value.toString()); |
157 } | 212 } |
158 } | 213 } |
159 // } | 214 // } |
160 log.debug("Query dauerte: "+(System.currentTimeMillis()-start) +"ms"); | 215 log.debug("Query dauerte: "+(System.currentTimeMillis()-start) +"ms"); |