public class Select extends Query
distinct, limitExpr, offsetExpr, randomAccessResult, sampleSize
create, parameters, prepareAlways, session, sqlStatement
Modifier and Type | Method and Description |
---|---|
void |
addCondition(Expression cond)
Add a condition to the list of conditions.
|
void |
addGlobalCondition(Parameter param,
int columnId,
int comparisonType)
Add a condition to the query.
|
void |
addTableFilter(TableFilter filter,
boolean isTop)
Add a table to the query.
|
void |
fireBeforeSelectTriggers()
Call the before triggers on all tables.
|
int |
getColumnCount()
Get the column count of this query.
|
double |
getCost()
Calculate the cost to execute this query.
|
HashMap<Expression,Object> |
getCurrentGroup() |
int |
getCurrentGroupRowId() |
ArrayList<Expression> |
getExpressions()
The the list of select expressions.
|
String |
getPlanSQL()
Get the SQL statement with the execution plan.
|
HashSet<Table> |
getTables()
Get all tables that are involved in this query.
|
ArrayList<TableFilter> |
getTopFilters() |
TableFilter |
getTopTableFilter() |
int |
getType()
Get the command type as defined in CommandInterface
|
void |
init()
Initialize the query.
|
boolean |
isCacheable() |
boolean |
isEverything(ExpressionVisitor visitor)
Check if this expression and all sub-expressions can fulfill a criteria.
|
boolean |
isQuickAggregateQuery()
Check if this is an aggregate query with direct lookup, for example a
query of the type SELECT COUNT(*) FROM TEST or
SELECT MAX(ID) FROM TEST.
|
boolean |
isReadOnly()
Check if this command is read only.
|
void |
mapColumns(ColumnResolver resolver,
int level)
Map the columns to the given column resolver.
|
void |
prepare()
Prepare this statement.
|
ResultInterface |
queryMeta()
Get an empty result set containing the meta data.
|
protected LocalResult |
queryWithoutCache(int maxRows,
ResultTarget target)
Execute the query without checking the cache.
|
void |
setEvaluatable(TableFilter tableFilter,
boolean b)
Change the evaluatable flag.
|
void |
setExpressions(ArrayList<Expression> expressions) |
void |
setForUpdate(boolean b)
Set the 'for update' flag.
|
void |
setGroupBy(ArrayList<Expression> group) |
void |
setGroupQuery()
Called if this query contains aggregate functions.
|
void |
setHaving(Expression having) |
void |
setOrder(ArrayList<SelectOrderBy> order)
Set the order by list.
|
void |
updateAggregate(Session s)
Update all aggregate function values.
|
disableCache, getCostAsExpression, getMaxDataModificationId, getParameterValues, isQuery, isTransactional, prepareOrder, query, setDistinct, setLimit, setOffset, setRandomAccessResult, setSampleSize
checkCanceled, checkParameters, getCurrentObjectId, getCurrentRowNumber, getObjectId, getParameters, getSQL, getSQL, getSQL, needRecompile, setCommand, setCurrentRowNumber, setObjectId, setParameterList, setPrepareAlways, setRow, setSession, setSQL, toString, update
public Select(Session session)
public void addTableFilter(TableFilter filter, boolean isTop)
filter
- the table to addisTop
- if the table can be the first table in the query planpublic ArrayList<TableFilter> getTopFilters()
public void setExpressions(ArrayList<Expression> expressions)
public void setGroupQuery()
public void setGroupBy(ArrayList<Expression> group)
public HashMap<Expression,Object> getCurrentGroup()
public int getCurrentGroupRowId()
public void setOrder(ArrayList<SelectOrderBy> order)
Query
public void addCondition(Expression cond)
cond
- the condition to addpublic ResultInterface queryMeta()
Prepared
protected LocalResult queryWithoutCache(int maxRows, ResultTarget target)
Query
queryWithoutCache
in class Query
maxRows
- the limit as specified in the JDBC method calltarget
- the target to write results topublic void init()
Query
public void prepare()
Prepared
public double getCost()
Query
public HashSet<Table> getTables()
Query
public void fireBeforeSelectTriggers()
Query
fireBeforeSelectTriggers
in class Query
public String getPlanSQL()
Prepared
getPlanSQL
in class Prepared
public void setHaving(Expression having)
public int getColumnCount()
Query
getColumnCount
in class Query
public TableFilter getTopTableFilter()
public ArrayList<Expression> getExpressions()
Query
getExpressions
in class Query
public void setForUpdate(boolean b)
Query
setForUpdate
in class Query
b
- the new settingpublic void mapColumns(ColumnResolver resolver, int level)
Query
mapColumns
in class Query
resolver
- the resolverlevel
- the subquery level (0 is the top level query, 1 is the first
subquery level)public void setEvaluatable(TableFilter tableFilter, boolean b)
Query
setEvaluatable
in class Query
tableFilter
- the table filterb
- the new valuepublic boolean isQuickAggregateQuery()
public void addGlobalCondition(Parameter param, int columnId, int comparisonType)
Query
addGlobalCondition
in class Query
param
- the parametercolumnId
- the column index (0 meaning the first column)comparisonType
- the comparison typepublic void updateAggregate(Session s)
Query
updateAggregate
in class Query
s
- the sessionpublic boolean isEverything(ExpressionVisitor visitor)
Query
isEverything
in class Query
visitor
- the visitorpublic boolean isReadOnly()
Prepared
isReadOnly
in class Prepared
public boolean isCacheable()
isCacheable
in class Prepared
Copyright © 2012 JBoss by Red Hat. All Rights Reserved.