Package org.apache.openjpa.jdbc.sql
Class LogicalUnion.UnionSelect
java.lang.Object
org.apache.openjpa.jdbc.sql.LogicalUnion.UnionSelect
- All Implemented Interfaces:
Select
,SelectExecutor
- Enclosing class:
- LogicalUnion
A select that is part of a logical union.
-
Field Summary
Modifier and TypeFieldDescriptionprotected List
protected int
protected final int
protected final SelectImpl
Fields inherited from interface org.apache.openjpa.jdbc.sql.Select
EAGER_INNER, EAGER_OUTER, EAGER_PARALLEL, FROM_SELECT_ALIAS, SUBS_ANY_JOINABLE, SUBS_EXACT, SUBS_JOINABLE, SUBS_NONE, TYPE_JOINLESS, TYPE_TWO_PART
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionvoid
Apply class conditions from relation joins.AND the given joins together.void
Append the given joins to the given buffer.void
Clear odering conditions.void
Clear the existing column selects.ctx()
Return the JPQL query context of this selecteagerClone
(FieldMapping key, int eagerType, boolean toMany, int sels) Return a select that will be eagerly executed with this one, or null if the select cannot be created for the given key and join type.execute
(JDBCStore store, JDBCFetchConfiguration fetch) Execute this select in the context of the given store manager.execute
(JDBCStore store, JDBCFetchConfiguration fetch, int lockLevel) Execute this select in the context of the given store manager.fullClone
(int sels) Return a SELECT that is a complete clone of this one.boolean
Whether to automatically make results distinct when relational joins would otherwise introduce duplicates.getColumnAlias
(String col, Table table) Return the alias for the given column.getColumnAlias
(String col, Table table, Joins joins) Return the alias for the given column.getColumnAlias
(Column col) Return the alias for the given column.getColumnAlias
(Column col, Object alias) Return the alias for the given column, without creating new table aliasgetColumnAlias
(Column col, Joins joins) Return the alias for the given column.Return the select configuration.int
Return the number of instances matching this select.Delegate select.getEager
(FieldMapping key) Return the eager select for the given key.long
The result end index.get joined table metadatas excluded for polymorphic queriesint
The expected result count for the query.Another select instance that creates a temporary table from which this select pulls data.Return the grouping SQL for this select.boolean
Return the flag to indicate whether this Select has internally generated subselectReturn the HAVING clause, or null if none.Get the aliases for identifier columns that can be used in COUNT selects to find the number of matches.get joined table metadatas for polymorphic queriesReturn the top-levelJoin
elements for this select.getJoins()
Return the top-level joins for this select.int
The join syntax for this select, as one of the syntax constants fromJoinSyntaxes
.Return the ordering SQL for this select.Return the parent of this select, if it is a subselect.Return the aliases of all selected columns and all selected buffers, in the order they were selected.Return the indexes of the data in the select clause this query is ordered by.Return the actualVal
s andColumn
s that were selected, in the order that they were selected.getSQL()
Get the buffer if it has been computed by a previous call toSelectExecutor.toSelect(boolean, JDBCFetchConfiguration)
, if any.long
The result start index.Return the subselect path for this select, if it is a subselect.Return this select's subselects, or empty collection if none.Return the set of all used table aliases.get table-per-class metadata for polymorphic queriesgetWhere()
Return the WHERE clause, minus any necessary end joins.void
Add a GROUP BY clause.void
Add a GROUP BY clause.void
groupBy
(ClassMapping mapping, int subclasses, JDBCStore store, JDBCFetchConfiguration fetch) Group by the columns of the given mapping, possibly including subclasses.void
groupBy
(ClassMapping mapping, int subclasses, JDBCStore store, JDBCFetchConfiguration fetch, Joins joins) Group by the columns of the given mapping, possibly including subclasses.void
Group by the given column.void
Group by the given columns.void
Group by the given columns.void
Group by the given column.void
Add a GROUP BY clause.void
Add a GROUP BY clause.boolean
hasEagerJoin
(boolean toMany) Whether this select has an eager join of the specified type.boolean
hasJoin
(boolean toMany) Whether this select has a join of the specified type.boolean
Affirm if this receiver requires more than one selects to fetch its data.void
Add the given having conditions.void
Add the given having conditions.void
Add the given having conditions.void
Add the given having conditions.int
indexOf()
The index of this select within the UNION, or 0.boolean
Return true if this is an aggregate select.boolean
Whether this is a SELECT DISTINCT / UNION ALL.boolean
isLob()
Return true if this select includes a LOB.boolean
isLRS()
Whether the result of this select should be treated as a large result set.boolean
isSelected
(Table table) Return whether the given table is being used in this select.void
Extended trace that logs eager relationsnewJoins()
Return a new instance to use for joining.Return a new instance to use for outer joining.OR the given joins together.boolean
Add an ORDER BY clause.boolean
Add an ORDER BY clause.int
Order by the given columns.int
Order by the given columns.boolean
Order by the given column.boolean
Order by the given column.boolean
Add an ORDER BY clause.boolean
Add an ORDER BY clause.int
orderByPrimaryKey
(ClassMapping mapping, boolean asc, boolean select) Order on the primary key columns of the given mapping, joining to superclasses as necessary to get all columns needed to construct an object id.int
orderByPrimaryKey
(ClassMapping mapping, boolean asc, Joins joins, boolean select) Select and order on the primary key columns of the given mapping, joining to superclasses as necessary to get all columns needed to construct an object id.Return a join set making the given joins outer joins.protected void
recordOrder
(Object ord, boolean asc) Record that we're ordering by a SQL expression.protected void
recordOrderColumns
(Column[] cols, boolean asc) Record that we're ordering by the given columns.boolean
Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from aResult
.boolean
Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from aResult
.void
select
(ClassMapping mapping, int subclasses, JDBCStore store, JDBCFetchConfiguration fetch, int eager) Select the columns of the given mapping, possibly including subclasses.void
select
(ClassMapping mapping, int subclasses, JDBCStore store, JDBCFetchConfiguration fetch, int eager, Joins joins) Select the columns of the given mapping, possibly including subclasses.boolean
Select the given column.int
Select the given columns.int
Select the given columns.boolean
Select the given column.boolean
Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from aResult
.boolean
Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from aResult
.void
selectIdentifier
(ClassMapping mapping, int subclasses, JDBCStore store, JDBCFetchConfiguration fetch, int eager) Select the columns of the given mapping, possibly including subclasses.void
selectIdentifier
(ClassMapping mapping, int subclasses, JDBCStore store, JDBCFetchConfiguration fetch, int eager, Joins joins) Select the columns of the given mapping, possibly including subclasses.boolean
selectIdentifier
(Column col) Select the given column as one that can be used to get a count of distinct matches.int
selectIdentifier
(Column[] cols) Select the given columns as ones that can be used to get a count of distinct matches.int
selectIdentifier
(Column[] cols, Joins joins) Select the given columns as ones that can be used to get a count of distinct matches.boolean
selectIdentifier
(Column col, Joins joins) Select the given column as one that can be used to get a count of distinct matches.void
selectPlaceholder
(String sql) Select the given SQL as a placeholder for a UNION element.int
selectPrimaryKey
(ClassMapping mapping) Select the primary key columns of the given mapping, joining to superclasses as necessary to get all columns needed to construct an object id.int
selectPrimaryKey
(ClassMapping mapping, Joins joins) Select the primary key columns of the given mapping, joining to superclasses as necessary to get all columns needed to construct an object id.void
setAggregate
(boolean agg) Set to true for aggregate selects.void
setAutoDistinct
(boolean distinct) Whether to automatically make results distinct when relational joins would otherwise introduce duplicates.void
setContext
(Context context) Set JPQL query context for this selectvoid
setDistinct
(boolean distinct) Whether this is a SELECT DISTINCT / UNION ALL.void
Set joined table metadatas excluded for polymorphic queriesvoid
setExpectedResultCount
(int expectedResultCount, boolean force) The expected result count for the query.void
setFromSelect
(Select sel) Another select instance that creates a temporary table from which this select pulls data.void
setHasSubselect
(boolean hasSub) Set the flag to indicate whether this Select has internally generated subselectvoid
setJoinedTableClassMeta
(List meta) Set joined table metadatas for polymorphic queriesvoid
setJoinSyntax
(int joinSyntax) The join syntax for this select, as one of the syntax constants fromJoinSyntaxes
.void
setLob
(boolean lob) Set to true for selects that include LOB columns.void
setLRS
(boolean lrs) Whether the result of this select should be treated as a large result set.void
Turn this select into a subselect of the given instance.void
setRange
(long start, long end) Set the result range for this select.void
setSchemaAlias
(String schemaAlias) Record the initial schemaAlias of a join pathvoid
Set table-per-class metadata for polymorphic queriesboolean
Whether this select can be executed for update.boolean
supportsRandomAccess
(boolean forUpdate) Return whether this select can support a random access result set type.toSelect
(boolean forUpdate, JDBCFetchConfiguration fetch) Return this select as a SQL statement formatted for the current dictionary.Return this select as a COUNT SQL statement formatted for the current dictionary.toString()
Implement toString to generate SQL string for profiling/debuggging.void
Add the given where conditions.void
Add the given where conditions.void
Add the given where conditions.void
Add the given where conditions.void
Add the given where conditions.whereClone
(int sels) Return a SELECT with the same joins and where conditions as this one.void
whereForeignKey
(ForeignKey fk, Object oid, ClassMapping mapping, JDBCStore store) Add where conditions setting the given foreign key to the given oid values.void
wherePrimaryKey
(Object oid, ClassMapping mapping, JDBCStore store) Add where conditions setting the mapping's primary key to the given oid values.
-
Field Details
-
sel
-
pos
protected final int pos -
orders
protected int orders -
orderIdxs
-
-
Constructor Details
-
UnionSelect
-
-
Method Details
-
getDelegate
Delegate select. -
getSelectedOrderIndexes
Return the indexes of the data in the select clause this query is ordered by. -
getConfiguration
Description copied from interface:SelectExecutor
Return the select configuration.- Specified by:
getConfiguration
in interfaceSelectExecutor
-
indexOf
public int indexOf()Description copied from interface:Select
The index of this select within the UNION, or 0. -
toSelect
Description copied from interface:SelectExecutor
Return this select as a SQL statement formatted for the current dictionary.- Specified by:
toSelect
in interfaceSelectExecutor
-
getSQL
Description copied from interface:SelectExecutor
Get the buffer if it has been computed by a previous call toSelectExecutor.toSelect(boolean, JDBCFetchConfiguration)
, if any.- Specified by:
getSQL
in interfaceSelectExecutor
-
toSelectCount
Description copied from interface:SelectExecutor
Return this select as a COUNT SQL statement formatted for the current dictionary.- Specified by:
toSelectCount
in interfaceSelectExecutor
-
getAutoDistinct
public boolean getAutoDistinct()Description copied from interface:SelectExecutor
Whether to automatically make results distinct when relational joins would otherwise introduce duplicates.- Specified by:
getAutoDistinct
in interfaceSelectExecutor
-
setAutoDistinct
public void setAutoDistinct(boolean distinct) Description copied from interface:SelectExecutor
Whether to automatically make results distinct when relational joins would otherwise introduce duplicates.- Specified by:
setAutoDistinct
in interfaceSelectExecutor
-
isDistinct
public boolean isDistinct()Description copied from interface:SelectExecutor
Whether this is a SELECT DISTINCT / UNION ALL.- Specified by:
isDistinct
in interfaceSelectExecutor
-
setDistinct
public void setDistinct(boolean distinct) Description copied from interface:SelectExecutor
Whether this is a SELECT DISTINCT / UNION ALL.- Specified by:
setDistinct
in interfaceSelectExecutor
-
isLRS
public boolean isLRS()Description copied from interface:SelectExecutor
Whether the result of this select should be treated as a large result set.- Specified by:
isLRS
in interfaceSelectExecutor
-
setLRS
public void setLRS(boolean lrs) Description copied from interface:SelectExecutor
Whether the result of this select should be treated as a large result set.- Specified by:
setLRS
in interfaceSelectExecutor
-
getJoinSyntax
public int getJoinSyntax()Description copied from interface:SelectExecutor
The join syntax for this select, as one of the syntax constants fromJoinSyntaxes
.- Specified by:
getJoinSyntax
in interfaceSelectExecutor
-
setJoinSyntax
public void setJoinSyntax(int joinSyntax) Description copied from interface:SelectExecutor
The join syntax for this select, as one of the syntax constants fromJoinSyntaxes
.- Specified by:
setJoinSyntax
in interfaceSelectExecutor
-
supportsRandomAccess
public boolean supportsRandomAccess(boolean forUpdate) Description copied from interface:SelectExecutor
Return whether this select can support a random access result set type.- Specified by:
supportsRandomAccess
in interfaceSelectExecutor
-
supportsLocking
public boolean supportsLocking()Description copied from interface:SelectExecutor
Whether this select can be executed for update.- Specified by:
supportsLocking
in interfaceSelectExecutor
-
hasMultipleSelects
public boolean hasMultipleSelects()Description copied from interface:SelectExecutor
Affirm if this receiver requires more than one selects to fetch its data.- Specified by:
hasMultipleSelects
in interfaceSelectExecutor
-
getCount
Description copied from interface:SelectExecutor
Return the number of instances matching this select.- Specified by:
getCount
in interfaceSelectExecutor
- Throws:
SQLException
-
execute
Description copied from interface:SelectExecutor
Execute this select in the context of the given store manager.- Specified by:
execute
in interfaceSelectExecutor
- Throws:
SQLException
-
execute
public Result execute(JDBCStore store, JDBCFetchConfiguration fetch, int lockLevel) throws SQLException Description copied from interface:SelectExecutor
Execute this select in the context of the given store manager.- Specified by:
execute
in interfaceSelectExecutor
- Throws:
SQLException
-
getSubselects
Description copied from interface:Select
Return this select's subselects, or empty collection if none.- Specified by:
getSubselects
in interfaceSelect
-
getParent
Description copied from interface:Select
Return the parent of this select, if it is a subselect. -
getSubselectPath
Description copied from interface:Select
Return the subselect path for this select, if it is a subselect.- Specified by:
getSubselectPath
in interfaceSelect
-
setParent
Description copied from interface:Select
Turn this select into a subselect of the given instance. -
setHasSubselect
public void setHasSubselect(boolean hasSub) Description copied from interface:Select
Set the flag to indicate whether this Select has internally generated subselect- Specified by:
setHasSubselect
in interfaceSelect
-
getHasSubselect
public boolean getHasSubselect()Description copied from interface:Select
Return the flag to indicate whether this Select has internally generated subselect- Specified by:
getHasSubselect
in interfaceSelect
-
getFromSelect
Description copied from interface:Select
Another select instance that creates a temporary table from which this select pulls data.- Specified by:
getFromSelect
in interfaceSelect
-
setFromSelect
Description copied from interface:Select
Another select instance that creates a temporary table from which this select pulls data.- Specified by:
setFromSelect
in interfaceSelect
-
hasEagerJoin
public boolean hasEagerJoin(boolean toMany) Description copied from interface:Select
Whether this select has an eager join of the specified type.- Specified by:
hasEagerJoin
in interfaceSelect
-
hasJoin
public boolean hasJoin(boolean toMany) Description copied from interface:Select
Whether this select has a join of the specified type. -
isSelected
Description copied from interface:Select
Return whether the given table is being used in this select.- Specified by:
isSelected
in interfaceSelect
-
getTableAliases
Description copied from interface:Select
Return the set of all used table aliases.- Specified by:
getTableAliases
in interfaceSelect
-
getSelects
Description copied from interface:Select
Return the actualVal
s andColumn
s that were selected, in the order that they were selected.- Specified by:
getSelects
in interfaceSelect
-
getSelectAliases
Description copied from interface:Select
Return the aliases of all selected columns and all selected buffers, in the order they were selected. Each alias may be either a string or aSQLBuffer
.- Specified by:
getSelectAliases
in interfaceSelect
-
getIdentifierAliases
Description copied from interface:Select
Get the aliases for identifier columns that can be used in COUNT selects to find the number of matches. Each alias will be a string. If no identifier columns have been nominated, then all column alises are returned.- Specified by:
getIdentifierAliases
in interfaceSelect
-
getOrdering
Description copied from interface:Select
Return the ordering SQL for this select.- Specified by:
getOrdering
in interfaceSelect
-
getGrouping
Description copied from interface:Select
Return the grouping SQL for this select.- Specified by:
getGrouping
in interfaceSelect
-
getWhere
Description copied from interface:Select
Return the WHERE clause, minus any necessary end joins. -
getHaving
Description copied from interface:Select
Return the HAVING clause, or null if none. -
addJoinClassConditions
public void addJoinClassConditions()Description copied from interface:Select
Apply class conditions from relation joins. This may affect the return values ofSelect.getJoins()
,Select.getJoinIterator()
, andSelect.getWhere()
.- Specified by:
addJoinClassConditions
in interfaceSelect
-
getJoins
Description copied from interface:Select
Return the top-level joins for this select. -
getJoinIterator
Description copied from interface:Select
Return the top-levelJoin
elements for this select.- Specified by:
getJoinIterator
in interfaceSelect
-
getStartIndex
public long getStartIndex()Description copied from interface:Select
The result start index.- Specified by:
getStartIndex
in interfaceSelect
-
getEndIndex
public long getEndIndex()Description copied from interface:Select
The result end index.- Specified by:
getEndIndex
in interfaceSelect
-
setRange
public void setRange(long start, long end) Description copied from interface:Select
Set the result range for this select. -
getColumnAlias
Description copied from interface:Select
Return the alias for the given column.- Specified by:
getColumnAlias
in interfaceSelect
-
getColumnAlias
Description copied from interface:Select
Return the alias for the given column.- Specified by:
getColumnAlias
in interfaceSelect
-
getColumnAlias
Description copied from interface:Select
Return the alias for the given column, without creating new table alias- Specified by:
getColumnAlias
in interfaceSelect
-
getColumnAlias
Description copied from interface:Select
Return the alias for the given column.- Specified by:
getColumnAlias
in interfaceSelect
-
getColumnAlias
Description copied from interface:Select
Return the alias for the given column.- Specified by:
getColumnAlias
in interfaceSelect
-
isAggregate
public boolean isAggregate()Description copied from interface:Select
Return true if this is an aggregate select.- Specified by:
isAggregate
in interfaceSelect
-
setAggregate
public void setAggregate(boolean agg) Description copied from interface:Select
Set to true for aggregate selects.- Specified by:
setAggregate
in interfaceSelect
-
isLob
public boolean isLob()Description copied from interface:Select
Return true if this select includes a LOB. -
setLob
public void setLob(boolean lob) Description copied from interface:Select
Set to true for selects that include LOB columns. -
selectPlaceholder
Description copied from interface:Select
Select the given SQL as a placeholder for a UNION element.- Specified by:
selectPlaceholder
in interfaceSelect
-
clearSelects
public void clearSelects()Description copied from interface:Select
Clear the existing column selects.- Specified by:
clearSelects
in interfaceSelect
-
select
Description copied from interface:Select
Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from aResult
. -
select
Description copied from interface:Select
Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from aResult
. -
select
Description copied from interface:Select
Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from aResult
. -
select
Description copied from interface:Select
Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from aResult
. -
select
Description copied from interface:Select
Select the given column. -
select
Description copied from interface:Select
Select the given column. -
select
Description copied from interface:Select
Select the given columns. -
select
Description copied from interface:Select
Select the given columns. -
select
public void select(ClassMapping mapping, int subclasses, JDBCStore store, JDBCFetchConfiguration fetch, int eager) Description copied from interface:Select
Select the columns of the given mapping, possibly including subclasses. This method should be called after all where conditions are added in case the given mapping batches other selects. -
select
public void select(ClassMapping mapping, int subclasses, JDBCStore store, JDBCFetchConfiguration fetch, int eager, Joins joins) Description copied from interface:Select
Select the columns of the given mapping, possibly including subclasses. This method should be called after all where conditions are added in case the given mapping batches other selects. -
selectIdentifier
Description copied from interface:Select
Select the given column as one that can be used to get a count of distinct matches. It is not necessary to designate distinct identifiers when eagerly traversing the entire result of the select or when not using an LRSSize setting ofcount
.- Specified by:
selectIdentifier
in interfaceSelect
- Returns:
- true if selected
-
selectIdentifier
Description copied from interface:Select
Select the given column as one that can be used to get a count of distinct matches. It is not necessary to designate distinct identifiers when eagerly traversing the entire result of the select or when not using an LRSSize setting ofcount
.- Specified by:
selectIdentifier
in interfaceSelect
- Returns:
- true if selected
-
selectIdentifier
Description copied from interface:Select
Select the given columns as ones that can be used to get a count of distinct matches. It is not necessary to designate distinct identifiers when eagerly traversing the entire result of the select or when not using an LRSSize setting ofcount
.- Specified by:
selectIdentifier
in interfaceSelect
- Returns:
- bit set of indexes of columns that were selected
-
selectIdentifier
Description copied from interface:Select
Select the given columns as ones that can be used to get a count of distinct matches. It is not necessary to designate distinct identifiers when eagerly traversing the entire result of the select or when not using an LRSSize setting ofcount
.- Specified by:
selectIdentifier
in interfaceSelect
- Returns:
- bit set of indexes of columns that were selected
-
selectIdentifier
public void selectIdentifier(ClassMapping mapping, int subclasses, JDBCStore store, JDBCFetchConfiguration fetch, int eager) Description copied from interface:Select
Select the columns of the given mapping, possibly including subclasses. This method should be called after all where conditions are added in case the given mapping batches other selects. The primary key columns of the mapping can be used to get a count of distinct matches. It is not necessary to designate distinct identifiers when eagerly traversing the entire result of the select or when not using an LRSSize setting ofcount
.- Specified by:
selectIdentifier
in interfaceSelect
-
selectIdentifier
public void selectIdentifier(ClassMapping mapping, int subclasses, JDBCStore store, JDBCFetchConfiguration fetch, int eager, Joins joins) Description copied from interface:Select
Select the columns of the given mapping, possibly including subclasses. This method should be called after all where conditions are added in case the given mapping batches other selects. The primary key columns of the mapping can be used to get a count of distinct matches. It is not necessary to designate distinct identifiers when eagerly traversing the entire result of the select or when not using an LRSSize setting ofcount
.- Specified by:
selectIdentifier
in interfaceSelect
-
selectPrimaryKey
Description copied from interface:Select
Select the primary key columns of the given mapping, joining to superclasses as necessary to get all columns needed to construct an object id.- Specified by:
selectPrimaryKey
in interfaceSelect
- Returns:
- bit set of indexes of pk columns that were selected
-
selectPrimaryKey
Description copied from interface:Select
Select the primary key columns of the given mapping, joining to superclasses as necessary to get all columns needed to construct an object id.- Specified by:
selectPrimaryKey
in interfaceSelect
- Returns:
- bit set of indexes of pk columns that were selected
-
orderByPrimaryKey
Description copied from interface:Select
Order on the primary key columns of the given mapping, joining to superclasses as necessary to get all columns needed to construct an object id. Optionally selects ordering data if not already selected.- Specified by:
orderByPrimaryKey
in interfaceSelect
-
orderByPrimaryKey
Description copied from interface:Select
Select and order on the primary key columns of the given mapping, joining to superclasses as necessary to get all columns needed to construct an object id. Optionally selects ordering data if not already selected.- Specified by:
orderByPrimaryKey
in interfaceSelect
-
recordOrder
Record that we're ordering by a SQL expression. -
recordOrderColumns
Record that we're ordering by the given columns. -
orderBy
Description copied from interface:Select
Order by the given column. Optionally selects ordering data if not already selected. -
orderBy
Description copied from interface:Select
Order by the given column. Optionally selects ordering data if not already selected. -
orderBy
Description copied from interface:Select
Order by the given columns. Optionally selects ordering data if not already selected. -
orderBy
Description copied from interface:Select
Order by the given columns. Optionally selects ordering data if not already selected. -
orderBy
Description copied from interface:Select
Add an ORDER BY clause. Optionally selects ordering data if not already selected. -
orderBy
Description copied from interface:Select
Add an ORDER BY clause. Optionally selects ordering data if not already selected. -
orderBy
Description copied from interface:Select
Add an ORDER BY clause. Optionally selects ordering data if not already selected. -
orderBy
Description copied from interface:Select
Add an ORDER BY clause. Optionally selects ordering data if not already selected. -
clearOrdering
public void clearOrdering()Description copied from interface:Select
Clear odering conditions.- Specified by:
clearOrdering
in interfaceSelect
-
wherePrimaryKey
Description copied from interface:Select
Add where conditions setting the mapping's primary key to the given oid values. If the given mapping does not use oid values for its primary key, we will recursively join to its superclass until we find an ancestor that does.- Specified by:
wherePrimaryKey
in interfaceSelect
-
whereForeignKey
Description copied from interface:Select
Add where conditions setting the given foreign key to the given oid values.- Specified by:
whereForeignKey
in interfaceSelect
- See Also:
-
where
Description copied from interface:Select
Add the given where conditions. -
where
Description copied from interface:Select
Add the given where conditions. -
where
Description copied from interface:Select
Add the given where conditions. -
where
Description copied from interface:Select
Add the given where conditions. -
where
Description copied from interface:Select
Add the given where conditions. -
having
Description copied from interface:Select
Add the given having conditions. -
having
Description copied from interface:Select
Add the given having conditions. -
having
Description copied from interface:Select
Add the given having conditions. -
having
Description copied from interface:Select
Add the given having conditions. -
groupBy
Description copied from interface:Select
Add a GROUP BY clause. -
groupBy
Description copied from interface:Select
Add a GROUP BY clause. -
groupBy
Description copied from interface:Select
Add a GROUP BY clause. -
groupBy
Description copied from interface:Select
Add a GROUP BY clause. -
groupBy
Description copied from interface:Select
Group by the given column. -
groupBy
Description copied from interface:Select
Group by the given column. -
groupBy
Description copied from interface:Select
Group by the given columns. -
groupBy
Description copied from interface:Select
Group by the given columns. -
groupBy
public void groupBy(ClassMapping mapping, int subclasses, JDBCStore store, JDBCFetchConfiguration fetch) Description copied from interface:Select
Group by the columns of the given mapping, possibly including subclasses. Assumes EAGER_NONE. -
groupBy
public void groupBy(ClassMapping mapping, int subclasses, JDBCStore store, JDBCFetchConfiguration fetch, Joins joins) Description copied from interface:Select
Group by the columns of the given mapping, possibly including subclasses. Assumes EAGER_NONE. -
whereClone
Description copied from interface:Select
Return a SELECT with the same joins and where conditions as this one.- Specified by:
whereClone
in interfaceSelect
- Parameters:
sels
- number of selects to UNION together; ignored if <= 1
-
fullClone
Description copied from interface:Select
Return a SELECT that is a complete clone of this one. -
eagerClone
Description copied from interface:Select
Return a select that will be eagerly executed with this one, or null if the select cannot be created for the given key and join type. If the join type is inner or outer, then this select instance will be returned. Otherwise, the returned select will have a clone of this select's where conditions and joins but will be independent.- Specified by:
eagerClone
in interfaceSelect
- Parameters:
key
- the key for the eager selecteagerType
- one of the EAGER_* constantstoMany
- whether the eager join is to-manysels
- number of selects to UNION together; ignored if <= 1
-
getEager
Description copied from interface:Select
Return the eager select for the given key. -
newJoins
Description copied from interface:Select
Return a new instance to use for joining. -
newOuterJoins
Description copied from interface:Select
Return a new instance to use for outer joining.- Specified by:
newOuterJoins
in interfaceSelect
-
append
Description copied from interface:Select
Append the given joins to the given buffer. -
and
Description copied from interface:Select
AND the given joins together. The given joins will be hollowed in the process. -
or
Description copied from interface:Select
OR the given joins together. The common joins will be removed in the process. -
outer
Description copied from interface:Select
Return a join set making the given joins outer joins. -
toString
Description copied from interface:Select
Implement toString to generate SQL string for profiling/debuggging. -
getExpectedResultCount
public int getExpectedResultCount()Description copied from interface:SelectExecutor
The expected result count for the query.- Specified by:
getExpectedResultCount
in interfaceSelectExecutor
-
setExpectedResultCount
public void setExpectedResultCount(int expectedResultCount, boolean force) Description copied from interface:SelectExecutor
The expected result count for the query.- Specified by:
setExpectedResultCount
in interfaceSelectExecutor
force
- if false, the count will be discarded if this select has any to-many eager joins that would throw off the result count
-
setContext
Description copied from interface:Select
Set JPQL query context for this select- Specified by:
setContext
in interfaceSelect
-
ctx
Description copied from interface:Select
Return the JPQL query context of this select -
setSchemaAlias
Description copied from interface:Select
Record the initial schemaAlias of a join path- Specified by:
setSchemaAlias
in interfaceSelect
-
logEagerRelations
public void logEagerRelations()Description copied from interface:Select
Extended trace that logs eager relations- Specified by:
logEagerRelations
in interfaceSelect
-
setTablePerClassMeta
Description copied from interface:Select
Set table-per-class metadata for polymorphic queries- Specified by:
setTablePerClassMeta
in interfaceSelect
-
getTablePerClassMeta
Description copied from interface:Select
get table-per-class metadata for polymorphic queries- Specified by:
getTablePerClassMeta
in interfaceSelect
-
setJoinedTableClassMeta
Description copied from interface:Select
Set joined table metadatas for polymorphic queries- Specified by:
setJoinedTableClassMeta
in interfaceSelect
-
getJoinedTableClassMeta
Description copied from interface:Select
get joined table metadatas for polymorphic queries- Specified by:
getJoinedTableClassMeta
in interfaceSelect
-
setExcludedJoinedTableClassMeta
Description copied from interface:Select
Set joined table metadatas excluded for polymorphic queries- Specified by:
setExcludedJoinedTableClassMeta
in interfaceSelect
-
getExcludedJoinedTableClassMeta
Description copied from interface:Select
get joined table metadatas excluded for polymorphic queries- Specified by:
getExcludedJoinedTableClassMeta
in interfaceSelect
-
getDictionary
- Specified by:
getDictionary
in interfaceSelect
-