org.apache.openjpa.jdbc.sql
Class LogicalUnion.UnionSelect

java.lang.Object
  extended by org.apache.openjpa.jdbc.sql.LogicalUnion.UnionSelect
All Implemented Interfaces:
Select, SelectExecutor
Enclosing class:
LogicalUnion

public class LogicalUnion.UnionSelect
extends Object
implements Select

A select that is part of a logical union.


Field Summary
protected  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
LogicalUnion.UnionSelect(SelectImpl sel, int pos)
           
 
Method Summary
 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.
 SelectExecutor 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.
 Result execute(JDBCStore store, JDBCFetchConfiguration fetch, int lockLevel, List params)
          Execute this select in the context of the given store manager.
 Result execute(JDBCStore store, JDBCFetchConfiguration fetch, List params)
          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.
 String getColumnAlias(Column col)
          Return the alias for the given column.
 String getColumnAlias(Column col, Joins joins)
          Return the alias for the given column.
 String getColumnAlias(String col, Table table)
          Return the alias for the given column.
 String getColumnAlias(String col, Table table, 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.
 SelectExecutor getEager(FieldMapping key)
          Return the eager select for the given key.
 long getEndIndex()
          The result end index.
 int 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.
 SQLBuffer getHaving()
          Return the HAVING clause, or null if none.
 List getIdentifierAliases()
          Get the aliases for identifier columns that can be used in COUNT selects to find the number of matches.
 Iterator getJoinIterator()
          Return the top-level Join 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 from JoinSyntaxes.
 SQLBuffer getOrdering()
          Return the ordering SQL for this select.
 Select getParent()
          Return the parent of this select, if it is a subselect.
 List getSelectAliases()
          Return the aliases of all selected columns and all selected buffers, in the order they were selected.
 List getSelectedOrderIndexes()
          Return the indexes of the data in the select clause this query is ordered by.
 List getSelects()
          Return the actual Vals and Columns that were selected, in the order that they were selected.
 SQLBuffer getSQL()
          Return the SQL for this select.
 long getStartIndex()
          The result start index.
 String getSubselectPath()
          Return the subselect path for this select, if it is a subselect.
 List getSubselects()
          Return this select's subselects, or empty collection if none.
 Collection getTableAliases()
          Return the set of all used table aliases.
 SQLBuffer getWhere()
          Return the WHERE clause, minus any necessary end joins.
 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.
 void groupBy(String sql)
          Add a GROUP BY clause.
 void groupBy(String 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.
 void having(SQLBuffer sql)
          Add the given having conditions.
 void having(SQLBuffer sql, Joins joins)
          Add the given having conditions.
 void having(String sql)
          Add the given having conditions.
 void having(String 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.
 Joins 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.
 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)
          Add an ORDER BY clause.
 boolean orderBy(SQLBuffer sql, boolean asc, Joins joins, boolean select)
          Add an ORDER BY clause.
 boolean orderBy(String sql, boolean asc, boolean select)
          Add an ORDER BY clause.
 boolean orderBy(String sql, boolean asc, Joins joins, boolean select)
          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(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.
 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, Object id)
          Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from a Result.
 boolean select(SQLBuffer sql, Object id, Joins joins)
          Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from a Result.
 boolean select(String sql, Object id)
          Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from a Result.
 boolean select(String sql, Object id, Joins joins)
          Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from a Result.
 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 setDistinct(boolean distinct)
          Whether this is a SELECT DISTINCT / UNION ALL.
 void 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 setJoinSyntax(int joinSyntax)
          The join syntax for this select, as one of the syntax constants from JoinSyntaxes.
 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, 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 setSQL(JDBCStore store, JDBCFetchConfiguration fetch)
          Create and set the SQLBuffer object to this select.
 boolean 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.
 String toString()
          Implement toString to generate SQL string for profiling/debuggging.
 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.
 void where(String sql)
          Add the given where conditions.
 void where(String 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, Object oid, ClassMapping mapping, JDBCStore store)
          Add where conditions setting the given foreign key to the given oid values.
 int wherePrimaryKey(ClassMapping mapping, Column[] toCols, Column[] fromCols, Object oid, JDBCStore store, PathJoins pj, SQLBuffer buf, List parmList)
          Add where conditions setting the mapping's primary 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.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

sel

protected final SelectImpl sel

pos

protected final int pos

orders

protected int orders

orderIdxs

protected List orderIdxs
Constructor Detail

LogicalUnion.UnionSelect

public LogicalUnion.UnionSelect(SelectImpl sel,
                                int pos)
Method Detail

getDelegate

public SelectImpl getDelegate()
Delegate select.


getSelectedOrderIndexes

public 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 interface SelectExecutor

indexOf

public int indexOf()
Description copied from interface: Select
The index of this select within the UNION, or 0.

Specified by:
indexOf in interface Select

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 interface SelectExecutor

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 interface SelectExecutor

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 interface SelectExecutor

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 interface SelectExecutor

isDistinct

public boolean isDistinct()
Description copied from interface: SelectExecutor
Whether this is a SELECT DISTINCT / UNION ALL.

Specified by:
isDistinct in interface SelectExecutor

setDistinct

public void setDistinct(boolean distinct)
Description copied from interface: SelectExecutor
Whether this is a SELECT DISTINCT / UNION ALL.

Specified by:
setDistinct in interface SelectExecutor

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 interface SelectExecutor

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 interface SelectExecutor

getJoinSyntax

public int getJoinSyntax()
Description copied from interface: SelectExecutor
The join syntax for this select, as one of the syntax constants from JoinSyntaxes.

Specified by:
getJoinSyntax in interface SelectExecutor

setJoinSyntax

public void setJoinSyntax(int joinSyntax)
Description copied from interface: SelectExecutor
The join syntax for this select, as one of the syntax constants from JoinSyntaxes.

Specified by:
setJoinSyntax in interface SelectExecutor

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 interface SelectExecutor

supportsLocking

public boolean supportsLocking()
Description copied from interface: SelectExecutor
Whether this select can be executed for update.

Specified by:
supportsLocking in interface SelectExecutor

getCount

public int getCount(JDBCStore store)
             throws SQLException
Description copied from interface: SelectExecutor
Return the number of instances matching this select.

Specified by:
getCount in interface SelectExecutor
Throws:
SQLException

execute

public Result execute(JDBCStore store,
                      JDBCFetchConfiguration fetch,
                      List params)
               throws SQLException
Description copied from interface: SelectExecutor
Execute this select in the context of the given store manager.

Specified by:
execute in interface SelectExecutor
Throws:
SQLException

execute

public Result execute(JDBCStore store,
                      JDBCFetchConfiguration fetch,
                      int lockLevel,
                      List params)
               throws SQLException
Description copied from interface: SelectExecutor
Execute this select in the context of the given store manager.

Specified by:
execute in interface SelectExecutor
Throws:
SQLException

execute

public Result execute(JDBCStore store,
                      JDBCFetchConfiguration fetch)
               throws SQLException
Description copied from interface: SelectExecutor
Execute this select in the context of the given store manager.

Specified by:
execute in interface SelectExecutor
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 interface SelectExecutor
Throws:
SQLException

getSubselects

public List getSubselects()
Description copied from interface: Select
Return this select's subselects, or empty collection if none.

Specified by:
getSubselects in interface Select

getParent

public Select getParent()
Description copied from interface: Select
Return the parent of this select, if it is a subselect.

Specified by:
getParent in interface Select

getSubselectPath

public String getSubselectPath()
Description copied from interface: Select
Return the subselect path for this select, if it is a subselect.

Specified by:
getSubselectPath in interface Select

setParent

public void setParent(Select parent,
                      String path)
Description copied from interface: Select
Turn this select into a subselect of the given instance.

Specified by:
setParent in interface Select

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 interface Select

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 interface Select

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 interface Select

hasJoin

public boolean hasJoin(boolean toMany)
Description copied from interface: Select
Whether this select has a join of the specified type.

Specified by:
hasJoin in interface Select

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 interface Select

getTableAliases

public Collection getTableAliases()
Description copied from interface: Select
Return the set of all used table aliases.

Specified by:
getTableAliases in interface Select

getSelects

public List getSelects()
Description copied from interface: Select
Return the actual Vals and Columns that were selected, in the order that they were selected.

Specified by:
getSelects in interface Select

getSelectAliases

public 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 a SQLBuffer.

Specified by:
getSelectAliases in interface Select

getIdentifierAliases

public 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 interface Select

getOrdering

public SQLBuffer getOrdering()
Description copied from interface: Select
Return the ordering SQL for this select.

Specified by:
getOrdering in interface Select

getGrouping

public SQLBuffer getGrouping()
Description copied from interface: Select
Return the grouping SQL for this select.

Specified by:
getGrouping in interface Select

getWhere

public SQLBuffer getWhere()
Description copied from interface: Select
Return the WHERE clause, minus any necessary end joins.

Specified by:
getWhere in interface Select

getHaving

public SQLBuffer getHaving()
Description copied from interface: Select
Return the HAVING clause, or null if none.

Specified by:
getHaving in interface Select

getSQL

public SQLBuffer getSQL()
Description copied from interface: Select
Return the SQL for this select. This buffer contains the final SQL to be executed/cached.

Specified by:
getSQL in interface Select

setSQL

public void setSQL(JDBCStore store,
                   JDBCFetchConfiguration fetch)
Description copied from interface: Select
Create and set the SQLBuffer object to this select. This buffer contains the final SQL to be executed/cached.

Specified by:
setSQL in interface Select

addJoinClassConditions

public void addJoinClassConditions()
Description copied from interface: Select
Apply class conditions from relation joins. This may affect the return values of Select.getJoins(), Select.getJoinIterator(), and Select.getWhere().

Specified by:
addJoinClassConditions in interface Select

getJoins

public Joins getJoins()
Description copied from interface: Select
Return the top-level joins for this select.

Specified by:
getJoins in interface Select

getJoinIterator

public Iterator getJoinIterator()
Description copied from interface: Select
Return the top-level Join elements for this select.

Specified by:
getJoinIterator in interface Select

getStartIndex

public long getStartIndex()
Description copied from interface: Select
The result start index.

Specified by:
getStartIndex in interface Select

getEndIndex

public long getEndIndex()
Description copied from interface: Select
The result end index.

Specified by:
getEndIndex in interface Select

setRange

public void setRange(long start,
                     long end)
Description copied from interface: Select
Set the result range for this select.

Specified by:
setRange in interface Select

getColumnAlias

public String getColumnAlias(Column col)
Description copied from interface: Select
Return the alias for the given column.

Specified by:
getColumnAlias in interface Select

getColumnAlias

public String getColumnAlias(Column col,
                             Joins joins)
Description copied from interface: Select
Return the alias for the given column.

Specified by:
getColumnAlias in interface Select

getColumnAlias

public String getColumnAlias(String col,
                             Table table)
Description copied from interface: Select
Return the alias for the given column.

Specified by:
getColumnAlias in interface Select

getColumnAlias

public String getColumnAlias(String col,
                             Table table,
                             Joins joins)
Description copied from interface: Select
Return the alias for the given column.

Specified by:
getColumnAlias in interface Select

isAggregate

public boolean isAggregate()
Description copied from interface: Select
Return true if this is an aggregate select.

Specified by:
isAggregate in interface Select

setAggregate

public void setAggregate(boolean agg)
Description copied from interface: Select
Set to true for aggregate selects.

Specified by:
setAggregate in interface Select

isLob

public boolean isLob()
Description copied from interface: Select
Return true if this select includes a LOB.

Specified by:
isLob in interface Select

setLob

public void setLob(boolean lob)
Description copied from interface: Select
Set to true for selects that include LOB columns.

Specified by:
setLob in interface Select

selectPlaceholder

public void selectPlaceholder(String sql)
Description copied from interface: Select
Select the given SQL as a placeholder for a UNION element.

Specified by:
selectPlaceholder in interface Select

clearSelects

public void clearSelects()
Description copied from interface: Select
Clear the existing column selects.

Specified by:
clearSelects in interface Select

select

public boolean select(SQLBuffer sql,
                      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 a Result.

Specified by:
select in interface Select
Returns:
true if selected

select

public boolean select(SQLBuffer sql,
                      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 a Result.

Specified by:
select in interface Select
Returns:
true if selected

select

public boolean select(String sql,
                      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 a Result.

Specified by:
select in interface Select
Returns:
true if selected

select

public boolean select(String sql,
                      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 a Result.

Specified by:
select in interface Select
Returns:
true if selected

select

public boolean select(Column col)
Description copied from interface: Select
Select the given column.

Specified by:
select in interface Select
Returns:
true if selected

select

public boolean select(Column col,
                      Joins joins)
Description copied from interface: Select
Select the given column.

Specified by:
select in interface Select
Returns:
true if selected

select

public int select(Column[] cols)
Description copied from interface: Select
Select the given columns.

Specified by:
select in interface Select
Returns:
bit set of indexes of columns that were selected

select

public int select(Column[] cols,
                  Joins joins)
Description copied from interface: Select
Select the given columns.

Specified by:
select in interface Select
Returns:
bit set of indexes of columns that were selected

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.

Specified by:
select in interface Select

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.

Specified by:
select in interface Select

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 of count.

Specified by:
selectIdentifier in interface Select
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 of count.

Specified by:
selectIdentifier in interface Select
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 of count.

Specified by:
selectIdentifier in interface Select
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 of count.

Specified by:
selectIdentifier in interface Select
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 of count.

Specified by:
selectIdentifier in interface Select

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 of count.

Specified by:
selectIdentifier in interface Select

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 interface Select
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 interface Select
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 interface Select

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 interface Select

recordOrder

protected void recordOrder(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.

Specified by:
orderBy in interface Select

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.

Specified by:
orderBy in interface Select

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.

Specified by:
orderBy in interface Select

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.

Specified by:
orderBy in interface Select

orderBy

public boolean orderBy(SQLBuffer sql,
                       boolean asc,
                       boolean select)
Description copied from interface: Select
Add an ORDER BY clause. Optionally selects ordering data if not already selected.

Specified by:
orderBy in interface Select

orderBy

public boolean orderBy(SQLBuffer 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.

Specified by:
orderBy in interface Select

orderBy

public boolean orderBy(String sql,
                       boolean asc,
                       boolean select)
Description copied from interface: Select
Add an ORDER BY clause. Optionally selects ordering data if not already selected.

Specified by:
orderBy in interface Select

orderBy

public boolean orderBy(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.

Specified by:
orderBy in interface Select

clearOrdering

public void clearOrdering()
Description copied from interface: Select
Clear odering conditions.

Specified by:
clearOrdering in interface Select

wherePrimaryKey

public void wherePrimaryKey(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 interface Select

wherePrimaryKey

public int wherePrimaryKey(ClassMapping mapping,
                           Column[] toCols,
                           Column[] fromCols,
                           Object oid,
                           JDBCStore store,
                           PathJoins pj,
                           SQLBuffer buf,
                           List parmList)
Description copied from interface: Select
Add where conditions setting the mapping's primary key to the given oid values. If the parmList is not null, the value of the primary key will be collected and saved into the parmList. If the parmList is null, this method will build the where clause with the value incorporated in the where clause.

Specified by:
wherePrimaryKey in interface Select

whereForeignKey

public void whereForeignKey(ForeignKey fk,
                            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 interface Select
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.

Specified by:
where in interface Select

where

public void where(SQLBuffer sql)
Description copied from interface: Select
Add the given where conditions.

Specified by:
where in interface Select

where

public void where(SQLBuffer sql,
                  Joins joins)
Description copied from interface: Select
Add the given where conditions.

Specified by:
where in interface Select

where

public void where(String sql)
Description copied from interface: Select
Add the given where conditions.

Specified by:
where in interface Select

where

public void where(String sql,
                  Joins joins)
Description copied from interface: Select
Add the given where conditions.

Specified by:
where in interface Select

having

public void having(SQLBuffer sql)
Description copied from interface: Select
Add the given having conditions.

Specified by:
having in interface Select

having

public void having(SQLBuffer sql,
                   Joins joins)
Description copied from interface: Select
Add the given having conditions.

Specified by:
having in interface Select

having

public void having(String sql)
Description copied from interface: Select
Add the given having conditions.

Specified by:
having in interface Select

having

public void having(String sql,
                   Joins joins)
Description copied from interface: Select
Add the given having conditions.

Specified by:
having in interface Select

groupBy

public void groupBy(SQLBuffer sql)
Description copied from interface: Select
Add a GROUP BY clause.

Specified by:
groupBy in interface Select

groupBy

public void groupBy(SQLBuffer sql,
                    Joins joins)
Description copied from interface: Select
Add a GROUP BY clause.

Specified by:
groupBy in interface Select

groupBy

public void groupBy(String sql)
Description copied from interface: Select
Add a GROUP BY clause.

Specified by:
groupBy in interface Select

groupBy

public void groupBy(String sql,
                    Joins joins)
Description copied from interface: Select
Add a GROUP BY clause.

Specified by:
groupBy in interface Select

groupBy

public void groupBy(Column col)
Description copied from interface: Select
Group by the given column.

Specified by:
groupBy in interface Select

groupBy

public void groupBy(Column col,
                    Joins joins)
Description copied from interface: Select
Group by the given column.

Specified by:
groupBy in interface Select

groupBy

public void groupBy(Column[] cols)
Description copied from interface: Select
Group by the given columns.

Specified by:
groupBy in interface Select

groupBy

public void groupBy(Column[] cols,
                    Joins joins)
Description copied from interface: Select
Group by the given columns.

Specified by:
groupBy in interface Select

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.

Specified by:
groupBy in interface Select

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.

Specified by:
groupBy in interface Select

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 interface Select
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.

Specified by:
fullClone in interface Select
Parameters:
sels - number of selects to UNION together; ignored if <= 1

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 interface Select
Parameters:
key - the key for the eager select
eagerType - one of the EAGER_* constants
toMany - whether the eager join is to-many
sels - 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.

Specified by:
getEager in interface Select

newJoins

public Joins newJoins()
Description copied from interface: Select
Return a new instance to use for joining.

Specified by:
newJoins in interface Select

newOuterJoins

public Joins newOuterJoins()
Description copied from interface: Select
Return a new instance to use for outer joining.

Specified by:
newOuterJoins in interface Select

append

public void append(SQLBuffer buf,
                   Joins joins)
Description copied from interface: Select
Append the given joins to the given buffer.

Specified by:
append in interface Select

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.

Specified by:
and in interface Select

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.

Specified by:
or in interface Select

outer

public Joins outer(Joins joins)
Description copied from interface: Select
Return a join set making the given joins outer joins.

Specified by:
outer in interface Select

toString

public String toString()
Description copied from interface: Select
Implement toString to generate SQL string for profiling/debuggging.

Specified by:
toString in interface Select
Overrides:
toString in class Object

getExpectedResultCount

public int getExpectedResultCount()
Description copied from interface: SelectExecutor
The expected result count for the query.

Specified by:
getExpectedResultCount in interface SelectExecutor

setExpectedResultCount

public void setExpectedResultCount(int expectedResultCount,
                                   boolean force)
Description copied from interface: SelectExecutor
The expected result count for the query.

Specified by:
setExpectedResultCount in interface SelectExecutor
force - if false, the count will be discarded if this select has any to-many eager joins that would throw off the result count


Copyright © 2006-2013 Apache Software Foundation. All Rights Reserved.