public void testAfter() throws Exception { FilterFactory ff = dataStore.getFilterFactory(); After after = ff.after(ff.property(aname("dt")), ff.literal("2009-02-01 00:00:00")); assertDatesMatch(after, "2009-06-28 15:12:41", "2009-09-29 17:54:23"); }
private Query energyConsumptionGreaterThan(double value) { FilterFactory filterFactory = dataStore.getFilterFactory(); Filter filter = filterFactory.greater( filterFactory.property(aname("energy_consumption")), filterFactory.literal(value)); return new Query(tname("buildings"), filter); }
public void testBegunBy() throws Exception { Period period = period("2009-01-15 13:10:12", "2009-06-28 15:12:41"); FilterFactory ff = dataStore.getFilterFactory(); BegunBy before = ff.begunBy(ff.literal(period), ff.property(aname("dt"))); assertDatesMatch(before, "2009-01-15 13:10:12"); }
public void testTContains() throws Exception { Period period = period("2009-01-01 00:00:00", "2009-07-28 15:12:41"); FilterFactory ff = dataStore.getFilterFactory(); TContains during = ff.tcontains(ff.literal(period), ff.property(aname("dt"))); assertDatesMatch(during, "2009-01-15 13:10:12", "2009-06-28 15:12:41"); }
public void testBegins() throws Exception { Period period = period("2009-01-15 13:10:12", "2009-06-28 15:12:41"); FilterFactory ff = dataStore.getFilterFactory(); Begins before = ff.begins(ff.property(aname("dt")), ff.literal(period)); assertDatesMatch(before, "2009-01-15 13:10:12"); }
public void testEnds() throws Exception { Period period = period("2009-01-15 13:10:12", "2009-06-28 15:12:41"); FilterFactory ff = dataStore.getFilterFactory(); Ends before = ff.ends(ff.property(aname("dt")), ff.literal(period)); assertDatesMatch(before, "2009-06-28 15:12:41"); }
public void testEndedBy() throws Exception { Period period = period("2009-01-15 13:10:12", "2009-06-28 15:12:41"); FilterFactory ff = dataStore.getFilterFactory(); Ends before = ff.ends(ff.property(aname("dt")), ff.literal(period)); assertDatesMatch(before, "2009-06-28 15:12:41"); }
public void testCountWithFilter() throws Exception { FilterFactory ff = dataStore.getFilterFactory(); PropertyIsEqualTo filter = ff.equals(ff.property(aname("stringProperty")), ff.literal("one")); Query query = new Query(); query.setFilter(filter); assertEquals(1, featureSource.getCount(query)); }
public void testConversionFilter() throws Exception { FilterFactory ff = dataStore.getFilterFactory(); PropertyIsEqualTo f = ff.equals( ff.property(aname("doubleProperty")), ff.add(ff.property(aname("intProperty")), ff.literal("0.1"))); assertEquals(1, featureSource.getCount(new Query(null, f))); }
public void testMax() throws Exception { FilterFactory ff = dataStore.getFilterFactory(); PropertyName p = ff.property(aname("doubleProperty")); MaxVisitor v = new MyMaxVisitor(p); dataStore.getFeatureSource(tname("ft1")).accepts(Query.ALL, v, null); assertFalse(visited); assertEquals(2.2, v.getResult().toDouble(), 0.01); }
public void testMin() throws Exception { FilterFactory ff = dataStore.getFilterFactory(); PropertyName p = ff.property(aname("doubleProperty")); MinVisitor v = new MyMinVisitor(p); dataStore.getFeatureSource(tname("ft1")).accepts(Query.ALL, v, null); assertFalse(visited); assertEquals(0.0, v.getResult().toDouble(), 0.01); }
public void testTemporalJoin() throws Exception { FilterFactory ff = dataStore.getFilterFactory(); After after = ff.after(ff.property(aname("dt")), ff.property("other." + aname("dt"))); Query q = new Query(tname("dates")); q.getJoins().add(new Join(tname("dates"), after).alias("other")); q.setSortBy(new SortBy[] {ff.sort(aname("dt"), SortOrder.ASCENDING)}); assertDatesMatch(q, "2009-06-28 15:12:41", "2009-09-29 17:54:23", "2009-09-29 17:54:23"); }
public void testAfterInterval() throws Exception { Period period = period("2009-02-01 00:00:00", "2009-07-01 00:00:00"); FilterFactory ff = dataStore.getFilterFactory(); After after = ff.after(ff.property(aname("dt")), ff.literal(period)); assertDatesMatch(after, "2009-09-29 17:54:23"); after = ff.after(ff.literal(period), ff.property(aname("dt"))); assertDatesMatch(after, "2009-01-15 13:10:12"); }
public void testSimpleIn() throws IOException { FilterFactory ff = dataStore.getFilterFactory(); Function function = ff.function( "in", ff.property(aname("intProperty")), ff.literal("1"), ff.literal("2")); Filter filter = ff.equal(function, ff.literal("true"), false); SimpleFeatureSource fs = dataStore.getFeatureSource(tname("ft1")); SimpleFeatureCollection fc = fs.getFeatures(filter); assertEquals(getCaseInsensitiveSet("ft1.1", "ft1.2"), collectFeatureIds(fc)); }
public void testNotEqual() throws IOException { FilterFactory ff = dataStore.getFilterFactory(); Function function = ff.function( "in", ff.property(aname("intProperty")), ff.literal("1"), ff.literal("2")); Filter filter = ff.notEqual(function, ff.literal("true"), false); SimpleFeatureSource fs = dataStore.getFeatureSource(tname("ft1")); SimpleFeatureCollection fc = fs.getFeatures(filter); assertEquals(getCaseInsensitiveSet("ft1.0"), collectFeatureIds(fc)); }
public void testRemoveFeatures() throws IOException { FilterFactory ff = dataStore.getFilterFactory(); Filter filter = ff.equals(ff.property(aname("intProperty")), ff.literal(1)); SimpleFeatureCollection features = featureStore.getFeatures(); assertEquals(3, features.size()); featureStore.removeFeatures(filter); assertEquals(2, features.size()); featureStore.removeFeatures(Filter.INCLUDE); assertEquals(0, features.size()); }
public void testGreater() throws IOException { FilterFactory ff = dataStore.getFilterFactory(); Function function = ff.function( "in", ff.property(aname("intProperty")), ff.literal("1"), ff.literal("2")); Filter filter = ff.greater(function, ff.literal("false"), false); SimpleFeatureSource fs = dataStore.getFeatureSource(tname("ft1")); SimpleFeatureCollection fc = fs.getFeatures(filter); assertEquals(getCaseInsensitiveSet("ft1.1", "ft1.2"), collectFeatureIds(fc)); }
public void testMinWithFilter() throws Exception { FilterFactory ff = dataStore.getFilterFactory(); PropertyName p = ff.property(aname("doubleProperty")); MinVisitor v = new MyMinVisitor(p); Filter f = ff.greater(ff.property(aname("doubleProperty")), ff.literal(1)); Query q = new Query(tname("ft1"), f); dataStore.getFeatureSource(tname("ft1")).accepts(q, v, null); assertFalse(visited); assertEquals(1.1, v.getResult().toDouble(), 0.01); }
public void testSumWithFilter() throws Exception { FilterFactory ff = dataStore.getFilterFactory(); PropertyName p = ff.property(aname("doubleProperty")); SumVisitor v = new MySumVisitor(p); Filter f = ff.less(ff.property(aname("doubleProperty")), ff.literal(2)); Query q = new Query(tname("ft1"), f); dataStore.getFeatureSource(tname("ft1")).accepts(q, v, null); assertFalse(visited); assertEquals(1.1, v.getResult().toDouble(), 0.01); }
public void testLikeFilter() throws Exception { FilterFactory2 ff = (FilterFactory2) dataStore.getFilterFactory(); PropertyIsLike caseSensitiveLike = ff.like(ff.property(aname("stringProperty")), "Z*", "*", "?", "\\", true); PropertyIsLike caseInsensitiveLike = ff.like(ff.property(aname("stringProperty")), "Z*", "*", "?", "\\", false); PropertyIsLike caseInsensitiveLike2 = ff.like(ff.property(aname("stringProperty")), "z*", "*", "?", "\\", false); assertEquals(0, featureSource.getCount(new Query(null, caseSensitiveLike))); assertEquals(1, featureSource.getCount(new Query(null, caseInsensitiveLike))); assertEquals(1, featureSource.getCount(new Query(null, caseInsensitiveLike2))); }