io.daobab.query

Class QueryField<E extends Entity,F>

java.lang.Object

io.daobab.query.base.Query<E,QueryField<E,F>>

io.daobab.query.QueryField<E,F>

All Implemented Interfaces:

ILoggerBean, QueryExpressionProvider, QueryHaving<QueryField<E,F>>, QueryJoin<QueryField<E,F>>, QueryLimit<QueryField<E,F>>, QueryOrder<QueryField<E,F>>, QuerySetOperator<QueryField<E,F>>, QueryWhere<QueryField<E,F>>, RemoteQuery<QueryField<E,F>>, FieldsProvider<F>, ManyCellsProvider<F>, InnerQueryField<E,F>

public final class QueryField<E extends Entity,F>
extends Query<E,QueryField<E,F>>
implements InnerQueryField<E,F>, ManyCellsProvider<F>, QueryJoin<QueryField<E,F>>

Author:

Klaudiusz Wojtkowiak, (C) Elephant Software 2018-2021

Field Summary

Fields inherited from class io.daobab.query.base.Query

_cache, _calcJoins, _groupBy, _nativeQuery, _unique, orderBy, refreshCasheWhenNoResult

Constructor Summary

Constructors

Constructor and Description
QueryField(QueryTarget target, Column<E,F,?> column)
QueryField(QueryTarget target, ColumnFunction<E,?,?,?> column)
QueryField(QueryTarget target, Map<String,Object> remote)
QueryField(String nativeQuery, QueryTarget target, Column<E,?,?> column)

Method Summary

Modifier and Type	Method and Description
DummyColumnRelation<Dual,String,EntityRelation>	as(String asName)
<F> DummyColumnRelation<Dual,F,EntityRelation>	as(String asName, Class<F> clazz)
long	countAny() Count all record Equivalent of count(*)
long	countBy(Count cnt)
Optional<F>	findFirst()
List<F>	findMany()
QueryType	getQueryType()
Query	getSelect()
InnerSelectManyCells<E,F>	innerResult()
boolean	isResultCached()
String	toSqlQuery()

Methods inherited from class io.daobab.query.base.Query

addSetOperator, clone, distinct, doIf, doIfElse, fromRemote, geNativeQuery, getAllEntitiesRelated, getCount, getEntityClass, getEntityName, getFields, getGroupBy, getHavingWrapper, getIdentifier, getIdentifierStorage, getInfoColumn, getInfoColumn, getJoins, getLimit, getLog, getOrderBy, getSentQuery, getSetOperatorList, getTarget, getWhereWrapper, groupBy, handleException, having, init, init, isLogQueryEnabled, logQuery, modifyQuery, noCache, orderBy, setEntityClass, setEntityName, setFields, setHavingWrapper, setIdentifier, setIdentifierStorage, setJoins, setSentQuery, setTarget, setTempCount, setTempLimit, setWhereWrapper, smartJoins, toRemote, where

Methods inherited from class java.lang.Object

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

Methods inherited from interface io.daobab.result.FieldsProvider

exists, filter, findOne, forEach, map

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

getEntityName, getJoins, getTarget, 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, setJoins

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

Constructor Detail

QueryField

public QueryField(QueryTarget target,
                  Column<E,F,?> column)

QueryField

public QueryField(QueryTarget target,
                  ColumnFunction<E,?,?,?> column)

QueryField

public QueryField(QueryTarget target,
                  Map<String,Object> remote)

QueryField

public QueryField(String nativeQuery,
                  QueryTarget target,
                  Column<E,?,?> column)

Method Detail

as

public DummyColumnRelation<Dual,String,EntityRelation> as(String asName)

as

public <F> DummyColumnRelation<Dual,F,EntityRelation> as(String asName,
                                                         Class<F> clazz)

innerResult

public InnerSelectManyCells<E,F> innerResult()

Specified by:

innerResult in interface InnerQueryField<E extends Entity,F>

countBy

public long countBy(Count cnt)

countAny

public long countAny()

Count all record Equivalent of count(*)

Specified by:

countAny in interface FieldsProvider<F>

Returns:

findMany

public List<F> findMany()

Specified by:

findMany in interface FieldsProvider<F>

findFirst

public Optional<F> findFirst()

Specified by:

findFirst in interface FieldsProvider<F>

getSelect

public Query getSelect()

Specified by:

getSelect in interface QueryExpressionProvider

isResultCached

public boolean isResultCached()

Specified by:

isResultCached in interface QueryExpressionProvider

getQueryType

public QueryType getQueryType()

Specified by:

getQueryType in class Query<E extends Entity,QueryField<E extends Entity,F>>

toSqlQuery

public String toSqlQuery()

Specified by:

toSqlQuery in class Query<E extends Entity,QueryField<E extends Entity,F>>