- 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
,FromItem
,Statement
public class PlainSelect extends Select
- See Also:
- Serialized Form
-
-
Nested Class Summary
Nested Classes Modifier and Type Class Description static class
PlainSelect.BigQuerySelectQualifier
-
Field Summary
-
Fields inherited from class net.sf.jsqlparser.statement.select.Select
alias, fetch, forClause, forMode, forUpdateTable, isolation, limit, limitBy, offset, oracleSiblings, orderByElements, pivot, unPivot, withItemsList
-
-
Constructor Summary
Constructors Constructor Description PlainSelect()
PlainSelect(java.util.Collection<Expression> selectExpressions, FromItem fromItem)
PlainSelect(java.util.Collection<Expression> selectExpressions, FromItem fromItem, java.util.Collection<Expression> orderByExpressions)
PlainSelect(java.util.Collection<Expression> selectExpressions, FromItem fromItem, Expression whereExpressions)
PlainSelect(java.util.Collection<Expression> selectExpressions, FromItem fromItem, Expression whereExpressions, java.util.Collection<Expression> orderByExpressions)
PlainSelect(FromItem fromItem)
PlainSelect(FromItem fromItem, java.util.Collection<Expression> orderByExpressions)
PlainSelect(FromItem fromItem, Expression whereExpressions)
PlainSelect(FromItem fromItem, Expression whereExpressions, java.util.Collection<Expression> orderByExpressions)
-
Method Summary
-
Methods inherited from class net.sf.jsqlparser.statement.select.Select
accept, accept, addOrderByElements, addOrderByElements, addOrderByElements, addOrderByExpressions, addWithItemsList, addWithItemsList, appendStringListTo, appendTo, as, getAlias, getFetch, getForClause, getFormattedList, getFormattedList, getForMode, getForUpdateTable, getIsolation, getLimit, getLimitBy, getOffset, getOrderByElements, getPivot, getPlainSelect, getSelectBody, getSetOperationList, getStringList, getStringList, getUnPivot, getValues, getWait, getWithItemsList, isNoWait, isOracleSiblings, isSkipLocked, orderByToString, orderByToString, setAlias, setFetch, setForClause, setForMode, setForUpdateTable, setIsolation, setLimit, setLimitBy, setNoWait, setOffset, setOracleSiblings, setOrderByElements, setPivot, setSkipLocked, setUnPivot, setWait, setWithItemsList, withAlias, withFetch, withForMode, withForUpdateTable, withIsolation, withLimit, withLimitBy, withOffset, withOrderByElements, withSkipLocked, withWait, withWithItemsList
-
Methods inherited from class net.sf.jsqlparser.parser.ASTNodeAccessImpl
getASTNode, getParent, getParent, 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
-
Methods inherited from interface net.sf.jsqlparser.expression.Expression
accept
-
-
-
-
Field Detail
-
distinct
private Distinct distinct
-
bigQuerySelectQualifier
private PlainSelect.BigQuerySelectQualifier bigQuerySelectQualifier
-
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
-
preferringClause
private PreferringClause preferringClause
-
oracleHint
private OracleHint oracleHint
-
mySqlSqlCalcFoundRows
private boolean mySqlSqlCalcFoundRows
-
mySqlCacheFlag
private MySqlSqlCacheFlags mySqlCacheFlag
-
forXmlPath
private java.lang.String forXmlPath
-
ksqlWindow
private KSQLWindow ksqlWindow
-
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
-
-
Constructor Detail
-
PlainSelect
public PlainSelect()
-
PlainSelect
public PlainSelect(FromItem fromItem)
-
PlainSelect
public PlainSelect(FromItem fromItem, Expression whereExpressions)
-
PlainSelect
public PlainSelect(FromItem fromItem, java.util.Collection<Expression> orderByExpressions)
-
PlainSelect
public PlainSelect(FromItem fromItem, Expression whereExpressions, java.util.Collection<Expression> orderByExpressions)
-
PlainSelect
public PlainSelect(java.util.Collection<Expression> selectExpressions, FromItem fromItem)
-
PlainSelect
public PlainSelect(java.util.Collection<Expression> selectExpressions, FromItem fromItem, Expression whereExpressions)
-
PlainSelect
public PlainSelect(java.util.Collection<Expression> selectExpressions, FromItem fromItem, java.util.Collection<Expression> orderByExpressions)
-
PlainSelect
public PlainSelect(java.util.Collection<Expression> selectExpressions, FromItem fromItem, Expression whereExpressions, java.util.Collection<Expression> orderByExpressions)
-
-
Method Detail
-
isUseBrackets
@Deprecated public boolean isUseBrackets()
Deprecated.
-
getFromItem
public FromItem getFromItem()
-
setFromItem
public void setFromItem(FromItem item)
-
getIntoTables
public java.util.List<Table> getIntoTables()
-
setIntoTables
public void setIntoTables(java.util.List<Table> intoTables)
-
getSelectItems
public java.util.List<SelectItem<?>> getSelectItems()
-
setSelectItems
public void setSelectItems(java.util.List<SelectItem<?>> list)
-
getSelectItem
public SelectItem<?> getSelectItem(int index)
-
getWhere
public Expression getWhere()
-
setWhere
public void setWhere(Expression where)
-
withFromItem
public PlainSelect withFromItem(FromItem item)
-
withSelectItems
public PlainSelect withSelectItems(java.util.List<SelectItem<?>> list)
-
withSelectItems
public PlainSelect withSelectItems(SelectItem<?>... selectItems)
-
addSelectItems
public PlainSelect addSelectItems(SelectItem<?>... items)
-
addSelectExpressions
public PlainSelect addSelectExpressions(java.util.Collection<Expression> expressions)
-
addSelectItems
public PlainSelect addSelectItems(Expression... expressions)
-
addSelectItem
public PlainSelect addSelectItem(Expression expression, Alias alias)
-
addSelectItem
public PlainSelect addSelectItem(Expression expression)
-
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)
-
setJoins
public void setJoins(java.util.List<Join> list)
-
getJoin
public Join getJoin(int index)
-
addJoins
public PlainSelect addJoins(Join... joins)
-
withJoins
public PlainSelect withJoins(java.util.List<Join> joins)
-
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 <T,S> T accept(SelectVisitor<T> selectVisitor, S context)
-
accept
public <T,S> T accept(FromItemVisitor<T> fromItemVisitor, S context)
-
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)
-
getBigQuerySelectQualifier
public PlainSelect.BigQuerySelectQualifier getBigQuerySelectQualifier()
-
setBigQuerySelectQualifier
public PlainSelect setBigQuerySelectQualifier(PlainSelect.BigQuerySelectQualifier bigQuerySelectQualifier)
-
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)
-
getPreferringClause
public PreferringClause getPreferringClause()
-
setPreferringClause
public void setPreferringClause(PreferringClause preferringClause)
-
getOracleHint
public OracleHint getOracleHint()
-
setOracleHint
public void setOracleHint(OracleHint oracleHint)
-
getForXmlPath
public java.lang.String getForXmlPath()
-
setForXmlPath
public void setForXmlPath(java.lang.String forXmlPath)
-
getKsqlWindow
public KSQLWindow getKsqlWindow()
-
setKsqlWindow
public void setKsqlWindow(KSQLWindow ksqlWindow)
-
isEmitChanges
public boolean isEmitChanges()
-
setEmitChanges
public void setEmitChanges(boolean emitChanges)
-
getWindowDefinitions
public java.util.List<WindowDefinition> getWindowDefinitions()
-
setWindowDefinitions
public void setWindowDefinitions(java.util.List<WindowDefinition> windowDefinitions)
-
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)
-
getMySqlSqlCalcFoundRows
public boolean getMySqlSqlCalcFoundRows()
-
setMySqlSqlCalcFoundRows
public void setMySqlSqlCalcFoundRows(boolean mySqlCalcFoundRows)
-
getMySqlSqlCacheFlag
public MySqlSqlCacheFlags getMySqlSqlCacheFlag()
-
setMySqlSqlCacheFlag
public void setMySqlSqlCacheFlag(MySqlSqlCacheFlags sqlCacheFlag)
-
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)
-
withPreferringClause
public PlainSelect withPreferringClause(PreferringClause preferringClause)
-
withOracleHint
public PlainSelect withOracleHint(OracleHint oracleHint)
-
withOracleSiblings
public PlainSelect withOracleSiblings(boolean oracleSiblings)
- Overrides:
withOracleSiblings
in classSelect
-
withForXmlPath
public PlainSelect withForXmlPath(java.lang.String forXmlPath)
-
withKsqlWindow
public PlainSelect withKsqlWindow(KSQLWindow ksqlWindow)
-
withNoWait
public PlainSelect withNoWait(boolean noWait)
-
withHaving
public PlainSelect withHaving(Expression having)
-
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)
-
-