Package com.hades.builder.sqlCommand.clauseBuilder.aggregate

Interface SQLAggregateClause<E extends EntityType>

All Known Implementing Classes:

AggregateClause

public interface SQLAggregateClause<E extends EntityType>

all aggregate functions in sql such as SUM,AVG,COUNT,...

Author:

alireza_bayat created on 2/26/22

Method Summary

Modifier and Type	Method	Description
SQLAggregateClause<E>	avg(E e, String field)
SQLAggregateClause<E>	count(E e, String field)
SQLAggregateClause<E>	createInstance(E e)	create instance Class of given entity to be used in Aggregate clauses
SQLAggregateClause<E>	groupBy(String... field)
SQLAggregateClause<E>	having(String field, String filterPhrase)
SQLAggregateClause<E>	max(E e, String field)
SQLAggregateClause<E>	min(E e, String field)
SQLAggregateClause<E>	sum(E e, String field)

Method Details

createInstance

SQLAggregateClause<E> createInstance(E e)

create instance Class of given entity to be used in Aggregate clauses

probably not needed in second approach

Parameters:

e - passed entity object

Returns:

SQLAggregateClause object

count

SQLAggregateClause<E> count(E e,
 String field)

avg

SQLAggregateClause<E> avg(E e,
 String field)

sum

SQLAggregateClause<E> sum(E e,
 String field)

min

SQLAggregateClause<E> min(E e,
 String field)

max

SQLAggregateClause<E> max(E e,
 String field)

groupBy

SQLAggregateClause<E> groupBy(String... field)

having

SQLAggregateClause<E> having(String field,
 String filterPhrase)