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
public class LogicalUnion.UnionSelect extends java.lang.Object implements Select
A select that is part of a logical union.
-
-
Field Summary
Fields Modifier and Type Field Description protected java.util.List
orderIdxs
protected int
orders
protected int
pos
protected SelectImpl
sel
-
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
Constructors Constructor Description UnionSelect(SelectImpl sel, int pos)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
addJoinClassConditions()
Apply class conditions from relation joins.Joins
and(Joins joins1, Joins joins2)
AND the given joins together.void
append(SQLBuffer buf, Joins joins)
Append the given joins to the given buffer.void
clearOrdering()
Clear odering conditions.void
clearSelects()
Clear the existing column selects.Context
ctx()
Return the JPQL query context of this selectSelectExecutor
eagerClone(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.Result
execute(JDBCStore store, JDBCFetchConfiguration fetch)
Execute this select in the context of the given store manager.Result
execute(JDBCStore store, JDBCFetchConfiguration fetch, int lockLevel)
Execute this select in the context of the given store manager.SelectExecutor
fullClone(int sels)
Return a SELECT that is a complete clone of this one.boolean
getAutoDistinct()
Whether to automatically make results distinct when relational joins would otherwise introduce duplicates.java.lang.String
getColumnAlias(java.lang.String col, Table table)
Return the alias for the given column.java.lang.String
getColumnAlias(java.lang.String col, Table table, Joins joins)
Return the alias for the given column.java.lang.String
getColumnAlias(Column col)
Return the alias for the given column.java.lang.String
getColumnAlias(Column col, java.lang.Object alias)
Return the alias for the given column, without creating new table aliasjava.lang.String
getColumnAlias(Column col, Joins joins)
Return the alias for the given column.JDBCConfiguration
getConfiguration()
Return the select configuration.int
getCount(JDBCStore store)
Return the number of instances matching this select.SelectImpl
getDelegate()
Delegate select.DBDictionary
getDictionary()
SelectExecutor
getEager(FieldMapping key)
Return the eager select for the given key.long
getEndIndex()
The result end index.java.util.List
getExcludedJoinedTableClassMeta()
get joined table metadatas excluded for polymorphic queriesint
getExpectedResultCount()
The expected result count for the query.Select
getFromSelect()
Another select instance that creates a temporary table from which this select pulls data.SQLBuffer
getGrouping()
Return the grouping SQL for this select.boolean
getHasSubselect()
Return the flag to indicate whether this Select has internally generated subselectSQLBuffer
getHaving()
Return the HAVING clause, or null if none.java.util.List
getIdentifierAliases()
Get the aliases for identifier columns that can be used in COUNT selects to find the number of matches.java.util.List
getJoinedTableClassMeta()
get joined table metadatas for polymorphic queriesjava.util.Iterator
getJoinIterator()
Return the top-levelJoin
elements for this select.Joins
getJoins()
Return the top-level joins for this select.int
getJoinSyntax()
The join syntax for this select, as one of the syntax constants fromJoinSyntaxes
.SQLBuffer
getOrdering()
Return the ordering SQL for this select.Select
getParent()
Return the parent of this select, if it is a subselect.java.util.List
getSelectAliases()
Return the aliases of all selected columns and all selected buffers, in the order they were selected.java.util.List
getSelectedOrderIndexes()
Return the indexes of the data in the select clause this query is ordered by.java.util.List
getSelects()
Return the actualVal
s andColumn
s that were selected, in the order that they were selected.SQLBuffer
getSQL()
Get the buffer if it has been computed by a previous call toSelectExecutor.toSelect(boolean, JDBCFetchConfiguration)
, if any.long
getStartIndex()
The result start index.java.lang.String
getSubselectPath()
Return the subselect path for this select, if it is a subselect.java.util.List
getSubselects()
Return this select's subselects, or empty collection if none.java.util.Collection
getTableAliases()
Return the set of all used table aliases.ClassMapping
getTablePerClassMeta()
get table-per-class metadata for polymorphic queriesSQLBuffer
getWhere()
Return the WHERE clause, minus any necessary end joins.void
groupBy(java.lang.String sql)
Add a GROUP BY clause.void
groupBy(java.lang.String sql, Joins joins)
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
groupBy(Column col)
Group by the given column.void
groupBy(Column[] cols)
Group by the given columns.void
groupBy(Column[] cols, Joins joins)
Group by the given columns.void
groupBy(Column col, Joins joins)
Group by the given column.void
groupBy(SQLBuffer sql)
Add a GROUP BY clause.void
groupBy(SQLBuffer sql, Joins joins)
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
hasMultipleSelects()
Affirm if this receiver requires more than one selects to fetch its data.void
having(java.lang.String sql)
Add the given having conditions.void
having(java.lang.String sql, Joins joins)
Add the given having conditions.void
having(SQLBuffer sql)
Add the given having conditions.void
having(SQLBuffer sql, Joins joins)
Add the given having conditions.int
indexOf()
The index of this select within the UNION, or 0.boolean
isAggregate()
Return true if this is an aggregate select.boolean
isDistinct()
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
logEagerRelations()
Extended trace that logs eager relationsJoins
newJoins()
Return a new instance to use for joining.Joins
newOuterJoins()
Return a new instance to use for outer joining.Joins
or(Joins joins1, Joins joins2)
OR the given joins together.boolean
orderBy(java.lang.String sql, boolean asc, boolean select)
Add an ORDER BY clause.boolean
orderBy(java.lang.String sql, boolean asc, Joins joins, boolean select)
Add an ORDER BY clause.int
orderBy(Column[] cols, boolean asc, boolean select)
Order by the given columns.int
orderBy(Column[] cols, boolean asc, Joins joins, boolean select)
Order by the given columns.boolean
orderBy(Column col, boolean asc, boolean select)
Order by the given column.boolean
orderBy(Column col, boolean asc, Joins joins, boolean select)
Order by the given column.boolean
orderBy(SQLBuffer sql, boolean asc, boolean select, Value selAs)
Add an ORDER BY clause.boolean
orderBy(SQLBuffer sql, boolean asc, Joins joins, boolean select, Value selAs)
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.Joins
outer(Joins joins)
Return a join set making the given joins outer joins.protected void
recordOrder(java.lang.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(java.lang.String sql, java.lang.Object id)
Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from aResult
.boolean
select(java.lang.String sql, java.lang.Object id, Joins joins)
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(Column col)
Select the given column.int
select(Column[] cols)
Select the given columns.int
select(Column[] cols, Joins joins)
Select the given columns.boolean
select(Column col, Joins joins)
Select the given column.boolean
select(SQLBuffer sql, java.lang.Object id)
Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from aResult
.boolean
select(SQLBuffer sql, java.lang.Object id, Joins joins)
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(java.lang.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
setExcludedJoinedTableClassMeta(java.util.List meta)
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(java.util.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
setParent(Select parent, java.lang.String path)
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(java.lang.String schemaAlias)
Record the initial schemaAlias of a join pathvoid
setTablePerClassMeta(ClassMapping meta)
Set table-per-class metadata for polymorphic queriesboolean
supportsLocking()
Whether this select can be executed for update.boolean
supportsRandomAccess(boolean forUpdate)
Return whether this select can support a random access result set type.SQLBuffer
toSelect(boolean forUpdate, JDBCFetchConfiguration fetch)
Return this select as a SQL statement formatted for the current dictionary.SQLBuffer
toSelectCount()
Return this select as a COUNT SQL statement formatted for the current dictionary.java.lang.String
toString()
Implement toString to generate SQL string for profiling/debuggging.void
where(java.lang.String sql)
Add the given where conditions.void
where(java.lang.String sql, Joins joins)
Add the given where conditions.void
where(Joins joins)
Add the given where conditions.void
where(SQLBuffer sql)
Add the given where conditions.void
where(SQLBuffer sql, Joins joins)
Add the given where conditions.SelectExecutor
whereClone(int sels)
Return a SELECT with the same joins and where conditions as this one.void
whereForeignKey(ForeignKey fk, java.lang.Object oid, ClassMapping mapping, JDBCStore store)
Add where conditions setting the given foreign key to the given oid values.void
wherePrimaryKey(java.lang.Object oid, ClassMapping mapping, JDBCStore store)
Add where conditions setting the mapping's primary key to the given oid values.
-
-
-
Field Detail
-
sel
protected final SelectImpl sel
-
pos
protected final int pos
-
orders
protected int orders
-
orderIdxs
protected java.util.List orderIdxs
-
-
Constructor Detail
-
UnionSelect
public UnionSelect(SelectImpl sel, int pos)
-
-
Method Detail
-
getDelegate
public SelectImpl getDelegate()
Delegate select.
-
getSelectedOrderIndexes
public java.util.List getSelectedOrderIndexes()
Return the indexes of the data in the select clause this query is ordered by.
-
getConfiguration
public JDBCConfiguration 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
public SQLBuffer toSelect(boolean forUpdate, JDBCFetchConfiguration fetch)
Description copied from interface:SelectExecutor
Return this select as a SQL statement formatted for the current dictionary.- Specified by:
toSelect
in interfaceSelectExecutor
-
getSQL
public SQLBuffer 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
public SQLBuffer 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
public int getCount(JDBCStore store) throws java.sql.SQLException
Description copied from interface:SelectExecutor
Return the number of instances matching this select.- Specified by:
getCount
in interfaceSelectExecutor
- Throws:
java.sql.SQLException
-
execute
public Result execute(JDBCStore store, JDBCFetchConfiguration fetch) throws java.sql.SQLException
Description copied from interface:SelectExecutor
Execute this select in the context of the given store manager.- Specified by:
execute
in interfaceSelectExecutor
- Throws:
java.sql.SQLException
-
execute
public Result execute(JDBCStore store, JDBCFetchConfiguration fetch, int lockLevel) throws java.sql.SQLException
Description copied from interface:SelectExecutor
Execute this select in the context of the given store manager.- Specified by:
execute
in interfaceSelectExecutor
- Throws:
java.sql.SQLException
-
getSubselects
public java.util.List getSubselects()
Description copied from interface:Select
Return this select's subselects, or empty collection if none.- Specified by:
getSubselects
in interfaceSelect
-
getParent
public Select getParent()
Description copied from interface:Select
Return the parent of this select, if it is a subselect.
-
getSubselectPath
public java.lang.String getSubselectPath()
Description copied from interface:Select
Return the subselect path for this select, if it is a subselect.- Specified by:
getSubselectPath
in interfaceSelect
-
setParent
public void setParent(Select parent, java.lang.String path)
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
public Select 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
public void setFromSelect(Select sel)
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
public boolean isSelected(Table table)
Description copied from interface:Select
Return whether the given table is being used in this select.- Specified by:
isSelected
in interfaceSelect
-
getTableAliases
public java.util.Collection getTableAliases()
Description copied from interface:Select
Return the set of all used table aliases.- Specified by:
getTableAliases
in interfaceSelect
-
getSelects
public java.util.List 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
public java.util.List 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
public java.util.List 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
public SQLBuffer getOrdering()
Description copied from interface:Select
Return the ordering SQL for this select.- Specified by:
getOrdering
in interfaceSelect
-
getGrouping
public SQLBuffer getGrouping()
Description copied from interface:Select
Return the grouping SQL for this select.- Specified by:
getGrouping
in interfaceSelect
-
getWhere
public SQLBuffer getWhere()
Description copied from interface:Select
Return the WHERE clause, minus any necessary end joins.
-
getHaving
public SQLBuffer 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
public Joins getJoins()
Description copied from interface:Select
Return the top-level joins for this select.
-
getJoinIterator
public java.util.Iterator 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
public java.lang.String getColumnAlias(Column col)
Description copied from interface:Select
Return the alias for the given column.- Specified by:
getColumnAlias
in interfaceSelect
-
getColumnAlias
public java.lang.String getColumnAlias(Column col, Joins joins)
Description copied from interface:Select
Return the alias for the given column.- Specified by:
getColumnAlias
in interfaceSelect
-
getColumnAlias
public java.lang.String getColumnAlias(Column col, java.lang.Object alias)
Description copied from interface:Select
Return the alias for the given column, without creating new table alias- Specified by:
getColumnAlias
in interfaceSelect
-
getColumnAlias
public java.lang.String getColumnAlias(java.lang.String col, Table table)
Description copied from interface:Select
Return the alias for the given column.- Specified by:
getColumnAlias
in interfaceSelect
-
getColumnAlias
public java.lang.String getColumnAlias(java.lang.String col, Table table, Joins joins)
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
public void selectPlaceholder(java.lang.String sql)
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
public boolean select(SQLBuffer sql, java.lang.Object id)
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
public boolean select(SQLBuffer sql, java.lang.Object id, Joins joins)
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
public boolean select(java.lang.String sql, java.lang.Object id)
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
public boolean select(java.lang.String sql, java.lang.Object id, Joins joins)
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
public boolean select(Column col)
Description copied from interface:Select
Select the given column.
-
select
public boolean select(Column col, Joins joins)
Description copied from interface:Select
Select the given column.
-
select
public int select(Column[] cols)
Description copied from interface:Select
Select the given columns.
-
select
public int select(Column[] cols, Joins joins)
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
public boolean selectIdentifier(Column col)
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
public boolean selectIdentifier(Column col, Joins joins)
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
public int selectIdentifier(Column[] cols)
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 int selectIdentifier(Column[] cols, Joins joins)
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
public int selectPrimaryKey(ClassMapping mapping)
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
public int selectPrimaryKey(ClassMapping mapping, Joins joins)
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
public int orderByPrimaryKey(ClassMapping mapping, boolean asc, boolean select)
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
public int orderByPrimaryKey(ClassMapping mapping, boolean asc, Joins joins, boolean select)
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
protected void recordOrder(java.lang.Object ord, boolean asc)
Record that we're ordering by a SQL expression.
-
recordOrderColumns
protected void recordOrderColumns(Column[] cols, boolean asc)
Record that we're ordering by the given columns.
-
orderBy
public boolean orderBy(Column col, boolean asc, boolean select)
Description copied from interface:Select
Order by the given column. Optionally selects ordering data if not already selected.
-
orderBy
public boolean orderBy(Column col, boolean asc, Joins joins, boolean select)
Description copied from interface:Select
Order by the given column. Optionally selects ordering data if not already selected.
-
orderBy
public int orderBy(Column[] cols, boolean asc, boolean select)
Description copied from interface:Select
Order by the given columns. Optionally selects ordering data if not already selected.
-
orderBy
public int orderBy(Column[] cols, boolean asc, Joins joins, boolean select)
Description copied from interface:Select
Order by the given columns. Optionally selects ordering data if not already selected.
-
orderBy
public boolean orderBy(SQLBuffer sql, boolean asc, boolean select, Value selAs)
Description copied from interface:Select
Add an ORDER BY clause. Optionally selects ordering data if not already selected.
-
orderBy
public boolean orderBy(SQLBuffer sql, boolean asc, Joins joins, boolean select, Value selAs)
Description copied from interface:Select
Add an ORDER BY clause. Optionally selects ordering data if not already selected.
-
orderBy
public boolean orderBy(java.lang.String sql, boolean asc, boolean select)
Description copied from interface:Select
Add an ORDER BY clause. Optionally selects ordering data if not already selected.
-
orderBy
public boolean orderBy(java.lang.String sql, boolean asc, Joins joins, boolean select)
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
public void wherePrimaryKey(java.lang.Object oid, ClassMapping mapping, JDBCStore store)
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
public void whereForeignKey(ForeignKey fk, java.lang.Object oid, ClassMapping mapping, JDBCStore store)
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:
Select.wherePrimaryKey(java.lang.Object, org.apache.openjpa.jdbc.meta.ClassMapping, org.apache.openjpa.jdbc.kernel.JDBCStore)
-
where
public void where(Joins joins)
Description copied from interface:Select
Add the given where conditions.
-
where
public void where(SQLBuffer sql)
Description copied from interface:Select
Add the given where conditions.
-
where
public void where(SQLBuffer sql, Joins joins)
Description copied from interface:Select
Add the given where conditions.
-
where
public void where(java.lang.String sql)
Description copied from interface:Select
Add the given where conditions.
-
where
public void where(java.lang.String sql, Joins joins)
Description copied from interface:Select
Add the given where conditions.
-
having
public void having(SQLBuffer sql)
Description copied from interface:Select
Add the given having conditions.
-
having
public void having(SQLBuffer sql, Joins joins)
Description copied from interface:Select
Add the given having conditions.
-
having
public void having(java.lang.String sql)
Description copied from interface:Select
Add the given having conditions.
-
having
public void having(java.lang.String sql, Joins joins)
Description copied from interface:Select
Add the given having conditions.
-
groupBy
public void groupBy(SQLBuffer sql)
Description copied from interface:Select
Add a GROUP BY clause.
-
groupBy
public void groupBy(SQLBuffer sql, Joins joins)
Description copied from interface:Select
Add a GROUP BY clause.
-
groupBy
public void groupBy(java.lang.String sql)
Description copied from interface:Select
Add a GROUP BY clause.
-
groupBy
public void groupBy(java.lang.String sql, Joins joins)
Description copied from interface:Select
Add a GROUP BY clause.
-
groupBy
public void groupBy(Column col)
Description copied from interface:Select
Group by the given column.
-
groupBy
public void groupBy(Column col, Joins joins)
Description copied from interface:Select
Group by the given column.
-
groupBy
public void groupBy(Column[] cols)
Description copied from interface:Select
Group by the given columns.
-
groupBy
public void groupBy(Column[] cols, Joins joins)
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
public SelectExecutor whereClone(int sels)
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
public SelectExecutor fullClone(int sels)
Description copied from interface:Select
Return a SELECT that is a complete clone of this one.
-
eagerClone
public SelectExecutor eagerClone(FieldMapping key, int eagerType, boolean toMany, int sels)
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
public SelectExecutor getEager(FieldMapping key)
Description copied from interface:Select
Return the eager select for the given key.
-
newJoins
public Joins newJoins()
Description copied from interface:Select
Return a new instance to use for joining.
-
newOuterJoins
public Joins newOuterJoins()
Description copied from interface:Select
Return a new instance to use for outer joining.- Specified by:
newOuterJoins
in interfaceSelect
-
append
public void append(SQLBuffer buf, Joins joins)
Description copied from interface:Select
Append the given joins to the given buffer.
-
and
public Joins and(Joins joins1, Joins joins2)
Description copied from interface:Select
AND the given joins together. The given joins will be hollowed in the process.
-
or
public Joins or(Joins joins1, Joins joins2)
Description copied from interface:Select
OR the given joins together. The common joins will be removed in the process.
-
outer
public Joins outer(Joins joins)
Description copied from interface:Select
Return a join set making the given joins outer joins.
-
toString
public java.lang.String 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
public void setContext(Context context)
Description copied from interface:Select
Set JPQL query context for this select- Specified by:
setContext
in interfaceSelect
-
ctx
public Context ctx()
Description copied from interface:Select
Return the JPQL query context of this select
-
setSchemaAlias
public void setSchemaAlias(java.lang.String schemaAlias)
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
public void setTablePerClassMeta(ClassMapping meta)
Description copied from interface:Select
Set table-per-class metadata for polymorphic queries- Specified by:
setTablePerClassMeta
in interfaceSelect
-
getTablePerClassMeta
public ClassMapping getTablePerClassMeta()
Description copied from interface:Select
get table-per-class metadata for polymorphic queries- Specified by:
getTablePerClassMeta
in interfaceSelect
-
setJoinedTableClassMeta
public void setJoinedTableClassMeta(java.util.List meta)
Description copied from interface:Select
Set joined table metadatas for polymorphic queries- Specified by:
setJoinedTableClassMeta
in interfaceSelect
-
getJoinedTableClassMeta
public java.util.List getJoinedTableClassMeta()
Description copied from interface:Select
get joined table metadatas for polymorphic queries- Specified by:
getJoinedTableClassMeta
in interfaceSelect
-
setExcludedJoinedTableClassMeta
public void setExcludedJoinedTableClassMeta(java.util.List meta)
Description copied from interface:Select
Set joined table metadatas excluded for polymorphic queries- Specified by:
setExcludedJoinedTableClassMeta
in interfaceSelect
-
getExcludedJoinedTableClassMeta
public java.util.List getExcludedJoinedTableClassMeta()
Description copied from interface:Select
get joined table metadatas excluded for polymorphic queries- Specified by:
getExcludedJoinedTableClassMeta
in interfaceSelect
-
getDictionary
public DBDictionary getDictionary()
- Specified by:
getDictionary
in interfaceSelect
-
-