org.sormula.operation.aggregate

Class SelectAvgOperation<R,T>

java.lang.Object

org.sormula.operation.SqlOperation<R>

org.sormula.operation.ScalarSelectOperation<R>

org.sormula.operation.aggregate.SelectAggregateOperation<R,T>

org.sormula.operation.aggregate.SelectAvgOperation<R,T>

Type Parameters:

R - class type which contains members for columns of a row in a table

T - class type of aggregate result

All Implemented Interfaces:

java.lang.AutoCloseable, java.lang.Iterable<R>

public class SelectAvgOperation<R,T>
extends SelectAggregateOperation<R,T>

SQL AVG aggregate operation. See base class for details about use.

Since:

1.1

Author:

Jeff Miller

Constructor Summary

Constructors

Constructor and Description
SelectAvgOperation(Table<R> table, java.lang.String expression) Constructs for standard sql select statement as: SELECT AVG(e), ...

Method Summary

Methods inherited from class org.sormula.operation.aggregate.SelectAggregateOperation

initBaseSql, readAggregate

Methods inherited from class org.sormula.operation.ScalarSelectOperation

addFilter, close, execute, getFilterPredicateMap, getMaximumRowsRead, getOrderByName, getOrderByTranslator, getResultSet, getRowsReadCount, getSql, isExecuted, isLazySelectsCascades, isNotifyLazySelects, iterator, positionAbsolute, positionRelative, postRead, postReadCascade, prepareCascades, preRead, preReadCascade, readNext, removeFilter, resetRowsReadCount, select, select, setFilterPredicateMap, setMaximumRowsRead, setOrderBy, setOrderByTranslator, setParameters, setRowParameters, updateActiveFilterPredicate

Methods inherited from class org.sormula.operation.SqlOperation

cancel, cascade, closeCascades, closeStatement, createRowField, getBaseSql, getCascadeDepth, getConnection, getCustomSql, getNamedParameterMap, getNextParameter, getOperationTime, getParameter, getParameters, getPreparedSql, getPreparedStatement, getQueryTimeout, getRequiredCascades, getTable, getTargetTable, getTimingId, getWhereAnnotation, getWhereConditionName, getWhereTranslator, initOperationTime, isCached, isCascade, isCascading, isIncludeIdentityColumns, isPrimaryKey, isReadOnly, isRequiredCascade, isTimings, logTimings, prepare, prepareCascades, prepareCheck, prepareStatement, setBaseSql, setCached, setCascade, setCascadeDepth, setCustomSql, setIncludeIdentityColumns, setNamedParameterMap, setNextParameter, setParameter, setQueryTimeout, setReadOnly, setRequiredCascades, setTimingId, setTimings, setWhere, setWhereTranslator, writeColumns, writeParameter, writeParameters, writeWhere

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.lang.Iterable

forEach, spliterator

Constructor Detail

SelectAvgOperation

public SelectAvgOperation(Table<R> table,
                          java.lang.String expression)
                   throws OperationException

Constructs for standard sql select statement as:
SELECT AVG(e), ... FROM table
where e is a SQL expression (typically a column name).

Parameters:

table - select from this table

expression - expression to use as parameter to function; typically it is the name of a column to that aggregate function operates upon (example: AVG(amount) amount is expression)

Throws:

OperationException - if error