Revision 44764 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.h2/src/test/java/org/gvsig/fmap/dal/store/h2/TestCreate.java
| TestCreate.java | ||
|---|---|---|
| 1 | 1 |
package org.gvsig.fmap.dal.store.h2; |
| 2 | 2 |
|
| 3 |
import java.time.LocalDate; |
|
| 4 |
import java.time.LocalTime; |
|
| 3 | 5 |
import java.util.Date; |
| 4 | 6 |
import java.util.List; |
| 5 | 7 |
import junit.framework.TestCase; |
| 6 | 8 |
import static junit.framework.TestCase.assertEquals; |
| 9 |
import org.gvsig.expressionevaluator.ExpressionBuilder; |
|
| 10 |
import org.gvsig.expressionevaluator.ExpressionUtils; |
|
| 11 |
import org.gvsig.expressionevaluator.GeometryExpressionBuilder; |
|
| 7 | 12 |
import org.gvsig.fmap.dal.DALLocator; |
| 8 | 13 |
import org.gvsig.fmap.dal.DataTypes; |
| 9 | 14 |
import org.gvsig.fmap.dal.DataManager; |
| ... | ... | |
| 13 | 18 |
import org.gvsig.fmap.dal.feature.EditableFeatureType; |
| 14 | 19 |
import org.gvsig.fmap.dal.feature.Feature; |
| 15 | 20 |
import org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor; |
| 21 |
import org.gvsig.fmap.dal.feature.FeatureQuery; |
|
| 22 |
import org.gvsig.fmap.dal.feature.FeatureSet; |
|
| 16 | 23 |
import org.gvsig.fmap.dal.feature.FeatureStore; |
| 17 | 24 |
import org.gvsig.fmap.dal.feature.FeatureType; |
| 18 | 25 |
import org.gvsig.fmap.dal.feature.NewFeatureStoreParameters; |
| ... | ... | |
| 267 | 274 |
|
| 268 | 275 |
} |
| 269 | 276 |
|
| 277 |
public void testFilterByDate() throws Exception {
|
|
| 278 |
FeatureStore sourceStore = TestUtils.openSourceStore1(); |
|
| 279 |
JDBCServerExplorer explorer = TestUtils.openServerExplorer(DBNAME); |
|
| 280 |
|
|
| 281 |
createFrom(explorer, sourceStore); |
|
| 282 |
copyFrom(explorer, sourceStore, FeatureStore.MODE_APPEND); |
|
| 283 |
|
|
| 284 |
FeatureStore h2Store = openTargetStore1(explorer); |
|
| 285 |
ExpressionBuilder expbuilder = ExpressionUtils.createExpressionBuilder(); |
|
| 270 | 286 |
|
| 287 |
String filter = expbuilder.or( |
|
| 288 |
expbuilder.and( |
|
| 289 |
expbuilder.gt( |
|
| 290 |
expbuilder.column("Time"),
|
|
| 291 |
expbuilder.time("01:02:03")
|
|
| 292 |
), |
|
| 293 |
expbuilder.lt( |
|
| 294 |
expbuilder.column("Time"),
|
|
| 295 |
expbuilder.time(new Date()) |
|
| 296 |
) |
|
| 297 |
), |
|
| 298 |
expbuilder.and( |
|
| 299 |
expbuilder.gt( |
|
| 300 |
expbuilder.column("Date"),
|
|
| 301 |
expbuilder.date("2019-02-17")
|
|
| 302 |
), |
|
| 303 |
expbuilder.lt( |
|
| 304 |
expbuilder.column("Date"),
|
|
| 305 |
expbuilder.date(new Date()) |
|
| 306 |
) |
|
| 307 |
) |
|
| 308 |
).toString(); |
|
| 309 |
FeatureQuery query = sourceStore.createFeatureQuery(); |
|
| 310 |
query.addFilter(filter); |
|
| 311 |
List<Feature> features = h2Store.getFeatures(query); |
|
| 312 |
int sz = features.size(); |
|
| 313 |
} |
|
| 314 |
|
|
| 271 | 315 |
} |
Also available in: Unified diff