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

Class AggregateClause<E extends EntityType>

java.lang.Object

com.hades.builder.sqlCommand.clauseBuilder.ClauseElements

com.hades.builder.sqlCommand.clauseBuilder.aggregate.AggregateClause<E>

All Implemented Interfaces:

SQLAggregateClause<E>

public class AggregateClause<E extends EntityType>
extends ClauseElements
implements SQLAggregateClause<E>

Author:

alireza_bayat created on 2/26/22

Field Summary

Fields inherited from class com.hades.builder.sqlCommand.clauseBuilder.ClauseElements

clause

Constructor Summary

Constructors

Constructor	Description
AggregateClause()
AggregateClause(Class<?> clazz)	pass entity class object as param

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)

Methods inherited from class com.hades.builder.sqlCommand.clauseBuilder.ClauseElements

getClause, setClause

Methods inherited from class java.lang.Object

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

Constructor Details

AggregateClause

public AggregateClause(Class<?> clazz)

pass entity class object as param

AggregateClause

public AggregateClause()

Method Details

createInstance

public SQLAggregateClause<E> createInstance(E e)

Description copied from interface: SQLAggregateClause

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

probably not needed in second approach

Specified by:

createInstance in interface SQLAggregateClause<E extends EntityType>

Parameters:

e - passed entity object

Returns:

SQLAggregateClause object

count

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

Specified by:

count in interface SQLAggregateClause<E extends EntityType>

avg

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

Specified by:

avg in interface SQLAggregateClause<E extends EntityType>

sum

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

Specified by:

sum in interface SQLAggregateClause<E extends EntityType>

min

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

Specified by:

min in interface SQLAggregateClause<E extends EntityType>

max

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

Specified by:

max in interface SQLAggregateClause<E extends EntityType>

groupBy

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

Specified by:

groupBy in interface SQLAggregateClause<E extends EntityType>

having

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

Specified by:

having in interface SQLAggregateClause<E extends EntityType>