Class PlainSelect

    • Constructor Detail

      • PlainSelect

        public PlainSelect()
      • PlainSelect

        public PlainSelect​(FromItem fromItem)
      • 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,
                           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)
      • setWhere

        public void setWhere​(Expression where)
      • addSelectExpressions

        public PlainSelect addSelectExpressions​(java.util.Collection<Expression> expressions)
      • 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
      • setJoins

        public void setJoins​(java.util.List<Join> list)
      • getJoin

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

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

        public PlainSelect withMySqlSqlCalcFoundRows​(boolean mySqlCalcFoundRows)
      • getMySqlSqlCalcFoundRows

        public boolean getMySqlSqlCalcFoundRows()
      • setMySqlSqlCalcFoundRows

        public void setMySqlSqlCalcFoundRows​(boolean mySqlCalcFoundRows)
      • setMySqlSqlCacheFlag

        public void setMySqlSqlCacheFlag​(MySqlSqlCacheFlags sqlCacheFlag)
      • withIntoTables

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

        public PlainSelect withMySqlHintStraightJoin​(boolean mySqlHintStraightJoin)
      • withForXmlPath

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

        public PlainSelect withNoWait​(boolean noWait)
      • 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)