Class Select

    • Constructor Detail

      • Select

        public Select()
    • Method Detail

      • orderByToString

        public static java.lang.String orderByToString​(java.util.List<OrderByElement> orderByElements)
      • orderByToString

        public static java.lang.String orderByToString​(boolean oracleSiblings,
                                                       java.util.List<OrderByElement> orderByElements)
      • getFormattedList

        public static java.lang.String getFormattedList​(java.util.List<?> list,
                                                        java.lang.String expression)
      • getFormattedList

        public static java.lang.String getFormattedList​(java.util.List<?> list,
                                                        java.lang.String expression,
                                                        boolean useComma,
                                                        boolean useBrackets)
      • getStringList

        public static java.lang.String getStringList​(java.util.List<?> list)
        List the toString out put of the objects in the List comma separated. If the List is null or empty an empty string is returned.

        The same as getStringList(list, true, false)

        Parameters:
        list - list of objects with toString methods
        Returns:
        comma separated list of the elements in the list
        See Also:
        getStringList(List, boolean, boolean)
      • getStringList

        public static java.lang.String getStringList​(java.util.List<?> list,
                                                     boolean useComma,
                                                     boolean useBrackets)
        List the toString out put of the objects in the List that can be comma separated. If the List is null or empty an empty string is returned.
        Parameters:
        list - list of objects with toString methods
        useComma - true if the list has to be comma separated
        useBrackets - true if the list has to be enclosed in brackets
        Returns:
        comma separated list of the elements in the list
      • appendStringListTo

        public static java.lang.StringBuilder appendStringListTo​(java.lang.StringBuilder builder,
                                                                 java.util.List<?> list,
                                                                 boolean useComma,
                                                                 boolean useBrackets)
        Append the toString out put of the objects in the List (that can be comma separated). If the List is null or empty an empty string is returned.
        Parameters:
        list - list of objects with toString methods
        useComma - true if the list has to be comma separated
        useBrackets - true if the list has to be enclosed in brackets
        Returns:
        comma separated list of the elements in the list
      • getWithItemsList

        public java.util.List<WithItem> getWithItemsList()
      • setWithItemsList

        public void setWithItemsList​(java.util.List<WithItem> withItemsList)
      • withWithItemsList

        public Select withWithItemsList​(java.util.List<WithItem> withItemsList)
      • addWithItemsList

        public Select addWithItemsList​(java.util.Collection<? extends WithItem> withItemsList)
      • addWithItemsList

        public Select addWithItemsList​(WithItem... withItemsList)
      • isOracleSiblings

        public boolean isOracleSiblings()
      • setOracleSiblings

        public void setOracleSiblings​(boolean oracleSiblings)
      • isNoWait

        public boolean isNoWait()
      • setNoWait

        public void setNoWait​(boolean noWait)
      • withOracleSiblings

        public Select withOracleSiblings​(boolean oracleSiblings)
      • getForClause

        public ForClause getForClause()
      • getOrderByElements

        public java.util.List<OrderByElement> getOrderByElements()
      • setOrderByElements

        public void setOrderByElements​(java.util.List<OrderByElement> orderByElements)
      • withOrderByElements

        public Select withOrderByElements​(java.util.List<OrderByElement> orderByElements)
      • addOrderByElements

        public Select addOrderByElements​(java.util.Collection<? extends OrderByElement> orderByElements)
      • addOrderByExpressions

        public Select addOrderByExpressions​(java.util.Collection<Expression> orderByExpressions)
      • addOrderByElements

        public Select addOrderByElements​(Expression... orderByExpressions)
      • getLimit

        public Limit getLimit()
      • setLimit

        public void setLimit​(Limit limit)
      • getLimitBy

        public Limit getLimitBy()
      • setLimitBy

        public void setLimitBy​(Limit limitBy)
      • withLimitBy

        public <E extends Select> E withLimitBy​(java.lang.Class<E> type,
                                                Limit limitBy)
      • getOffset

        public Offset getOffset()
      • setOffset

        public void setOffset​(Offset offset)
      • getFetch

        public Fetch getFetch()
      • setFetch

        public void setFetch​(Fetch fetch)
      • setIsolation

        public void setIsolation​(WithIsolation isolation)
      • getForMode

        public ForMode getForMode()
      • setForMode

        public void setForMode​(ForMode forMode)
      • getForUpdateTable

        public Table getForUpdateTable()
      • setForUpdateTable

        public void setForUpdateTable​(Table forUpdateTable)
      • getWait

        public Wait getWait()
        Returns the value of the Wait set for this SELECT
        Returns:
        the value of the Wait set for this SELECT
      • setWait

        public void setWait​(Wait wait)
        Sets the Wait for this SELECT
        Parameters:
        wait - the Wait for this SELECT
      • isSkipLocked

        public boolean isSkipLocked()
      • setSkipLocked

        public void setSkipLocked​(boolean skipLocked)
      • appendSelectBodyTo

        public abstract java.lang.StringBuilder appendSelectBodyTo​(java.lang.StringBuilder builder)
      • appendTo

        public java.lang.StringBuilder appendTo​(java.lang.StringBuilder builder)
        Overrides:
        appendTo in class ASTNodeAccessImpl
      • toString

        public java.lang.String toString()
        Overrides:
        toString in class java.lang.Object
      • accept

        public abstract <T,​S> T accept​(SelectVisitor<T> selectVisitor,
                                             S context)
      • getSelectBody

        @Deprecated
        public Select getSelectBody()
        Deprecated.
      • getValues

        public Values getValues()
      • as

        public <E extends Select> E as​(java.lang.Class<E> type)
      • withForUpdateTable

        public Select withForUpdateTable​(Table forUpdateTable)
      • withSkipLocked

        public Select withSkipLocked​(boolean skipLocked)
      • withWait

        public Select withWait​(Wait wait)