Class PlainSelect
- java.lang.Object
-
- net.sf.jsqlparser.parser.ASTNodeAccessImpl
-
- net.sf.jsqlparser.statement.select.Select
-
- net.sf.jsqlparser.statement.select.PlainSelect
-
- All Implemented Interfaces:
java.io.Serializable
,Expression
,Model
,ASTNodeAccess
,Statement
public class PlainSelect extends Select
- See Also:
- Serialized Form
-
-
Field Summary
-
Fields inherited from class net.sf.jsqlparser.statement.select.Select
fetch, forClause, isolation, limit, limitBy, offset, oracleSiblings, orderByElements, withItemsList
-
-
Constructor Summary
Constructors Constructor Description PlainSelect()
-
Method Summary
-
Methods inherited from class net.sf.jsqlparser.statement.select.Select
accept, accept, addOrderByElements, addOrderByElements, addWithItemsList, addWithItemsList, appendStringListTo, appendTo, as, getFetch, getForClause, getFormattedList, getFormattedList, getIsolation, getLimit, getLimitBy, getOffset, getOrderByElements, getPlainSelect, getSelectBody, getSetOperationList, getStringList, getStringList, getValues, getWithItemsList, isOracleSiblings, orderByToString, orderByToString, setFetch, setForClause, setIsolation, setLimit, setLimitBy, setOffset, setOracleSiblings, setOrderByElements, setWithItemsList, withFetch, withIsolation, withLimit, withLimitBy, withOffset, withOrderByElements, withWithItemsList
-
Methods inherited from class net.sf.jsqlparser.parser.ASTNodeAccessImpl
getASTNode, setASTNode
-
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
-
Methods inherited from interface net.sf.jsqlparser.parser.ASTNodeAccess
getASTNode, setASTNode
-
-
-
-
Field Detail
-
distinct
private Distinct distinct
-
selectItems
private java.util.List<SelectItem<?>> selectItems
-
intoTables
private java.util.List<Table> intoTables
-
fromItem
private FromItem fromItem
-
lateralViews
private java.util.List<LateralView> lateralViews
-
joins
private java.util.List<Join> joins
-
where
private Expression where
-
groupBy
private GroupByElement groupBy
-
having
private Expression having
-
qualify
private Expression qualify
-
optimizeFor
private OptimizeFor optimizeFor
-
skip
private Skip skip
-
mySqlHintStraightJoin
private boolean mySqlHintStraightJoin
-
first
private First first
-
top
private Top top
-
oracleHierarchical
private OracleHierarchicalExpression oracleHierarchical
-
oracleHint
private OracleHint oracleHint
-
forMode
private ForMode forMode
-
forUpdateTable
private Table forUpdateTable
-
skipLocked
private boolean skipLocked
-
wait
private Wait wait
-
mySqlSqlCalcFoundRows
private boolean mySqlSqlCalcFoundRows
-
mySqlCacheFlag
private MySqlSqlCacheFlags mySqlCacheFlag
-
forXmlPath
private java.lang.String forXmlPath
-
ksqlWindow
private KSQLWindow ksqlWindow
-
noWait
private boolean noWait
-
emitChanges
private boolean emitChanges
-
windowDefinitions
private java.util.List<WindowDefinition> windowDefinitions
-
isUsingFinal
private boolean isUsingFinal
- See Also:
- Clickhouse FINAL
-
isUsingOnly
private boolean isUsingOnly
-
useWithNoLog
private boolean useWithNoLog
-
intoTempTable
private Table intoTempTable
-
-
Method Detail
-
isUseBrackets
@Deprecated public boolean isUseBrackets()
Deprecated.
-
getFromItem
public FromItem getFromItem()
-
getIntoTables
public java.util.List<Table> getIntoTables()
-
getSelectItems
public java.util.List<SelectItem<?>> getSelectItems()
-
getSelectItem
public SelectItem<?> getSelectItem(int index)
-
getWhere
public Expression getWhere()
-
withFromItem
public PlainSelect withFromItem(FromItem item)
-
setFromItem
public void setFromItem(FromItem item)
-
setIntoTables
public void setIntoTables(java.util.List<Table> intoTables)
-
withSelectItems
public PlainSelect withSelectItems(java.util.List<SelectItem<?>> list)
-
setSelectItems
public void setSelectItems(java.util.List<SelectItem<?>> list)
-
addSelectItems
public PlainSelect addSelectItems(SelectItem<?>... items)
-
addSelectItems
public PlainSelect addSelectItems(Expression... expressions)
-
addSelectItem
public PlainSelect addSelectItem(Expression expression, Alias alias)
-
addSelectItem
public PlainSelect addSelectItem(Expression expression)
-
setWhere
public void setWhere(Expression where)
-
getLateralViews
public java.util.List<LateralView> getLateralViews()
-
setLateralViews
public void setLateralViews(java.util.Collection<LateralView> lateralViews)
-
addLateralView
public PlainSelect addLateralView(LateralView lateralView)
-
withLateralViews
public PlainSelect withLateralViews(java.util.Collection<LateralView> lateralViews)
-
getJoin
public Join getJoin(int index)
-
addJoins
public PlainSelect addJoins(Join... joins)
-
withJoins
public PlainSelect withJoins(java.util.List<Join> joins)
-
setJoins
public void setJoins(java.util.List<Join> list)
-
isUsingFinal
public boolean isUsingFinal()
-
setUsingFinal
public void setUsingFinal(boolean usingFinal)
-
withUsingFinal
public PlainSelect withUsingFinal(boolean usingFinal)
-
isUsingOnly
public boolean isUsingOnly()
-
setUsingOnly
public void setUsingOnly(boolean usingOnly)
-
withUsingOnly
public PlainSelect withUsingOnly(boolean usingOnly)
-
isUseWithNoLog
public boolean isUseWithNoLog()
-
setUseWithNoLog
public void setUseWithNoLog(boolean useWithNoLog)
-
withUseWithNoLog
public PlainSelect withUseWithNoLog(boolean useWithNoLog)
-
getIntoTempTable
public Table getIntoTempTable()
-
setIntoTempTable
public void setIntoTempTable(Table intoTempTable)
-
withIntoTempTable
public PlainSelect withIntoTempTable(Table intoTempTable)
-
accept
public void accept(SelectVisitor selectVisitor)
-
getOptimizeFor
public OptimizeFor getOptimizeFor()
-
setOptimizeFor
public void setOptimizeFor(OptimizeFor optimizeFor)
-
getTop
public Top getTop()
-
setTop
public void setTop(Top top)
-
getSkip
public Skip getSkip()
-
setSkip
public void setSkip(Skip skip)
-
getMySqlHintStraightJoin
public boolean getMySqlHintStraightJoin()
-
setMySqlHintStraightJoin
public void setMySqlHintStraightJoin(boolean mySqlHintStraightJoin)
-
getFirst
public First getFirst()
-
setFirst
public void setFirst(First first)
-
getDistinct
public Distinct getDistinct()
-
setDistinct
public void setDistinct(Distinct distinct)
-
getHaving
public Expression getHaving()
-
setHaving
public void setHaving(Expression expression)
-
getQualify
public Expression getQualify()
-
setQualify
public PlainSelect setQualify(Expression qualify)
-
getGroupBy
public GroupByElement getGroupBy()
A list ofExpression
s of the GROUP BY clause. It is null in case there is no GROUP BY clause- Returns:
- a list of
Expression
s
-
setGroupByElement
public void setGroupByElement(GroupByElement groupBy)
-
addGroupByColumnReference
public PlainSelect addGroupByColumnReference(Expression expr)
-
getOracleHierarchical
public OracleHierarchicalExpression getOracleHierarchical()
-
setOracleHierarchical
public void setOracleHierarchical(OracleHierarchicalExpression oracleHierarchical)
-
getForMode
public ForMode getForMode()
-
setForMode
public void setForMode(ForMode forMode)
-
getForUpdateTable
public Table getForUpdateTable()
-
setForUpdateTable
public void setForUpdateTable(Table forUpdateTable)
-
getOracleHint
public OracleHint getOracleHint()
-
setOracleHint
public void setOracleHint(OracleHint oracleHint)
-
setWait
public void setWait(Wait wait)
Sets theWait
for this SELECT- Parameters:
wait
- theWait
for this SELECT
-
getWait
public Wait getWait()
Returns the value of theWait
set for this SELECT- Returns:
- the value of the
Wait
set for this SELECT
-
getForXmlPath
public java.lang.String getForXmlPath()
-
setForXmlPath
public void setForXmlPath(java.lang.String forXmlPath)
-
getKsqlWindow
public KSQLWindow getKsqlWindow()
-
setKsqlWindow
public void setKsqlWindow(KSQLWindow ksqlWindow)
-
setEmitChanges
public void setEmitChanges(boolean emitChanges)
-
isEmitChanges
public boolean isEmitChanges()
-
getWindowDefinitions
public java.util.List<WindowDefinition> getWindowDefinitions()
-
setWindowDefinitions
public void setWindowDefinitions(java.util.List<WindowDefinition> windowDefinitions)
-
isSkipLocked
public boolean isSkipLocked()
-
setSkipLocked
public void setSkipLocked(boolean skipLocked)
-
appendSelectBodyTo
public java.lang.StringBuilder appendSelectBodyTo(java.lang.StringBuilder builder)
- Specified by:
appendSelectBodyTo
in classSelect
-
withMySqlSqlCalcFoundRows
public PlainSelect withMySqlSqlCalcFoundRows(boolean mySqlCalcFoundRows)
-
withMySqlSqlNoCache
public PlainSelect withMySqlSqlNoCache(MySqlSqlCacheFlags mySqlCacheFlag)
-
setMySqlSqlCalcFoundRows
public void setMySqlSqlCalcFoundRows(boolean mySqlCalcFoundRows)
-
setMySqlSqlCacheFlag
public void setMySqlSqlCacheFlag(MySqlSqlCacheFlags sqlCacheFlag)
-
getMySqlSqlCalcFoundRows
public boolean getMySqlSqlCalcFoundRows()
-
getMySqlSqlCacheFlag
public MySqlSqlCacheFlags getMySqlSqlCacheFlag()
-
setNoWait
public void setNoWait(boolean noWait)
-
isNoWait
public boolean isNoWait()
-
withDistinct
public PlainSelect withDistinct(Distinct distinct)
-
withIntoTables
public PlainSelect withIntoTables(java.util.List<Table> intoTables)
-
withWhere
public PlainSelect withWhere(Expression where)
-
withOptimizeFor
public PlainSelect withOptimizeFor(OptimizeFor optimizeFor)
-
withSkip
public PlainSelect withSkip(Skip skip)
-
withMySqlHintStraightJoin
public PlainSelect withMySqlHintStraightJoin(boolean mySqlHintStraightJoin)
-
withFirst
public PlainSelect withFirst(First first)
-
withTop
public PlainSelect withTop(Top top)
-
withOracleHierarchical
public PlainSelect withOracleHierarchical(OracleHierarchicalExpression oracleHierarchical)
-
withOracleHint
public PlainSelect withOracleHint(OracleHint oracleHint)
-
withOracleSiblings
public PlainSelect withOracleSiblings(boolean oracleSiblings)
- Overrides:
withOracleSiblings
in classSelect
-
withForMode
public PlainSelect withForMode(ForMode forMode)
-
withForUpdateTable
public PlainSelect withForUpdateTable(Table forUpdateTable)
-
withForXmlPath
public PlainSelect withForXmlPath(java.lang.String forXmlPath)
-
withKsqlWindow
public PlainSelect withKsqlWindow(KSQLWindow ksqlWindow)
-
withNoWait
public PlainSelect withNoWait(boolean noWait)
-
withSkipLocked
public PlainSelect withSkipLocked(boolean skipLocked)
-
withHaving
public PlainSelect withHaving(Expression having)
-
withWait
public PlainSelect withWait(Wait wait)
-
addSelectItems
public PlainSelect addSelectItems(java.util.Collection<? extends SelectItem<?>> selectItems)
-
addIntoTables
public PlainSelect addIntoTables(Table... intoTables)
-
addIntoTables
public PlainSelect addIntoTables(java.util.Collection<? extends Table> intoTables)
-
addJoins
public PlainSelect addJoins(java.util.Collection<? extends Join> joins)
-
getFromItem
public <E extends FromItem> E getFromItem(java.lang.Class<E> type)
-
getWhere
public <E extends Expression> E getWhere(java.lang.Class<E> type)
-
getHaving
public <E extends Expression> E getHaving(java.lang.Class<E> type)
-
-