/** * Calculate sum (using FeatureCalc) - only one parameter is used. * * @param collection collection to calculate the sum * @param expression Single Expression argument * @return An object containing the sum value of the attributes * @throws IllegalFilterException * @throws IOException */ static CalcResult calculateSum(SimpleFeatureCollection collection, Expression expression) throws IllegalFilterException, IOException { SumVisitor sumVisitor = new SumVisitor(expression); collection.accepts(sumVisitor, null); return sumVisitor.getResult(); }
int value1 = sumVisitor.getResult().toInt(); assertEquals(6, value1); double value2 = sumVisitor2.getResult().toDouble(); assertEquals((double) 7.5, value2, 0); CalcResult sumResult1 = sumVisitor.getResult(); CalcResult sumResult2 = sumVisitor2.getResult(); CalcResult sumResult3 = sumResult1.merge(sumResult2); assertEquals((double) 13.5, sumResult3.toDouble(), 0); CalcResult sumResult4 = sumVisitor2.getResult(); CalcResult sumResult5 = sumResult3.merge(sumResult4); assertEquals(-28.5, sumResult5.toDouble(), 0); assertEquals(CalcResult.NULL_RESULT, sumVisitor.getResult()); assertSame(sumResult2, sumVisitor.getResult().merge(sumResult2)); assertSame(sumResult2, sumResult2.merge(sumVisitor.getResult()));
public void testSum() throws Exception { FilterFactory ff = dataStore.getFilterFactory(); PropertyName p = ff.property(aname("doubleProperty")); SumVisitor v = new MySumVisitor(p); dataStore.getFeatureSource(tname("ft1")).accepts(Query.ALL, v, null); assertFalse(visited); assertEquals(3.3, 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); }
/** * Calculate sum (using FeatureCalc) - only one parameter is used. * * @param collection collection to calculate the sum * @param expression Single Expression argument * * @return An object containing the sum value of the attributes * * @throws IllegalFilterException * @throws IOException */ static CalcResult calculateSum(SimpleFeatureCollection collection, Expression expression) throws IllegalFilterException, IOException { SumVisitor sumVisitor = new SumVisitor(expression); collection.accepts(sumVisitor, null); return sumVisitor.getResult(); }
/** * Calculate sum (using FeatureCalc) - only one parameter is used. * * @param collection collection to calculate the sum * @param expression Single Expression argument * * @return An object containing the sum value of the attributes * * @throws IllegalFilterException * @throws IOException */ public static CalcResult calculateSum(FeatureCollection collection, Expression expression) throws IllegalFilterException, IOException { SumVisitor sumVisitor = new SumVisitor(expression); collection.accepts(sumVisitor, null); return sumVisitor.getResult(); }
public void testCountSumMerge() throws IllegalFilterException, IOException { CountVisitor countVisitor = new CountVisitor(); fc2.accepts(countVisitor, null); // count = 2 SumVisitor sumVisitor = new SumVisitor(3, ft2); fc2.accepts(sumVisitor, null); // sum = 7.5 CalcResult countResult = countVisitor.getResult(); CalcResult sumResult = sumVisitor.getResult(); CalcResult averageResult1 = countResult.merge(sumResult); CalcResult averageResult2 = sumResult.merge(countResult); // both average results were correct? assertEquals((double) 3.75, averageResult1.toDouble(), 0); assertEquals((double) 3.75, averageResult2.toDouble(), 0); // neither sum nor count was destroyed? assertEquals(2, countResult.toInt()); assertEquals((double) 7.5, sumResult.toDouble(), 0); }
public void testSumWithLimitOffset() throws Exception { if (!dataStore.getSQLDialect().isLimitOffsetSupported()) { return; } FilterFactory ff = dataStore.getFilterFactory(); PropertyName p = ff.property(aname("doubleProperty")); SumVisitor v = new MySumVisitor(p); Query q = new Query(tname("ft1")); q.setStartIndex(0); q.setMaxFeatures(2); dataStore.getFeatureSource(tname("ft1")).accepts(q, v, null); assertFalse(visited); assertEquals(1.1, v.getResult().toDouble(), 0.01); }