io.daobab.query.base

Class Query<E extends Entity,Q extends Query>

java.lang.Object

io.daobab.query.base.Query<E,Q>

All Implemented Interfaces:

ILoggerBean, QueryHaving<Q>, QueryJoin<Q>, QueryLimit<Q>, QueryOrder<Q>, QuerySetOperator<Q>, QueryWhere<Q>, RemoteQuery<Q>

Direct Known Subclasses:

QueryDelete, QueryEntity, QueryField, QueryInsert, QueryPlate, QueryUpdate

public abstract class Query<E extends Entity,Q extends Query>
extends Object
implements QueryJoin<Q>, QueryWhere<Q>, QueryOrder<Q>, QueryLimit<Q>, QueryHaving<Q>, QuerySetOperator<Q>, RemoteQuery<Q>, ILoggerBean

Author:

Klaudiusz Wojtkowiak, (C) Elephant Software 2018-2021

Field Summary

Fields

Modifier and Type	Field and Description
boolean	_cache
boolean	_calcJoins
List<Column<?,?,?>>	_groupBy
protected String	_nativeQuery
boolean	_unique
protected Order	orderBy
protected boolean	refreshCasheWhenNoResult

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	Query()

Method Summary

Modifier and Type	Method and Description
void	addSetOperator(SetOperator union)
static <E extends Entity,RV extends Query> RV	clone(Query<E,RV> from, Query<E,RV> to)
Q	distinct()
Q	doIf(boolean active, UnaryOperator<Q> logic)
Q	doIfElse(boolean active, UnaryOperator<Q> logicIf, UnaryOperator<Q> logicElse)
void	fromRemote(QueryTarget target, Map<String,Object> rv)
String	geNativeQuery()
Set<String>	getAllEntitiesRelated() Get all DAO related withoutTransactionTo this statement
Count	getCount()
Class	getEntityClass()
String	getEntityName()
List<TableColumn>	getFields()
List<Column<?,?,?>>	getGroupBy()
Having	getHavingWrapper()
String	getIdentifier()
IdentifierStorage	getIdentifierStorage()
protected TableColumn	getInfoColumn(Column column)
protected TableColumn	getInfoColumn(ColumnFunction column)
List<JoinWrapper>	getJoins()
Limit	getLimit()
org.slf4j.Logger	getLog()
Order	getOrderBy()
abstract QueryType	getQueryType()
String	getSentQuery()
List<SetOperator>	getSetOperatorList()
QueryTarget	getTarget()
Where	getWhereWrapper()
Q	groupBy(Column<?,?,?>... columns)
void	handleException(String statement, Throwable t)
Q	having(Having having)
protected void	init(QueryTarget target, Entity entity)
protected void	init(QueryTarget target, String entityName)
boolean	isLogQueryEnabled()
Q	logQuery()
protected Q	modifyQuery()
Q	noCache()
Q	orderBy(Order orderBy)
void	setEntityClass(Class entityClass)
void	setEntityName(String entityName)
protected void	setFields(List<TableColumn> fields)
void	setHavingWrapper(Having havingWrapper)
Q	setIdentifier(String identifier)
protected void	setIdentifierStorage(IdentifierStorage identifierStorage)
void	setJoins(List<JoinWrapper> joins)
void	setSentQuery(String sentQuery)
protected void	setTarget(QueryTarget target)
protected void	setTempCount(Count c)
void	setTempLimit(Limit limit)
void	setWhereWrapper(Where whereWrapper)
Q	smartJoins()
Map<String,Object>	toRemote(boolean singleResult)
abstract String	toSqlQuery()
Q	where(Where whereWrapper)

Methods inherited from class java.lang.Object

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

Methods inherited from interface io.daobab.query.base.QueryJoin

join, join, join, join, join, join, join, join, join, join, join, join, join, join, join, joinByFlag1, joinByFlag1, joinByFlag2, joinByFlag2, joinByFlag3, joinByFlag3, joinByFlag4, joinByFlag4, joinByPk, joinByPk, joinPk, joinPk, joinPk, joinRoute, joinRoute, joinThrough, joinThrough, joinWhere, joinWhere

Methods inherited from interface io.daobab.query.base.QueryWhere

whereAnd, whereBetween, whereBetween, whereEqual, whereEqual, whereEqual, whereEqual, whereEqual, whereEqual, whereGreater, whereGreater, whereGreater, whereGreater, whereGreater, whereGreaterOrEqual, whereGreaterOrEqual, whereGreaterOrEqual, whereGreaterOrEqual, whereGreaterOrEqual, whereIfNotNull, whereIn, whereIn, whereIn, whereIn, whereIn, whereIsNull, whereLess, whereLess, whereLess, whereLess, whereLess, whereLessOrEqual, whereLessOrEqual, whereLessOrEqual, whereLessOrEqual, whereLessOrEqual, whereLike, whereLike, whereLike, whereNotEqual, whereNotEqual, whereNotEqual, whereNotEqual, whereNotEqual, whereNotIn, whereNotIn, whereNotIn, whereNotIn, whereNotIn, whereNotLike, whereNotLike, whereNotNull, whereOR, whereOr

Methods inherited from interface io.daobab.query.base.QueryOrder

orderAscBy, orderBy, orderBy, orderDescBy

Methods inherited from interface io.daobab.query.base.QueryLimit

limitBy, limitBy, limitBy, page, setLimit, setTempPage

Methods inherited from interface io.daobab.query.base.QueryHaving

