Class PlainSelect

    • Field Detail

      • selectItems

        private java.util.List<SelectItem<?>> selectItems
      • intoTables

        private java.util.List<Table> intoTables
      • lateralViews

        private java.util.List<LateralView> lateralViews
      • joins

        private java.util.List<Join> joins
      • skip

        private Skip skip
      • mySqlHintStraightJoin

        private boolean mySqlHintStraightJoin
      • first

        private First first
      • top

        private Top top
      • forUpdateTable

        private Table forUpdateTable
      • skipLocked

        private boolean skipLocked
      • wait

        private Wait wait
      • mySqlSqlCalcFoundRows

        private boolean mySqlSqlCalcFoundRows
      • forXmlPath

        private java.lang.String forXmlPath
      • noWait

        private boolean noWait
      • emitChanges

        private boolean emitChanges
      • isUsingOnly

        private boolean isUsingOnly
      • useWithNoLog

        private boolean useWithNoLog
      • intoTempTable

        private Table intoTempTable
    • Constructor Detail

      • PlainSelect

        public PlainSelect()
    • 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)
      • setFromItem

        public void setFromItem​(FromItem item)
      • setIntoTables

        public void setIntoTables​(java.util.List<Table> intoTables)
      • setSelectItems

        public void setSelectItems​(java.util.List<SelectItem<?>> list)
      • setWhere

        public void setWhere​(Expression where)
      • getLateralViews

        public java.util.List<LateralView> getLateralViews()
      • setLateralViews

        public void setLateralViews​(java.util.Collection<LateralView> lateralViews)
      • getJoins

        public java.util.List<Join> getJoins()
        The list of Joins
        Returns:
        the list of Joins
      • getJoin

        public Join getJoin​(int index)
      • 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)
      • 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)
      • setHaving

        public void setHaving​(Expression expression)
      • getGroupBy

        public GroupByElement getGroupBy()
        A list of Expressions of the GROUP BY clause. It is null in case there is no GROUP BY clause
        Returns:
        a list of Expressions
      • setGroupByElement

        public void setGroupByElement​(GroupByElement groupBy)
      • 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 the Wait for this SELECT
        Parameters:
        wait - the Wait for this SELECT
      • getWait

        public Wait getWait()
        Returns the value of the Wait 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 class Select
      • toString

        public java.lang.String toString()
        Overrides:
        toString in class Select
      • withMySqlSqlCalcFoundRows

        public PlainSelect withMySqlSqlCalcFoundRows​(boolean mySqlCalcFoundRows)
      • setMySqlSqlCalcFoundRows

        public void setMySqlSqlCalcFoundRows​(boolean mySqlCalcFoundRows)
      • setMySqlSqlCacheFlag

        public void setMySqlSqlCacheFlag​(MySqlSqlCacheFlags sqlCacheFlag)
      • getMySqlSqlCalcFoundRows

        public boolean getMySqlSqlCalcFoundRows()
      • setNoWait

        public void setNoWait​(boolean noWait)
      • isNoWait

        public boolean isNoWait()
      • withIntoTables

        public PlainSelect withIntoTables​(java.util.List<Table> intoTables)
      • withMySqlHintStraightJoin

        public PlainSelect withMySqlHintStraightJoin​(boolean mySqlHintStraightJoin)
      • withForUpdateTable

        public PlainSelect withForUpdateTable​(Table forUpdateTable)
      • withForXmlPath

        public PlainSelect withForXmlPath​(java.lang.String forXmlPath)
      • withNoWait

        public PlainSelect withNoWait​(boolean noWait)
      • withSkipLocked

        public PlainSelect withSkipLocked​(boolean skipLocked)
      • addSelectItems

        public PlainSelect addSelectItems​(java.util.Collection<? extends SelectItem<?>> selectItems)
      • 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)