API 4.8

    Base Package: net.sf.jsqlparser

    Base

    JSQLParserException

    extends: Exception

    JSQLParserException ()
    JSQLParserException (message, cause)
    String message
    Throwable cause
    JSQLParserException (message)
    String message
    JSQLParserException (cause)
    Throwable cause

    Model

    implements: Serializable provides: Expression, FromItem, Statement,


    A marker interface for jsqlparser-model-classes.
    The datastructure where the sql syntax is represented by a tree consists of Model’s

    expression

    AnalyticType

    [OVER, WITHIN_GROUP, WITHIN_GROUP_OVER, FILTER_ONLY]

    AnyType

    [ANY, SOME, ALL]

    DateTimeLiteralExpression.DateTime

    [DATE, TIME, TIMESTAMP, TIMESTAMPTZ]

    JsonAggregateOnNullType

    [NULL, ABSENT]

    JsonAggregateUniqueKeysType

    [WITH, WITHOUT]

    JsonFunctionType

    [OBJECT, ARRAY, POSTGRES_OBJECT, MYSQL_OBJECT]

    SpannerInterleaveIn.OnDelete

    [CASCADE, NO_ACTION]

    TrimFunction.TrimSpecification

    [LEADING, TRAILING, BOTH]

    WindowElement.Type

    [ROWS, RANGE]

    WindowOffset.Type

    [PRECEDING, FOLLOWING, CURRENT, EXPR]

    Alias

    extends: Object implements: Serializable

    Alias (name)
    String name
    Alias (name, useAs)
    String name
    boolean useAs
    getName () → String
    returns String
    setName (name)
    String name
    isUseAs () → boolean
    returns boolean
    setUseAs (useAs)
    boolean useAs
    getAliasColumns () → List
    returns List
    setAliasColumns (aliasColumns)
    List aliasColumns
    @Override
    toString () → String
    returns String
    withName (name) → Alias
    String name
    returns Alias
    withUseAs (useAs) → Alias
    boolean useAs
    returns Alias
    withAliasColumns (aliasColumns) → Alias
    List aliasColumns
    returns Alias
    addAliasColumns (aliasColumns) → Alias
    AliasColumn aliasColumns
    returns Alias
    addAliasColumns (aliasColumns) → Alias
    Collection aliasColumns
    returns Alias

    Alias.AliasColumn

    extends: Object implements: Serializable

    AliasColumn (name, colDataType)
    String name
    ColDataType colDataType
    AliasColumn (name)
    String name

    AllValue

    extends: ASTNodeAccessImpl implements: Expression

    AllValue ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String

    AnalyticExpression

    extends: ASTNodeAccessImpl implements: Expression

    Analytic function. The name of the function is variable but the parameters following the special analytic function path. e.g. row_number() over (order by test). Additional there can be an expression for an analytical aggregate like sum(col) or the “all collumns” wildcard like count(*).
    AnalyticExpression ()
    AnalyticExpression (function)
    Function function
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    getKeep () → KeepExpression
    setKeep (keep)
    getPartitionExpressionList () → ExpressionList
    setPartitionExpressionList (partitionExpressionList)
    ExpressionList partitionExpressionList
    setPartitionExpressionList (partitionExpressionList, brackets)
    ExpressionList partitionExpressionList
    boolean brackets
    isPartitionByBrackets () → boolean
    returns boolean
    getName () → String
    returns String
    setName (name)
    String name
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    getOffset () → Expression
    returns Expression
    setOffset (offset)
    Expression offset
    getDefaultValue () → Expression
    returns Expression
    setDefaultValue (defaultValue)
    Expression defaultValue
    getWindowElement () → WindowElement
    setWindowElement (windowElement)
    WindowElement windowElement
    getType () → AnalyticType
    returns AnalyticType
    setType (type)
    AnalyticType type
    isDistinct () → boolean
    returns boolean
    setDistinct (distinct)
    boolean distinct
    isUnique () → boolean
    returns boolean
    setUnique (unique)
    boolean unique
    isIgnoreNulls () → boolean
    returns boolean
    setIgnoreNulls (ignoreNulls)
    boolean ignoreNulls
    isIgnoreNullsOutside () → boolean
    returns boolean
    setIgnoreNullsOutside (ignoreNullsOutside)
    boolean ignoreNullsOutside
    getWindowName () → String
    returns String
    setWindowName (windowName)
    String windowName
    getWindowDefinition () → WindowDefinition
    setWindowDefinition (windowDef)
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    isAllColumns () → boolean
    returns boolean
    setAllColumns (allColumns)
    boolean allColumns
    getFilterExpression () → Expression
    returns Expression
    setFilterExpression (filterExpression)
    Expression filterExpression
    withName (name) → AnalyticExpression
    String name
    withExpression (expression) → AnalyticExpression
    Expression expression
    withOffset (offset) → AnalyticExpression
    withDefaultValue (defaultValue) → AnalyticExpression
    Expression defaultValue
    withAllColumns (allColumns) → AnalyticExpression
    boolean allColumns
    withKeep (keep) → AnalyticExpression
    withType (type) → AnalyticExpression
    AnalyticType type
    withDistinct (distinct) → AnalyticExpression
    boolean distinct
    withUnique (unique) → AnalyticExpression
    boolean unique
    withIgnoreNulls (ignoreNulls) → AnalyticExpression
    boolean ignoreNulls
    withFilterExpression (filterExpression) → AnalyticExpression
    Expression filterExpression
    withWindowElement (windowElement) → AnalyticExpression
    WindowElement windowElement
    getExpression (type) → E
    Class type
    returns E
    getOffset (type) → E
    Class type
    returns E
    getDefaultValue (type) → E
    Class type
    returns E
    getFilterExpression (type) → E
    Class type
    returns E
    getFuncOrderBy () → List
    returns List
    setFuncOrderBy (funcOrderBy)
    List funcOrderBy

    AnyComparisonExpression

    extends: ASTNodeAccessImpl implements: Expression

    Combines ANY and SOME expressions.
    AnyComparisonExpression (anyType, select)
    AnyType anyType
    Select select
    getSelect () → Select
    returns Select
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getAnyType () → AnyType
    returns AnyType
    @Override
    toString () → String
    returns String

    ArrayConstructor

    extends: ASTNodeAccessImpl implements: Expression

    ArrayConstructor (expressions, arrayKeyword)
    ExpressionList expressions
    boolean arrayKeyword
    getExpressions () → ExpressionList
    setExpressions (expressions)
    ExpressionList expressions
    isArrayKeyword () → boolean
    returns boolean
    setArrayKeyword (arrayKeyword)
    boolean arrayKeyword
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String

    ArrayExpression

    extends: ASTNodeAccessImpl implements: Expression

    ArrayExpression ()
    ArrayExpression (objExpression, indexExpression, startIndexExpression, stopIndexExpression)
    Expression objExpression
    Expression indexExpression
    Expression startIndexExpression
    Expression stopIndexExpression
    getObjExpression () → Expression
    returns Expression
    setObjExpression (objExpression)
    Expression objExpression
    getIndexExpression () → Expression
    returns Expression
    setIndexExpression (indexExpression)
    Expression indexExpression
    getStartIndexExpression () → Expression
    returns Expression
    setStartIndexExpression (startIndexExpression)
    Expression startIndexExpression
    getStopIndexExpression () → Expression
    returns Expression
    setStopIndexExpression (stopIndexExpression)
    Expression stopIndexExpression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withObjExpression (objExpression) → ArrayExpression
    Expression objExpression
    withIndexExpression (indexExpression) → ArrayExpression
    Expression indexExpression
    withRangeExpression (startIndexExpression, stopIndexExpression) → ArrayExpression
    Expression startIndexExpression
    Expression stopIndexExpression
    getObjExpression (type) → E
    Class type
    returns E
    getIndexExpression (type) → E
    Class type
    returns E

    BinaryExpression

    extends: ASTNodeAccessImpl implements: Expression provides: Addition, AndExpression, BitwiseAnd, BitwiseLeftShift, BitwiseOr, BitwiseRightShift, BitwiseXor, Concat, Division, IntegerDivision, IsDistinctExpression, JsonOperator, LikeExpression, Modulo, Multiplication, OldOracleJoinBinaryExpression, OrExpression, RegExpMatchOperator, SimilarToExpression, Subtraction, XorExpression

    A basic class for binary expressions, that is expressions having a left member and a right member which are in turn expressions.
    BinaryExpression ()
    getLeftExpression () → Expression
    returns Expression
    getRightExpression () → Expression
    returns Expression
    withLeftExpression (expression) → BinaryExpression
    Expression expression
    setLeftExpression (expression)
    Expression expression
    withRightExpression (expression) → BinaryExpression
    Expression expression
    setRightExpression (expression)
    Expression expression
    @Override
    toString () → String
    returns String
    getStringExpression () → String
    returns String
    getLeftExpression (type) → E
    Class type
    returns E
    getRightExpression (type) → E
    Class type
    returns E

    CaseExpression

    extends: ASTNodeAccessImpl implements: Expression

    CASE/WHEN expression. Syntax: `CASE WHEN condition THEN expression [WHEN condition THEN expression]... [ELSE expression] END`
    or

    `CASE expression WHEN condition THEN expression [WHEN condition THEN expression]... [ELSE expression] END`
    CaseExpression ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getSwitchExpression () → Expression
    returns Expression
    setSwitchExpression (switchExpression)
    Expression switchExpression
    getElseExpression () → Expression
    returns Expression | Returns the elseExpression.
    setElseExpression (elseExpression)
    Expression elseExpression | elseExpression The elseExpression to set.
    getWhenClauses () → List
    returns List | Returns the whenClauses.
    setWhenClauses (whenClauses)
    List whenClauses | whenClauses The whenClauses to set.
    @Override
    toString () → String
    returns String
    withSwitchExpression (switchExpression) → CaseExpression
    Expression switchExpression
    withWhenClauses (whenClauses) → CaseExpression
    List whenClauses
    withElseExpression (elseExpression) → CaseExpression
    Expression elseExpression
    addWhenClauses (whenClauses) → CaseExpression
    WhenClause whenClauses
    addWhenClauses (whenClauses) → CaseExpression
    Collection whenClauses
    getSwitchExpression (type) → E
    Class type
    returns E
    getElseExpression (type) → E
    Class type
    returns E
    isUsingBrackets () → boolean
    returns boolean | the usingBrackets
    setUsingBrackets (usingBrackets)
    boolean usingBrackets | usingBrackets the usingBrackets to set
    withUsingBrackets (usingBrackets) → CaseExpression
    boolean usingBrackets | usingBrackets the usingBrackets to set

    CastExpression

    extends: ASTNodeAccessImpl implements: Expression

    CastExpression (keyword)
    String keyword
    CastExpression ()
    getColDataType () → ColDataType
    returns ColDataType
    getColumnDefinitions () → ArrayList
    returns ArrayList
    setColDataType (colDataType)
    ColDataType colDataType
    addColumnDefinition (columnDefinition)
    ColumnDefinition columnDefinition
    getLeftExpression () → Expression
    returns Expression
    setLeftExpression (expression)
    Expression expression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    isUseCastKeyword () → boolean
    returns boolean
    setUseCastKeyword (useCastKeyword)
    boolean useCastKeyword
    @Override
    toString () → String
    returns String
    withType (type) → CastExpression
    withUseCastKeyword (useCastKeyword) → CastExpression
    boolean useCastKeyword
    withLeftExpression (leftExpression) → CastExpression
    Expression leftExpression
    getLeftExpression (type) → E
    Class type
    returns E

    CollateExpression

    extends: ASTNodeAccessImpl implements: Expression

    CollateExpression ()
    CollateExpression (leftExpression, collate)
    Expression leftExpression
    String collate
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getLeftExpression () → Expression
    returns Expression
    setLeftExpression (leftExpression)
    Expression leftExpression
    getCollate () → String
    returns String
    setCollate (collate)
    String collate
    @Override
    toString () → String
    returns String
    withLeftExpression (leftExpression) → CollateExpression
    Expression leftExpression
    withCollate (collate) → CollateExpression
    String collate
    getLeftExpression (type) → E
    Class type
    returns E

    ConnectByRootOperator

    extends: ASTNodeAccessImpl implements: Expression

    ConnectByRootOperator (column)
    Column column
    getColumn () → Column
    returns Column
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    DateTimeLiteralExpression

    extends: ASTNodeAccessImpl implements: Expression

    DateTimeLiteralExpression ()
    getValue () → String
    returns String
    setValue (value)
    String value
    getType () → DateTime
    returns DateTime
    setType (type)
    DateTime type
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withValue (value) → DateTimeLiteralExpression
    String value
    withType (type) → DateTimeLiteralExpression
    DateTime type

    DateValue

    extends: ASTNodeAccessImpl implements: Expression

    A Date in the form {d ‘yyyy-mm-dd’}
    DateValue ()
    DateValue (value)
    Date value
    DateValue (value)
    A Date in the form {d ‘yyyy-mm-dd’}
    String value | value The text presentation of the Date to be parsed.
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getValue () → Date
    returns Date
    setValue (d)
    Date d
    @Override
    toString () → String
    returns String
    withValue (value) → DateValue
    Date value
    returns DateValue

    DoubleValue

    extends: ASTNodeAccessImpl implements: Expression

    Every number with a point or a exponential format is a DoubleValue
    DoubleValue ()
    DoubleValue (value)
    String value
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getValue () → double
    returns double
    setValue (d)
    double d
    @Override
    toString () → String
    returns String
    withValue (value) → DoubleValue
    double value
    returns DoubleValue

    ExpressionVisitorAdapter

    extends: Object implements: ExpressionVisitor, PivotVisitor, SelectItemVisitor

    ExpressionVisitorAdapter ()
    getSelectVisitor () → SelectVisitor
    setSelectVisitor (selectVisitor)
    SelectVisitor selectVisitor
    @Override
    visit (value)
    NullValue value
    @Override
    visit (function)
    Function function
    @Override
    visit (expr)
    @Override
    visit (parameter)
    JdbcParameter parameter
    @Override
    visit (parameter)
    @Override
    visit (value)
    @Override
    visit (value)
    LongValue value
    @Override
    visit (value)
    DateValue value
    @Override
    visit (value)
    TimeValue value
    @Override
    visit (value)
    @Override
    visit (parenthesis)
    Parenthesis parenthesis
    @Override
    visit (value)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    Between expr
    visit (overlapsCondition)
    OverlapsCondition overlapsCondition
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (column)
    Column column
    @Override
    visit (selectBody)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (memberOfExpression)
    MemberOfExpression memberOfExpression
    @Override
    visit (expr)
    @Override
    visit (expr)
    Concat expr
    @Override
    visit (expr)
    Matches expr
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    Modulo expr
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expressionList)
    ExpressionList expressionList
    @Override
    visit (rowConstructor)
    RowConstructor rowConstructor
    @Override
    visit (notExpr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    returns void
    @Override
    visit (jsonExpr)
    @Override
    visit (expr)
    @Override
    visit (var)
    @Override
    visit (bind)
    @Override
    visit (expr)
    @Override
    visit (groupConcat)
    MySQLGroupConcat groupConcat
    @Override
    visit (pivot)
    Pivot pivot
    @Override
    visit (pivot)
    PivotXml pivot
    @Override
    visit (unpivot)
    UnPivot unpivot
    @Override
    visit (allColumns)
    AllColumns allColumns
    @Override
    visit (allTableColumns)
    AllTableColumns allTableColumns
    @Override
    visit (allValue)
    AllValue allValue
    @Override
    visit (isDistinctExpression)
    IsDistinctExpression isDistinctExpression
    @Override
    visit (selectExpressionItem)
    SelectItem selectExpressionItem
    @Override
    visit (rowGetExpression)
    RowGetExpression rowGetExpression
    @Override
    visit (hexValue)
    HexValue hexValue
    @Override
    visit (hint)
    @Override
    visit (timeKeyExpression)
    TimeKeyExpression timeKeyExpression
    @Override
    visit (literal)
    @Override
    visit (nextVal)
    @Override
    visit (col)
    @Override
    visit (expr)
    @Override
    visit (array)
    @Override
    visit (aThis)
    @Override
    visit (var)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expression)
    @Override
    visit (expression)
    JsonFunction expression
    @Override
    visit (connectByRootOperator)
    ConnectByRootOperator connectByRootOperator
    @Override
    visit (oracleNamedFunctionParameter)
    OracleNamedFunctionParameter oracleNamedFunctionParameter
    @Override
    visit (geometryDistance)
    GeometryDistance geometryDistance
    @Override
    visit (selectBody)
    Select selectBody
    @Override
    visit (transcodingFunction)
    TranscodingFunction transcodingFunction
    @Override
    visit (trimFunction)
    TrimFunction trimFunction
    @Override
    visit (rangeExpression)
    RangeExpression rangeExpression
    @Override
    visit (tsqlLeftJoin)
    TSQLLeftJoin tsqlLeftJoin
    @Override
    visit (tsqlRightJoin)
    TSQLRightJoin tsqlRightJoin

    ExtractExpression

    extends: ASTNodeAccessImpl implements: Expression

    Extract value from date/time expression. The name stores the part - name to get from the following date/time expression.
    ExtractExpression ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getName () → String
    returns String
    setName (name)
    String name
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    toString () → String
    returns String
    withName (name) → ExtractExpression
    String name
    withExpression (expression) → ExtractExpression
    Expression expression
    getExpression (type) → E
    Class type
    returns E

    FilterOverImpl

    extends: ASTNodeAccessImpl provides: JsonAggregateFunction

    FilterOverImpl ()
    getAnalyticType () → AnalyticType
    returns AnalyticType
    setAnalyticType (analyticType)
    AnalyticType analyticType
    withAnalyticType (analyticType) → FilterOverImpl
    AnalyticType analyticType
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    withOrderByElements (orderByElements) → FilterOverImpl
    List orderByElements
    getPartitionExpressionList () → ExpressionList
    setPartitionExpressionList (partitionExpressionList)
    ExpressionList partitionExpressionList
    setPartitionExpressionList (partitionExpressionList, brackets)
    ExpressionList partitionExpressionList
    boolean brackets
    isPartitionByBrackets () → boolean
    returns boolean
    getFilterExpression () → Expression
    returns Expression
    setFilterExpression (filterExpression)
    Expression filterExpression
    withFilterExpression (filterExpression) → FilterOverImpl
    Expression filterExpression
    getWindowElement () → WindowElement
    setWindowElement (windowElement)
    WindowElement windowElement
    withWindowElement (windowElement) → FilterOverImpl
    WindowElement windowElement
    @SuppressWarnings
    append (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override,| @SuppressWarnings
    toString () → String
    returns String

    Function

    extends: ASTNodeAccessImpl implements: Expression provides: TableFunction

    A function as MAX,COUNT…
    Function ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getName () → String
    returns String
    getMultipartName () → List
    returns List
    setName (string)
    String string
    withName (name) → Function
    String name
    returns Function
    withName (nameparts) → Function
    List nameparts
    returns Function
    setName (string)
    List string
    isAllColumns () → boolean
    returns boolean
    setAllColumns (b)
    boolean b
    isIgnoreNulls () → boolean
    returns boolean
    setIgnoreNulls (ignoreNulls)
    This is at the moment only necessary for AnalyticExpression initialization and not for normal functions. Therefore there is no deparsing for it for normal functions.
    boolean ignoreNulls
    isDistinct () → boolean
    true if the function is “distinct”
    returns boolean | true if the function is “distinct”
    setDistinct (b)
    boolean b
    isUnique () → boolean
    true if the function is “unique”
    returns boolean | true if the function is “unique”
    setUnique (b)
    boolean b
    getParameters () → ExpressionList
    The list of parameters of the function (if any, else null) If the parameter is “*”, allColumns is set to true
    returns ExpressionList | the list of parameters of the function (if any, else null)
    setParameters (expressions)
    Expression expressions
    setParameters (list)
    getNamedParameters () → NamedExpressionList
    the parameters might be named parameters, e.g. substring(‘foobar’ from 2 for 3)
    returns NamedExpressionList | the list of named parameters of the function (if any, else null)
    setNamedParameters (list)
    isEscaped () → boolean
    Return true if it’s in the form “{fn function_body() }”
    returns boolean | true if it’s java-escaped
    setEscaped (isEscaped)
    boolean isEscaped
    getAttribute () → Object
    returns Object
    setAttribute (attributeExpression)
    Expression attributeExpression
    @Deprecated
    getAttributeName () → String
    returns String
    setAttributeName (attributeName)
    String attributeName
    getAttributeColumn () → Column
    returns Column
    setAttribute (attributeColumn)
    Column attributeColumn
    withAttribute (attributeColumn) → Function
    Column attributeColumn
    returns Function
    getKeep () → KeepExpression
    setKeep (keep)
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    withAttribute (attribute) → Function
    Expression attribute
    returns Function
    @Deprecated
    withAttributeName (attributeName) → Function
    String attributeName
    returns Function
    withKeep (keep) → Function
    returns Function
    withIgnoreNulls (ignoreNulls) → Function
    boolean ignoreNulls
    returns Function
    withParameters (parameters) → Function
    ExpressionList parameters
    returns Function
    withParameters (parameters) → Function
    Expression parameters
    returns Function
    withNamedParameters (namedParameters) → Function
    NamedExpressionList namedParameters
    returns Function
    withAllColumns (allColumns) → Function
    boolean allColumns
    returns Function
    withDistinct (distinct) → Function
    boolean distinct
    returns Function
    withUnique (unique) → Function
    boolean unique
    returns Function
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    getAttribute (type) → E
    Class type
    returns E

    HexValue

    extends: ASTNodeAccessImpl implements: Expression

    HexValue ()
    HexValue (value)
    String value
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getValue () → String
    returns String
    setValue (value)
    String value
    withValue (value) → HexValue
    String value
    returns HexValue
    @Override
    toString () → String
    returns String

    IntervalExpression

    extends: ASTNodeAccessImpl implements: Expression

    IntervalExpression ()
    IntervalExpression (intervalKeyword)
    boolean intervalKeyword
    isUsingIntervalKeyword () → boolean
    returns boolean
    getParameter () → String
    returns String
    setParameter (parameter)
    String parameter
    getIntervalType () → String
    returns String
    setIntervalType (intervalType)
    String intervalType
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    toString () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    withParameter (parameter) → IntervalExpression
    String parameter
    withIntervalType (intervalType) → IntervalExpression
    String intervalType
    withExpression (expression) → IntervalExpression
    Expression expression
    getExpression (type) → E
    Class type
    returns E

    JdbcNamedParameter

    extends: ASTNodeAccessImpl implements: Expression

    JdbcNamedParameter ()
    JdbcNamedParameter (name)
    String name
    getParameterCharacter () → String
    returns String
    setParameterCharacter (parameterCharacter) → JdbcNamedParameter
    String parameterCharacter
    getName () → String
    returns String
    setName (name)
    String name
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withName (name) → JdbcNamedParameter
    String name

    JdbcParameter

    extends: ASTNodeAccessImpl implements: Expression

    A ‘?’ in a statement or a ?<number> e.g. ?4
    JdbcParameter ()
    JdbcParameter (index, useFixedIndex)
    Integer index
    boolean useFixedIndex
    getIndex () → Integer
    returns Integer
    setIndex (index)
    Integer index
    isUseFixedIndex () → boolean
    returns boolean
    setUseFixedIndex (useFixedIndex)
    boolean useFixedIndex
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withIndex (index) → JdbcParameter
    Integer index
    withUseFixedIndex (useFixedIndex) → JdbcParameter
    boolean useFixedIndex

    JsonAggregateFunction

    extends: FilterOverImpl implements: Expression

    JsonAggregateFunction ()
    getOnNullType () → JsonAggregateOnNullType
    returns JsonAggregateOnNullType
    setOnNullType (onNullType)
    JsonAggregateOnNullType onNullType
    withOnNullType (onNullType) → JsonAggregateFunction
    JsonAggregateOnNullType onNullType
    getUniqueKeysType () → JsonAggregateUniqueKeysType
    returns JsonAggregateUniqueKeysType
    setUniqueKeysType (uniqueKeysType)
    JsonAggregateUniqueKeysType uniqueKeysType
    withUniqueKeysType (uniqueKeysType) → JsonAggregateFunction
    JsonAggregateUniqueKeysType uniqueKeysType
    getType () → JsonFunctionType
    returns JsonFunctionType
    setType (type)
    JsonFunctionType type
    withType (type) → JsonAggregateFunction
    JsonFunctionType type
    setType (typeName)
    String typeName
    withType (typeName) → JsonAggregateFunction
    String typeName
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    withExpression (expression) → JsonAggregateFunction
    Expression expression
    isUsingKeyKeyword () → boolean
    returns boolean
    setUsingKeyKeyword (usingKeyKeyword)
    boolean usingKeyKeyword
    withUsingKeyKeyword (usingKeyKeyword) → JsonAggregateFunction
    boolean usingKeyKeyword
    getKey () → String
    returns String
    setKey (key)
    String key
    withKey (key) → JsonAggregateFunction
    String key
    isUsingValueKeyword () → boolean
    returns boolean
    setUsingValueKeyword (usingValueKeyword)
    boolean usingValueKeyword
    withUsingValueKeyword (usingValueKeyword) → JsonAggregateFunction
    boolean usingValueKeyword
    getValue () → Object
    returns Object
    setValue (value)
    Object value
    withValue (value) → JsonAggregateFunction
    Object value
    isUsingFormatJson () → boolean
    returns boolean
    setUsingFormatJson (usingFormatJson)
    boolean usingFormatJson
    withUsingFormatJson (usingFormatJson) → JsonAggregateFunction
    boolean usingFormatJson
    getExpressionOrderByElements () → List
    returns List
    setExpressionOrderByElements (orderByElements)
    List orderByElements
    withExpressionOrderByElements (orderByElements) → JsonAggregateFunction
    List orderByElements
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    append (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @SuppressWarnings
    appendObject (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @SuppressWarnings
    appendArray (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    JsonExpression

    extends: ASTNodeAccessImpl implements: Expression

    JsonExpression ()
    JsonExpression (expr)
    JsonExpression (expr, idents)
    List idents
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getExpression () → Expression
    returns Expression
    setExpression (expr)
    addIdent (ident, operator)
    String ident
    String operator
    addAllIdents (idents)
    Collection idents
    getIdentList () → List
    returns List
    getIdent (index) → Entry
    int index
    returns Entry
    @Deprecated
    getIdents () → List
    returns List
    @Deprecated
    getOperators () → List
    returns List
    @Override
    toString () → String
    returns String
    withExpression (expr) → JsonExpression

    JsonFunction

    extends: ASTNodeAccessImpl implements: Expression

    JsonFunction ()
    getKeyValuePairs () → ArrayList
    returns ArrayList
    getExpressions () → ArrayList
    returns ArrayList
    getKeyValuePair (i) → JsonKeyValuePair
    int i
    getExpression (i) → JsonFunctionExpression
    int i
    add (keyValuePair) → boolean
    JsonKeyValuePair keyValuePair
    returns boolean
    add (i, keyValuePair)
    int i
    JsonKeyValuePair keyValuePair
    add (expression) → boolean
    returns boolean
    add (i, expression)
    int i
    isEmpty () → boolean
    returns boolean
    getOnNullType () → JsonAggregateOnNullType
    returns JsonAggregateOnNullType
    setOnNullType (onNullType)
    JsonAggregateOnNullType onNullType
    withOnNullType (onNullType) → JsonFunction
    JsonAggregateOnNullType onNullType
    returns JsonFunction
    getUniqueKeysType () → JsonAggregateUniqueKeysType
    returns JsonAggregateUniqueKeysType
    setUniqueKeysType (uniqueKeysType)
    JsonAggregateUniqueKeysType uniqueKeysType
    withUniqueKeysType (uniqueKeysType) → JsonFunction
    JsonAggregateUniqueKeysType uniqueKeysType
    returns JsonFunction
    getType () → JsonFunctionType
    returns JsonFunctionType
    setType (type)
    JsonFunctionType type
    withType (type) → JsonFunction
    JsonFunctionType type
    returns JsonFunction
    setType (typeName)
    String typeName
    withType (typeName) → JsonFunction
    String typeName
    returns JsonFunction
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    append (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @SuppressWarnings
    appendObject (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @SuppressWarnings
    appendPostgresObject (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    appendMySqlObject (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @SuppressWarnings
    appendArray (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    JsonFunctionExpression

    extends: Object implements: Serializable

    JsonFunctionExpression (expression)
    Expression expression
    getExpression () → Expression
    returns Expression
    isUsingFormatJson () → boolean
    returns boolean
    setUsingFormatJson (usingFormatJson)
    boolean usingFormatJson
    withUsingFormatJson (usingFormatJson) → JsonFunctionExpression
    boolean usingFormatJson
    append (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    JsonKeyValuePair

    extends: Object implements: Serializable

    JsonKeyValuePair (key, value, usingKeyKeyword, usingValueKeyword)
    String key
    Object value
    boolean usingKeyKeyword
    boolean usingValueKeyword
    isUsingKeyKeyword () → boolean
    returns boolean
    setUsingKeyKeyword (usingKeyKeyword)
    boolean usingKeyKeyword
    withUsingKeyKeyword (usingKeyKeyword) → JsonKeyValuePair
    boolean usingKeyKeyword
    isUsingValueKeyword () → boolean
    returns boolean
    setUsingValueKeyword (usingValueKeyword)
    boolean usingValueKeyword
    withUsingValueKeyword (usingValueKeyword) → JsonKeyValuePair
    boolean usingValueKeyword
    isUsingFormatJson () → boolean
    returns boolean
    setUsingFormatJson (usingFormatJson)
    boolean usingFormatJson
    withUsingFormatJson (usingFormatJson) → JsonKeyValuePair
    boolean usingFormatJson
    @Override
    hashCode () → int
    returns int
    @Override
    equals (obj) → boolean
    Object obj
    returns boolean
    getKey () → String
    returns String
    getValue () → Object
    returns Object
    append (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    KeepExpression

    extends: ASTNodeAccessImpl implements: Expression

    KeepExpression ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    getName () → String
    returns String
    setName (name)
    String name
    isFirst () → boolean
    returns boolean
    setFirst (first)
    boolean first
    @Override
    toString () → String
    returns String
    withName (name) → KeepExpression
    String name
    withOrderByElements (orderByElements) → KeepExpression
    List orderByElements
    withFirst (first) → KeepExpression
    boolean first
    addOrderByElements (orderByElements) → KeepExpression
    OrderByElement orderByElements
    addOrderByElements (orderByElements) → KeepExpression
    Collection orderByElements

    LongValue

    extends: ASTNodeAccessImpl implements: Expression

    Every number without a point or an exponential format is a LongValue.
    LongValue ()
    LongValue (value)
    String value
    LongValue (value)
    long value
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getValue () → long
    returns long
    getBigIntegerValue () → BigInteger
    returns BigInteger
    setValue (d)
    long d
    withValue (d) → LongValue
    long d
    returns LongValue
    getStringValue () → String
    returns String
    setStringValue (string)
    String string
    @Override
    toString () → String
    returns String
    withStringValue (stringValue) → LongValue
    String stringValue
    returns LongValue
    @Override
    equals (o) → boolean
    Object o
    returns boolean
    @Override
    hashCode () → int
    returns int

    MySQLGroupConcat

    extends: ASTNodeAccessImpl implements: Expression

    MySQLGroupConcat ()
    getExpressionList () → ExpressionList
    setExpressionList (expressionList)
    ExpressionList expressionList
    isDistinct () → boolean
    returns boolean
    setDistinct (distinct)
    boolean distinct
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    getSeparator () → String
    returns String
    setSeparator (separator)
    String separator
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withExpressionList (expressionList) → MySQLGroupConcat
    ExpressionList expressionList
    withDistinct (distinct) → MySQLGroupConcat
    boolean distinct
    withOrderByElements (orderByElements) → MySQLGroupConcat
    List orderByElements
    withSeparator (separator) → MySQLGroupConcat
    String separator
    addOrderByElements (orderByElements) → MySQLGroupConcat
    OrderByElement orderByElements
    addOrderByElements (orderByElements) → MySQLGroupConcat
    Collection orderByElements

    MySQLIndexHint

    extends: Object implements: Serializable

    MySQLIndexHint (action, indexQualifier, indexNames)
    String action
    String indexQualifier
    List indexNames
    getAction () → String
    returns String
    getIndexQualifier () → String
    returns String
    getIndexNames () → List
    returns List
    @Override
    toString () → String
    returns String

    NextValExpression

    extends: ASTNodeAccessImpl implements: Expression

    NextValExpression (nameList, image)
    List nameList
    String image
    isUsingNextValueFor () → boolean
    returns boolean
    setUsingNextValueFor (usingNextValueFor)
    boolean usingNextValueFor
    withNextValueFor (usingNextValueFor) → NextValExpression
    boolean usingNextValueFor
    getNameList () → List
    returns List
    getName () → String
    returns String
    @Override
    toString () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    NotExpression

    extends: ASTNodeAccessImpl implements: Expression

    It represents a “not ” or “!” before an expression.
    NotExpression ()
    NotExpression (expression)
    Expression expression
    NotExpression (expression, useExclamationMark)
    Expression expression
    boolean useExclamationMark
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    isExclamationMark () → boolean
    returns boolean
    setExclamationMark (exclamationMark)
    boolean exclamationMark
    withExpression (expression) → NotExpression
    Expression expression
    withExclamationMark (exclamationMark) → NotExpression
    boolean exclamationMark
    getExpression (type) → E
    Class type
    returns E

    NullValue

    extends: ASTNodeAccessImpl implements: Expression

    NullValue ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String

    NumericBind

    extends: ASTNodeAccessImpl implements: Expression

    NumericBind ()
    getBindId () → int
    returns int
    setBindId (bindId)
    int bindId
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withBindId (bindId) → NumericBind
    int bindId
    returns NumericBind

    OracleHierarchicalExpression

    extends: ASTNodeAccessImpl implements: Expression

    OracleHierarchicalExpression ()
    getStartExpression () → Expression
    returns Expression
    setStartExpression (startExpression)
    Expression startExpression
    getConnectExpression () → Expression
    returns Expression
    setConnectExpression (connectExpression)
    Expression connectExpression
    isNoCycle () → boolean
    returns boolean
    setNoCycle (noCycle)
    boolean noCycle
    isConnectFirst () → boolean
    returns boolean
    setConnectFirst (connectFirst)
    boolean connectFirst
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withStartExpression (startExpression) → OracleHierarchicalExpression
    Expression startExpression
    withConnectExpression (connectExpression) → OracleHierarchicalExpression
    Expression connectExpression
    withNoCycle (noCycle) → OracleHierarchicalExpression
    boolean noCycle
    withConnectFirst (connectFirst) → OracleHierarchicalExpression
    boolean connectFirst
    getStartExpression (type) → E
    Class type
    returns E
    getConnectExpression (type) → E
    Class type
    returns E

    OracleHint

    extends: ASTNodeAccessImpl implements: Expression

    Oracle Hint Expression
    OracleHint ()
    isHintMatch (comment) → boolean
    String comment
    returns boolean
    setComment (comment)
    String comment
    getValue () → String
    returns String
    setValue (value)
    String value
    isSingleLine () → boolean
    returns boolean
    setSingleLine (singleLine)
    boolean singleLine
    @Override
    accept (visitor)
    @Override
    toString () → String
    returns String
    withValue (value) → OracleHint
    String value
    returns OracleHint
    withSingleLine (singleLine) → OracleHint
    boolean singleLine
    returns OracleHint
    getHintFromSelectBody (selectBody) → OracleHint
    Select selectBody
    returns OracleHint

    OracleNamedFunctionParameter

    extends: ASTNodeAccessImpl implements: Expression

    OracleNamedFunctionParameter (name, expression)
    String name
    Expression expression
    getName () → String
    returns String
    getExpression () → Expression
    returns Expression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    OrderByClause

    extends: Object implements: Serializable

    OrderByClause ()
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    toStringOrderByElements (b)
    StringBuilder b
    withOrderByElements (orderByElements) → OrderByClause
    List orderByElements
    addOrderByElements (orderByElements) → OrderByClause
    OrderByElement orderByElements
    addOrderByElements (orderByElements) → OrderByClause
    Collection orderByElements

    OverlapsCondition

    extends: ASTNodeAccessImpl implements: Expression

    OverlapsCondition (left, right)
    getLeft () → ExpressionList
    getRight () → ExpressionList
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String

    Parenthesis

    extends: ASTNodeAccessImpl implements: Expression

    It represents an expression like “(” expression “)”
    Parenthesis ()
    Parenthesis (expression)
    Expression expression
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withExpression (expression) → Parenthesis
    Expression expression
    returns Parenthesis
    getExpression (type) → E
    Class type
    returns E

    PartitionByClause

    extends: Object implements: Serializable

    PartitionByClause ()
    getPartitionExpressionList () → ExpressionList
    setPartitionExpressionList (partitionExpressionList)
    ExpressionList partitionExpressionList
    setPartitionExpressionList (partitionExpressionList, brackets)
    ExpressionList partitionExpressionList
    boolean brackets
    toStringPartitionBy (b)
    StringBuilder b
    isBrackets () → boolean
    returns boolean
    withPartitionExpressionList (partitionExpressionList) → PartitionByClause
    ExpressionList partitionExpressionList

    RangeExpression

    extends: ASTNodeAccessImpl implements: Expression

    RangeExpression (startExpression, endExpression)
    Expression startExpression
    Expression endExpression
    getStartExpression () → Expression
    returns Expression
    setStartExpression (startExpression) → RangeExpression
    Expression startExpression
    getEndExpression () → Expression
    returns Expression
    setEndExpression (endExpression) → RangeExpression
    Expression endExpression
    @Override
    toString () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    RowConstructor

    extends: ParenthesedExpressionList implements: Expression

    RowConstructor ()
    RowConstructor (name, expressionList)
    String name
    ExpressionList expressionList
    getName () → String
    returns String
    setName (name)
    String name
    @Override
    toString () → String
    returns String
    withName (name) → RowConstructor
    String name

    RowGetExpression

    extends: ASTNodeAccessImpl implements: Expression

    RowGetExpression (expression, columnName)
    Expression expression
    String columnName
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    getColumnName () → String
    returns String
    setColumnName (columnName)
    String columnName

    SQLServerHints

    extends: Object implements: Serializable

    SQLServerHints ()
    withNoLock () → SQLServerHints
    getNoLock () → Boolean
    returns Boolean
    setNoLock (noLock)
    Boolean noLock
    getIndexName () → String
    returns String
    setIndexName (indexName)
    String indexName
    @Override
    toString () → String
    returns String
    withNoLock (noLock) → SQLServerHints
    Boolean noLock
    withIndexName (indexName) → SQLServerHints
    String indexName

    SignedExpression

    extends: ASTNodeAccessImpl implements: Expression

    It represents a “-” or “+” or “~” before an expression
    SignedExpression ()
    SignedExpression (sign, expression)
    char sign
    Expression expression
    getSign () → char
    returns char
    setSign (sign)
    char sign
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withSign (sign) → SignedExpression
    char sign
    withExpression (expression) → SignedExpression
    Expression expression
    getExpression (type) → E
    Class type
    returns E

    SpannerInterleaveIn

    extends: Object

    SpannerInterleaveIn ()
    SpannerInterleaveIn (table, action)
    Table table
    OnDelete action
    SpannerInterleaveIn (nameParts)
    List nameParts
    SpannerInterleaveIn (tableName)
    String tableName
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    getOnDelete () → OnDelete
    returns OnDelete
    setOnDelete (action)
    OnDelete action
    @Override
    toString () → String
    returns String
    withTable (table) → SpannerInterleaveIn
    Table table
    withOnDelete (action) → SpannerInterleaveIn
    OnDelete action

    StringValue

    extends: ASTNodeAccessImpl implements: Expression

    A string as in ‘example_string’
    StringValue ()
    StringValue (escapedValue)
    String escapedValue
    getValue () → String
    returns String
    getPrefix () → String
    returns String
    getNotExcapedValue () → String
    returns String
    setValue (string)
    String string
    setPrefix (prefix)
    String prefix
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withPrefix (prefix) → StringValue
    String prefix
    returns StringValue
    withValue (value) → StringValue
    String value
    returns StringValue
    @Override
    equals (o) → boolean
    Object o
    returns boolean
    @Override
    hashCode () → int
    returns int

    TimeKeyExpression

    extends: ASTNodeAccessImpl implements: Expression

    TimeKeyExpression ()
    TimeKeyExpression (value)
    String value
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getStringValue () → String
    returns String
    setStringValue (string)
    String string
    @Override
    toString () → String
    returns String
    withStringValue (stringValue) → TimeKeyExpression
    String stringValue

    TimeValue

    extends: ASTNodeAccessImpl implements: Expression

    A Time in the form {t ‘hh:mm:ss’}
    TimeValue ()
    TimeValue (value)
    String value
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getValue () → Time
    returns Time
    setValue (d)
    Time d
    @Override
    toString () → String
    returns String
    withValue (value) → TimeValue
    Time value
    returns TimeValue

    TimestampValue

    extends: ASTNodeAccessImpl implements: Expression

    A Timestamp in the form {ts ‘yyyy-mm-dd hh:mm:ss.f …’}
    TimestampValue ()
    TimestampValue (value)
    String value
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getValue () → Timestamp
    returns Timestamp
    setValue (d)
    Timestamp d
    getRawValue () → String
    returns String
    setRawValue (rawValue)
    String rawValue
    @Override
    toString () → String
    returns String
    withValue (value) → TimestampValue
    Timestamp value

    TimezoneExpression

    extends: ASTNodeAccessImpl implements: Expression

    TimezoneExpression ()
    getLeftExpression () → Expression
    returns Expression
    setLeftExpression (expression)
    Expression expression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getTimezoneExpressions () → List
    returns List
    addTimezoneExpression (timezoneExpr)
    Expression timezoneExpr
    @Override
    toString () → String
    returns String

    TranscodingFunction

    extends: ASTNodeAccessImpl implements: Expression

    TranscodingFunction (expression, transcodingName)
    Expression expression
    String transcodingName
    TranscodingFunction ()
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    withExpression (expression) → TranscodingFunction
    Expression expression
    getTranscodingName () → String
    returns String
    setTranscodingName (transcodingName)
    String transcodingName
    withTranscodingName (transcodingName) → TranscodingFunction
    String transcodingName
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    TrimFunction

    extends: ASTNodeAccessImpl implements: Expression

    TrimFunction (trimSpecification, expression, fromExpression, isUsingFromKeyword)
    TrimSpecification trimSpecification
    Expression expression
    Expression fromExpression
    boolean isUsingFromKeyword
    TrimFunction ()
    getTrimSpecification () → TrimSpecification
    returns TrimSpecification
    setTrimSpecification (trimSpecification)
    TrimSpecification trimSpecification
    withTrimSpecification (trimSpecification) → TrimFunction
    TrimSpecification trimSpecification
    returns TrimFunction
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    withExpression (expression) → TrimFunction
    Expression expression
    returns TrimFunction
    getFromExpression () → Expression
    returns Expression
    setFromExpression (fromExpression)
    Expression fromExpression
    withFromExpression (fromExpression) → TrimFunction
    Expression fromExpression
    returns TrimFunction
    isUsingFromKeyword () → boolean
    returns boolean
    setUsingFromKeyword (useFromKeyword)
    boolean useFromKeyword
    withUsingFromKeyword (useFromKeyword) → TrimFunction
    boolean useFromKeyword
    returns TrimFunction
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    UserVariable

    extends: ASTNodeAccessImpl implements: Expression

    Simple uservariables like @test.
    UserVariable ()
    UserVariable (name)
    String name
    getName () → String
    returns String
    setName (name)
    String name
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    isDoubleAdd () → boolean
    returns boolean
    setDoubleAdd (doubleAdd)
    boolean doubleAdd
    @Override
    toString () → String
    returns String
    withName (name) → UserVariable
    String name
    returns UserVariable
    withDoubleAdd (doubleAdd) → UserVariable
    boolean doubleAdd
    returns UserVariable

    VariableAssignment

    extends: ASTNodeAccessImpl implements: Expression

    Assignment to a user variable like in select @a = 5.
    VariableAssignment ()
    getVariable () → UserVariable
    returns UserVariable
    setVariable (variable)
    UserVariable variable
    getOperation () → String
    returns String
    setOperation (operation)
    String operation
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    toString () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    WhenClause

    extends: ASTNodeAccessImpl implements: Expression

    A clause of following syntax: WHEN condition THEN expression. Which is part of a CaseExpression.
    WhenClause ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getThenExpression () → Expression
    returns Expression
    setThenExpression (thenExpression)
    Expression thenExpression
    getWhenExpression () → Expression
    returns Expression | Returns the whenExpression.
    setWhenExpression (whenExpression)
    Expression whenExpression | whenExpression The whenExpression to set.
    @Override
    toString () → String
    returns String
    withWhenExpression (whenExpression) → WhenClause
    Expression whenExpression
    returns WhenClause
    withThenExpression (thenExpression) → WhenClause
    Expression thenExpression
    returns WhenClause
    getThenExpression (type) → E
    Class type
    returns E
    getWhenExpression (type) → E
    Class type
    returns E

    WindowDefinition

    extends: Object implements: Serializable

    WindowDefinition ()
    getOrderBy () → OrderByClause
    getPartitionBy () → PartitionByClause
    getWindowElement () → WindowElement
    setWindowElement (windowElement)
    WindowElement windowElement
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    getPartitionExpressionList () → ExpressionList
    setPartitionExpressionList (partitionExpressionList)
    ExpressionList partitionExpressionList
    setPartitionExpressionList (partitionExpressionList, brackets)
    ExpressionList partitionExpressionList
    boolean brackets
    getWindowName () → String
    returns String
    setWindowName (windowName)
    String windowName
    withWindowName (windowName) → WindowDefinition
    String windowName
    @Override
    toString () → String
    returns String

    WindowElement

    extends: Object implements: Serializable

    WindowElement ()
    getType () → Type
    returns Type
    setType (type)
    Type type
    getOffset () → WindowOffset
    returns WindowOffset
    setOffset (offset)
    getRange () → WindowRange
    returns WindowRange
    setRange (range)
    @Override
    toString () → String
    returns String
    withType (type) → WindowElement
    Type type
    withOffset (offset) → WindowElement
    withRange (range) → WindowElement

    WindowOffset

    extends: Object implements: Serializable

    WindowOffset ()
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    getType () → Type
    returns Type
    setType (type)
    Type type
    @Override
    toString () → String
    returns String
    withExpression (expression) → WindowOffset
    Expression expression
    returns WindowOffset
    withType (type) → WindowOffset
    Type type
    returns WindowOffset
    getExpression (type) → E
    Class type
    returns E

    WindowRange

    extends: Object implements: Serializable

    WindowRange ()
    getEnd () → WindowOffset
    returns WindowOffset
    setEnd (end)
    getStart () → WindowOffset
    returns WindowOffset
    setStart (start)
    @Override
    toString () → String
    returns String
    withStart (start) → WindowRange
    returns WindowRange
    withEnd (end) → WindowRange

    XMLSerializeExpr

    extends: ASTNodeAccessImpl implements: Expression

    XMLSerializeExpr ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    getDataType () → ColDataType
    returns ColDataType
    setDataType (dataType)
    ColDataType dataType
    @Override
    toString () → String
    returns String

    Expression

    implements: ASTNodeAccess, Model provides: AllColumns, AllValue, AnalyticExpression, AnyComparisonExpression, ArrayConstructor, ArrayExpression, Between, BinaryExpression, CaseExpression, CastExpression, CollateExpression, Column, ConnectByRootOperator, DateTimeLiteralExpression, DateValue, DoubleValue, ExistsExpression, ExpressionList, ExtractExpression, FullTextSearch, Function, HexValue, InExpression, IntervalExpression, IsBooleanExpression, IsNullExpression, JdbcNamedParameter, JdbcParameter, JsonAggregateFunction, JsonExpression, JsonFunction, KeepExpression, LongValue, MemberOfExpression, MultipleExpression, MySQLGroupConcat, NextValExpression, NotExpression, NullValue, NumericBind, OracleHierarchicalExpression, OracleHint, OracleNamedFunctionParameter, OverlapsCondition, Parenthesis, RangeExpression, RowConstructor, RowGetExpression, Select, SignedExpression, StringValue, TimeKeyExpression, TimeValue, TimestampValue, TimezoneExpression, TranscodingFunction, TrimFunction, UserVariable, VariableAssignment, WhenClause, XMLSerializeExpr,

    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    ExpressionVisitor

    provides: ExpressionDeParser, ExpressionValidator, ExpressionVisitorAdapter, TablesNamesFinder,

    visit (aThis)
    visit (aThis)
    visit (nullValue)
    NullValue nullValue
    visit (function)
    Function function
    visit (signedExpression)
    SignedExpression signedExpression
    visit (jdbcParameter)
    JdbcParameter jdbcParameter
    visit (jdbcNamedParameter)
    JdbcNamedParameter jdbcNamedParameter
    visit (doubleValue)
    DoubleValue doubleValue
    visit (longValue)
    LongValue longValue
    visit (hexValue)
    HexValue hexValue
    visit (dateValue)
    DateValue dateValue
    visit (timeValue)
    TimeValue timeValue
    visit (timestampValue)
    TimestampValue timestampValue
    visit (parenthesis)
    Parenthesis parenthesis
    visit (stringValue)
    StringValue stringValue
    visit (addition)
    Addition addition
    visit (division)
    Division division
    visit (division)
    visit (multiplication)
    Multiplication multiplication
    visit (subtraction)
    Subtraction subtraction
    visit (andExpression)
    AndExpression andExpression
    visit (orExpression)
    OrExpression orExpression
    visit (orExpression)
    XorExpression orExpression
    visit (between)
    Between between
    visit (overlapsCondition)
    OverlapsCondition overlapsCondition
    visit (equalsTo)
    EqualsTo equalsTo
    visit (greaterThan)
    GreaterThan greaterThan
    visit (greaterThanEquals)
    GreaterThanEquals greaterThanEquals
    visit (inExpression)
    InExpression inExpression
    visit (fullTextSearch)
    FullTextSearch fullTextSearch
    visit (isNullExpression)
    IsNullExpression isNullExpression
    visit (isBooleanExpression)
    IsBooleanExpression isBooleanExpression
    visit (likeExpression)
    LikeExpression likeExpression
    visit (minorThan)
    MinorThan minorThan
    visit (minorThanEquals)
    MinorThanEquals minorThanEquals
    visit (notEqualsTo)
    NotEqualsTo notEqualsTo
    visit (doubleAnd)
    DoubleAnd doubleAnd
    visit (contains)
    Contains contains
    visit (containedBy)
    ContainedBy containedBy
    visit (selectBody)
    visit (tableColumn)
    Column tableColumn
    visit (caseExpression)
    CaseExpression caseExpression
    visit (whenClause)
    WhenClause whenClause
    visit (existsExpression)
    ExistsExpression existsExpression
    visit (memberOfExpression)
    MemberOfExpression memberOfExpression
    visit (anyComparisonExpression)
    AnyComparisonExpression anyComparisonExpression
    visit (concat)
    Concat concat
    visit (matches)
    Matches matches
    visit (bitwiseAnd)
    BitwiseAnd bitwiseAnd
    visit (bitwiseOr)
    BitwiseOr bitwiseOr
    visit (bitwiseXor)
    BitwiseXor bitwiseXor
    visit (cast)
    visit (modulo)
    Modulo modulo
    visit (aexpr)
    visit (eexpr)
    visit (iexpr)
    visit (oexpr)
    visit (rexpr)
    visit (jsonExpr)
    visit (jsonExpr)
    JsonOperator jsonExpr
    visit (var)
    visit (bind)
    visit (aexpr)
    visit (groupConcat)
    MySQLGroupConcat groupConcat
    visit (expressionList)
    ExpressionList expressionList
    visit (rowConstructor)
    RowConstructor rowConstructor
    visit (rowGetExpression)
    RowGetExpression rowGetExpression
    visit (hint)
    visit (timeKeyExpression)
    TimeKeyExpression timeKeyExpression
    visit (literal)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (allColumns)
    AllColumns allColumns
    visit (allTableColumns)
    AllTableColumns allTableColumns
    visit (allValue)
    AllValue allValue
    visit (isDistinctExpression)
    IsDistinctExpression isDistinctExpression
    visit (geometryDistance)
    GeometryDistance geometryDistance
    visit (selectBody)
    Select selectBody
    visit (transcodingFunction)
    TranscodingFunction transcodingFunction
    visit (trimFunction)
    TrimFunction trimFunction
    visit (rangeExpression)
    RangeExpression rangeExpression
    visit (tsqlLeftJoin)
    TSQLLeftJoin tsqlLeftJoin
    visit (tsqlRightJoin)
    TSQLRightJoin tsqlRightJoin

    expression.operators.arithmetic

    Addition

    extends: BinaryExpression

    Addition ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → Addition
    returns Addition
    @Override
    withRightExpression (arg0) → Addition
    returns Addition

    BitwiseAnd

    extends: BinaryExpression

    BitwiseAnd ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → BitwiseAnd
    returns BitwiseAnd
    @Override
    withRightExpression (arg0) → BitwiseAnd
    returns BitwiseAnd

    BitwiseLeftShift

    extends: BinaryExpression

    BitwiseLeftShift ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → BitwiseLeftShift
    @Override
    withRightExpression (arg0) → BitwiseLeftShift

    BitwiseOr

    extends: BinaryExpression

    BitwiseOr ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → BitwiseOr
    returns BitwiseOr
    @Override
    withRightExpression (arg0) → BitwiseOr
    returns BitwiseOr

    BitwiseRightShift

    extends: BinaryExpression

    BitwiseRightShift ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → BitwiseRightShift
    @Override
    withRightExpression (arg0) → BitwiseRightShift

    BitwiseXor

    extends: BinaryExpression

    BitwiseXor ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → BitwiseXor
    returns BitwiseXor
    @Override
    withRightExpression (arg0) → BitwiseXor
    returns BitwiseXor

    Concat

    extends: BinaryExpression

    Concat ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → Concat
    returns Concat
    @Override
    withRightExpression (arg0) → Concat
    returns Concat

    Division

    extends: BinaryExpression

    Division ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → Division
    returns Division
    @Override
    withRightExpression (arg0) → Division
    returns Division

    IntegerDivision

    extends: BinaryExpression

    IntegerDivision ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → IntegerDivision
    @Override
    withRightExpression (arg0) → IntegerDivision

    Modulo

    extends: BinaryExpression

    Modulo expression (a % b).
    Modulo ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → Modulo
    returns Modulo
    @Override
    withRightExpression (arg0) → Modulo
    returns Modulo

    Multiplication

    extends: BinaryExpression

    Multiplication ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → Multiplication
    @Override
    withRightExpression (arg0) → Multiplication

    Subtraction

    extends: BinaryExpression

    Subtraction ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → Subtraction
    returns Subtraction
    @Override
    withRightExpression (arg0) → Subtraction
    returns Subtraction

    expression.operators.conditional

    AndExpression

    extends: BinaryExpression

    AndExpression ()
    AndExpression (leftExpression, rightExpression)
    Expression leftExpression
    Expression rightExpression
    setUseOperator (useOperator)
    boolean useOperator
    isUseOperator () → boolean
    returns boolean
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    withUseOperator (useOperator) → AndExpression
    boolean useOperator
    @Override
    withLeftExpression (arg0) → AndExpression
    @Override
    withRightExpression (arg0) → AndExpression

    OrExpression

    extends: BinaryExpression

    OrExpression ()
    OrExpression (leftExpression, rightExpression)
    Expression leftExpression
    Expression rightExpression
    @Override
    withLeftExpression (expression) → OrExpression
    Expression expression
    returns OrExpression
    @Override
    withRightExpression (expression) → OrExpression
    Expression expression
    returns OrExpression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String

    XorExpression

    extends: BinaryExpression

    XorExpression ()
    XorExpression (leftExpression, rightExpression)
    Expression leftExpression
    Expression rightExpression
    @Override
    withLeftExpression (expression) → XorExpression
    Expression expression
    @Override
    withRightExpression (expression) → XorExpression
    Expression expression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String

    expression.operators.relational

    LikeExpression.KeyWord

    [LIKE, ILIKE, RLIKE, REGEXP]

    RegExpMatchOperatorType

    [MATCH_CASESENSITIVE, MATCH_CASEINSENSITIVE, NOT_MATCH_CASESENSITIVE, NOT_MATCH_CASEINSENSITIVE]

    PostgresSQL match operators.

    Between

    extends: ASTNodeAccessImpl implements: Expression

    A “BETWEEN” expr1 expr2 statement
    Between ()
    getBetweenExpressionEnd () → Expression
    returns Expression
    getBetweenExpressionStart () → Expression
    returns Expression
    getLeftExpression () → Expression
    returns Expression
    isNot () → boolean
    returns boolean
    setBetweenExpressionEnd (expression)
    Expression expression
    setBetweenExpressionStart (expression)
    Expression expression
    setLeftExpression (expression)
    Expression expression
    setNot (b)
    boolean b
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withLeftExpression (leftExpression) → Between
    Expression leftExpression
    returns Between
    withNot (not) → Between
    boolean not
    returns Between
    withBetweenExpressionStart (betweenExpressionStart) → Between
    Expression betweenExpressionStart
    returns Between
    withBetweenExpressionEnd (betweenExpressionEnd) → Between
    Expression betweenExpressionEnd
    returns Between
    getBetweenExpressionEnd (type) → E
    Class type
    returns E
    getBetweenExpressionStart (type) → E
    Class type
    returns E
    getLeftExpression (type) → E
    Class type
    returns E

    ComparisonOperator

    extends: OldOracleJoinBinaryExpression provides: ContainedBy, Contains, DoubleAnd, EqualsTo, GeometryDistance, GreaterThan, GreaterThanEquals, MinorThan, MinorThanEquals, NotEqualsTo, TSQLLeftJoin, TSQLRightJoin

    ComparisonOperator (operator)
    String operator
    ComparisonOperator (operator, left, right)
    String operator
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → ComparisonOperator
    @Override
    withRightExpression (arg0) → ComparisonOperator
    @Override
    withOldOracleJoinSyntax (oldOracleJoinSyntax) → ComparisonOperator
    int oldOracleJoinSyntax
    @Override
    withOraclePriorPosition (oraclePriorPosition) → ComparisonOperator
    int oraclePriorPosition

    ContainedBy

    extends: ComparisonOperator

    ContainedBy ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    Contains

    extends: ComparisonOperator

    Contains ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    DoubleAnd

    extends: ComparisonOperator

    DoubleAnd ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    EqualsTo

    extends: ComparisonOperator

    EqualsTo ()
    EqualsTo (left, right)
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    withLeftExpression (expression) → EqualsTo
    Expression expression
    returns EqualsTo
    @Override
    withRightExpression (expression) → EqualsTo
    Expression expression
    returns EqualsTo
    @Override
    withOldOracleJoinSyntax (arg0) → EqualsTo
    int arg0
    returns EqualsTo
    @Override
    withOraclePriorPosition (arg0) → EqualsTo
    int arg0
    returns EqualsTo

    ExistsExpression

    extends: ASTNodeAccessImpl implements: Expression

    ExistsExpression ()
    getRightExpression () → Expression
    returns Expression
    setRightExpression (expression)
    Expression expression
    isNot () → boolean
    returns boolean
    setNot (b)
    boolean b
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getStringExpression () → String
    returns String
    @Override
    toString () → String
    returns String
    withRightExpression (rightExpression) → ExistsExpression
    Expression rightExpression
    withNot (not) → ExistsExpression
    boolean not
    getRightExpression (type) → E
    Class type
    returns E

    ExpressionList

    extends: ArrayList implements: Expression, Serializable provides: NamedExpressionList, ParenthesedExpressionList

    A list of expressions, as in SELECT A FROM TAB WHERE B IN (expr1,expr2,expr3)
    ExpressionList (expressions)
    Collection expressions
    ExpressionList (expressions)
    List expressions
    ExpressionList (expressions)
    T expressions
    @Deprecated
    isUsingBrackets () → boolean
    returns boolean
    @Deprecated
    getExpressions () → List
    returns List
    @Deprecated
    setExpressions (expressions)
    List expressions
    addExpression (expression) → ExpressionList
    T expression
    addExpressions (expressions) → ExpressionList
    T expressions
    addExpressions (expressions) → ExpressionList
    Collection expressions
    withExpressions (expressions) → ExpressionList
    T expressions
    withExpressions (expressions) → ExpressionList
    Collection expressions
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getASTNode () → SimpleNode
    returns SimpleNode
    @Override
    setASTNode (node)
    SimpleNode node

    FullTextSearch

    extends: ASTNodeAccessImpl implements: Expression

    FullTextSearch ()
    setMatchColumns (columns)
    getMatchColumns () → ExpressionList
    setAgainstValue (val)
    setAgainstValue (val)
    setAgainstValue (val)
    getAgainstValue () → Expression
    returns Expression
    setSearchModifier (val)
    String val
    getSearchModifier () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withMatchColumns (matchColumns) → FullTextSearch
    ExpressionList matchColumns
    withAgainstValue (againstValue) → FullTextSearch
    StringValue againstValue
    withSearchModifier (searchModifier) → FullTextSearch
    String searchModifier
    addMatchColumns (matchColumns) → FullTextSearch
    Column matchColumns
    addMatchColumns (matchColumns) → FullTextSearch
    Collection matchColumns

    GeometryDistance

    extends: ComparisonOperator

    GeometryDistance ()
    GeometryDistance (operator)
    String operator
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    GreaterThan

    extends: ComparisonOperator

    GreaterThan ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    withLeftExpression (arg0) → GreaterThan
    returns GreaterThan
    @Override
    withRightExpression (arg0) → GreaterThan
    returns GreaterThan
    @Override
    withOldOracleJoinSyntax (arg0) → GreaterThan
    int arg0
    returns GreaterThan
    @Override
    withOraclePriorPosition (arg0) → GreaterThan
    int arg0
    returns GreaterThan

    GreaterThanEquals

    extends: ComparisonOperator

    GreaterThanEquals ()
    GreaterThanEquals (operator)
    String operator
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    withLeftExpression (arg0) → GreaterThanEquals
    @Override
    withRightExpression (arg0) → GreaterThanEquals
    @Override
    withOldOracleJoinSyntax (arg0) → GreaterThanEquals
    int arg0
    @Override
    withOraclePriorPosition (arg0) → GreaterThanEquals
    int arg0

    InExpression

    extends: ASTNodeAccessImpl implements: Expression, SupportsOldOracleJoinSyntax

    InExpression ()
    InExpression (leftExpression, rightExpression)
    Expression leftExpression
    Expression rightExpression
    @Override
    setOldOracleJoinSyntax (oldOracleJoinSyntax)
    int oldOracleJoinSyntax
    @Override
    getOldOracleJoinSyntax () → int
    returns int
    getLeftExpression () → Expression
    returns Expression
    withLeftExpression (expression) → InExpression
    Expression expression
    returns InExpression
    setLeftExpression (expression)
    Expression expression
    isGlobal () → boolean
    returns boolean
    setGlobal (b) → InExpression
    boolean b
    returns InExpression
    isNot () → boolean
    returns boolean
    setNot (b)
    boolean b
    getRightExpression () → Expression
    returns Expression
    setRightExpression (rightExpression)
    Expression rightExpression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    @Override
    getOraclePriorPosition () → int
    returns int
    @Override
    setOraclePriorPosition (priorPosition)
    int priorPosition
    withRightExpression (rightExpression) → InExpression
    Expression rightExpression
    returns InExpression
    @Override
    withOldOracleJoinSyntax (oldOracleJoinSyntax) → InExpression
    int oldOracleJoinSyntax
    returns InExpression
    @Override
    withOraclePriorPosition (priorPosition) → InExpression
    int priorPosition
    returns InExpression
    withGlobal (global) → InExpression
    boolean global
    returns InExpression
    withNot (not) → InExpression
    boolean not
    returns InExpression
    getLeftExpression (type) → E
    Class type
    returns E
    getRightExpression (type) → E
    Class type
    returns E

    IsBooleanExpression

    extends: ASTNodeAccessImpl implements: Expression

    IsBooleanExpression ()
    getLeftExpression () → Expression
    returns Expression
    isNot () → boolean
    returns boolean
    setLeftExpression (expression)
    Expression expression
    setNot (b)
    boolean b
    isTrue () → boolean
    returns boolean
    setIsTrue (isTrue)
    boolean isTrue
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withIsTrue (isTrue) → IsBooleanExpression
    boolean isTrue
    withLeftExpression (leftExpression) → IsBooleanExpression
    Expression leftExpression
    withNot (not) → IsBooleanExpression
    boolean not
    getLeftExpression (type) → E
    Class type
    returns E

    IsDistinctExpression

    extends: BinaryExpression

    IsDistinctExpression ()
    isNot () → boolean
    returns boolean
    setNot (b)
    boolean b
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    toString () → String
    returns String

    IsNullExpression

    extends: ASTNodeAccessImpl implements: Expression

    IsNullExpression ()
    getLeftExpression () → Expression
    returns Expression
    isNot () → boolean
    returns boolean
    setLeftExpression (expression)
    Expression expression
    setNot (b)
    boolean b
    isUseIsNull () → boolean
    returns boolean
    setUseIsNull (useIsNull)
    boolean useIsNull
    isUseNotNull () → boolean
    returns boolean
    setUseNotNull (useNotNull) → IsNullExpression
    boolean useNotNull
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withUseIsNull (useIsNull) → IsNullExpression
    boolean useIsNull
    withLeftExpression (leftExpression) → IsNullExpression
    Expression leftExpression
    withNot (not) → IsNullExpression
    boolean not
    getLeftExpression (type) → E
    Class type
    returns E

    JsonOperator

    extends: BinaryExpression

    JsonOperator (op)
    String op
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → JsonOperator
    returns JsonOperator
    @Override
    withRightExpression (arg0) → JsonOperator
    returns JsonOperator

    LikeExpression

    extends: BinaryExpression

    LikeExpression ()
    isNot () → boolean
    returns boolean
    setNot (b)
    boolean b
    isUseBinary () → boolean
    returns boolean
    setUseBinary (useBinary) → LikeExpression
    boolean useBinary
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Deprecated,| @Override
    getStringExpression () → String
    returns String
    @Override
    toString () → String
    returns String
    getEscape () → Expression
    returns Expression
    setEscape (escapeExpression)
    Expression escapeExpression
    @Deprecated
    isCaseInsensitive () → boolean
    returns boolean
    @Deprecated
    setCaseInsensitive (caseInsensitive)
    boolean caseInsensitive
    getLikeKeyWord () → KeyWord
    returns KeyWord
    setLikeKeyWord (likeKeyWord) → LikeExpression
    KeyWord likeKeyWord
    setLikeKeyWord (likeKeyWord) → LikeExpression
    String likeKeyWord
    withEscape (escape) → LikeExpression
    Expression escape
    @Deprecated
    withCaseInsensitive (caseInsensitive) → LikeExpression
    boolean caseInsensitive
    withNot (not) → LikeExpression
    boolean not
    @Override
    withLeftExpression (arg0) → LikeExpression
    @Override
    withRightExpression (arg0) → LikeExpression

    Matches

    extends: OldOracleJoinBinaryExpression

    Matches ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → Matches
    returns Matches
    @Override
    withRightExpression (arg0) → Matches
    returns Matches
    @Override
    withOldOracleJoinSyntax (oldOracleJoinSyntax) → Matches
    int oldOracleJoinSyntax
    returns Matches
    @Override
    withOraclePriorPosition (oraclePriorPosition) → Matches
    int oraclePriorPosition
    returns Matches

    MemberOfExpression

    extends: ASTNodeAccessImpl implements: Expression

    MemberOfExpression (leftExpression, rightExpression)
    Expression leftExpression
    Expression rightExpression
    getLeftExpression () → Expression
    returns Expression
    setLeftExpression (leftExpression) → MemberOfExpression
    Expression leftExpression
    getRightExpression () → Expression
    returns Expression
    setRightExpression (rightExpression) → MemberOfExpression
    Expression rightExpression
    isNot () → boolean
    returns boolean
    setNot (not) → MemberOfExpression
    boolean not
    @Override
    toString () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    MinorThan

    extends: ComparisonOperator

    MinorThan ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    withLeftExpression (arg0) → MinorThan
    returns MinorThan
    @Override
    withRightExpression (arg0) → MinorThan
    returns MinorThan
    @Override
    withOldOracleJoinSyntax (arg0) → MinorThan
    int arg0
    returns MinorThan
    @Override
    withOraclePriorPosition (arg0) → MinorThan
    int arg0
    returns MinorThan

    MinorThanEquals

    extends: ComparisonOperator

    MinorThanEquals ()
    MinorThanEquals (operator)
    String operator
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    withLeftExpression (arg0) → MinorThanEquals
    @Override
    withRightExpression (arg0) → MinorThanEquals
    @Override
    withOldOracleJoinSyntax (arg0) → MinorThanEquals
    int arg0
    @Override
    withOraclePriorPosition (arg0) → MinorThanEquals
    int arg0

    NamedExpressionList

    extends: ExpressionList

    A list of named expressions, as in as in select substr(‘xyzzy’ from 2 for 3)
    NamedExpressionList ()
    getNames () → List
    returns List
    setNames (list)
    List list
    @Override
    toString () → String
    returns String
    withNames (names) → NamedExpressionList
    List names
    addNames (names) → NamedExpressionList
    String names
    addNames (names) → NamedExpressionList
    Collection names

    NotEqualsTo

    extends: ComparisonOperator

    NotEqualsTo ()
    NotEqualsTo (operator)
    String operator
    NotEqualsTo (left, right)
    @Override
    withLeftExpression (expression) → NotEqualsTo
    Expression expression
    returns NotEqualsTo
    @Override
    withRightExpression (expression) → NotEqualsTo
    Expression expression
    returns NotEqualsTo
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    withOldOracleJoinSyntax (arg0) → NotEqualsTo
    int arg0
    returns NotEqualsTo
    @Override
    withOraclePriorPosition (arg0) → NotEqualsTo
    int arg0
    returns NotEqualsTo

    OldOracleJoinBinaryExpression

    extends: BinaryExpression implements: SupportsOldOracleJoinSyntax provides: ComparisonOperator, Matches

    OldOracleJoinBinaryExpression ()
    @Override
    setOldOracleJoinSyntax (oldOracleJoinSyntax)
    int oldOracleJoinSyntax
    @Override
    toString () → String
    returns String
    @Override
    getOldOracleJoinSyntax () → int
    returns int
    @Override
    getOraclePriorPosition () → int
    returns int
    @Override
    setOraclePriorPosition (oraclePriorPosition)
    int oraclePriorPosition
    withOldOracleJoinSyntax (oldOracleJoinSyntax) → OldOracleJoinBinaryExpression
    int oldOracleJoinSyntax
    withOraclePriorPosition (oraclePriorPosition) → OldOracleJoinBinaryExpression
    int oraclePriorPosition
    @Override
    withLeftExpression (arg0) → OldOracleJoinBinaryExpression
    @Override
    withRightExpression (arg0) → OldOracleJoinBinaryExpression

    ParenthesedExpressionList

    extends: ExpressionList provides: RowConstructor

    ParenthesedExpressionList ()
    ParenthesedExpressionList (expressions)
    ExpressionList expressions
    ParenthesedExpressionList (expressions)
    T expressions
    ParenthesedExpressionList (expressions)
    Collection expressions
    from (expressions) → ParenthesedExpressionList
    @Override
    toString () → String
    returns String

    RegExpMatchOperator

    extends: BinaryExpression

    RegExpMatchOperator (operatorType)
    RegExpMatchOperatorType operatorType
    getOperatorType () → RegExpMatchOperatorType
    returns RegExpMatchOperatorType
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → RegExpMatchOperator
    @Override
    withRightExpression (arg0) → RegExpMatchOperator

    SimilarToExpression

    extends: BinaryExpression

    SimilarToExpression ()
    isNot () → boolean
    returns boolean
    setNot (b)
    boolean b
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    toString () → String
    returns String
    getEscape () → String
    returns String
    setEscape (escape)
    String escape
    withEscape (escape) → SimilarToExpression
    String escape
    withNot (not) → SimilarToExpression
    boolean not
    @Override
    withLeftExpression (arg0) → SimilarToExpression
    @Override
    withRightExpression (arg0) → SimilarToExpression

    TSQLLeftJoin

    extends: ComparisonOperator

    TSQLLeftJoin ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    TSQLRightJoin

    extends: ComparisonOperator

    TSQLRightJoin ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    SupportsOldOracleJoinSyntax

    provides: InExpression, OldOracleJoinBinaryExpression,

    getOldOracleJoinSyntax () → int
    returns int
    setOldOracleJoinSyntax (oldOracleJoinSyntax)
    int oldOracleJoinSyntax
    withOldOracleJoinSyntax (oldOracleJoinSyntax) → SupportsOldOracleJoinSyntax
    int oldOracleJoinSyntax
    getOraclePriorPosition () → int
    returns int
    setOraclePriorPosition (priorPosition)
    int priorPosition
    withOraclePriorPosition (priorPosition) → SupportsOldOracleJoinSyntax
    int priorPosition

    parser

    ASTNodeAccessImpl

    extends: Object implements: ASTNodeAccess provides: AllColumns, AllValue, AnalyticExpression, AnyComparisonExpression, ArrayConstructor, ArrayExpression, Between, BinaryExpression, CaseExpression, CastExpression, CollateExpression, Column, ConnectByRootOperator, DateTimeLiteralExpression, DateValue, DoubleValue, ExistsExpression, ExtractExpression, FilterOverImpl, ForClause, FullTextSearch, Function, HexValue, InExpression, IntervalExpression, IsBooleanExpression, IsNullExpression, JdbcNamedParameter, JdbcParameter, Join, JsonExpression, JsonFunction, KSQLJoinWindow, KSQLWindow, KeepExpression, Limit, LongValue, MemberOfExpression, MultipleExpression, MySQLGroupConcat, NextValExpression, NotExpression, NullValue, NumericBind, OracleHierarchicalExpression, OracleHint, OracleNamedFunctionParameter, OverlapsCondition, Parenthesis, RangeExpression, RowGetExpression, Select, SelectItem, Sequence, SetOperation, SignedExpression, StringValue, Synonym, Table, TimeKeyExpression, TimeValue, TimestampValue, TimezoneExpression, TranscodingFunction, TrimFunction, UserVariable, VariableAssignment, WhenClause, XMLSerializeExpr

    ASTNodeAccessImpl ()
    @Override
    getASTNode () → SimpleNode
    returns SimpleNode
    @Override
    setASTNode (node)
    SimpleNode node
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder

    AbstractJSqlParser

    extends: Object

    AbstractJSqlParser ()
    withSquareBracketQuotation (allowSquareBracketQuotation) → P
    boolean allowSquareBracketQuotation
    returns P
    withAllowComplexParsing (allowComplexParsing) → P
    boolean allowComplexParsing
    returns P
    withUnsupportedStatements (allowUnsupportedStatements) → P
    boolean allowUnsupportedStatements
    returns P
    withTimeOut (timeOutMillSeconds) → P
    long timeOutMillSeconds
    returns P
    withBackslashEscapeCharacter (allowBackslashEscapeCharacter) → P
    boolean allowBackslashEscapeCharacter
    returns P
    withFeature (f, enabled) → P
    Feature f
    boolean enabled
    returns P
    withFeature (f, value) → P
    Feature f
    long value
    returns P
    getConfiguration () → FeatureConfiguration
    me () → P
    returns P
    getAsBoolean (f) → boolean
    Feature f
    returns boolean
    getAsLong (f) → Long
    Feature f
    returns Long
    setErrorRecovery (errorRecovery)
    boolean errorRecovery
    getParseErrors () → List
    returns List

    BaseToken

    extends: Object

    BaseToken ()

    CCJSqlParserManager

    extends: Object implements: JSqlParser

    CCJSqlParserManager ()
    @Override
    parse (statementReader) → Statement
    Reader statementReader
    returns Statement

    CCJSqlParserUtil

    extends: Object

    Toolfunctions to start and use JSqlParser.
    parse (statementReader) → Statement
    Reader statementReader
    returns Statement
    parse (sql) → Statement
    String sql
    returns Statement
    parse (sql, consumer) → Statement
    Parses an sql statement while allowing via consumer to configure the used parser before. For instance to activate SQLServer bracket quotation on could use: {@code CCJSqlParserUtil.parse(“select * from [mytable]”, parser -> parser.withSquareBracketQuotation(true)); }
    String sql
    Consumer consumer
    returns Statement |
    parse (sql, executorService, consumer) → Statement
    String sql
    ExecutorService executorService
    Consumer consumer
    returns Statement
    newParser (sql) → CCJSqlParser
    String sql
    returns CCJSqlParser
    newParser (is) → CCJSqlParser
    InputStream is
    returns CCJSqlParser
    newParser (is, encoding) → CCJSqlParser
    InputStream is
    String encoding
    returns CCJSqlParser
    parseAST (sql) → Node
    String sql
    returns Node
    parse (is) → Statement
    InputStream is
    returns Statement
    parse (is, encoding) → Statement
    InputStream is
    String encoding
    returns Statement
    parseExpression (expression) → Expression
    String expression
    returns Expression
    parseExpression (expression, allowPartialParse) → Expression
    String expression
    boolean allowPartialParse
    returns Expression
    @SuppressWarnings
    parseExpression (expressionStr, allowPartialParse, consumer) → Expression
    String expressionStr
    boolean allowPartialParse
    Consumer consumer
    returns Expression
    parseCondExpression (condExpr) → Expression
    Parse an conditional expression. This is the expression after a where clause. Partial parsing is enabled.
    String condExpr
    returns Expression | the expression parsed
    parseCondExpression (condExpr, allowPartialParse) → Expression
    Parse an conditional expression. This is the expression after a where clause.
    String condExpr
    boolean allowPartialParse | allowPartialParse false: needs the whole string to be processed.
    returns Expression | the expression parsed
    @SuppressWarnings
    parseCondExpression (conditionalExpressionStr, allowPartialParse, consumer) → Expression
    String conditionalExpressionStr
    boolean allowPartialParse
    Consumer consumer
    returns Expression
    parseStatement (parser, executorService) → Statement
    CCJSqlParser parser | parser the Parser armed with a Statement text
    ExecutorService executorService | executorService the Executor Service for parsing within a Thread
    returns Statement | the parsed Statement
    parseStatements (sqls) → Statements
    Parse a statement list.
    String sqls
    returns Statements | the statements parsed
    parseStatements (sqls, consumer) → Statements
    String sqls
    Consumer consumer
    returns Statements
    parseStatements (sqls, executorService, consumer) → Statements
    Parse a statement list.
    String sqls
    ExecutorService executorService
    Consumer consumer
    returns Statements | the statements parsed
    parseStatements (parser, executorService) → Statements
    CCJSqlParser parser | parser the Parser armed with a Statement text
    ExecutorService executorService | executorService the Executor Service for parsing within a Thread
    returns Statements | the Statements (representing a List of single statements)
    streamStatements (listener, is, encoding)
    InputStream is
    String encoding
    getNestingDepth (sql) → int
    String sql
    returns int
    getUnbalancedPosition (text) → int
    String text
    returns int

    ParserKeywordsUtils

    extends: Object

    ParserKeywordsUtils ()
    @SuppressWarnings
    getReservedKeywords (restriction) → List
    int restriction
    returns List
    main (args)
    String args | args with: Grammar File, Keyword Documentation File
    getAllKeywordsUsingRegex (file) → TreeSet
    File file
    returns TreeSet
    buildGrammarForRelObjectNameWithoutValue (file)
    File file
    buildGrammarForRelObjectName (file)
    File file
    getAllKeywords (file) → TreeSet
    File file
    returns TreeSet
    rightPadding (input, ch, length) → String
    String input
    char ch
    int length
    returns String
    writeKeywordsDocumentationFile (file)
    File file

    SimpleCharStream

    extends: Object

    SimpleCharStream (dstream, startline, startcolumn, buffersize)
    Constructor
    Provider dstream
    int startline
    int startcolumn
    int buffersize
    SimpleCharStream (dstream, startline, startcolumn)
    Constructor
    Provider dstream
    int startline
    int startcolumn
    SimpleCharStream (dstream)
    Constructor
    Provider dstream
    setTabSize (i)
    int i
    getTabSize () → int
    returns int
    getAbsoluteTokenBegin () → int
    returns int
    boolean wrapAround
    returns void
    returns void
    BeginToken () → char
    Start.
    returns char | the character read
    char c
    returns void
    readChar () → char
    Read a character.
    returns char | the character read
    @Deprecated
    getColumn () → int
    returns int | the column
    @Deprecated
    getLine () → int
    returns int | the line
    getEndColumn () → int
    returns int | get token end column number.
    getEndLine () → int
    returns int | get token end line number.
    getBeginColumn () → int
    returns int | get token beginning column number.
    getBeginLine () → int
    returns int | get token beginning line number.
    backup (amount)
    Backup a number of characters.
    int amount
    ReInit (dstream, startline, startcolumn, buffersize)
    Reinitialise.
    Provider dstream
    int startline
    int startcolumn
    int buffersize
    ReInit (dstream, startline, startcolumn)
    Reinitialise.
    Provider dstream
    int startline
    int startcolumn
    ReInit (dstream)
    Reinitialise.
    Provider dstream
    GetImage () → String
    returns String | get token literal value.
    GetSuffix (len) → char
    int len
    returns char | get the suffix.
    Done ()
    Reset buffer when finished.
    adjustBeginLineColumn (newLine, newCol)
    Method to adjust line and column numbers for the start of a token.
    int newLine
    int newCol

    ASTNodeAccess

    implements: Serializable provides: ASTNodeAccessImpl, Expression,

    getASTNode () → SimpleNode
    returns SimpleNode
    setASTNode (node)
    SimpleNode node

    JSqlParser

    provides: CCJSqlParserManager,

    parse (statementReader) → Statement
    Reader statementReader
    returns Statement

    StatementListener

    provides:

    accept (statement)
    Statement statement

    parser.feature

    Feature

    [select, selectGroupBy, selectGroupByGroupingSets, selectHaving, selectInto, limit, limitNull, limitAll, limitOffset, offset, offsetParam, fetch, fetchFirst, fetchNext, join, joinOuterSimple, joinSimple, joinRight, joinNatural, joinFull, joinLeft, joinCross, joinOuter, joinSemi, joinInner, joinStraight, joinApply, joinWindow, joinUsingColumns, skip, first, top, optimizeFor, selectUnique, distinct, distinctOn, orderBy, orderByNullOrdering, selectForUpdate, selectForShare, selectForKeyShare, selectForNoKeyUpdate, selectForUpdateOfTable, selectForUpdateWait, selectForUpdateNoWait, selectForUpdateSkipLocked, insert, insertFromSelect, insertModifierPriority, insertModifierIgnore, insertUseSet, insertUseDuplicateKeyUpdate, insertReturningAll, insertReturningExpressionList, insertValues, values, tableStatement, update, updateFrom, updateJoins, updateUseSelect, updateOrderBy, updateLimit, updateReturning, delete, deleteJoin, deleteTables, deleteLimit, deleteOrderBy, deleteReturningExpressionList, upsert, merge, alterTable, alterSequence, alterView, refreshMaterializedView, refreshMaterializedWithDataView, refreshMaterializedWithNoDataView, alterViewReplace, alterIndex, analyze, truncate, execute, executeExec, executeCall, executeExecute, executeStatement, executeStatementImmediate, executeUsing, replace, drop, dropTable, dropIndex, dropView, dropSchema, dropSequence, dropTableIfExists, dropIndexIfExists, dropViewIfExists, dropSchemaIfExists, dropSequenceIfExists, createSchema, createView, createViewForce, createViewTemporary, createOrReplaceView, createViewMaterialized, createViewWithComment, createTable, createTableUnlogged, createTableCreateOptionStrings, createTableTableOptionStrings, createTableIfNotExists, createTableRowMovement, createTableFromSelect, createIndex, createSequence, createSynonym, createTrigger, commit, comment, commentOnTable, commentOnColumn, commentOnView, describe, desc, explain, show, showTables, showColumns, showIndex, use, grant, function, createFunction, createProcedure, functionalStatement, block, declare, set, reset, pivot, unpivot, pivotXml, setOperation, setOperationUnion, setOperationIntersect, setOperationExcept, setOperationMinus, withItem, withItemRecursive, lateralSubSelect, valuesList, tableFunction, jdbcParameter, jdbcNamedParameter, exprLike, exprSimilarTo, kSqlWindow, oracleOldJoinSyntax, oraclePriorPosition, oracleHint, oracleHierarchicalExpression, oracleOrderBySiblings, mySqlHintStraightJoin, mysqlSqlCacheFlag, mysqlCalcFoundRows, selectForXmlPath, allowSquareBracketQuotation, allowPostgresSpecificSyntax, allowComplexParsing, allowUnsupportedStatements, timeOut, allowBackslashEscapeCharacter]

    FeatureConfiguration

    extends: Object

    FeatureConfiguration ()
    setValue (feature, value) → FeatureConfiguration
    Feature feature
    Object value
    returns FeatureConfiguration | this
    getValue (feature) → Object
    Feature feature
    returns Object | the configured feature value - can be null
    getAsBoolean (f) → boolean
    Feature f
    returns boolean
    getAsLong (f) → Long
    Feature f
    returns Long
    getAsString (f) → String
    Feature f
    returns String

    FeatureSet

    provides: FeatureSetValidation, ModifyableFeatureSet,

    getFeatures () → Set
    returns Set
    contains (feature) → boolean
    Feature feature
    returns boolean | true if the feature is identical to one of the features contained in this set, false otherwise
    getFeaturesClone () → Set
    returns Set | a new HashSet with a copy of supported features
    getNotContained (features) → Set
    Collection features
    returns Set | all features within this feature set which are not contained in given set
    retainAll (features) → Set
    Collection features
    returns Set | all features within this feature set which are contained in given set too.

    ModifyableFeatureSet

    implements: FeatureSet provides: FeaturesAllowed,

    add (featureSets) → ModifyableFeatureSet
    FeatureSet featureSets
    returns ModifyableFeatureSet | this
    add (features) → ModifyableFeatureSet
    Feature features
    returns ModifyableFeatureSet | this
    add (features) → ModifyableFeatureSet
    Collection features
    returns ModifyableFeatureSet | this
    remove (featureSets) → ModifyableFeatureSet
    FeatureSet featureSets
    returns ModifyableFeatureSet | this
    remove (features) → ModifyableFeatureSet
    Feature features
    returns ModifyableFeatureSet | this
    remove (features) → ModifyableFeatureSet
    Collection features
    returns ModifyableFeatureSet | this
    unmodifyable () → FeatureSet
    makes the inner Feature-set unmodifiable
    returns FeatureSet | this

    schema

    Sequence.ParameterType

    [INCREMENT_BY, START_WITH, RESTART_WITH, MAXVALUE, NOMAXVALUE, MINVALUE, NOMINVALUE, CYCLE, NOCYCLE, CACHE, NOCACHE, ORDER, NOORDER, KEEP, NOKEEP, SESSION, GLOBAL]

    The available parameters to a sequence

    Column

    extends: ASTNodeAccessImpl implements: Expression, MultiPartName

    A column. It can have the table name it belongs to.
    Column ()
    Column (table, columnName)
    Table table
    String columnName
    Column (nameParts)
    List nameParts
    Column (columnName)
    String columnName
    getArrayConstructor () → ArrayConstructor
    setArrayConstructor (arrayConstructor) → Column
    ArrayConstructor arrayConstructor
    returns Column
    getTable () → Table
    Retrieve the information regarding the Table this Column does belong to, if any can be inferred.
    The inference is based only on local information, and not on the whole SQL command. For example, consider the following query:
    SELECT x FROM Foo
    Given the Column called x, this method would return null, and not the info about the table Foo. On the other hand, consider:
    SELECT t.x FROM Foo t
    Here, we will get a Table object for a table called t. But because the inference is local, such object will not know that t is just an alias for Foo.
    returns Table | an instance of net.sf.jsqlparser.schema.Table representing the table this column does belong to, if it can be inferred. Can be null.
    setTable (table)
    Table table
    getColumnName () → String
    returns String
    setColumnName (string)
    String string
    @Override
    getFullyQualifiedName () → String
    returns String
    getFullyQualifiedName (aliases) → String
    boolean aliases
    returns String
    @Deprecated
    getName (aliases) → String
    boolean aliases
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withTable (table) → Column
    Table table
    returns Column
    withColumnName (columnName) → Column
    String columnName
    returns Column
    withCommentText (commentText) → Column
    String commentText
    returns Column
    setCommentText (commentText)
    String commentText
    getCommentText () → String
    returns String

    Database

    extends: Object implements: MultiPartName

    Database (databaseName)
    String databaseName
    Database (server, databaseName)
    Server server
    String databaseName
    getServer () → Server
    returns Server
    setServer (server)
    Server server
    getDatabaseName () → String
    returns String
    setDatabaseName (databaseName)
    String databaseName
    @Override
    getFullyQualifiedName () → String
    returns String
    @Override
    toString () → String
    returns String
    withServer (server) → Database
    Server server
    returns Database
    withDatabaseName (databaseName) → Database
    String databaseName
    returns Database

    Sequence

    extends: ASTNodeAccessImpl implements: MultiPartName

    Represents the database type for a SEQUENCE
    Sequence ()
    Sequence (partItems)
    List partItems
    setParameters (parameters)
    List parameters
    getParameters () → List
    returns List
    getDatabase () → Database
    returns Database
    setDatabase (database)
    Database database
    withDatabase (database) → Sequence
    Database database
    returns Sequence
    getSchemaName () → String
    returns String
    setSchemaName (string)
    String string
    withSchemaName (string) → Sequence
    String string
    returns Sequence
    getName () → String
    returns String
    setName (string)
    String string
    withName (string) → Sequence
    String string
    returns Sequence
    @Override
    getFullyQualifiedName () → String
    returns String
    @Override
    toString () → String
    returns String
    withParameters (parameters) → Sequence
    List parameters
    returns Sequence
    addParameters (parameters) → Sequence
    Parameter parameters
    returns Sequence
    addParameters (parameters) → Sequence
    Collection parameters
    returns Sequence

    Sequence.Parameter

    extends: Object

    Represents a parameter when declaring a sequence
    Parameter (option)
    ParameterType option
    getValue () → Long
    returns Long
    setValue (value)
    Long value
    formatParameter () → String
    returns String
    withValue (value) → Parameter
    Long value
    returns Parameter

    Server

    extends: Object implements: MultiPartName

    Server (serverAndInstanceName)
    String serverAndInstanceName
    Server (serverName, instanceName)
    String serverName
    String instanceName
    getServerName () → String
    returns String
    setServerName (serverName)
    String serverName
    getInstanceName () → String
    returns String
    setInstanceName (instanceName)
    String instanceName
    @Override
    getFullyQualifiedName () → String
    returns String
    @Override
    toString () → String
    returns String
    withServerName (serverName) → Server
    String serverName
    returns Server
    withInstanceName (instanceName) → Server
    String instanceName
    returns Server

    Synonym

    extends: ASTNodeAccessImpl implements: MultiPartName

    Synonym ()
    Synonym (partItems)
    List partItems
    getDatabase () → Database
    returns Database
    setDatabase (database)
    Database database
    withDatabase (database) → Synonym
    Database database
    returns Synonym
    getSchemaName () → String
    returns String
    setSchemaName (string)
    String string
    withSchemaName (string) → Synonym
    String string
    returns Synonym
    getName () → String
    returns String
    setName (string)
    String string
    withName (string) → Synonym
    String string
    returns Synonym
    @Override
    getFullyQualifiedName () → String
    returns String
    @Override
    toString () → String
    returns String

    Table

    extends: ASTNodeAccessImpl implements: FromItem, MultiPartName

    A table. It can have an alias and the schema name it belongs to.
    Table ()
    Table (name)
    String name
    Table (schemaName, name)
    String schemaName
    String name
    Table (database, schemaName, name)
    Database database
    String schemaName
    String name
    Table (partItems)
    List partItems
    getDatabase () → Database
    returns Database
    withDatabase (database) → Table
    Database database
    returns Table
    setDatabase (database)
    Database database
    getSchemaName () → String
    returns String
    withSchemaName (schemaName) → Table
    String schemaName
    returns Table
    setSchemaName (schemaName)
    String schemaName
    getName () → String
    returns String
    getDBLinkName () → String
    returns String
    withName (name) → Table
    String name
    returns Table
    setName (name)
    String name
    @Override
    getAlias () → Alias
    returns Alias
    @Override
    setAlias (alias)
    Alias alias
    @Override
    getFullyQualifiedName () → String
    returns String
    @Override
    accept (fromItemVisitor)
    FromItemVisitor fromItemVisitor
    accept (intoTableVisitor)
    IntoTableVisitor intoTableVisitor
    @Override
    getPivot () → Pivot
    returns Pivot
    @Override
    setPivot (pivot)
    Pivot pivot
    @Override
    getUnPivot () → UnPivot
    returns UnPivot
    @Override
    setUnPivot (unpivot)
    UnPivot unpivot
    getIndexHint () → MySQLIndexHint
    withHint (hint) → Table
    returns Table
    setHint (hint)
    getSqlServerHints () → SQLServerHints
    setSqlServerHints (sqlServerHints)
    SQLServerHints sqlServerHints
    getSampleClause () → SampleClause
    returns SampleClause
    setSampleClause (sampleClause) → Table
    SampleClause sampleClause
    returns Table
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    @Override
    withUnPivot (unpivot) → Table
    UnPivot unpivot
    returns Table
    @Override
    withAlias (alias) → Table
    Alias alias
    returns Table
    @Override
    withPivot (pivot) → Table
    Pivot pivot
    returns Table
    withSqlServerHints (sqlServerHints) → Table
    SQLServerHints sqlServerHints
    returns Table
    getNameParts () → List
    returns List

    MultiPartName

    provides: Column, Database, Sequence, Server, Synonym, Table,

    getFullyQualifiedName () → String
    returns String

    statement

    DeclareType

    [TABLE, AS, TYPE]

    ExplainStatement.OptionType

    [ANALYZE, VERBOSE, COSTS, BUFFERS, FORMAT]

    PurgeObjectType

    [TABLE, INDEX, RECYCLEBIN, DBA_RECYCLEBIN, TABLESPACE]

    ReferentialAction.Action

    [CASCADE, RESTRICT, NO_ACTION, SET_DEFAULT, SET_NULL]

    ReferentialAction.Type

    [DELETE, UPDATE]

    Block

    extends: Object implements: Statement

    Block ()
    getStatements () → Statements
    returns Statements
    setStatements (statements)
    Statements statements
    hasSemicolonAfterEnd () → boolean
    returns boolean
    setSemicolonAfterEnd (hasSemicolonAfterEnd)
    boolean hasSemicolonAfterEnd
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    withStatements (statements) → Block
    Statements statements
    returns Block

    Commit

    extends: Object implements: Statement

    Commit ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    toString () → String
    returns String

    CreateFunctionalStatement

    extends: Object implements: Statement provides: CreateFunction, CreateProcedure

    A base for the declaration of function like statements
    String kind
    String kind
    List functionDeclarationParts
    boolean orReplace
    String kind
    List functionDeclarationParts
    setFunctionDeclarationParts (functionDeclarationParts)
    List functionDeclarationParts
    getFunctionDeclarationParts () → List
    returns List | the declaration parts after CREATE FUNCTION|PROCEDURE
    getKind () → String
    returns String | the kind of functional statement
    setOrReplace (orReplace)
    boolean orReplace
    formatDeclaration () → String
    returns String | a whitespace appended String with the declaration parts with some minimal formatting.
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    toString () → String
    returns String
    withFunctionDeclarationParts (functionDeclarationParts) → CreateFunctionalStatement
    List functionDeclarationParts
    addFunctionDeclarationParts (functionDeclarationParts) → CreateFunctionalStatement
    String functionDeclarationParts
    addFunctionDeclarationParts (functionDeclarationParts) → CreateFunctionalStatement
    Collection functionDeclarationParts

    DeclareStatement

    extends: Object implements: Statement

    DeclareStatement ()
    setUserVariable (userVariable)
    UserVariable userVariable
    getUserVariable () → UserVariable
    returns UserVariable
    @Deprecated
    getType () → DeclareType
    returns DeclareType | the DeclareType
    getDeclareType () → DeclareType
    returns DeclareType | the DeclareType
    getTypeName () → String
    returns String
    setDeclareType (declareType)
    DeclareType declareType
    addType (colDataType, defaultExpr)
    ColDataType colDataType
    Expression defaultExpr
    addType (userVariable, colDataType, defaultExpr)
    UserVariable userVariable
    ColDataType colDataType
    Expression defaultExpr
    addTypeDefExprList (typeDefExpressions) → DeclareStatement
    TypeDefExpr typeDefExpressions
    addTypeDefExprList (typeDefExpressions) → DeclareStatement
    Collection typeDefExpressions
    withTypeDefExprList (typeDefExpressions) → DeclareStatement
    List typeDefExpressions
    setTypeDefExprList (expr)
    List expr
    getTypeDefExprList () → List
    returns List
    addColumnDefinition (colDef)
    setColumnDefinitions (columnDefinitions)
    List columnDefinitions
    getColumnDefinitions () → List
    returns List
    getTypeDefinitions () → List
    returns List
    setTypeName (typeName)
    String typeName
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    withUserVariable (userVariable) → DeclareStatement
    UserVariable userVariable
    withTypeName (typeName) → DeclareStatement
    String typeName
    withDeclareType (declareType) → DeclareStatement
    DeclareType declareType
    withColumnDefinitions (columnDefinitions) → DeclareStatement
    List columnDefinitions
    addColumnDefinitions (statements) → DeclareStatement
    ColumnDefinition statements
    addColumnDefinitions (columnDefinitions) → DeclareStatement
    Collection columnDefinitions

    DeclareStatement.TypeDefExpr

    extends: Object implements: Serializable

    TypeDefExpr (colDataType, defaultExpr)
    ColDataType colDataType
    Expression defaultExpr
    TypeDefExpr (userVariable, colDataType, defaultExpr)
    UserVariable userVariable
    ColDataType colDataType
    Expression defaultExpr

    DescribeStatement

    extends: Object implements: Statement

    DescribeStatement ()
    DescribeStatement (table)
    Table table
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    withTable (table) → DescribeStatement
    Table table
    getDescribeType () → String
    returns String
    setDescribeType (describeType) → DescribeStatement
    String describeType

    ExplainStatement

    extends: Object implements: Statement

    An EXPLAIN statement
    ExplainStatement ()
    ExplainStatement (select)
    Select select
    getTable () → Table
    returns Table
    setTable (table) → ExplainStatement
    Table table
    getStatement () → Select
    returns Select
    setStatement (select)
    Select select
    getOptions () → LinkedHashMap
    returns LinkedHashMap
    addOption (option)
    Option option
    getOption (optionType) → Option
    Returns the first option that matches this optionType
    OptionType optionType | optionType the option type to retrieve an Option for
    returns Option | an option of that type, or null. In case of duplicate options, the first found option will be returned.
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor

    ExplainStatement.Option

    extends: Object implements: Serializable

    Option (type)
    OptionType type
    getType () → OptionType
    returns OptionType
    getValue () → String
    returns String
    setValue (value)
    String value
    formatOption () → String
    returns String
    withValue (value) → Option
    String value
    returns Option

    IfElseStatement

    extends: Object implements: Statement

    IfElseStatement (condition, ifStatement)
    Expression condition
    Statement ifStatement
    getCondition () → Expression
    returns Expression
    getIfStatement () → Statement
    returns Statement
    setElseStatement (elseStatement)
    Statement elseStatement
    getElseStatement () → Statement
    returns Statement
    setUsingSemicolonForElseStatement (usingSemicolonForElseStatement)
    boolean usingSemicolonForElseStatement
    isUsingSemicolonForElseStatement () → boolean
    returns boolean
    setUsingSemicolonForIfStatement (usingSemicolonForIfStatement)
    boolean usingSemicolonForIfStatement
    isUsingSemicolonForIfStatement () → boolean
    returns boolean
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor

    OutputClause

    extends: Object implements: Serializable

    T-SQL Output Clause
    OutputClause (selectItemList, tableVariable, outputTable, columnList)
    List selectItemList
    UserVariable tableVariable
    Table outputTable
    List columnList
    getSelectItemList () → List
    returns List
    setSelectItemList (selectItemList)
    List selectItemList
    getTableVariable () → UserVariable
    returns UserVariable
    setTableVariable (tableVariable)
    UserVariable tableVariable
    getOutputTable () → Table
    returns Table
    setOutputTable (outputTable)
    Table outputTable
    getColumnList () → List
    returns List
    setColumnList (columnList)
    List columnList
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    PurgeStatement

    extends: Object implements: Statement

    PurgeStatement (table)
    Table table
    PurgeStatement (index)
    Index index
    PurgeStatement (purgeObjectType)
    PurgeObjectType purgeObjectType
    PurgeStatement (purgeObjectType, tableSpaceName, userName)
    PurgeObjectType purgeObjectType
    String tableSpaceName
    String userName
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @SuppressWarnings
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    getUserName () → String
    returns String
    setUserName (userName)
    String userName
    getPurgeObjectType () → PurgeObjectType
    returns PurgeObjectType
    getObject () → Object
    returns Object

    ReferentialAction

    extends: Object implements: Serializable

    ReferentialAction ()
    ReferentialAction (type, action)
    Type type
    Action action
    getType () → Type
    returns Type
    setType (type)
    Type type
    withType (type) → ReferentialAction
    Type type
    getAction () → Action
    returns Action
    setAction (action)
    Action action
    withAction (action) → ReferentialAction
    Action action
    @Override
    hashCode () → int
    returns int
    @Override
    toString () → String
    returns String
    @Override
    equals (obj) → boolean
    Object obj
    returns boolean

    ResetStatement

    extends: Object implements: Statement

    ResetStatement ()
    ResetStatement (name)
    String name
    add (name)
    String name
    getName () → String
    returns String
    setName (name)
    String name
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor

    ReturningClause

    extends: ArrayList

    RETURNING clause according to a href= "https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DELETE.html#GUID-156845A5-B626-412B-9F95-8869B988ABD7" Part of UPDATE, INSERT, DELETE statements
    ReturningClause (keyword, selectItems, dataItems)
    Keyword keyword
    List selectItems
    List dataItems
    ReturningClause (keyword, selectItems, dataItems)
    String keyword
    List selectItems
    List dataItems
    ReturningClause (keyword, selectItems)
    Keyword keyword
    List selectItems
    ReturningClause (keyword, selectItems)
    String keyword
    List selectItems
    getKeyword () → Keyword
    returns Keyword
    setKeyword (keyword) → ReturningClause
    Keyword keyword
    getDataItems () → List
    returns List
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    RollbackStatement

    extends: Object implements: Statement

    RollbackStatement ()
    isUsingWorkKeyword () → boolean
    returns boolean
    withUsingWorkKeyword (usingWorkKeyword) → RollbackStatement
    boolean usingWorkKeyword
    setUsingWorkKeyword (usingWorkKeyword)
    boolean usingWorkKeyword
    isUsingSavepointKeyword () → boolean
    returns boolean
    withUsingSavepointKeyword (usingSavepointKeyword) → RollbackStatement
    boolean usingSavepointKeyword
    setUsingSavepointKeyword (usingSavepointKeyword)
    boolean usingSavepointKeyword
    getSavepointName () → String
    returns String
    withSavepointName (savepointName) → RollbackStatement
    String savepointName
    setSavepointName (savepointName)
    String savepointName
    getForceDistributedTransactionIdentifier () → String
    returns String
    withForceDistributedTransactionIdentifier (forceDistributedTransactionIdentifier) → RollbackStatement
    String forceDistributedTransactionIdentifier
    setForceDistributedTransactionIdentifier (forceDistributedTransactionIdentifier)
    String forceDistributedTransactionIdentifier
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor

    SavepointStatement

    extends: Object implements: Statement

    SavepointStatement (savepointName)
    String savepointName
    getSavepointName () → String
    returns String
    setSavepointName (savepointName)
    String savepointName
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor

    SetStatement

    extends: Object implements: Statement

    SetStatement ()
    SetStatement (name, value)
    Object name
    add (name, value, useEqual)
    Object name
    boolean useEqual
    remove (idx)
    int idx
    getCount () → int
    returns int
    isUseEqual (idx) → boolean
    int idx
    returns boolean
    isUseEqual () → boolean
    returns boolean
    withUseEqual (idx, useEqual) → SetStatement
    int idx
    boolean useEqual
    returns SetStatement
    setUseEqual (idx, useEqual) → SetStatement
    int idx
    boolean useEqual
    returns SetStatement
    withUseEqual (useEqual) → SetStatement
    boolean useEqual
    returns SetStatement
    setUseEqual (useEqual) → SetStatement
    boolean useEqual
    returns SetStatement
    getName () → Object
    returns Object
    getName (idx) → Object
    int idx
    returns Object
    setName (name)
    String name
    setName (idx, name)
    int idx
    String name
    getExpressions (idx) → List
    int idx
    returns List
    getExpressions () → List
    returns List
    setExpressions (idx, expressions)
    int idx
    ExpressionList expressions
    setExpressions (expressions)
    ExpressionList expressions
    @Override
    toString () → String
    returns String
    getKeyValuePairs () → List
    returns List
    addKeyValuePairs (keyValuePairs)
    Collection keyValuePairs
    addKeyValuePairs (keyValuePairs)
    NameExpr keyValuePairs
    clear ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getEffectParameter () → String
    returns String
    setEffectParameter (effectParameter)
    String effectParameter
    withEffectParameter (effectParameter) → SetStatement
    String effectParameter
    returns SetStatement

    ShowColumnsStatement

    extends: Object implements: Statement

    ShowColumnsStatement ()
    ShowColumnsStatement (tableName)
    String tableName
    getTableName () → String
    returns String
    setTableName (tableName)
    String tableName
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    withTableName (tableName) → ShowColumnsStatement
    String tableName

    ShowStatement

    extends: Object implements: Statement

    ShowStatement ()
    ShowStatement (name)
    String name
    getName () → String
    returns String
    setName (name)
    String name
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    withName (name) → ShowStatement
    String name

    StatementVisitorAdapter

    extends: Object implements: StatementVisitor

    StatementVisitorAdapter ()
    @Override
    visit (comment)
    Comment comment
    @Override
    visit (commit)
    Commit commit
    @Override
    visit (select)
    Select select
    @Override
    visit (delete)
    Delete delete
    @Override
    visit (update)
    Update update
    @Override
    visit (insert)
    Insert insert
    @Override
    visit (drop)
    Drop drop
    @Override
    visit (truncate)
    Truncate truncate
    @Override
    visit (createIndex)
    CreateIndex createIndex
    @Override
    visit (aThis)
    @Override
    visit (createTable)
    CreateTable createTable
    @Override
    visit (createView)
    CreateView createView
    @Override
    visit (alter)
    Alter alter
    @Override
    visit (stmts)
    @Override
    visit (execute)
    Execute execute
    @Override
    visit (set)
    @Override
    visit (reset)
    @Override
    visit (merge)
    Merge merge
    @Override
    visit (alterView)
    AlterView alterView
    @Override
    visit (upsert)
    Upsert upsert
    @Override
    visit (use)
    @Override
    visit (block)
    Block block
    @Override
    visit (describe)
    @Override
    visit (aThis)
    @Override
    visit (aThis)
    @Override
    visit (set)
    @Override
    visit (set)
    @Override
    visit (showTables)
    @Override
    visit (aThis)
    @Override
    visit (grant)
    Grant grant
    @Override
    visit (createSequence)
    CreateSequence createSequence
    @Override
    visit (alterSequence)
    AlterSequence alterSequence
    @Override
    visit (createFunctionalStatement)
    CreateFunctionalStatement createFunctionalStatement
    @Override
    visit (createSynonym)
    CreateSynonym createSynonym
    @Override
    visit (analyze)
    Analyze analyze
    @Override
    visit (savepointStatement)
    SavepointStatement savepointStatement
    @Override
    visit (rollbackStatement)
    RollbackStatement rollbackStatement
    @Override
    visit (alterSession)
    AlterSession alterSession
    @Override
    visit (ifElseStatement)
    IfElseStatement ifElseStatement
    @Override
    visit (renameTableStatement)
    RenameTableStatement renameTableStatement
    @Override
    visit (purgeStatement)
    PurgeStatement purgeStatement
    @Override
    visit (alterSystemStatement)
    AlterSystemStatement alterSystemStatement
    @Override
    visit (unsupportedStatement)
    UnsupportedStatement unsupportedStatement
    @Override
    visit (materializedView)

    Statements

    extends: ArrayList implements: Serializable

    Statements ()
    @Deprecated
    getStatements () → List
    returns List
    @Deprecated
    setStatements (statements)
    List statements
    accept (statementVisitor)
    StatementVisitor statementVisitor
    get (type, index) → E
    Class type
    int index
    returns E
    @Override
    toString () → String
    returns String

    UnsupportedStatement

    extends: Object implements: Statement

    UnsupportedStatement (declarations)
    List declarations
    UnsupportedStatement (upfront, declarations)
    String upfront
    List declarations
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @SuppressWarnings
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    isEmpty () → boolean
    returns boolean

    UseStatement

    extends: Object implements: Statement

    UseStatement ()
    UseStatement (name)
    String name
    UseStatement (name, hasSchemaKeyword)
    String name
    boolean hasSchemaKeyword
    getName () → String
    returns String
    setName (name)
    String name
    hasSchemaKeyword () → boolean
    returns boolean
    setSchemaKeyword (schemaKeyword)
    boolean schemaKeyword
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    withName (name) → UseStatement
    String name
    returns UseStatement

    Statement

    implements: Model provides: Alter, AlterSequence, AlterSession, AlterSystemStatement, AlterView, Analyze, Block, Comment, Commit, CreateFunctionalStatement, CreateIndex, CreateSchema, CreateSequence, CreateSynonym, CreateTable, CreateView, DeclareStatement, Delete, DescribeStatement, Drop, Execute, ExplainStatement, Grant, IfElseStatement, Insert, Merge, PurgeStatement, RefreshMaterializedViewStatement, RenameTableStatement, ResetStatement, RollbackStatement, SavepointStatement, Select, SetStatement, ShowColumnsStatement, ShowIndexStatement, ShowStatement, ShowTablesStatement, Truncate, UnsupportedStatement, Update, Upsert, UseStatement,

    accept (statementVisitor)
    StatementVisitor statementVisitor

    StatementVisitor

    provides: StatementDeParser, StatementValidator, StatementVisitorAdapter, TablesNamesFinder,

    visit (analyze)
    Analyze analyze
    visit (savepointStatement)
    SavepointStatement savepointStatement
    visit (rollbackStatement)
    RollbackStatement rollbackStatement
    visit (comment)
    Comment comment
    visit (commit)
    Commit commit
    visit (delete)
    Delete delete
    visit (update)
    Update update
    visit (insert)
    Insert insert
    visit (drop)
    Drop drop
    visit (truncate)
    Truncate truncate
    visit (createIndex)
    CreateIndex createIndex
    visit (aThis)
    visit (createTable)
    CreateTable createTable
    visit (createView)
    CreateView createView
    visit (alterView)
    AlterView alterView
    visit (materializedView)
    visit (alter)
    Alter alter
    visit (stmts)
    visit (execute)
    Execute execute
    visit (set)
    visit (reset)
    visit (set)
    visit (showIndex)
    visit (showTables)
    visit (merge)
    Merge merge
    visit (select)
    Select select
    visit (upsert)
    Upsert upsert
    visit (use)
    visit (block)
    Block block
    visit (describe)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (grant)
    Grant grant
    visit (createSequence)
    CreateSequence createSequence
    visit (alterSequence)
    AlterSequence alterSequence
    visit (createFunctionalStatement)
    CreateFunctionalStatement createFunctionalStatement
    visit (createSynonym)
    CreateSynonym createSynonym
    visit (alterSession)
    AlterSession alterSession
    visit (aThis)
    visit (renameTableStatement)
    RenameTableStatement renameTableStatement
    visit (purgeStatement)
    PurgeStatement purgeStatement
    visit (alterSystemStatement)
    AlterSystemStatement alterSystemStatement
    visit (unsupportedStatement)
    UnsupportedStatement unsupportedStatement

    statement.alter

    AlterOperation

    [ADD, ALTER, DROP, DROP_PRIMARY_KEY, DROP_UNIQUE, DROP_FOREIGN_KEY, MODIFY, CHANGE, ALGORITHM, RENAME, RENAME_TABLE, RENAME_INDEX, RENAME_KEY, RENAME_CONSTRAINT, COMMENT, COMMENT_WITH_EQUAL_SIGN, UNSPECIFIC]

    AlterSessionOperation

    [ADVISE_COMMIT, ADVISE_ROLLBACK, ADVISE_NOTHING, CLOSE_DATABASE_LINK, ENABLE_COMMIT_IN_PROCEDURE, DISABLE_COMMIT_IN_PROCEDURE, ENABLE_GUARD, DISABLE_GUARD, ENABLE_PARALLEL_DML, DISABLE_PARALLEL_DML, FORCE_PARALLEL_DML, ENABLE_PARALLEL_DDL, DISABLE_PARALLEL_DDL, FORCE_PARALLEL_DDL, ENABLE_PARALLEL_QUERY, DISABLE_PARALLEL_QUERY, FORCE_PARALLEL_QUERY, ENABLE_RESUMABLE, DISABLE_RESUMABLE, SET]

    AlterSystemOperation

    [ARCHIVE_LOG, CHECKPOINT, CHECK_DATAFILES, DUMP_ACTIVE_SESSION_HISTORY, ENABLE_DISTRIBUTED_RECOVERY, DISABLE_DISTRIBUTED_RECOVERY, ENABLE_RESTRICTED_SESSION, DISABLE_RESTRICTED_SESSION, FLUSH, DISCONNECT_SESSION, KILL_SESSION, SWITCH, SUSPEND, RESUME, QUIESCE, UNQUIESCE, SHUTDOWN, REGISTER, SET, RESET]

    Alter

    extends: Object implements: Statement

    Alter ()
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    isUseOnly () → boolean
    returns boolean
    setUseOnly (useOnly)
    boolean useOnly
    addAlterExpression (alterExpression)
    AlterExpression alterExpression
    getAlterExpressions () → List
    returns List
    setAlterExpressions (alterExpressions)
    List alterExpressions
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    toString () → String
    returns String
    withTable (table) → Alter
    Table table
    returns Alter
    withUseOnly (useOnly) → Alter
    boolean useOnly
    returns Alter
    withAlterExpressions (alterExpressions) → Alter
    List alterExpressions
    returns Alter
    addAlterExpressions (alterExpressions) → Alter
    AlterExpression alterExpressions
    returns Alter
    addAlterExpressions (alterExpressions) → Alter
    Collection alterExpressions
    returns Alter

    AlterExpression

    extends: Object implements: Serializable

    AlterExpression ()
    getOldIndex () → Index
    returns Index
    setOldIndex (oldIndex)
    Index oldIndex
    hasColumn () → boolean
    returns boolean
    useBrackets () → boolean
    returns boolean
    useBrackets (useBrackets)
    boolean useBrackets
    hasColumn (hasColumn)
    boolean hasColumn
    getFkSourceSchema () → String
    returns String
    setFkSourceSchema (fkSourceSchema)
    String fkSourceSchema
    getCommentText () → String
    returns String
    setCommentText (commentText)
    String commentText
    getOperation () → AlterOperation
    returns AlterOperation
    setOperation (operation)
    AlterOperation operation
    getOptionalSpecifier () → String
    returns String
    setOptionalSpecifier (optionalSpecifier)
    String optionalSpecifier
    setReferentialAction (type, action)
    Type type
    Action action
    withReferentialAction (type, action) → AlterExpression
    Type type
    Action action
    removeReferentialAction (type)
    Type type
    getReferentialAction (type) → ReferentialAction
    Type type
    @Deprecated
    isOnDeleteCascade () → boolean
    returns boolean |
    @Deprecated
    setOnDeleteCascade (onDeleteCascade)
    boolean onDeleteCascade
    @Deprecated
    isOnDeleteRestrict () → boolean
    returns boolean |
    @Deprecated
    setOnDeleteRestrict (onDeleteRestrict)
    boolean onDeleteRestrict
    @Deprecated
    isOnDeleteSetNull () → boolean
    returns boolean |
    @Deprecated
    setOnDeleteSetNull (onDeleteSetNull)
    boolean onDeleteSetNull
    getFkColumns () → List
    returns List
    setFkColumns (fkColumns)
    List fkColumns
    getFkSourceTable () → String
    returns String
    setFkSourceTable (fkSourceTable)
    String fkSourceTable
    getColDataTypeList () → List
    returns List
    addColDataType (columnName, colDataType)
    String columnName
    ColDataType colDataType
    addColDataType (columnDataType)
    ColumnDataType columnDataType
    addColDropNotNull (columnDropNotNull)
    ColumnDropNotNull columnDropNotNull
    addColDropDefault (columnDropDefault)
    ColumnDropDefault columnDropDefault
    getFkSourceColumns () → List
    returns List
    setFkSourceColumns (fkSourceColumns)
    List fkSourceColumns
    getNewTableName () → String
    returns String
    setNewTableName (newTableName)
    String newTableName
    getColumnName () → String
    returns String
    setColumnName (columnName)
    String columnName
    @Deprecated
    getColOldName () → String
    returns String
    @Deprecated
    setColOldName (columnOldName)
    String columnOldName
    getColumnOldName () → String
    returns String
    setColumnOldName (columnOldName)
    String columnOldName
    getConstraintName () → String
    returns String
    setConstraintName (constraintName)
    String constraintName
    isUsingIfExists () → boolean
    returns boolean
    setUsingIfExists (usingIfExists)
    boolean usingIfExists
    getPkColumns () → List
    returns List
    setPkColumns (pkColumns)
    List pkColumns
    getUkColumns () → List
    returns List
    setUkColumns (ukColumns)
    List ukColumns
    getUkName () → String
    returns String
    setUkName (ukName)
    String ukName
    getIndex () → Index
    returns Index
    setIndex (index)
    Index index
    getConstraints () → List
    returns List
    setConstraints (constraints)
    List constraints
    getColumnDropNotNullList () → List
    returns List
    addParameters (params)
    String params
    getParameters () → List
    returns List
    getUseEqual () → boolean
    returns boolean
    setUseEqual (useEqual)
    boolean useEqual
    getUk () → boolean
    returns boolean
    setUk (uk)
    boolean uk
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    withOperation (operation) → AlterExpression
    AlterOperation operation
    withOptionalSpecifier (optionalSpecifier) → AlterExpression
    String optionalSpecifier
    withColumnName (columnName) → AlterExpression
    String columnName
    withPkColumns (pkColumns) → AlterExpression
    List pkColumns
    withUkColumns (ukColumns) → AlterExpression
    List ukColumns
    withUkName (ukName) → AlterExpression
    String ukName
    withIndex (index) → AlterExpression
    Index index
    withConstraintName (constraintName) → AlterExpression
    String constraintName
    withUsingIfExists (usingIfExists) → AlterExpression
    boolean usingIfExists
    withOnDeleteRestrict (onDeleteRestrict) → AlterExpression
    boolean onDeleteRestrict
    withOnDeleteSetNull (onDeleteSetNull) → AlterExpression
    boolean onDeleteSetNull
    withOnDeleteCascade (onDeleteCascade) → AlterExpression
    boolean onDeleteCascade
    withFkColumns (fkColumns) → AlterExpression
    List fkColumns
    withFkSourceSchema (fkSourceSchema) → AlterExpression
    String fkSourceSchema
    withFkSourceTable (fkSourceTable) → AlterExpression
    String fkSourceTable
    withFkSourceColumns (fkSourceColumns) → AlterExpression
    List fkSourceColumns
    withUk (uk) → AlterExpression
    boolean uk
    withUseEqual (useEqual) → AlterExpression
    boolean useEqual
    withConstraints (constraints) → AlterExpression
    List constraints
    withCommentText (commentText) → AlterExpression
    String commentText
    withColumnOldName (columnOldName) → AlterExpression
    String columnOldName
    addPkColumns (pkColumns) → AlterExpression
    String pkColumns
    addPkColumns (pkColumns) → AlterExpression
    Collection pkColumns
    addUkColumns (ukColumns) → AlterExpression
    String ukColumns
    addUkColumns (ukColumns) → AlterExpression
    Collection ukColumns
    addFkColumns (fkColumns) → AlterExpression
    String fkColumns
    addFkColumns (fkColumns) → AlterExpression
    Collection fkColumns
    addFkSourceColumns (fkSourceColumns) → AlterExpression
    String fkSourceColumns
    addFkSourceColumns (fkSourceColumns) → AlterExpression
    Collection fkSourceColumns
    addConstraints (constraints) → AlterExpression
    ConstraintState constraints
    addConstraints (constraints) → AlterExpression
    Collection constraints

    AlterExpression.ColumnDataType

    extends: ColumnDefinition

    ColumnDataType (withType)
    boolean withType
    ColumnDataType (columnName, withType, colDataType, columnSpecs)
    String columnName
    boolean withType
    ColDataType colDataType
    List columnSpecs
    @Override
    toString () → String
    returns String
    @Override
    withColDataType (colDataType) → ColumnDataType
    ColDataType colDataType
    @Override
    withColumnName (columnName) → ColumnDataType
    String columnName
    @Override
    addColumnSpecs (columnSpecs) → ColumnDataType
    String columnSpecs
    @Override
    addColumnSpecs (columnSpecs) → ColumnDataType
    Collection columnSpecs
    @Override
    withColumnSpecs (columnSpecs) → ColumnDataType
    List columnSpecs

    AlterExpression.ColumnDropDefault

    extends: Object implements: Serializable

    ColumnDropDefault (columnName)
    String columnName
    getColumnName () → String
    returns String
    @Override
    toString () → String
    returns String

    AlterExpression.ColumnDropNotNull

    extends: Object implements: Serializable

    ColumnDropNotNull (columnName)
    String columnName
    ColumnDropNotNull (columnName, withNot)
    String columnName
    boolean withNot
    getColumnName () → String
    returns String
    isWithNot () → boolean
    returns boolean
    @Override
    toString () → String
    returns String

    AlterSession

    extends: Object implements: Statement

    AlterSession (operation, parameters)
    AlterSessionOperation operation
    List parameters
    getOperation () → AlterSessionOperation
    returns AlterSessionOperation
    setOperation (operation)
    AlterSessionOperation operation
    getParameters () → List
    returns List
    setParameters (parameters)
    List parameters
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor

    AlterSystemStatement

    extends: Object implements: Statement

    AlterSystemStatement (operation, parameters)
    AlterSystemOperation operation
    List parameters
    getOperation () → AlterSystemOperation
    returns AlterSystemOperation
    getParameters () → List
    returns List
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    DeferrableConstraint

    extends: Object implements: ConstraintState

    DeferrableConstraint ()
    DeferrableConstraint (not)
    boolean not
    isNot () → boolean
    returns boolean
    setNot (not)
    boolean not
    @Override
    toString () → String
    returns String
    withNot (not) → DeferrableConstraint
    boolean not

    EnableConstraint

    extends: Object implements: ConstraintState

    EnableConstraint ()
    EnableConstraint (disable)
    boolean disable
    isDisable () → boolean
    returns boolean
    setDisable (disable)
    boolean disable
    @Override
    toString () → String
    returns String
    withDisable (disable) → EnableConstraint
    boolean disable

    RenameTableStatement

    extends: Object implements: Statement

    RenameTableStatement (oldName, newName)
    Table oldName
    Table newName
    RenameTableStatement (oldName, newName, usingTableKeyword, usingIfExistsKeyword, waitDirective)
    Table oldName
    Table newName
    boolean usingTableKeyword
    boolean usingIfExistsKeyword
    String waitDirective
    addTableNames (oldName, newName)
    Table oldName
    Table newName
    isUsingTableKeyword () → boolean
    returns boolean
    setUsingTableKeyword (usingTableKeyword)
    boolean usingTableKeyword
    withUsingTableKeyword (usingTableKeyword) → RenameTableStatement
    boolean usingTableKeyword
    isUsingIfExistsKeyword () → boolean
    returns boolean
    setUsingIfExistsKeyword (usingIfExistsKeyword)
    boolean usingIfExistsKeyword
    withUsingIfExistsKeyword (usingIfExistsKeyword) → RenameTableStatement
    boolean usingIfExistsKeyword
    getWaitDirective () → String
    returns String
    setWaitDirective (waitDirective)
    String waitDirective
    withWaitDirective (waitDirective) → RenameTableStatement
    String waitDirective
    getTableNamesSize () → int
    returns int
    isTableNamesEmpty () → boolean
    returns boolean
    getTableNames () → Set
    returns Set
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    ValidateConstraint

    extends: Object implements: ConstraintState

    ValidateConstraint ()
    ValidateConstraint (not)
    boolean not
    isNot () → boolean
    returns boolean
    setNot (not)
    boolean not
    @Override
    toString () → String
    returns String
    withNot (not) → ValidateConstraint
    boolean not

    ConstraintState

    provides: DeferrableConstraint, EnableConstraint, ValidateConstraint,

    statement.alter.sequence

    AlterSequence

    extends: Object implements: Statement

    An ALTER SEQUENCE statement
    AlterSequence ()
    setSequence (sequence)
    Sequence sequence
    getSequence () → Sequence
    returns Sequence
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    toString () → String
    returns String
    withSequence (sequence) → AlterSequence
    Sequence sequence

    statement.analyze

    Analyze

    extends: Object implements: Statement

    Analyze ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    @Override
    toString () → String
    returns String
    withTable (table) → Analyze
    Table table
    returns Analyze

    statement.comment

    Comment

    extends: Object implements: Statement

    Comment ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    getColumn () → Column
    returns Column
    setColumn (column)
    Column column
    getView () → Table
    returns Table
    setView (view)
    Table view
    getComment () → StringValue
    returns StringValue
    setComment (comment)
    StringValue comment
    @Override
    toString () → String
    returns String
    withTable (table) → Comment
    Table table
    returns Comment
    withColumn (column) → Comment
    Column column
    returns Comment
    withComment (comment) → Comment
    StringValue comment
    returns Comment

    statement.create.function

    CreateFunction

    extends: CreateFunctionalStatement

    A CREATE PROCEDURE statement
    CreateFunction ()
    CreateFunction (functionDeclarationParts)
    List functionDeclarationParts
    CreateFunction (orReplace, functionDeclarationParts)
    boolean orReplace
    List functionDeclarationParts
    @Override
    withFunctionDeclarationParts (functionDeclarationParts) → CreateFunction
    List functionDeclarationParts
    @Override
    addFunctionDeclarationParts (functionDeclarationParts) → CreateFunction
    String functionDeclarationParts
    @Override
    addFunctionDeclarationParts (functionDeclarationParts) → CreateFunction
    Collection functionDeclarationParts

    statement.create.index

    CreateIndex

    extends: Object implements: Statement

    CreateIndex ()
    isIndexTypeBeforeOn () → boolean
    returns boolean
    setIndexTypeBeforeOn (indexTypeBeforeOn)
    boolean indexTypeBeforeOn
    isUsingIfNotExists () → boolean
    returns boolean
    setUsingIfNotExists (usingIfNotExists) → CreateIndex
    boolean usingIfNotExists
    returns CreateIndex
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getIndex () → Index
    returns Index
    setIndex (index)
    Index index
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    getTailParameters () → List
    returns List
    setTailParameters (tailParameters)
    List tailParameters
    @Override
    toString () → String
    returns String
    withTable (table) → CreateIndex
    Table table
    returns CreateIndex
    withIndex (index) → CreateIndex
    Index index
    returns CreateIndex
    withTailParameters (tailParameters) → CreateIndex
    List tailParameters
    returns CreateIndex

    statement.create.procedure

    CreateProcedure

    extends: CreateFunctionalStatement

    A CREATE PROCEDURE statement
    CreateProcedure ()
    CreateProcedure (functionDeclarationParts)
    List functionDeclarationParts
    CreateProcedure (orReplace, functionDeclarationParts)
    boolean orReplace
    List functionDeclarationParts
    @Override
    withFunctionDeclarationParts (functionDeclarationParts) → CreateProcedure
    List functionDeclarationParts
    @Override
    addFunctionDeclarationParts (functionDeclarationParts) → CreateProcedure
    String functionDeclarationParts
    @Override
    addFunctionDeclarationParts (functionDeclarationParts) → CreateProcedure
    Collection functionDeclarationParts

    statement.create.schema

    CreateSchema

    extends: Object implements: Statement

    CreateSchema ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    addStatement (statement) → boolean
    Add a statement to the schema definition
    Statement statement | statement The statement to be added
    returns boolean | true if the operation was successful
    getAuthorization () → String
    The owner of the schema.
    returns String | Owner name
    getSchemaName () → String
    The name of the schema
    returns String | Schema name
    getSchemaPath () → List
    The path of the schema
    returns List | Schema path
    getStatements () → List
    The statements executed as part of the schema creation
    returns List | the statements
    setAuthorization (authorization)
    The owner of the schems.
    String authorization | authorization Owner name
    setSchemaName (schemaName)
    Set the name of the schema
    String schemaName | schemaName Schema name
    setSchemaPath (schemaPath)
    Set the path of the schema
    List schemaPath | schemaPath Schema path
    toString () → String
    returns String
    withAuthorization (authorization) → CreateSchema
    String authorization
    returns CreateSchema
    withSchemaName (schemaName) → CreateSchema
    String schemaName
    returns CreateSchema
    withSchemaPath (schemaPath) → CreateSchema
    List schemaPath
    returns CreateSchema
    addSchemaPath (schemaPath) → CreateSchema
    String schemaPath
    returns CreateSchema
    addSchemaPath (schemaPath) → CreateSchema
    Collection schemaPath
    returns CreateSchema

    statement.create.sequence

    CreateSequence

    extends: Object implements: Statement

    A CREATE SEQUENCE statement
    CreateSequence ()
    setSequence (sequence)
    Sequence sequence
    getSequence () → Sequence
    returns Sequence
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    toString () → String
    returns String
    withSequence (sequence) → CreateSequence
    Sequence sequence

    statement.create.synonym

    CreateSynonym

    extends: Object implements: Statement

    CreateSynonym ()
    setSynonym (synonym)
    Synonym synonym
    getSynonym () → Synonym
    returns Synonym
    isOrReplace () → boolean
    returns boolean
    setOrReplace (orReplace)
    boolean orReplace
    isPublicSynonym () → boolean
    returns boolean
    setPublicSynonym (publicSynonym)
    boolean publicSynonym
    setForList (forList)
    List forList
    getForList () → List
    returns List
    getFor () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    toString () → String
    returns String
    withSynonym (synonym) → CreateSynonym
    Synonym synonym

    statement.create.table

    RowMovementMode

    [ENABLE, DISABLE]

    CheckConstraint

    extends: NamedConstraint

    CheckConstraint ()
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    toString () → String
    returns String
    withTable (table) → CheckConstraint
    Table table
    withExpression (expression) → CheckConstraint
    Expression expression
    getExpression (type) → E
    Class type
    returns E
    @Override
    withType (type) → CheckConstraint
    String type
    @Override
    withUsing (using) → CheckConstraint
    String using
    @Override
    withName (name) → CheckConstraint
    List name
    @Override
    withName (name) → CheckConstraint
    String name
    @Override
    withColumnsNames (list) → CheckConstraint
    List list
    @Override
    withColumns (columns) → CheckConstraint
    List columns
    @Override
    addColumns (functionDeclarationParts) → CheckConstraint
    ColumnParams functionDeclarationParts
    @Override
    addColumns (functionDeclarationParts) → CheckConstraint
    Collection functionDeclarationParts
    @Override
    withIndexSpec (idxSpec) → CheckConstraint
    List idxSpec

    ColDataType

    extends: Object implements: Serializable

    ColDataType ()
    ColDataType (dataType)
    String dataType
    getArgumentsStringList () → List
    returns List
    getDataType () → String
    returns String
    setArgumentsStringList (list)
    List list
    setDataType (string)
    String string
    setDataType (list)
    List list
    getCharacterSet () → String
    returns String
    setCharacterSet (characterSet)
    String characterSet
    getArrayData () → List
    returns List
    setArrayData (arrayData)
    List arrayData
    @Override
    toString () → String
    returns String
    withDataType (dataType) → ColDataType
    String dataType
    returns ColDataType
    withArgumentsStringList (argumentsStringList) → ColDataType
    List argumentsStringList
    returns ColDataType
    withCharacterSet (characterSet) → ColDataType
    String characterSet
    returns ColDataType
    withArrayData (arrayData) → ColDataType
    List arrayData
    returns ColDataType
    addArgumentsStringList (argumentsStringList) → ColDataType
    String argumentsStringList
    returns ColDataType
    addArgumentsStringList (argumentsStringList) → ColDataType
    Collection argumentsStringList
    returns ColDataType
    addArrayData (arrayData) → ColDataType
    Integer arrayData
    returns ColDataType
    addArrayData (arrayData) → ColDataType
    Collection arrayData
    returns ColDataType

    ColumnDefinition

    extends: Object implements: Serializable provides: ColumnDataType

    Globally used definition class for columns.
    ColumnDefinition ()
    ColumnDefinition (columnName, colDataType)
    String columnName
    ColDataType colDataType
    ColumnDefinition (columnName, colDataType, columnSpecs)
    String columnName
    ColDataType colDataType
    List columnSpecs
    getColumnSpecs () → List
    returns List
    setColumnSpecs (list)
    List list
    getColDataType () → ColDataType
    returns ColDataType
    setColDataType (type)
    getColumnName () → String
    returns String
    setColumnName (string)
    String string
    @Override
    toString () → String
    returns String
    toStringDataTypeAndSpec () → String
    returns String
    withColumnName (columnName) → ColumnDefinition
    String columnName
    withColDataType (colDataType) → ColumnDefinition
    ColDataType colDataType
    withColumnSpecs (columnSpecs) → ColumnDefinition
    List columnSpecs
    addColumnSpecs (columnSpecs) → ColumnDefinition
    String columnSpecs
    addColumnSpecs (columnSpecs) → ColumnDefinition
    Collection columnSpecs

    CreateTable

    extends: Object implements: Statement

    CreateTable ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    isUnlogged () → boolean
    returns boolean
    setUnlogged (unlogged)
    boolean unlogged
    getColumnDefinitions () → List
    returns List | a list of `ColumnDefinition`s of this table.
    setColumnDefinitions (list)
    List list
    getColumns () → List
    returns List
    setColumns (columns)
    List columns
    getTableOptionsStrings () → List
    returns List | a list of options (as simple strings) of this table definition, as (“TYPE”, “=”, “MYISAM”)
    setTableOptionsStrings (tableOptionsStrings)
    List tableOptionsStrings
    getCreateOptionsStrings () → List
    returns List
    setCreateOptionsStrings (createOptionsStrings)
    List createOptionsStrings
    getIndexes () → List
    returns List | a list of `Index`es (for example “PRIMARY KEY”) of this table.
    Indexes created with column definitions (as in mycol INT PRIMARY KEY) are not inserted into this list.
    setIndexes (list)
    List list
    getSelect () → Select
    returns Select
    setSelect (select, parenthesis)
    Select select
    boolean parenthesis
    getLikeTable () → Table
    returns Table
    setLikeTable (likeTable, parenthesis)
    Table likeTable
    boolean parenthesis
    isIfNotExists () → boolean
    returns boolean
    setIfNotExists (ifNotExists)
    boolean ifNotExists
    isOrReplace () → boolean
    returns boolean
    setOrReplace (orReplace)
    boolean orReplace
    isSelectParenthesis () → boolean
    returns boolean
    setSelectParenthesis (selectParenthesis)
    boolean selectParenthesis
    getRowMovement () → RowMovement
    returns RowMovement
    setRowMovement (rowMovement)
    RowMovement rowMovement
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    withTable (table) → CreateTable
    Table table
    returns CreateTable
    withUnlogged (unlogged) → CreateTable
    boolean unlogged
    returns CreateTable
    withCreateOptionsStrings (createOptionsStrings) → CreateTable
    List createOptionsStrings
    returns CreateTable
    withSelectParenthesis (selectParenthesis) → CreateTable
    boolean selectParenthesis
    returns CreateTable
    withIfNotExists (ifNotExists) → CreateTable
    boolean ifNotExists
    returns CreateTable
    withRowMovement (rowMovement) → CreateTable
    RowMovement rowMovement
    returns CreateTable
    withTableOptionsStrings (tableOptionsStrings) → CreateTable
    List tableOptionsStrings
    returns CreateTable
    withColumnDefinitions (columnDefinitions) → CreateTable
    List columnDefinitions
    returns CreateTable
    withColumns (columns) → CreateTable
    List columns
    returns CreateTable
    withIndexes (indexes) → CreateTable
    List indexes
    returns CreateTable
    addCreateOptionsStrings (createOptionsStrings) → CreateTable
    String createOptionsStrings
    returns CreateTable
    addCreateOptionsStrings (createOptionsStrings) → CreateTable
    Collection createOptionsStrings
    returns CreateTable
    addColumnDefinitions (columnDefinitions) → CreateTable
    ColumnDefinition columnDefinitions
    returns CreateTable
    addColumnDefinitions (columnDefinitions) → CreateTable
    Collection columnDefinitions
    returns CreateTable
    addColumns (columns) → CreateTable
    String columns
    returns CreateTable
    addColumns (columns) → CreateTable
    Collection columns
    returns CreateTable
    addIndexes (indexes) → CreateTable
    Index indexes
    returns CreateTable
    addIndexes (indexes) → CreateTable
    Collection indexes
    returns CreateTable
    getSpannerInterleaveIn () → SpannerInterleaveIn
    setSpannerInterleaveIn (spannerInterleaveIn)
    SpannerInterleaveIn spannerInterleaveIn
    withSpannerInterleaveIn (spannerInterleaveIn) → CreateTable
    SpannerInterleaveIn spannerInterleaveIn
    returns CreateTable

    ExcludeConstraint

    extends: Index

    ExcludeConstraint ()
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    toString () → String
    returns String
    withExpression (expression) → ExcludeConstraint
    Expression expression
    getExpression (type) → E
    Class type
    returns E
    @Override
    withName (name) → ExcludeConstraint
    List name
    @Override
    withType (type) → ExcludeConstraint
    String type
    @Override
    withUsing (using) → ExcludeConstraint
    String using
    @Override
    withColumnsNames (list) → ExcludeConstraint
    List list
    @Override
    withColumns (columns) → ExcludeConstraint
    List columns
    @Override
    addColumns (functionDeclarationParts) → ExcludeConstraint
    ColumnParams functionDeclarationParts
    @Override
    addColumns (functionDeclarationParts) → ExcludeConstraint
    Collection functionDeclarationParts
    @Override
    withIndexSpec (idxSpec) → ExcludeConstraint
    List idxSpec
    @Override
    withName (name) → ExcludeConstraint
    String name

    ForeignKeyIndex

    extends: NamedConstraint

    ForeignKeyIndex ()
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    getReferencedColumnNames () → List
    returns List
    setReferencedColumnNames (referencedColumnNames)
    List referencedColumnNames
    setReferentialAction (type, action)
    Type type
    Action action
    withReferentialAction (type, action) → ForeignKeyIndex
    Type type
    Action action
    removeReferentialAction (type)
    Type type
    getReferentialAction (type) → ReferentialAction
    Type type
    @Deprecated
    getOnDeleteReferenceOption () → String
    returns String
    @Deprecated
    setOnDeleteReferenceOption (onDeleteReferenceOption)
    String onDeleteReferenceOption
    @Deprecated
    getOnUpdateReferenceOption () → String
    returns String
    @Deprecated
    setOnUpdateReferenceOption (onUpdateReferenceOption)
    String onUpdateReferenceOption
    @Override
    toString () → String
    returns String
    withTable (table) → ForeignKeyIndex
    Table table
    withReferencedColumnNames (referencedColumnNames) → ForeignKeyIndex
    List referencedColumnNames
    withOnDeleteReferenceOption (onDeleteReferenceOption) → ForeignKeyIndex
    String onDeleteReferenceOption
    withOnUpdateReferenceOption (onUpdateReferenceOption) → ForeignKeyIndex
    String onUpdateReferenceOption
    addReferencedColumnNames (referencedColumnNames) → ForeignKeyIndex
    String referencedColumnNames
    addReferencedColumnNames (referencedColumnNames) → ForeignKeyIndex
    Collection referencedColumnNames
    @Override
    withType (type) → ForeignKeyIndex
    String type
    @Override
    withUsing (using) → ForeignKeyIndex
    String using
    @Override
    withName (name) → ForeignKeyIndex
    List name
    @Override
    withName (name) → ForeignKeyIndex
    String name
    @Override
    withColumnsNames (list) → ForeignKeyIndex
    List list
    @Override
    withColumns (columns) → ForeignKeyIndex
    List columns
    @Override
    addColumns (functionDeclarationParts) → ForeignKeyIndex
    ColumnParams functionDeclarationParts
    @Override
    addColumns (functionDeclarationParts) → ForeignKeyIndex
    Collection functionDeclarationParts
    @Override
    withIndexSpec (idxSpec) → ForeignKeyIndex
    List idxSpec

    Index

    extends: Object implements: Serializable provides: ExcludeConstraint, NamedConstraint

    Index ()
    getColumnsNames () → List
    returns List
    @Deprecated
    getColumnWithParams () → List
    returns List
    @Deprecated
    setColumnNamesWithParams (list)
    List list
    getColumns () → List
    returns List
    setColumns (columns)
    List columns
    withColumns (columns) → Index
    List columns
    returns Index
    addColumns (functionDeclarationParts) → Index
    ColumnParams functionDeclarationParts
    returns Index
    addColumns (functionDeclarationParts) → Index
    Collection functionDeclarationParts
    returns Index
    getName () → String
    returns String
    getNameParts () → List
    returns List
    getType () → String
    returns String
    setUsing (using)
    In postgresql, the index type (Btree, GIST, etc.) is indicated with a USING clause. Please note that: Oracle - the type might be BITMAP, indicating a bitmap kind of index MySQL - the type might be FULLTEXT or SPATIAL
    String using
    setColumnsNames (list)
    List list
    withColumnsNames (list) → Index
    List list
    returns Index
    setName (name)
    String name
    setName (name)
    List name
    setType (string)
    String string
    getUsing () → String
    returns String
    getIndexSpec () → List
    returns List
    setIndexSpec (idxSpec)
    List idxSpec
    withIndexSpec (idxSpec) → Index
    List idxSpec
    returns Index
    @Override
    toString () → String
    returns String
    withType (type) → Index
    String type
    returns Index
    withUsing (using) → Index
    String using
    returns Index
    withName (name) → Index
    List name
    returns Index
    withName (name) → Index
    String name
    returns Index
    getCommentText () → String
    returns String
    setCommentText (commentText)
    String commentText

    Index.ColumnParams

    extends: Object implements: Serializable

    ColumnParams (columnName)
    String columnName
    ColumnParams (columnName, params)
    String columnName
    List params
    getColumnName () → String
    returns String
    getParams () → List
    returns List
    @Override
    toString () → String
    returns String

    NamedConstraint

    extends: Index provides: CheckConstraint, ForeignKeyIndex

    NamedConstraint ()
    @Override
    toString () → String
    returns String
    @Override
    withName (name) → NamedConstraint
    List name
    @Override
    withName (name) → NamedConstraint
    String name
    @Override
    withType (type) → NamedConstraint
    String type
    @Override
    withUsing (using) → NamedConstraint
    String using
    @Override
    withColumnsNames (list) → NamedConstraint
    List list
    @Override
    withColumns (columns) → NamedConstraint
    List columns
    @Override
    addColumns (functionDeclarationParts) → NamedConstraint
    ColumnParams functionDeclarationParts
    @Override
    addColumns (functionDeclarationParts) → NamedConstraint
    Collection functionDeclarationParts
    @Override
    withIndexSpec (idxSpec) → NamedConstraint
    List idxSpec

    RowMovement

    extends: Object implements: Serializable

    RowMovement ()
    getMode () → RowMovementMode
    returns RowMovementMode
    setMode (mode)
    RowMovementMode mode
    withMode (mode) → RowMovement
    RowMovementMode mode
    returns RowMovement

    statement.create.view

    AutoRefreshOption

    [NONE, YES, NO]

    ForceOption

    [NONE, FORCE, NO_FORCE]

    TemporaryOption

    [NONE, TEMP, TEMPORARY]

    AlterView

    extends: Object implements: Statement

    AlterView ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getView () → Table
    returns Table
    setView (view)
    Table view
    getSelect () → Select
    returns Select
    setSelect (select)
    Select select
    getColumnNames () → List
    returns List
    setColumnNames (columnNames)
    List columnNames
    isUseReplace () → boolean
    returns boolean
    setUseReplace (useReplace)
    boolean useReplace
    @Override
    toString () → String
    returns String
    withView (view) → AlterView
    Table view
    returns AlterView
    withSelect (select) → AlterView
    Select select
    returns AlterView
    withUseReplace (useReplace) → AlterView
    boolean useReplace
    returns AlterView
    withColumnNames (columnNames) → AlterView
    List columnNames
    returns AlterView
    addColumnNames (columnNames) → AlterView
    String columnNames
    returns AlterView
    addColumnNames (columnNames) → AlterView
    Collection columnNames
    returns AlterView
    getSelectBody (type) → E
    Class type
    returns E

    CreateView

    extends: Object implements: Statement

    CreateView ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getView () → Table
    returns Table
    setView (view)
    Table view
    isOrReplace () → boolean
    returns boolean
    setOrReplace (orReplace)
    boolean orReplace | orReplace was “OR REPLACE” specified?
    getSelect () → Select
    returns Select
    setSelect (select)
    Select select
    getColumnNames () → ExpressionList
    setColumnNames (columnNames)
    ExpressionList columnNames
    isMaterialized () → boolean
    returns boolean
    setMaterialized (materialized)
    boolean materialized
    getForce () → ForceOption
    returns ForceOption
    setForce (force)
    ForceOption force
    getTemporary () → TemporaryOption
    returns TemporaryOption
    setTemporary (temp)
    TemporaryOption temp
    getAutoRefresh () → AutoRefreshOption
    returns AutoRefreshOption
    setAutoRefresh (autoRefresh)
    AutoRefreshOption autoRefresh
    isWithReadOnly () → boolean
    returns boolean
    setWithReadOnly (withReadOnly)
    boolean withReadOnly
    isIfNotExists () → boolean
    returns boolean
    setIfNotExists (ifNotExists)
    boolean ifNotExists
    @Override
    toString () → String
    returns String
    withView (view) → CreateView
    Table view
    returns CreateView
    withSelect (select) → CreateView
    Select select
    returns CreateView
    withOrReplace (orReplace) → CreateView
    boolean orReplace
    returns CreateView
    withColumnNames (columnNames) → CreateView
    ExpressionList columnNames
    returns CreateView
    withMaterialized (materialized) → CreateView
    boolean materialized
    returns CreateView
    withForce (force) → CreateView
    ForceOption force
    returns CreateView
    withWithReadOnly (withReadOnly) → CreateView
    boolean withReadOnly
    returns CreateView
    getViewCommentOptions () → List
    returns List
    setViewCommentOptions (viewCommentOptions)
    List viewCommentOptions

    statement.delete

    DeleteModifierPriority

    [LOW_PRIORITY]

    Delete

    extends: Object implements: Statement

    Delete ()
    getOutputClause () → OutputClause
    returns OutputClause
    setOutputClause (outputClause)
    OutputClause outputClause
    getReturningClause () → ReturningClause
    setReturningClause (returningClause) → Delete
    ReturningClause returningClause
    returns Delete
    getWithItemsList () → List
    returns List
    setWithItemsList (withItemsList)
    List withItemsList
    withWithItemsList (withItemsList) → Delete
    List withItemsList
    returns Delete
    addWithItemsList (withItemsList) → Delete
    WithItem withItemsList
    returns Delete
    addWithItemsList (withItemsList) → Delete
    Collection withItemsList
    returns Delete
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getTable () → Table
    returns Table
    getWhere () → Expression
    returns Expression
    setTable (name)
    Table name
    setWhere (expression)
    Expression expression
    getOracleHint () → OracleHint
    returns OracleHint
    setOracleHint (oracleHint)
    OracleHint oracleHint
    getLimit () → Limit
    returns Limit
    setLimit (limit)
    Limit limit
    getTables () → List
    returns List
    setTables (tables)
    List tables
    getUsingList () → List
    returns List
    setUsingList (usingList)
    List usingList
    getJoins () → List
    returns List
    setJoins (joins)
    List joins
    isHasFrom () → boolean
    returns boolean
    setHasFrom (hasFrom)
    boolean hasFrom
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    withTables (tables) → Delete
    List tables
    returns Delete
    withUsingList (usingList) → Delete
    List usingList
    returns Delete
    withJoins (joins) → Delete
    List joins
    returns Delete
    withLimit (limit) → Delete
    Limit limit
    returns Delete
    withOrderByElements (orderByElements) → Delete
    List orderByElements
    returns Delete
    withTable (table) → Delete
    Table table
    returns Delete
    withWhere (where) → Delete
    returns Delete
    withHasFrom (hasFrom) → Delete
    boolean hasFrom
    returns Delete
    withModifierPriority (modifierPriority) → Delete
    DeleteModifierPriority modifierPriority
    returns Delete
    withModifierIgnore (modifierIgnore) → Delete
    boolean modifierIgnore
    returns Delete
    withModifierQuick (modifierQuick) → Delete
    boolean modifierQuick
    returns Delete
    setModifierPriority (modifierPriority)
    DeleteModifierPriority modifierPriority
    getModifierPriority () → DeleteModifierPriority
    returns DeleteModifierPriority
    setModifierIgnore (modifierIgnore)
    boolean modifierIgnore
    setModifierQuick (modifierQuick)
    boolean modifierQuick
    isModifierIgnore () → boolean
    returns boolean
    isModifierQuick () → boolean
    returns boolean
    addTables (tables) → Delete
    Table tables
    returns Delete
    addTables (tables) → Delete
    Collection tables
    returns Delete
    addUsingList (usingList) → Delete
    Table usingList
    returns Delete
    addUsingList (usingList) → Delete
    Collection usingList
    returns Delete
    addJoins (joins) → Delete
    Join joins
    returns Delete
    addJoins (joins) → Delete
    Collection joins
    returns Delete
    addOrderByElements (orderByElements) → Delete
    OrderByElement orderByElements
    returns Delete
    addOrderByElements (orderByElements) → Delete
    Collection orderByElements
    returns Delete
    getWhere (type) → E
    Class type
    returns E

    statement.drop

    Drop

    extends: Object implements: Statement

    Drop ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getName () → Table
    returns Table
    getParameters () → List
    returns List
    getType () → String
    returns String
    setName (string)
    Table string
    setParameters (list)
    List list
    setType (string)
    String string
    isIfExists () → boolean
    returns boolean
    setIfExists (ifExists)
    boolean ifExists
    isUsingTemporary () → boolean
    returns boolean
    setUsingTemporary (useTemporary)
    boolean useTemporary
    withUsingTemporary (useTemporary) → Drop
    boolean useTemporary
    returns Drop
    isMaterialized () → boolean
    returns boolean
    setMaterialized (materialized)
    boolean materialized
    getTypeToParameters () → Map
    returns Map
    setTypeToParameters (typeToParameters)
    Map typeToParameters
    @Override
    toString () → String
    returns String
    formatFuncParams (params) → String
    List params
    returns String
    getParamsByType (type) → List
    String type
    returns List
    withIfExists (ifExists) → Drop
    boolean ifExists
    returns Drop
    withMaterialized (materialized) → Drop
    boolean materialized
    returns Drop
    withType (type) → Drop
    String type
    returns Drop
    withName (name) → Drop
    Table name
    returns Drop
    withParameters (parameters) → Drop
    List parameters
    returns Drop
    addParameters (parameters) → Drop
    String parameters
    returns Drop
    addParameters (parameters) → Drop
    Collection parameters
    returns Drop

    statement.execute

    Execute.ExecType

    [EXECUTE, EXEC, CALL]

    Execute

    extends: Object implements: Statement

    Execute ()
    getName () → String
    returns String
    setName (name)
    String name
    setName (names)
    List names
    getExprList () → ExpressionList
    setExprList (exprList)
    getExecType () → ExecType
    returns ExecType
    setExecType (execType)
    ExecType execType
    @Deprecated
    isParenthesis () → boolean
    returns boolean
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    toString () → String
    returns String
    withExecType (execType) → Execute
    ExecType execType
    returns Execute
    withName (name) → Execute
    String name
    returns Execute
    withExprList (exprList) → Execute
    returns Execute

    statement.grant

    Grant

    extends: Object implements: Statement

    Grant ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getRole () → String
    returns String
    setRole (role)
    String role
    getPrivileges () → List
    returns List
    setPrivileges (privileges)
    List privileges
    getObjectName () → String
    returns String
    getObjectNameParts () → List
    returns List
    setObjectName (objectName)
    String objectName
    setObjectName (objectName)
    List objectName
    getUsers () → List
    returns List
    setUsers (users)
    List users
    @Override
    toString () → String
    returns String
    withRole (role) → Grant
    String role
    returns Grant
    withPrivileges (privileges) → Grant
    List privileges
    returns Grant
    withObjectName (objectName) → Grant
    String objectName
    returns Grant
    withObjectName (objectName) → Grant
    List objectName
    returns Grant
    withUsers (users) → Grant
    List users
    returns Grant
    addPrivileges (privileges) → Grant
    String privileges
    returns Grant
    addPrivileges (privileges) → Grant
    Collection privileges
    returns Grant
    addUsers (users) → Grant
    String users
    returns Grant
    addUsers (users) → Grant
    Collection users
    returns Grant

    statement.insert

    ConflictActionType

    [DO_NOTHING, DO_UPDATE]

    InsertModifierPriority

    [LOW_PRIORITY, DELAYED, HIGH_PRIORITY, IGNORE]

    Insert

    extends: Object implements: Statement

    Insert ()
    getDuplicateUpdateSets () → List
    returns List
    getSetUpdateSets () → List
    returns List
    withDuplicateUpdateSets (duplicateUpdateSets) → Insert
    List duplicateUpdateSets
    returns Insert
    withSetUpdateSets (setUpdateSets) → Insert
    List setUpdateSets
    returns Insert
    getOutputClause () → OutputClause
    returns OutputClause
    setOutputClause (outputClause)
    OutputClause outputClause
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getTable () → Table
    returns Table
    setTable (name)
    Table name
    getOracleHint () → OracleHint
    returns OracleHint
    setOracleHint (oracleHint)
    OracleHint oracleHint
    getColumns () → ExpressionList
    setColumns (list)
    @Deprecated
    isUseValues () → boolean
    returns boolean
    getReturningClause () → ReturningClause
    setReturningClause (returningClause) → Insert
    ReturningClause returningClause
    returns Insert
    getSelect () → Select
    returns Select
    setSelect (select)
    Select select
    getValues () → Values
    returns Values
    getPlainSelect () → PlainSelect
    returns PlainSelect
    getSetOperationList () → SetOperationList
    @Deprecated
    isUseSelectBrackets () → boolean
    returns boolean
    @Deprecated
    isUseDuplicate () → boolean
    returns boolean
    getModifierPriority () → InsertModifierPriority
    returns InsertModifierPriority
    setModifierPriority (modifierPriority)
    InsertModifierPriority modifierPriority
    isModifierIgnore () → boolean
    returns boolean
    setModifierIgnore (modifierIgnore)
    boolean modifierIgnore
    @Deprecated
    isUseSet () → boolean
    returns boolean
    getWithItemsList () → List
    returns List
    setWithItemsList (withItemsList)
    List withItemsList
    getConflictTarget () → InsertConflictTarget
    setConflictTarget (conflictTarget)
    InsertConflictTarget conflictTarget
    withConflictTarget (conflictTarget) → Insert
    InsertConflictTarget conflictTarget
    returns Insert
    getConflictAction () → InsertConflictAction
    setConflictAction (conflictAction)
    InsertConflictAction conflictAction
    withConflictAction (conflictAction) → Insert
    InsertConflictAction conflictAction
    returns Insert
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    withWithItemsList (withList) → Insert
    List withList
    returns Insert
    withSelect (select) → Insert
    Select select
    returns Insert
    withModifierPriority (modifierPriority) → Insert
    InsertModifierPriority modifierPriority
    returns Insert
    withModifierIgnore (modifierIgnore) → Insert
    boolean modifierIgnore
    returns Insert
    withTable (table) → Insert
    Table table
    returns Insert
    withColumns (columns) → Insert
    returns Insert
    addColumns (columns) → Insert
    Column columns
    returns Insert
    addColumns (columns) → Insert
    Collection columns
    returns Insert

    InsertConflictAction

    extends: Object implements: Serializable

    https://www.postgresql.org/docs/current/sql-insert.html conflict_action is one of: DO NOTHING DO UPDATE SET { column_name = { expression | DEFAULT } | ( column_name [, …] ) = [ ROW ] ( { expression | DEFAULT } [, …] ) | ( column_name [, …] ) = ( sub-SELECT ) } [, …] [ WHERE condition ]
    InsertConflictAction (conflictActionType)
    ConflictActionType conflictActionType
    getUpdateSets () → List
    returns List
    setUpdateSets (updateSets)
    List updateSets
    withUpdateSets (updateSets) → InsertConflictAction
    List updateSets
    getConflictActionType () → ConflictActionType
    returns ConflictActionType
    setConflictActionType (conflictActionType)
    ConflictActionType conflictActionType
    withConflictActionType (conflictActionType) → InsertConflictAction
    ConflictActionType conflictActionType
    addUpdateSet (column, expression) → InsertConflictAction
    Column column
    Expression expression
    addUpdateSet (updateSet) → InsertConflictAction
    UpdateSet updateSet
    withUpdateSets (updateSets) → InsertConflictAction
    Collection updateSets
    getWhereExpression () → Expression
    returns Expression
    setWhereExpression (whereExpression)
    Expression whereExpression
    withWhereExpression (whereExpression) → InsertConflictAction
    Expression whereExpression
    @SuppressWarnings
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    InsertConflictTarget

    extends: Object implements: Serializable

    https://www.postgresql.org/docs/current/sql-insert.html conflict_target can be one of: ( { index_column_name | ( index_expression ) } [ COLLATE collation ] [ opclass ] [, …] ) [ WHERE index_predicate ] ON CONSTRAINT constraint_name Currently, COLLATE is not supported yet.
    InsertConflictTarget (indexColumnName, indexExpression, whereExpression, constraintName)
    String indexColumnName
    Expression indexExpression
    Expression whereExpression
    String constraintName
    InsertConflictTarget (indexColumnName, indexExpression, whereExpression, constraintName)
    Collection indexColumnName
    Expression indexExpression
    Expression whereExpression
    String constraintName
    getIndexColumnNames () → List
    returns List
    @Deprecated
    getIndexColumnName () → String
    returns String
    getIndexColumnName (index) → String
    int index
    returns String
    addIndexColumnName (indexColumnName) → boolean
    String indexColumnName
    returns boolean
    withIndexColumnName (indexColumnName) → InsertConflictTarget
    String indexColumnName
    addAllIndexColumnNames (indexColumnName) → boolean
    Collection indexColumnName
    returns boolean
    getIndexExpression () → Expression
    returns Expression
    setIndexExpression (indexExpression)
    Expression indexExpression
    withIndexExpression (indexExpression) → InsertConflictTarget
    Expression indexExpression
    getWhereExpression () → Expression
    returns Expression
    setWhereExpression (whereExpression)
    Expression whereExpression
    withWhereExpression (whereExpression) → InsertConflictTarget
    Expression whereExpression
    getConstraintName () → String
    returns String
    setConstraintName (constraintName)
    String constraintName
    withConstraintName (constraintName) → InsertConflictTarget
    String constraintName
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    toString () → String
    returns String

    statement.merge

    Merge

    extends: Object implements: Statement

    Merge ()
    getWithItemsList () → List
    returns List
    setWithItemsList (withItemsList)
    List withItemsList
    withWithItemsList (withItemsList) → Merge
    List withItemsList
    returns Merge
    addWithItemsList (withItemsList) → Merge
    WithItem withItemsList
    returns Merge
    addWithItemsList (withItemsList) → Merge
    Collection withItemsList
    returns Merge
    getTable () → Table
    returns Table
    setTable (name)
    Table name
    getOracleHint () → OracleHint
    returns OracleHint
    setOracleHint (oracleHint)
    OracleHint oracleHint
    @Deprecated
    getUsingTable () → Table
    returns Table
    @Deprecated
    setUsingTable (usingTable)
    Table usingTable
    @Deprecated
    setUsingSelect (usingSelect)
    ParenthesedSelect usingSelect
    @Deprecated
    getUsingAlias () → Alias
    returns Alias
    @Deprecated
    setUsingAlias (usingAlias)
    Alias usingAlias
    getFromItem () → FromItem
    returns FromItem
    setFromItem (fromItem)
    FromItem fromItem
    withFromItem (fromItem) → Merge
    FromItem fromItem
    returns Merge
    getOnCondition () → Expression
    returns Expression
    setOnCondition (onCondition)
    Expression onCondition
    getMergeInsert () → MergeInsert
    returns MergeInsert
    setMergeInsert (insert)
    getMergeUpdate () → MergeUpdate
    returns MergeUpdate
    setMergeUpdate (mergeUpdate)
    MergeUpdate mergeUpdate
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    isInsertFirst () → boolean
    returns boolean
    setInsertFirst (insertFirst)
    boolean insertFirst
    getOutputClause () → OutputClause
    returns OutputClause
    setOutputClause (outputClause) → Merge
    OutputClause outputClause
    returns Merge
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    @Deprecated
    withUsingTable (usingTable) → Merge
    Table usingTable
    returns Merge
    @Deprecated
    withUsingSelect (usingSelect) → Merge
    ParenthesedSelect usingSelect
    returns Merge
    @Deprecated
    withUsingAlias (usingAlias) → Merge
    Alias usingAlias
    returns Merge
    withOnCondition (onCondition) → Merge
    Expression onCondition
    returns Merge
    withMergeUpdate (mergeUpdate) → Merge
    MergeUpdate mergeUpdate
    returns Merge
    withInsertFirst (insertFirst) → Merge
    boolean insertFirst
    returns Merge
    withTable (table) → Merge
    Table table
    returns Merge
    withMergeInsert (mergeInsert) → Merge
    MergeInsert mergeInsert
    returns Merge
    getOnCondition (type) → E
    Class type
    returns E

    MergeInsert

    extends: Object implements: Serializable

    MergeInsert ()
    getAndPredicate () → Expression
    returns Expression
    setAndPredicate (andPredicate)
    Expression andPredicate
    getColumns () → ExpressionList
    setColumns (columns)
    getValues () → ExpressionList
    setValues (values)
    getWhereCondition () → Expression
    returns Expression
    setWhereCondition (whereCondition)
    Expression whereCondition
    @Override
    toString () → String
    returns String
    withAndPredicate (andPredicate) → MergeInsert
    Expression andPredicate
    returns MergeInsert
    withColumns (columns) → MergeInsert
    returns MergeInsert
    withValues (values) → MergeInsert
    returns MergeInsert
    addColumns (columns) → MergeInsert
    Column columns
    returns MergeInsert
    addColumns (columns) → MergeInsert
    Collection columns
    returns MergeInsert
    addValues (values) → MergeInsert
    Expression values
    returns