having, having, having, havingAnd, havingBetween, havingBetween, havingEqual, havingEqual, havingEqual, havingEqual, havingEqual, havingGreater, havingGreater, havingGreater, havingGreater, havingGreaterOrEqual, havingGreaterOrEqual, havingGreaterOrEqual, havingGreaterOrEqual, havingIfNotNull, havingIn, havingIn, havingIn, havingIsNotNull, havingIsNull, havingLess, havingLess, havingLess, havingLess, havingLessOrEqual, havingLessOrEqual, havingLessOrEqual, havingLessOrEqual, havingLike, havingNotEqual, havingNotEqual, havingNotEqual, havingNotIn, havingNotIn, havingNotIn, havingOR

Methods inherited from interface io.daobab.query.base.QuerySetOperator

except, exceptAll, intersect, minus, union, unionAll

Field Detail

_groupBy

public List<Column<?,?,?>> _groupBy

_unique

public boolean _unique

_cache

public boolean _cache

_calcJoins

public boolean _calcJoins

orderBy

protected Order orderBy

refreshCasheWhenNoResult

protected boolean refreshCasheWhenNoResult

_nativeQuery

protected String _nativeQuery

Constructor Detail

Query

protected Query()

Method Detail

getSetOperatorList

public List<SetOperator> getSetOperatorList()

addSetOperator

public void addSetOperator(SetOperator union)

Specified by:

addSetOperator in interface QuerySetOperator<Q extends Query>

clone

public static <E extends Entity,RV extends Query> RV clone(Query<E,RV> from,
                                                           Query<E,RV> to)

doIfElse

public Q doIfElse(boolean active,
                  UnaryOperator<Q> logicIf,
                  UnaryOperator<Q> logicElse)

doIf

public Q doIf(boolean active,
              UnaryOperator<Q> logic)

groupBy

public Q groupBy(Column<?,?,?>... columns)

getGroupBy

public List<Column<?,?,?>> getGroupBy()

init

protected void init(QueryTarget target,
                    String entityName)

init

protected void init(QueryTarget target,
                    Entity entity)

getWhereWrapper

public Where getWhereWrapper()

Specified by:

getWhereWrapper in interface QueryWhere<Q extends Query>

setWhereWrapper

public void setWhereWrapper(Where whereWrapper)

Specified by:

setWhereWrapper in interface QueryWhere<Q extends Query>

getFields

public List<TableColumn> getFields()

setFields

protected void setFields(List<TableColumn> fields)

getAllEntitiesRelated

public Set<String> getAllEntitiesRelated()

Get all DAO related withoutTransactionTo this statement

getIdentifierStorage

public IdentifierStorage getIdentifierStorage()

setIdentifierStorage

protected void setIdentifierStorage(IdentifierStorage identifierStorage)

where

public Q where(Where whereWrapper)

Specified by:

where in interface QueryWhere<Q extends Query>

getTarget

public QueryTarget getTarget()

Specified by:

getTarget in interface QueryJoin<Q extends Query>

setTarget

protected void setTarget(QueryTarget target)

having

public Q having(Having having)

Specified by:

having in interface QueryHaving<Q extends Query>

getOrderBy

public Order getOrderBy()

orderBy

public Q orderBy(Order orderBy)

Specified by:

orderBy in interface QueryOrder<Q extends Query>

getCount

public Count getCount()

setTempCount

protected void setTempCount(Count c)

getLimit

public Limit getLimit()

setTempLimit

public void setTempLimit(Limit limit)

Specified by:

setTempLimit in interface QueryLimit<Q extends Query>

handleException

public void handleException(String statement,
                            Throwable t)

logQuery

public Q logQuery()

isLogQueryEnabled

public boolean isLogQueryEnabled()

distinct

public Q distinct()

smartJoins

public Q smartJoins()

noCache

public Q noCache()

getEntityName

public String getEntityName()

Specified by:

getEntityName in interface QueryJoin<Q extends Query>

setEntityName

public void setEntityName(String entityName)

getEntityClass

public Class getEntityClass()

setEntityClass

public void setEntityClass(Class entityClass)

getHavingWrapper

public Having getHavingWrapper()

setHavingWrapper

public void setHavingWrapper(Having havingWrapper)

Specified by:

setHavingWrapper in interface QueryHaving<Q extends Query>

getJoins

public List<JoinWrapper> getJoins()

Specified by:

getJoins in interface QueryJoin<Q extends Query>

setJoins

public void setJoins(List<JoinWrapper> joins)

Specified by:

setJoins in interface QueryJoin<Q extends Query>

toRemote

public Map<String,Object> toRemote(boolean singleResult)

Specified by:

toRemote in interface RemoteQuery<Q extends Query>

fromRemote

public void fromRemote(QueryTarget target,
                       Map<String,Object> rv)

geNativeQuery

public String geNativeQuery()

modifyQuery

protected Q modifyQuery()

getLog

public org.slf4j.Logger getLog()

Specified by:

getLog in interface ILoggerBean

getIdentifier

public String getIdentifier()

setIdentifier

public Q setIdentifier(String identifier)

getQueryType

public abstract QueryType getQueryType()

getInfoColumn

protected TableColumn getInfoColumn(ColumnFunction column)

getInfoColumn

protected TableColumn getInfoColumn(Column column)

toSqlQuery

public abstract String toSqlQuery()

getSentQuery

public String getSentQuery()

setSentQuery

public void setSentQuery(String sentQuery)