API 4.9

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

returns KeepExpression

setKeep (keep)

KeepExpression keep

getPartitionExpressionList () → ExpressionList

returns 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

returns WindowElement

setWindowElement (windowElement)

WindowElement windowElement

getType () → AnalyticType

returns AnalyticType

setType (part)

AnalyticType part

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

returns WindowDefinition

setWindowDefinition (windowDef)

WindowDefinition 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

returns AnalyticExpression

withExpression (expression) → AnalyticExpression

Expression expression

returns AnalyticExpression

withOffset (offset) → AnalyticExpression

Expression offset

returns AnalyticExpression

withDefaultValue (defaultValue) → AnalyticExpression

Expression defaultValue

returns AnalyticExpression

withAllColumns (allColumns) → AnalyticExpression

boolean allColumns

returns AnalyticExpression

withKeep (keep) → AnalyticExpression

KeepExpression keep

returns AnalyticExpression

withType (part) → AnalyticExpression

AnalyticType part

returns AnalyticExpression

withDistinct (distinct) → AnalyticExpression

boolean distinct

returns AnalyticExpression

withUnique (unique) → AnalyticExpression

boolean unique

returns AnalyticExpression

withIgnoreNulls (ignoreNulls) → AnalyticExpression

boolean ignoreNulls

returns AnalyticExpression

withFilterExpression (filterExpression) → AnalyticExpression

Expression filterExpression

returns AnalyticExpression

withWindowElement (windowElement) → AnalyticExpression

WindowElement windowElement

returns AnalyticExpression

getExpression (part) → E

Class part

returns E

getOffset (part) → E

Class part

returns E

getDefaultValue (part) → E

Class part

returns E

getFilterExpression (part) → E

Class part

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

returns 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

returns ArrayExpression

withIndexExpression (indexExpression) → ArrayExpression

Expression indexExpression

returns ArrayExpression

withRangeExpression (startIndexExpression, stopIndexExpression) → ArrayExpression

Expression startIndexExpression

Expression stopIndexExpression

returns ArrayExpression

getObjExpression (part) → E

Class part

returns E

getIndexExpression (part) → E

Class part

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

returns BinaryExpression

setLeftExpression (expression)

Expression expression

withRightExpression (expression) → BinaryExpression

Expression expression

returns BinaryExpression

setRightExpression (expression)

Expression expression

@Override

toString () → String

returns String

getStringExpression () → String

returns String

getLeftExpression (part) → E

Class part

returns E

getRightExpression (part) → E

Class part

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

returns CaseExpression

withWhenClauses (whenClauses) → CaseExpression

List whenClauses

returns CaseExpression

withElseExpression (elseExpression) → CaseExpression

Expression elseExpression

returns CaseExpression

addWhenClauses (whenClauses) → CaseExpression

WhenClause whenClauses

returns CaseExpression

addWhenClauses (whenClauses) → CaseExpression

Collection whenClauses

returns CaseExpression

getSwitchExpression (part) → E

Class part

returns E

getElseExpression (part) → E

Class part

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

returns CaseExpression

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 (part) → CastExpression

ColDataType part

returns CastExpression

withUseCastKeyword (useCastKeyword) → CastExpression

boolean useCastKeyword

returns CastExpression

withLeftExpression (leftExpression) → CastExpression

Expression leftExpression

returns CastExpression

getLeftExpression (part) → E

Class part

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

returns CollateExpression

withCollate (collate) → CollateExpression

String collate

returns CollateExpression

getLeftExpression (part) → E

Class part

returns E

ConnectByRootOperator

extends: ASTNodeAccessImpl implements: Expression

ConnectByRootOperator (jdbcColumn)

Column jdbcColumn

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 (part)

DateTime part

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

toString () → String

returns String

withValue (value) → DateTimeLiteralExpression

String value

returns DateTimeLiteralExpression

withType (part) → DateTimeLiteralExpression

DateTime part

returns DateTimeLiteralExpression

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

returns SelectVisitor

setSelectVisitor (selectVisitor)

SelectVisitor selectVisitor

@Override

visit (value)

NullValue value

@Override

visit (function)

Function function

@Override

visit (expr)

SignedExpression expr

@Override

visit (parameter)

JdbcParameter parameter

@Override

visit (parameter)

JdbcNamedParameter parameter

@Override

visit (value)

DoubleValue value

@Override

visit (value)

LongValue value

@Override

visit (value)

DateValue value

@Override

visit (value)

TimeValue value

@Override

visit (value)

TimestampValue value

@Override

visit (parenthesis)

Parenthesis parenthesis

@Override

visit (value)

StringValue value

@Override

visit (expr)

Addition expr

@Override

visit (expr)

Division expr

@Override

visit (expr)

IntegerDivision expr

@Override

visit (expr)

Multiplication expr

@Override

visit (expr)

Subtraction expr

@Override

visit (expr)

AndExpression expr

@Override

visit (expr)

OrExpression expr

@Override

visit (expr)

XorExpression expr

@Override

visit (expr)

Between expr

visit (overlapsCondition)

OverlapsCondition overlapsCondition

@Override

visit (expr)

EqualsTo expr

@Override

visit (expr)

GreaterThan expr

@Override

visit (expr)

GreaterThanEquals expr

@Override

visit (expr)

InExpression expr

@Override

visit (expr)

IsNullExpression expr

@Override

visit (expr)

FullTextSearch expr

@Override

visit (expr)

IsBooleanExpression expr

@Override

visit (expr)

LikeExpression expr

@Override

visit (expr)

MinorThan expr

@Override

visit (expr)

MinorThanEquals expr

@Override

visit (expr)

NotEqualsTo expr

@Override

visit (expr)

DoubleAnd expr

@Override

visit (expr)

Contains expr

@Override

visit (expr)

ContainedBy expr

@Override

visit (jdbcColumn)

Column jdbcColumn

@Override

visit (selectBody)

ParenthesedSelect selectBody

@Override

visit (expr)

CaseExpression expr

@Override

visit (expr)

WhenClause expr

@Override

visit (expr)

ExistsExpression expr

@Override

visit (memberOfExpression)

MemberOfExpression memberOfExpression

@Override

visit (expr)

AnyComparisonExpression expr

@Override

visit (expr)

Concat expr

@Override

visit (expr)

Matches expr

@Override

visit (expr)

BitwiseAnd expr

@Override

visit (expr)

BitwiseOr expr

@Override

visit (expr)

BitwiseXor expr

@Override

visit (expr)

CastExpression expr

@Override

visit (expr)

Modulo expr

@Override

visit (expr)

AnalyticExpression expr

@Override

visit (expr)

ExtractExpression expr

@Override

visit (expr)

IntervalExpression expr

@Override

visit (expr)

OracleHierarchicalExpression expr

@Override

visit (expr)

RegExpMatchOperator expr

@Override

visit (expressionList)

ExpressionList expressionList

@Override

visit (rowConstructor)

RowConstructor rowConstructor

@Override

visit (notExpr)

NotExpression notExpr

@Override

visit (expr)

BitwiseRightShift expr

@Override

visit (expr)

BitwiseLeftShift expr

BinaryExpression expr

returns void

@Override

visit (jsonExpr)

JsonExpression jsonExpr

@Override

visit (expr)

JsonOperator expr

@Override

visit (var)

UserVariable var

@Override

visit (bind)

NumericBind bind

@Override

visit (expr)

KeepExpression 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)

OracleHint hint

@Override

visit (timeKeyExpression)

TimeKeyExpression timeKeyExpression

@Override

visit (literal)

DateTimeLiteralExpression literal

@Override

visit (nextVal)

NextValExpression nextVal

@Override

visit (col)

CollateExpression col

@Override

visit (expr)

SimilarToExpression expr

@Override

visit (array)

ArrayExpression array

@Override

visit (aThis)

ArrayConstructor aThis

@Override

visit (var)

VariableAssignment var

@Override

visit (expr)

XMLSerializeExpr expr

@Override

visit (expr)

TimezoneExpression expr

@Override

visit (expression)

JsonAggregateFunction 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

returns ExtractExpression

withExpression (expression) → ExtractExpression

Expression expression

returns ExtractExpression

getExpression (part) → E

Class part

returns E

FilterOverImpl

extends: ASTNodeAccessImpl provides: JsonAggregateFunction

FilterOverImpl ()

getAnalyticType () → AnalyticType

returns AnalyticType

setAnalyticType (analyticType)

AnalyticType analyticType

withAnalyticType (analyticType) → FilterOverImpl

AnalyticType analyticType

returns FilterOverImpl

getOrderByElements () → List

returns List

setOrderByElements (orderByElements)

List orderByElements

withOrderByElements (orderByElements) → FilterOverImpl

List orderByElements

returns FilterOverImpl

getPartitionExpressionList () → ExpressionList

returns 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

returns FilterOverImpl

getWindowElement () → WindowElement

returns WindowElement

setWindowElement (windowElement)

WindowElement windowElement

withWindowElement (windowElement) → FilterOverImpl

WindowElement windowElement

returns FilterOverImpl

@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)

ExpressionList 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)

NamedExpressionList 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

returns KeepExpression

setKeep (keep)

KeepExpression 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

KeepExpression keep

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 (part) → E

Class part

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

returns IntervalExpression

withIntervalType (intervalType) → IntervalExpression

String intervalType

returns IntervalExpression

withExpression (expression) → IntervalExpression

Expression expression

returns IntervalExpression

getExpression (part) → E

Class part

returns E

JdbcNamedParameter

extends: ASTNodeAccessImpl implements: Expression

JdbcNamedParameter ()

JdbcNamedParameter (name)

String name

getParameterCharacter () → String

returns String

setParameterCharacter (parameterCharacter) → JdbcNamedParameter

String parameterCharacter

returns JdbcNamedParameter

getName () → String

returns String

setName (name)

String name

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

toString () → String

returns String

withName (name) → JdbcNamedParameter

String name

returns JdbcNamedParameter

JdbcParameter

extends: ASTNodeAccessImpl implements: Expression

A ‘?’ in a statement or a ?<number> e.g. ?4

JdbcParameter ()

JdbcParameter (jdbcIndex, useFixedIndex, parameterCharacter)

Integer jdbcIndex

boolean useFixedIndex

String parameterCharacter

getParameterCharacter () → String

returns String

setParameterCharacter (parameterCharacter) → JdbcParameter

String parameterCharacter

returns JdbcParameter

getIndex () → Integer

returns Integer

setIndex (jdbcIndex)

Integer jdbcIndex

isUseFixedIndex () → boolean

returns boolean

setUseFixedIndex (useFixedIndex)

boolean useFixedIndex

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

toString () → String

returns String

withIndex (jdbcIndex) → JdbcParameter

Integer jdbcIndex

returns JdbcParameter

withUseFixedIndex (useFixedIndex) → JdbcParameter

boolean useFixedIndex

returns JdbcParameter

JsonAggregateFunction

extends: FilterOverImpl implements: Expression

JsonAggregateFunction ()

getOnNullType () → JsonAggregateOnNullType

returns JsonAggregateOnNullType

setOnNullType (onNullType)

JsonAggregateOnNullType onNullType

withOnNullType (onNullType) → JsonAggregateFunction

JsonAggregateOnNullType onNullType

returns JsonAggregateFunction

getUniqueKeysType () → JsonAggregateUniqueKeysType

returns JsonAggregateUniqueKeysType

setUniqueKeysType (uniqueKeysType)

JsonAggregateUniqueKeysType uniqueKeysType

withUniqueKeysType (uniqueKeysType) → JsonAggregateFunction

JsonAggregateUniqueKeysType uniqueKeysType

returns JsonAggregateFunction

getType () → JsonFunctionType

returns JsonFunctionType

setType (part)

JsonFunctionType part

withType (part) → JsonAggregateFunction

JsonFunctionType part

returns JsonAggregateFunction

setType (typeName)

String typeName

withType (typeName) → JsonAggregateFunction

String typeName

returns JsonAggregateFunction

getExpression () → Expression

returns Expression

setExpression (expression)

Expression expression

withExpression (expression) → JsonAggregateFunction

Expression expression

returns JsonAggregateFunction

isUsingKeyKeyword () → boolean

returns boolean

setUsingKeyKeyword (usingKeyKeyword)

boolean usingKeyKeyword

withUsingKeyKeyword (usingKeyKeyword) → JsonAggregateFunction

boolean usingKeyKeyword

returns JsonAggregateFunction

getKey () → String

returns String

setKey (key)

String key

withKey (key) → JsonAggregateFunction

String key

returns JsonAggregateFunction

isUsingValueKeyword () → boolean

returns boolean

setUsingValueKeyword (usingValueKeyword)

boolean usingValueKeyword

withUsingValueKeyword (usingValueKeyword) → JsonAggregateFunction

boolean usingValueKeyword

returns JsonAggregateFunction

getValue () → Object

returns Object

setValue (value)

Object value

withValue (value) → JsonAggregateFunction

Object value

returns JsonAggregateFunction

isUsingFormatJson () → boolean

returns boolean

setUsingFormatJson (usingFormatJson)

boolean usingFormatJson

withUsingFormatJson (usingFormatJson) → JsonAggregateFunction

boolean usingFormatJson

returns JsonAggregateFunction

getExpressionOrderByElements () → List

returns List

setExpressionOrderByElements (orderByElements)

List orderByElements

withExpressionOrderByElements (orderByElements) → JsonAggregateFunction

List orderByElements

returns JsonAggregateFunction

@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)

Expression expr

JsonExpression (expr, idents)

Expression expr

List idents

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

getExpression () → Expression

returns Expression

setExpression (expr)

Expression expr

addIdent (ident, operator)

String ident

String operator

addAllIdents (idents)

Collection idents

getIdentList () → List

returns List

getIdent (jdbcIndex) → Entry

int jdbcIndex

returns Entry

@Deprecated

getIdents () → List

returns List

@Deprecated

getOperators () → List

returns List

@Override

toString () → String

returns String

withExpression (expr) → JsonExpression

Expression expr

returns JsonExpression

JsonFunction

extends: ASTNodeAccessImpl implements: Expression

JsonFunction ()

getKeyValuePairs () → ArrayList

returns ArrayList

getExpressions () → ArrayList

returns ArrayList

getKeyValuePair (i) → JsonKeyValuePair

int i

returns JsonKeyValuePair

getExpression (i) → JsonFunctionExpression

int i

returns JsonFunctionExpression

add (keyValuePair) → boolean

JsonKeyValuePair keyValuePair

returns boolean

add (i, keyValuePair)

int i

JsonKeyValuePair keyValuePair

add (expression) → boolean

JsonFunctionExpression expression

returns boolean

add (i, expression)

int i

JsonFunctionExpression expression

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 (part)

JsonFunctionType part

withType (part) → JsonFunction

JsonFunctionType part

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

returns JsonFunctionExpression

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

returns JsonKeyValuePair

isUsingValueKeyword () → boolean

returns boolean

setUsingValueKeyword (usingValueKeyword)

boolean usingValueKeyword

withUsingValueKeyword (usingValueKeyword) → JsonKeyValuePair

boolean usingValueKeyword

returns JsonKeyValuePair

isUsingFormatJson () → boolean

returns boolean

setUsingFormatJson (usingFormatJson)

boolean usingFormatJson

withUsingFormatJson (usingFormatJson) → JsonKeyValuePair

boolean usingFormatJson

returns JsonKeyValuePair

@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

returns KeepExpression

withOrderByElements (orderByElements) → KeepExpression

List orderByElements

returns KeepExpression

withFirst (first) → KeepExpression

boolean first

returns KeepExpression

addOrderByElements (orderByElements) → KeepExpression

OrderByElement orderByElements

returns KeepExpression

addOrderByElements (orderByElements) → KeepExpression

Collection orderByElements

returns KeepExpression

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

returns 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

returns MySQLGroupConcat

withDistinct (distinct) → MySQLGroupConcat

boolean distinct

returns MySQLGroupConcat

withOrderByElements (orderByElements) → MySQLGroupConcat

List orderByElements

returns MySQLGroupConcat

withSeparator (separator) → MySQLGroupConcat

String separator

returns MySQLGroupConcat

addOrderByElements (orderByElements) → MySQLGroupConcat

OrderByElement orderByElements

returns MySQLGroupConcat

addOrderByElements (orderByElements) → MySQLGroupConcat

Collection orderByElements

returns MySQLGroupConcat

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

returns NextValExpression

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

returns NotExpression

withExclamationMark (exclamationMark) → NotExpression

boolean exclamationMark

returns NotExpression

getExpression (part) → E

Class part

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

returns OracleHierarchicalExpression

withConnectExpression (connectExpression) → OracleHierarchicalExpression

Expression connectExpression

returns OracleHierarchicalExpression

withNoCycle (noCycle) → OracleHierarchicalExpression

boolean noCycle

returns OracleHierarchicalExpression

withConnectFirst (connectFirst) → OracleHierarchicalExpression

boolean connectFirst

returns OracleHierarchicalExpression

getStartExpression (part) → E

Class part

returns E

getConnectExpression (part) → E

Class part

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)

ExpressionVisitor 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

returns OrderByClause

addOrderByElements (orderByElements) → OrderByClause

OrderByElement orderByElements

returns OrderByClause

addOrderByElements (orderByElements) → OrderByClause

Collection orderByElements

returns OrderByClause

OverlapsCondition

extends: ASTNodeAccessImpl implements: Expression

OverlapsCondition (left, right)

ExpressionList left

ExpressionList right

getLeft () → ExpressionList

returns ExpressionList

getRight () → ExpressionList

returns 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 (part) → E

Class part

returns E

PartitionByClause

extends: Object implements: Serializable

PartitionByClause ()

getPartitionExpressionList () → ExpressionList

returns 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

returns PartitionByClause

RangeExpression

extends: ASTNodeAccessImpl implements: Expression

RangeExpression (startExpression, endExpression)

Expression startExpression

Expression endExpression

getStartExpression () → Expression

returns Expression

setStartExpression (startExpression) → RangeExpression

Expression startExpression

returns RangeExpression

getEndExpression () → Expression

returns Expression

setEndExpression (endExpression) → RangeExpression

Expression endExpression

returns RangeExpression

@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

returns RowConstructor

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

returns 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

returns SQLServerHints

withIndexName (indexName) → SQLServerHints

String indexName

returns SQLServerHints

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

returns SignedExpression

withExpression (expression) → SignedExpression

Expression expression

returns SignedExpression

getExpression (part) → E

Class part

returns E

SpannerInterleaveIn

extends: Object

SpannerInterleaveIn ()

SpannerInterleaveIn (jdbcTable, action)

Table jdbcTable

OnDelete action

SpannerInterleaveIn (nameParts)

List nameParts

SpannerInterleaveIn (tableName)

String tableName

getTable () → Table

returns Table

setTable (jdbcTable)

Table jdbcTable

getOnDelete () → OnDelete

returns OnDelete

setOnDelete (action)

OnDelete action

@Override

toString () → String

returns String

withTable (jdbcTable) → SpannerInterleaveIn

Table jdbcTable

returns SpannerInterleaveIn

withOnDelete (action) → SpannerInterleaveIn

OnDelete action

returns SpannerInterleaveIn

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

returns TimeKeyExpression

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

returns TimestampValue

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

returns TranscodingFunction

getTranscodingName () → String

returns String

setTranscodingName (transcodingName)

String transcodingName

withTranscodingName (transcodingName) → TranscodingFunction

String transcodingName

returns TranscodingFunction

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 (part) → E

Class part

returns E

getWhenExpression (part) → E

Class part

returns E

WindowDefinition

extends: Object implements: Serializable

WindowDefinition ()

getOrderBy () → OrderByClause

returns OrderByClause

getPartitionBy () → PartitionByClause

returns PartitionByClause

getWindowElement () → WindowElement

returns WindowElement

setWindowElement (windowElement)

WindowElement windowElement

getOrderByElements () → List

returns List

setOrderByElements (orderByElements)

List orderByElements

getPartitionExpressionList () → ExpressionList

returns 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

returns WindowDefinition

@Override

toString () → String

returns String

WindowElement

extends: Object implements: Serializable

WindowElement ()

getType () → Type

returns Type

setType (part)

Type part

getOffset () → WindowOffset

returns WindowOffset

setOffset (offset)

WindowOffset offset

getRange () → WindowRange

returns WindowRange

setRange (range)

WindowRange range

@Override

toString () → String

returns String

withType (part) → WindowElement

Type part

returns WindowElement

withOffset (offset) → WindowElement

WindowOffset offset

returns WindowElement

withRange (range) → WindowElement

WindowRange range

returns WindowElement

WindowOffset

extends: Object implements: Serializable

WindowOffset ()

getExpression () → Expression

returns Expression

setExpression (expression)

Expression expression

getType () → Type

returns Type

setType (part)

Type part

@Override

toString () → String

returns String

withExpression (expression) → WindowOffset

Expression expression

returns WindowOffset

withType (part) → WindowOffset

Type part

returns WindowOffset

getExpression (part) → E

Class part

returns E

WindowRange

extends: Object implements: Serializable

WindowRange ()

getEnd () → WindowOffset

returns WindowOffset

setEnd (end)

WindowOffset end

getStart () → WindowOffset

returns WindowOffset

setStart (start)

WindowOffset start

@Override

toString () → String

returns String

withStart (start) → WindowRange

WindowOffset start

returns WindowRange

withEnd (end) → WindowRange

WindowOffset end

returns 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)

BitwiseRightShift aThis

visit (aThis)

BitwiseLeftShift 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)

IntegerDivision 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)

ParenthesedSelect 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)

CastExpression cast

visit (modulo)

Modulo modulo

visit (aexpr)

AnalyticExpression aexpr

visit (eexpr)

ExtractExpression eexpr

visit (iexpr)

IntervalExpression iexpr

visit (oexpr)

OracleHierarchicalExpression oexpr

visit (rexpr)

RegExpMatchOperator rexpr

visit (jsonExpr)

JsonExpression jsonExpr

visit (jsonExpr)

JsonOperator jsonExpr

visit (var)

UserVariable var

visit (bind)

NumericBind bind

visit (aexpr)

KeepExpression aexpr

visit (groupConcat)

MySQLGroupConcat groupConcat

visit (expressionList)

ExpressionList expressionList

visit (rowConstructor)

RowConstructor rowConstructor

visit (rowGetExpression)

RowGetExpression rowGetExpression

visit (hint)

OracleHint hint

visit (timeKeyExpression)

TimeKeyExpression timeKeyExpression

visit (literal)

DateTimeLiteralExpression literal

visit (aThis)

NotExpression aThis

visit (aThis)

NextValExpression aThis

visit (aThis)

CollateExpression aThis

visit (aThis)

SimilarToExpression aThis

visit (aThis)

ArrayExpression aThis

visit (aThis)

ArrayConstructor aThis

visit (aThis)

VariableAssignment aThis

visit (aThis)

XMLSerializeExpr aThis

visit (aThis)

TimezoneExpression aThis

visit (aThis)

JsonAggregateFunction aThis

visit (aThis)

JsonFunction aThis

visit (aThis)

ConnectByRootOperator aThis

visit (aThis)

OracleNamedFunctionParameter 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

Expression arg0

returns Addition

@Override

withRightExpression (arg0) → Addition

Expression arg0

returns Addition

BitwiseAnd

extends: BinaryExpression

BitwiseAnd ()

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

getStringExpression () → String

returns String

@Override

withLeftExpression (arg0) → BitwiseAnd

Expression arg0

returns BitwiseAnd

@Override

withRightExpression (arg0) → BitwiseAnd

Expression arg0

returns BitwiseAnd

BitwiseLeftShift

extends: BinaryExpression

BitwiseLeftShift ()

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

getStringExpression () → String

returns String

@Override

withLeftExpression (arg0) → BitwiseLeftShift

Expression arg0

returns BitwiseLeftShift

@Override

withRightExpression (arg0) → BitwiseLeftShift

Expression arg0

returns BitwiseLeftShift

BitwiseOr

extends: BinaryExpression

BitwiseOr ()

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

getStringExpression () → String

returns String

@Override

withLeftExpression (arg0) → BitwiseOr

Expression arg0

returns BitwiseOr

@Override

withRightExpression (arg0) → BitwiseOr

Expression arg0

returns BitwiseOr

BitwiseRightShift

extends: BinaryExpression

BitwiseRightShift ()

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

getStringExpression () → String

returns String

@Override

withLeftExpression (arg0) → BitwiseRightShift

Expression arg0

returns BitwiseRightShift

@Override

withRightExpression (arg0) → BitwiseRightShift

Expression arg0

returns BitwiseRightShift

BitwiseXor

extends: BinaryExpression

BitwiseXor ()

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

getStringExpression () → String

returns String

@Override

withLeftExpression (arg0) → BitwiseXor

Expression arg0

returns BitwiseXor

@Override

withRightExpression (arg0) → BitwiseXor

Expression arg0

returns BitwiseXor

Concat

extends: BinaryExpression

Concat ()

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

getStringExpression () → String

returns String

@Override

withLeftExpression (arg0) → Concat

Expression arg0

returns Concat

@Override

withRightExpression (arg0) → Concat

Expression arg0

returns Concat

Division

extends: BinaryExpression

Division ()

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

getStringExpression () → String

returns String

@Override

withLeftExpression (arg0) → Division

Expression arg0

returns Division

@Override

withRightExpression (arg0) → Division

Expression arg0

returns Division

IntegerDivision

extends: BinaryExpression

IntegerDivision ()

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

getStringExpression () → String

returns String

@Override

withLeftExpression (arg0) → IntegerDivision

Expression arg0

returns IntegerDivision

@Override

withRightExpression (arg0) → IntegerDivision

Expression arg0

returns IntegerDivision

Modulo

extends: BinaryExpression

Modulo expression (a % b).

Modulo ()

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

getStringExpression () → String

returns String

@Override

withLeftExpression (arg0) → Modulo

Expression arg0

returns Modulo

@Override

withRightExpression (arg0) → Modulo

Expression arg0

returns Modulo

Multiplication

extends: BinaryExpression

Multiplication ()

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

getStringExpression () → String

returns String

@Override

withLeftExpression (arg0) → Multiplication

Expression arg0

returns Multiplication

@Override

withRightExpression (arg0) → Multiplication

Expression arg0

returns Multiplication

Subtraction

extends: BinaryExpression

Subtraction ()

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

getStringExpression () → String

returns String

@Override

withLeftExpression (arg0) → Subtraction

Expression arg0

returns Subtraction

@Override

withRightExpression (arg0) → Subtraction

Expression arg0

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

returns AndExpression

@Override

withLeftExpression (arg0) → AndExpression

Expression arg0

returns AndExpression

@Override

withRightExpression (arg0) → AndExpression

Expression arg0

returns 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

returns XorExpression

@Override

withRightExpression (expression) → XorExpression

Expression expression

returns XorExpression

@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 (part) → E

Class part

returns E

getBetweenExpressionStart (part) → E

Class part

returns E

getLeftExpression (part) → E

Class part

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

Expression left

Expression right

@Override

getStringExpression () → String

returns String

@Override

withLeftExpression (arg0) → ComparisonOperator

Expression arg0

returns ComparisonOperator

@Override

withRightExpression (arg0) → ComparisonOperator

Expression arg0

returns ComparisonOperator

@Override

withOldOracleJoinSyntax (oldOracleJoinSyntax) → ComparisonOperator

int oldOracleJoinSyntax

returns ComparisonOperator

@Override

withOraclePriorPosition (oraclePriorPosition) → ComparisonOperator

int oraclePriorPosition

returns ComparisonOperator

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)

Expression left

Expression 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

returns ExistsExpression

withNot (not) → ExistsExpression

boolean not

returns ExistsExpression

getRightExpression (part) → E

Class part

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

returns ExpressionList

addExpressions (expressions) → ExpressionList

T expressions

returns ExpressionList

addExpressions (expressions) → ExpressionList

Collection expressions

returns ExpressionList

withExpressions (expressions) → ExpressionList

T expressions

returns ExpressionList

withExpressions (expressions) → ExpressionList

Collection expressions

returns ExpressionList

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 (jdbcColumns)

ExpressionList jdbcColumns

getMatchColumns () → ExpressionList

returns ExpressionList

setAgainstValue (val)

StringValue val

setAgainstValue (val)

JdbcNamedParameter val

setAgainstValue (val)

JdbcParameter 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

returns FullTextSearch

withAgainstValue (againstValue) → FullTextSearch

StringValue againstValue

returns FullTextSearch

withSearchModifier (searchModifier) → FullTextSearch

String searchModifier

returns FullTextSearch

addMatchColumns (matchColumns) → FullTextSearch

Column matchColumns

returns FullTextSearch

addMatchColumns (matchColumns) → FullTextSearch

Collection matchColumns

returns FullTextSearch

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

Expression arg0

returns GreaterThan

@Override

withRightExpression (arg0) → GreaterThan

Expression arg0

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

Expression arg0

returns GreaterThanEquals

@Override

withRightExpression (arg0) → GreaterThanEquals

Expression arg0

returns GreaterThanEquals

@Override

withOldOracleJoinSyntax (arg0) → GreaterThanEquals

int arg0

returns GreaterThanEquals

@Override

withOraclePriorPosition (arg0) → GreaterThanEquals

int arg0

returns GreaterThanEquals

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 (part) → E

Class part

returns E

getRightExpression (part) → E

Class part

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

returns IsBooleanExpression

withLeftExpression (leftExpression) → IsBooleanExpression

Expression leftExpression

returns IsBooleanExpression

withNot (not) → IsBooleanExpression

boolean not

returns IsBooleanExpression

getLeftExpression (part) → E

Class part

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

returns IsNullExpression

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

toString () → String

returns String

withUseIsNull (useIsNull) → IsNullExpression

boolean useIsNull

returns IsNullExpression

withLeftExpression (leftExpression) → IsNullExpression

Expression leftExpression

returns IsNullExpression

withNot (not) → IsNullExpression

boolean not

returns IsNullExpression

getLeftExpression (part) → E

Class part

returns E

JsonOperator

extends: BinaryExpression

JsonOperator (op)

String op

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

getStringExpression () → String

returns String

@Override

withLeftExpression (arg0) → JsonOperator

Expression arg0

returns JsonOperator

@Override

withRightExpression (arg0) → JsonOperator

Expression arg0

returns JsonOperator

LikeExpression

extends: BinaryExpression

LikeExpression ()

isNot () → boolean

returns boolean

setNot (b)

boolean b

isUseBinary () → boolean

returns boolean

setUseBinary (useBinary) → LikeExpression

boolean useBinary

returns LikeExpression

@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

returns LikeExpression

setLikeKeyWord (likeKeyWord) → LikeExpression

String likeKeyWord

returns LikeExpression

withEscape (escape) → LikeExpression

Expression escape

returns LikeExpression

@Deprecated

withCaseInsensitive (caseInsensitive) → LikeExpression

boolean caseInsensitive

returns LikeExpression

withNot (not) → LikeExpression

boolean not

returns LikeExpression

@Override

withLeftExpression (arg0) → LikeExpression

Expression arg0

returns LikeExpression

@Override

withRightExpression (arg0) → LikeExpression

Expression arg0

returns LikeExpression

Matches

extends: OldOracleJoinBinaryExpression

Matches ()

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

getStringExpression () → String

returns String

@Override

withLeftExpression (arg0) → Matches

Expression arg0

returns Matches

@Override

withRightExpression (arg0) → Matches

Expression arg0

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

returns MemberOfExpression

getRightExpression () → Expression

returns Expression

setRightExpression (rightExpression) → MemberOfExpression

Expression rightExpression

returns MemberOfExpression

isNot () → boolean

returns boolean

setNot (not) → MemberOfExpression

boolean not

returns MemberOfExpression

@Override

toString () → String

returns String

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

MinorThan

extends: ComparisonOperator

MinorThan ()

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Override

withLeftExpression (arg0) → MinorThan

Expression arg0

returns MinorThan

@Override

withRightExpression (arg0) → MinorThan

Expression arg0

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

Expression arg0

returns MinorThanEquals

@Override

withRightExpression (arg0) → MinorThanEquals

Expression arg0

returns MinorThanEquals

@Override

withOldOracleJoinSyntax (arg0) → MinorThanEquals

int arg0

returns MinorThanEquals

@Override

withOraclePriorPosition (arg0) → MinorThanEquals

int arg0

returns MinorThanEquals

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

returns NamedExpressionList

addNames (names) → NamedExpressionList

String names

returns NamedExpressionList

addNames (names) → NamedExpressionList

Collection names

returns NamedExpressionList

NotEqualsTo

extends: ComparisonOperator

NotEqualsTo ()

NotEqualsTo (operator)

String operator

NotEqualsTo (left, right)

Expression left

Expression 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

returns OldOracleJoinBinaryExpression

withOraclePriorPosition (oraclePriorPosition) → OldOracleJoinBinaryExpression

int oraclePriorPosition

returns OldOracleJoinBinaryExpression

@Override

withLeftExpression (arg0) → OldOracleJoinBinaryExpression

Expression arg0

returns OldOracleJoinBinaryExpression

@Override

withRightExpression (arg0) → OldOracleJoinBinaryExpression

Expression arg0

returns OldOracleJoinBinaryExpression

ParenthesedExpressionList

extends: ExpressionList provides: RowConstructor

ParenthesedExpressionList ()

ParenthesedExpressionList (expressions)

ExpressionList expressions

ParenthesedExpressionList (expressions)

T expressions

ParenthesedExpressionList (expressions)

Collection expressions

from (expressions) → ParenthesedExpressionList

ExpressionList expressions

returns 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

Expression arg0

returns RegExpMatchOperator

@Override

withRightExpression (arg0) → RegExpMatchOperator

Expression arg0

returns 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

returns SimilarToExpression

withNot (not) → SimilarToExpression

boolean not

returns SimilarToExpression

@Override

withLeftExpression (arg0) → SimilarToExpression

Expression arg0

returns SimilarToExpression

@Override

withRightExpression (arg0) → SimilarToExpression

Expression arg0

returns 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

returns SupportsOldOracleJoinSyntax

getOraclePriorPosition () → int

returns int

setOraclePriorPosition (priorPosition)

int priorPosition

withOraclePriorPosition (priorPosition) → SupportsOldOracleJoinSyntax

int priorPosition

returns SupportsOldOracleJoinSyntax

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

returns 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)

StatementListener listener

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 jdbcColumn

@Deprecated

getLine () → int

returns int | the line

getEndColumn () → int

returns int | get token end jdbcColumn number.

getEndLine () → int

returns int | get token end line number.

getBeginColumn () → int

returns int | get token beginning jdbcColumn 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 jdbcColumn 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.

copy () → ModifyableFeatureSet

returns ModifyableFeatureSet

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

jdbcSchema

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 jdbcColumn. It can have the jdbcTable name it belongs to.

Column ()

Column (jdbcTable, columnName)

Table jdbcTable

String columnName

Column (nameParts)

List nameParts

Column (columnName)

String columnName

getArrayConstructor () → ArrayConstructor

returns 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 jdbcTable Foo. On the other hand, consider:

SELECT t.x FROM Foo t

Here, we will get a Table object for a jdbcTable 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.jdbcSchema.Table representing the jdbcTable this jdbcColumn does belong to, if it can be inferred. Can be null.

setTable (jdbcTable)

Table jdbcTable

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 (jdbcTable) → Column

Table jdbcTable

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 part 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 jdbcTable. It can have an alias and the jdbcSchema 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

returns MySQLIndexHint

withHint (hint) → Table

MySQLIndexHint hint

returns Table

setHint (hint)

MySQLIndexHint hint

getSqlServerHints () → SQLServerHints

returns 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

returns CreateFunctionalStatement

addFunctionDeclarationParts (functionDeclarationParts) → CreateFunctionalStatement

String functionDeclarationParts

returns CreateFunctionalStatement

addFunctionDeclarationParts (functionDeclarationParts) → CreateFunctionalStatement

Collection functionDeclarationParts

returns CreateFunctionalStatement

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

returns DeclareStatement

addTypeDefExprList (typeDefExpressions) → DeclareStatement

Collection typeDefExpressions

returns DeclareStatement

withTypeDefExprList (typeDefExpressions) → DeclareStatement

List typeDefExpressions

returns DeclareStatement

setTypeDefExprList (expr)

List expr

getTypeDefExprList () → List

returns List

addColumnDefinition (colDef)

ColumnDefinition 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

returns DeclareStatement

withTypeName (typeName) → DeclareStatement

String typeName

returns DeclareStatement

withDeclareType (declareType) → DeclareStatement

DeclareType declareType

returns DeclareStatement

withColumnDefinitions (columnDefinitions) → DeclareStatement

List columnDefinitions

returns DeclareStatement

addColumnDefinitions (statements) → DeclareStatement

ColumnDefinition statements

returns DeclareStatement

addColumnDefinitions (columnDefinitions) → DeclareStatement

Collection columnDefinitions

returns DeclareStatement

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 (jdbcTable)

Table jdbcTable

getTable () → Table

returns Table

setTable (jdbcTable)

Table jdbcTable

@Override

toString () → String

returns String

@Override

accept (statementVisitor)

StatementVisitor statementVisitor

withTable (jdbcTable) → DescribeStatement

Table jdbcTable

returns DescribeStatement

getDescribeType () → String

returns String

setDescribeType (describeType) → DescribeStatement

String describeType

returns DescribeStatement

ExplainStatement

extends: Object implements: Statement

An EXPLAIN statement

ExplainStatement ()

ExplainStatement (select)

Select select

getTable () → Table

returns Table

setTable (jdbcTable) → ExplainStatement

Table jdbcTable

returns ExplainStatement

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 part to retrieve an Option for

returns Option | an option of that part, 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 (part)

OptionType part

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 (jdbcTable)

Table jdbcTable

PurgeStatement (jdbcIndex)

Index jdbcIndex

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 (part, action)

Type part

Action action

getType () → Type

returns Type

setType (part)

Type part

withType (part) → ReferentialAction

Type part

returns ReferentialAction

getAction () → Action

returns Action

setAction (action)

Action action

withAction (action) → ReferentialAction

Action action

returns ReferentialAction

@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

returns ReturningClause

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

returns RollbackStatement

setUsingWorkKeyword (usingWorkKeyword)

boolean usingWorkKeyword

isUsingSavepointKeyword () → boolean

returns boolean

withUsingSavepointKeyword (usingSavepointKeyword) → RollbackStatement

boolean usingSavepointKeyword

returns RollbackStatement

setUsingSavepointKeyword (usingSavepointKeyword)

boolean usingSavepointKeyword

getSavepointName () → String

returns String

withSavepointName (savepointName) → RollbackStatement

String savepointName

returns RollbackStatement

setSavepointName (savepointName)

String savepointName

getForceDistributedTransactionIdentifier () → String

returns String

withForceDistributedTransactionIdentifier (forceDistributedTransactionIdentifier) → RollbackStatement

String forceDistributedTransactionIdentifier

returns RollbackStatement

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

ExpressionList value

add (name, value, useEqual)

Object name

ExpressionList value

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

returns ShowColumnsStatement

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

returns ShowStatement

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)

CreateSchema aThis

@Override

visit (createTable)

CreateTable createTable

@Override

visit (createView)

CreateView createView

@Override

visit (alter)

Alter alter

@Override

visit (stmts)

Statements stmts

@Override

visit (execute)

Execute execute

@Override

visit (set)

SetStatement set

@Override

visit (reset)

ResetStatement reset

@Override

visit (merge)

Merge merge

@Override

visit (alterView)

AlterView alterView

@Override

visit (upsert)

Upsert upsert

@Override

visit (use)

UseStatement use

@Override

visit (block)

Block block

@Override

visit (describe)

DescribeStatement describe

@Override

visit (aThis)

ExplainStatement aThis

@Override

visit (aThis)

ShowStatement aThis

@Override

visit (set)

ShowColumnsStatement set

@Override

visit (set)

ShowIndexStatement set

@Override

visit (showTables)

ShowTablesStatement showTables

@Override

visit (aThis)

DeclareStatement 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)

RefreshMaterializedViewStatement materializedView

Statements

extends: ArrayList implements: Serializable

Statements ()

@Deprecated

getStatements () → List

returns List

@Deprecated

setStatements (statements)

List statements

accept (statementVisitor)

StatementVisitor statementVisitor

get (part, jdbcIndex) → E

Class part

int jdbcIndex

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)

CreateSchema aThis

visit (createTable)

CreateTable createTable

visit (createView)

CreateView createView

visit (alterView)

AlterView alterView

visit (materializedView)

RefreshMaterializedViewStatement materializedView

visit (alter)

Alter alter

visit (stmts)

Statements stmts

visit (execute)

Execute execute

visit (set)

SetStatement set

visit (reset)

ResetStatement reset

visit (set)

ShowColumnsStatement set

visit (showIndex)

ShowIndexStatement showIndex

visit (showTables)

ShowTablesStatement showTables

visit (merge)

Merge merge

visit (select)

Select select

visit (upsert)

Upsert upsert

visit (use)

UseStatement use

visit (block)

Block block

visit (describe)

DescribeStatement describe

visit (aThis)

ExplainStatement aThis

visit (aThis)

ShowStatement aThis

visit (aThis)

DeclareStatement 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)

IfElseStatement 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, TRUNCATE_PARTITION]

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 (jdbcTable)

Table jdbcTable

isUseOnly () → boolean

returns boolean

setUseOnly (useOnly)

boolean useOnly

isUseTableIfExists () → boolean

returns boolean

setUseTableIfExists (useTableIfExists)

boolean useTableIfExists

withUseTableIfExists (useTableIfExists) → Alter

boolean useTableIfExists

returns Alter

addAlterExpression (alterExpression)

AlterExpression alterExpression

getAlterExpressions () → List

returns List

setAlterExpressions (alterExpressions)

List alterExpressions

@Override

accept (statementVisitor)

StatementVisitor statementVisitor

@Override

toString () → String

returns String

withTable (jdbcTable) → Alter

Table jdbcTable

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 (part, action)

Type part

Action action

withReferentialAction (part, action) → AlterExpression

Type part

Action action

returns AlterExpression

removeReferentialAction (part)

Type part

getReferentialAction (part) → ReferentialAction

Type part

returns ReferentialAction |

@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 (jdbcIndex)

Index jdbcIndex

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

getTruncatePartitionName () → String

returns String

setTruncatePartitionName (truncatePartitionName)

String truncatePartitionName

withTruncatePartitionName (truncatePartitionName) → AlterExpression

String truncatePartitionName

returns AlterExpression

isUseIfNotExists () → boolean

returns boolean

setUseIfNotExists (useIfNotExists)

boolean useIfNotExists

withUserIfNotExists (userIfNotExists) → AlterExpression

boolean userIfNotExists

returns AlterExpression

@Override,| @SuppressWarnings

toString () → String

returns String

withOperation (operation) → AlterExpression

AlterOperation operation

returns AlterExpression

withOptionalSpecifier (optionalSpecifier) → AlterExpression

String optionalSpecifier

returns AlterExpression

withColumnName (columnName) → AlterExpression

String columnName

returns AlterExpression

withPkColumns (pkColumns) → AlterExpression

List pkColumns

returns AlterExpression

withUkColumns (ukColumns) → AlterExpression

List ukColumns

returns AlterExpression

withUkName (ukName) → AlterExpression

String ukName

returns AlterExpression

withIndex (jdbcIndex) → AlterExpression

Index jdbcIndex

returns AlterExpression

withConstraintName (constraintName) → AlterExpression

String constraintName

returns AlterExpression

withUsingIfExists (usingIfExists) → AlterExpression

boolean usingIfExists

returns AlterExpression

withOnDeleteRestrict (onDeleteRestrict) → AlterExpression

boolean onDeleteRestrict

returns AlterExpression

withOnDeleteSetNull (onDeleteSetNull) → AlterExpression

boolean onDeleteSetNull

returns AlterExpression

withOnDeleteCascade (onDeleteCascade) → AlterExpression

boolean onDeleteCascade

returns AlterExpression

withFkColumns (fkColumns) → AlterExpression

List fkColumns

returns AlterExpression

withFkSourceSchema (fkSourceSchema) → AlterExpression

String fkSourceSchema

returns AlterExpression

withFkSourceTable (fkSourceTable) → AlterExpression

String fkSourceTable

returns AlterExpression

withFkSourceColumns (fkSourceColumns) → AlterExpression

List fkSourceColumns

returns AlterExpression

withUk (uk) → AlterExpression

boolean uk

returns AlterExpression

withUseEqual (useEqual) → AlterExpression

boolean useEqual

returns AlterExpression

withConstraints (constraints) → AlterExpression

List constraints

returns AlterExpression

withCommentText (commentText) → AlterExpression

String commentText

returns AlterExpression

withColumnOldName (columnOldName) → AlterExpression

String columnOldName

returns AlterExpression

addPkColumns (pkColumns) → AlterExpression

String pkColumns

returns AlterExpression

addPkColumns (pkColumns) → AlterExpression

Collection pkColumns

returns AlterExpression

addUkColumns (ukColumns) → AlterExpression

String ukColumns

returns AlterExpression

addUkColumns (ukColumns) → AlterExpression

Collection ukColumns

returns AlterExpression

addFkColumns (fkColumns) → AlterExpression

String fkColumns

returns AlterExpression

addFkColumns (fkColumns) → AlterExpression

Collection fkColumns

returns AlterExpression

addFkSourceColumns (fkSourceColumns) → AlterExpression

String fkSourceColumns

returns AlterExpression

addFkSourceColumns (fkSourceColumns) → AlterExpression

Collection fkSourceColumns

returns AlterExpression

addConstraints (constraints) → AlterExpression

ConstraintState constraints

returns AlterExpression

addConstraints (constraints) → AlterExpression

Collection constraints

returns AlterExpression

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

returns ColumnDataType

@Override

withColumnName (columnName) → ColumnDataType

String columnName

returns ColumnDataType

@Override

addColumnSpecs (columnSpecs) → ColumnDataType

String columnSpecs

returns ColumnDataType

@Override

addColumnSpecs (columnSpecs) → ColumnDataType

Collection columnSpecs

returns ColumnDataType

@Override

withColumnSpecs (columnSpecs) → ColumnDataType

List columnSpecs

returns ColumnDataType

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

returns DeferrableConstraint

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

returns EnableConstraint

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

returns RenameTableStatement

isUsingIfExistsKeyword () → boolean

returns boolean

setUsingIfExistsKeyword (usingIfExistsKeyword)

boolean usingIfExistsKeyword

withUsingIfExistsKeyword (usingIfExistsKeyword) → RenameTableStatement

boolean usingIfExistsKeyword

returns RenameTableStatement

getWaitDirective () → String

returns String

setWaitDirective (waitDirective)

String waitDirective

withWaitDirective (waitDirective) → RenameTableStatement

String waitDirective

returns RenameTableStatement

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

returns ValidateConstraint

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

returns AlterSequence

statement.analyze

Analyze

extends: Object implements: Statement

Analyze ()

@Override

accept (statementVisitor)

StatementVisitor statementVisitor

getTable () → Table

returns Table

setTable (jdbcTable)

Table jdbcTable

@Override

toString () → String

returns String

withTable (jdbcTable) → Analyze

Table jdbcTable

returns Analyze

statement.comment

Comment

extends: Object implements: Statement

Comment ()

@Override

accept (statementVisitor)

StatementVisitor statementVisitor

getTable () → Table

returns Table

setTable (jdbcTable)

Table jdbcTable

getColumn () → Column

returns Column

setColumn (jdbcColumn)

Column jdbcColumn

getView () → Table

returns Table

setView (view)

Table view

getComment () → StringValue

returns StringValue

setComment (comment)

StringValue comment

@Override

toString () → String

returns String

withTable (jdbcTable) → Comment

Table jdbcTable

returns Comment

withColumn (jdbcColumn) → Comment

Column jdbcColumn

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

returns CreateFunction

@Override

addFunctionDeclarationParts (functionDeclarationParts) → CreateFunction

String functionDeclarationParts

returns CreateFunction

@Override

addFunctionDeclarationParts (functionDeclarationParts) → CreateFunction

Collection functionDeclarationParts

returns CreateFunction

statement.create.jdbcIndex

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 (jdbcIndex)

Index jdbcIndex

getTable () → Table

returns Table

setTable (jdbcTable)

Table jdbcTable

getTailParameters () → List

returns List

setTailParameters (tailParameters)

List tailParameters

@Override

toString () → String

returns String

withTable (jdbcTable) → CreateIndex

Table jdbcTable

returns CreateIndex

withIndex (jdbcIndex) → CreateIndex

Index jdbcIndex

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

returns CreateProcedure

@Override

addFunctionDeclarationParts (functionDeclarationParts) → CreateProcedure

String functionDeclarationParts

returns CreateProcedure

@Override

addFunctionDeclarationParts (functionDeclarationParts) → CreateProcedure

Collection functionDeclarationParts

returns CreateProcedure

statement.create.jdbcSchema

CreateSchema

extends: Object implements: Statement

CreateSchema ()

@Override

accept (statementVisitor)

StatementVisitor statementVisitor

addStatement (statement) → boolean

Add a statement to the jdbcSchema definition

Statement statement | statement The statement to be added

returns boolean | true if the operation was successful

getAuthorization () → String

The owner of the jdbcSchema.

returns String | Owner name

getSchemaName () → String

The name of the jdbcSchema

returns String | Schema name

getSchemaPath () → List

The path of the jdbcSchema

returns List | Schema path

getStatements () → List

The statements executed as part of the jdbcSchema creation

returns List | the statements

setAuthorization (authorization)

The owner of the schems.

String authorization | authorization Owner name

setSchemaName (schemaName)

Set the name of the jdbcSchema

String schemaName | schemaName Schema name

setSchemaPath (schemaPath)

Set the path of the jdbcSchema

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

returns CreateSequence

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

returns CreateSynonym

statement.create.jdbcTable

RowMovementMode

[ENABLE, DISABLE]

CheckConstraint

extends: NamedConstraint

CheckConstraint ()

getTable () → Table

returns Table

setTable (jdbcTable)

Table jdbcTable

getExpression () → Expression

returns Expression

setExpression (expression)

Expression expression

@Override

toString () → String

returns String

withTable (jdbcTable) → CheckConstraint

Table jdbcTable

returns CheckConstraint

withExpression (expression) → CheckConstraint

Expression expression

returns CheckConstraint

getExpression (part) → E

Class part

returns E

@Override

withType (part) → CheckConstraint

String part

returns CheckConstraint

@Override

withUsing (using) → CheckConstraint

String using

returns CheckConstraint

@Override

withName (name) → CheckConstraint

List name

returns CheckConstraint

@Override

withName (name) → CheckConstraint

String name

returns CheckConstraint

@Override

withColumnsNames (list) → CheckConstraint

List list

returns CheckConstraint

@Override

withColumns (jdbcColumns) → CheckConstraint

List jdbcColumns

returns CheckConstraint

@Override

addColumns (functionDeclarationParts) → CheckConstraint

ColumnParams functionDeclarationParts

returns CheckConstraint

@Override

addColumns (functionDeclarationParts) → CheckConstraint

Collection functionDeclarationParts

returns CheckConstraint

@Override

withIndexSpec (idxSpec) → CheckConstraint

List idxSpec

returns CheckConstraint

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 jdbcColumns.

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 (part)

ColDataType part

getColumnName () → String

returns String

setColumnName (string)

String string

@Override

toString () → String

returns String

toStringDataTypeAndSpec () → String

returns String

withColumnName (columnName) → ColumnDefinition

String columnName

returns ColumnDefinition

withColDataType (colDataType) → ColumnDefinition

ColDataType colDataType

returns ColumnDefinition

withColumnSpecs (columnSpecs) → ColumnDefinition

List columnSpecs

returns ColumnDefinition

addColumnSpecs (columnSpecs) → ColumnDefinition

String columnSpecs

returns ColumnDefinition

addColumnSpecs (columnSpecs) → ColumnDefinition

Collection columnSpecs

returns ColumnDefinition

CreateTable

extends: Object implements: Statement

CreateTable ()

@Override

accept (statementVisitor)

StatementVisitor statementVisitor

getTable () → Table

returns Table

setTable (jdbcTable)

Table jdbcTable

isUnlogged () → boolean

returns boolean

setUnlogged (unlogged)

boolean unlogged

getColumnDefinitions () → List

returns List | a list of `ColumnDefinition`s of this jdbcTable.

setColumnDefinitions (list)

List list

getColumns () → List

returns List

setColumns (jdbcColumns)

List jdbcColumns

getTableOptionsStrings () → List

returns List | a list of options (as simple strings) of this jdbcTable 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 jdbcTable.

Indexes created with jdbcColumn 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 (jdbcTable) → CreateTable

Table jdbcTable

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 (jdbcColumns) → CreateTable

List jdbcColumns

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 (jdbcColumns) → CreateTable

String jdbcColumns

returns CreateTable

addColumns (jdbcColumns) → CreateTable

Collection jdbcColumns

returns CreateTable

addIndexes (indexes) → CreateTable

Index indexes

returns CreateTable

addIndexes (indexes) → CreateTable

Collection indexes

returns CreateTable

getSpannerInterleaveIn () → SpannerInterleaveIn

returns 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

returns ExcludeConstraint

getExpression (part) → E

Class part

returns E

@Override

withName (name) → ExcludeConstraint

List name

returns ExcludeConstraint

@Override

withType (part) → ExcludeConstraint

String part

returns ExcludeConstraint

@Override

withUsing (using) → ExcludeConstraint

String using

returns ExcludeConstraint

@Override

withColumnsNames (list) → ExcludeConstraint

List list

returns ExcludeConstraint

@Override

withColumns (jdbcColumns) → ExcludeConstraint

List jdbcColumns

returns ExcludeConstraint

@Override

addColumns (functionDeclarationParts) → ExcludeConstraint

ColumnParams functionDeclarationParts

returns ExcludeConstraint

@Override

addColumns (functionDeclarationParts) → ExcludeConstraint

Collection functionDeclarationParts

returns ExcludeConstraint

@Override

withIndexSpec (idxSpec) → ExcludeConstraint

List idxSpec

returns ExcludeConstraint

@Override

withName (name) → ExcludeConstraint

String name

returns ExcludeConstraint

ForeignKeyIndex

extends: NamedConstraint

ForeignKeyIndex ()

getTable () → Table

returns Table

setTable (jdbcTable)

Table jdbcTable

getReferencedColumnNames () → List

returns List

setReferencedColumnNames (referencedColumnNames)

List referencedColumnNames

setReferentialAction (part, action)

Type part

Action action

withReferentialAction (part, action) → ForeignKeyIndex

Type part

Action action

returns ForeignKeyIndex

removeReferentialAction (part)

Type part

getReferentialAction (part) → ReferentialAction

Type part

returns ReferentialAction |

@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 (jdbcTable) → ForeignKeyIndex

Table jdbcTable

returns ForeignKeyIndex

withReferencedColumnNames (referencedColumnNames) → ForeignKeyIndex

List referencedColumnNames

returns ForeignKeyIndex

withOnDeleteReferenceOption (onDeleteReferenceOption) → ForeignKeyIndex

String onDeleteReferenceOption

returns ForeignKeyIndex

withOnUpdateReferenceOption (onUpdateReferenceOption) → ForeignKeyIndex

String onUpdateReferenceOption

returns ForeignKeyIndex

addReferencedColumnNames (referencedColumnNames) → ForeignKeyIndex

String referencedColumnNames

returns ForeignKeyIndex

addReferencedColumnNames (referencedColumnNames) → ForeignKeyIndex

Collection referencedColumnNames

returns ForeignKeyIndex

@Override

withType (part) → ForeignKeyIndex

String part

returns ForeignKeyIndex

@Override

withUsing (using) → ForeignKeyIndex

String using

returns ForeignKeyIndex

@Override

withName (name) → ForeignKeyIndex

List name

returns ForeignKeyIndex

@Override

withName (name) → ForeignKeyIndex

String name

returns ForeignKeyIndex

@Override

withColumnsNames (list) → ForeignKeyIndex

List list

returns ForeignKeyIndex

@Override

withColumns (jdbcColumns) → ForeignKeyIndex

List jdbcColumns

returns ForeignKeyIndex

@Override

addColumns (functionDeclarationParts) → ForeignKeyIndex

ColumnParams functionDeclarationParts

returns ForeignKeyIndex

@Override

addColumns (functionDeclarationParts) → ForeignKeyIndex

Collection functionDeclarationParts

returns ForeignKeyIndex

@Override

withIndexSpec (idxSpec) → ForeignKeyIndex

List idxSpec

returns ForeignKeyIndex

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 (jdbcColumns)

List jdbcColumns

withColumns (jdbcColumns) → Index

List jdbcColumns

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 jdbcIndex part (Btree, GIST, etc.) is indicated with a USING clause. Please note that: Oracle - the part might be BITMAP, indicating a bitmap kind of jdbcIndex MySQL - the part 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 (part) → Index

String part

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

returns NamedConstraint

@Override

withName (name) → NamedConstraint

String name

returns NamedConstraint

@Override

withType (part) → NamedConstraint

String part

returns NamedConstraint

@Override

withUsing (using) → NamedConstraint

String using

returns NamedConstraint

@Override

withColumnsNames (list) → NamedConstraint

List list

returns NamedConstraint

@Override

withColumns (jdbcColumns) → NamedConstraint

List jdbcColumns

returns NamedConstraint

@Override

addColumns (functionDeclarationParts) → NamedConstraint

ColumnParams functionDeclarationParts

returns NamedConstraint

@Override

addColumns (functionDeclarationParts) → NamedConstraint

Collection functionDeclarationParts

returns NamedConstraint

@Override

withIndexSpec (idxSpec) → NamedConstraint

List idxSpec

returns NamedConstraint

RowMovement

extends: Object implements: Serializable

Holds data for the row_movement clause: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7002.htm#i2204697

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, VOLATILE]

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 (part) → E

Class part

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

returns ExpressionList

setColumnNames (columnNames)

ExpressionList columnNames

isMaterialized () → boolean

returns boolean

setMaterialized (materialized)

boolean materialized

getForce () → ForceOption

returns ForceOption

setForce (force)

ForceOption force

isSecure () → boolean

returns boolean

setSecure (secure)

boolean secure

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

returns 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 (jdbcTables)

List jdbcTables

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 (jdbcTables) → Delete

List jdbcTables

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 (jdbcTable) → Delete

Table jdbcTable

returns Delete

withWhere (where) → Delete

Expression where

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 (jdbcTables) → Delete

Table jdbcTables

returns Delete

addTables (jdbcTables) → Delete

Collection jdbcTables

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 (part) → E

Class part

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 (part) → List

String part

returns List

withIfExists (ifExists) → Drop

boolean ifExists

returns Drop

withMaterialized (materialized) → Drop

boolean materialized

returns Drop

withType (part) → Drop

String part

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

returns ExpressionList

setExprList (exprList)

ExpressionList 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

ExpressionList exprList

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

returns ExpressionList

setColumns (list)

ExpressionList list

@Deprecated

isUseValues () → boolean

returns boolean

getReturningClause () → ReturningClause

returns 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

returns 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

returns InsertConflictTarget

setConflictTarget (conflictTarget)

InsertConflictTarget conflictTarget

withConflictTarget (conflictTarget) → Insert

InsertConflictTarget conflictTarget

returns Insert

getConflictAction () → InsertConflictAction

returns 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 (jdbcTable) → Insert

Table jdbcTable

returns Insert

withColumns (jdbcColumns) → Insert

ExpressionList jdbcColumns

returns Insert

addColumns (jdbcColumns) → Insert

Column jdbcColumns

returns Insert

addColumns (jdbcColumns) → Insert

Collection jdbcColumns

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

returns InsertConflictAction

getConflictActionType () → ConflictActionType

returns ConflictActionType

setConflictActionType (conflictActionType)

ConflictActionType conflictActionType

withConflictActionType (conflictActionType) → InsertConflictAction

ConflictActionType conflictActionType

returns InsertConflictAction

addUpdateSet (jdbcColumn, expression) → InsertConflictAction

Column jdbcColumn

Expression expression

returns InsertConflictAction

addUpdateSet (updateSet) → InsertConflictAction

UpdateSet updateSet

returns InsertConflictAction

withUpdateSets (updateSets) → InsertConflictAction

Collection updateSets

returns InsertConflictAction

getWhereExpression () → Expression

returns Expression

setWhereExpression (whereExpression)

Expression whereExpression

withWhereExpression (whereExpression) → InsertConflictAction

Expression whereExpression

returns InsertConflictAction

@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 (jdbcIndex) → String

int jdbcIndex

returns String

addIndexColumnName (indexColumnName) → boolean

String indexColumnName

returns boolean

withIndexColumnName (indexColumnName) → InsertConflictTarget

String indexColumnName

returns InsertConflictTarget

addAllIndexColumnNames (indexColumnName) → boolean

Collection indexColumnName

returns boolean

getIndexExpression () → Expression

returns Expression

setIndexExpression (indexExpression)

Expression indexExpression

withIndexExpression (indexExpression) → InsertConflictTarget

Expression indexExpression

returns InsertConflictTarget

getWhereExpression () → Expression

returns Expression

setWhereExpression (whereExpression)

Expression whereExpression

withWhereExpression (whereExpression) → InsertConflictTarget

Expression whereExpression

returns InsertConflictTarget

getConstraintName () → String

returns String

setConstraintName (constraintName)

String constraintName

withConstraintName (constraintName) → InsertConflictTarget

String constraintName

returns InsertConflictTarget

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

getOperations () → List

returns List

setOperations (operations)

List operations

getMergeInsert () → MergeInsert

returns MergeInsert

setMergeInsert (mergeInsert)

MergeInsert mergeInsert

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 (jdbcTable) → Merge

Table jdbcTable

returns Merge

withMergeInsert (mergeInsert) → Merge

MergeInsert mergeInsert

returns Merge

getOnCondition (part) → E

Class part

returns E

MergeDelete

extends: Object implements: Serializable, MergeOperation

MergeDelete ()

getAndPredicate () → Expression

returns Expression

setAndPredicate (andPredicate)

Expression andPredicate

withAndPredicate (andPredicate) → MergeDelete

Expression andPredicate

returns MergeDelete

@Override

accept (mergeOperationVisitor)

MergeOperationVisitor mergeOperationVisitor

@Override

toString () → String

returns String

MergeInsert

extends: Object implements: Serializable, MergeOperation

MergeInsert ()

getAndPredicate () → Expression

returns Expression

setAndPredicate (andPredicate)

Expression andPredicate

getColumns () → ExpressionList

returns ExpressionList

setColumns (jdbcColumns)

ExpressionList jdbcColumns

getValues () → ExpressionList

returns ExpressionList

setValues (values)

ExpressionList values

getWhereCondition () → Expression

returns Expression

setWhereCondition (whereCondition)

Expression whereCondition

@Override

accept (mergeOperationVisitor)

MergeOperationVisitor mergeOperationVisitor

@Override

toString () → String

returns String

withAndPredicate (andPredicate) → MergeInsert

Expression andPredicate

returns MergeInsert

withColumns (jdbcColumns) → MergeInsert

ExpressionList jdbcColumns

returns MergeInsert

withValues (values) → MergeInsert

ExpressionList values

returns MergeInsert

addColumns (jdbcColumns) → MergeInsert

Column jdbcColumns

returns MergeInsert

addColumns (jdbcColumns) → MergeInsert

Collection jdbcColumns

returns MergeInsert

addValues (values) → MergeInsert

Expression values

returns MergeInsert

addValues (values) → MergeInsert

Collection values

returns MergeInsert

withWhereCondition (whereCondition) → MergeInsert

Expression whereCondition

returns MergeInsert

getAndPredicate (part) → E

Class part

returns E

getWhereCondition (part) → E

Class part

returns E

MergeOperationVisitorAdapter

extends: Object implements: MergeOperationVisitor

MergeOperationVisitorAdapter ()

@Override

visit (mergeDelete)

MergeDelete mergeDelete

@Override

visit (mergeUpdate)

MergeUpdate mergeUpdate

@Override

visit (mergeInsert)

MergeInsert mergeInsert

MergeUpdate

extends: Object implements: Serializable, MergeOperation

MergeUpdate ()

MergeUpdate (updateSets)

List updateSets

getUpdateSets () → List

returns List

setUpdateSets (updateSets) → MergeUpdate

List updateSets

returns MergeUpdate

getAndPredicate () → Expression

returns Expression

setAndPredicate (andPredicate)

Expression andPredicate

getWhereCondition () → Expression

returns Expression

setWhereCondition (whereCondition)

Expression whereCondition

getDeleteWhereCondition () → Expression

returns Expression

setDeleteWhereCondition (deleteWhereCondition)

Expression deleteWhereCondition

@Override

accept (mergeOperationVisitor)

MergeOperationVisitor mergeOperationVisitor

@Override

toString () → String

returns String

withAndPredicate (andPredicate) → MergeUpdate

Expression andPredicate

returns MergeUpdate

withWhereCondition (whereCondition) → MergeUpdate

Expression whereCondition

returns MergeUpdate

withDeleteWhereCondition (deleteWhereCondition) → MergeUpdate

Expression deleteWhereCondition

returns MergeUpdate

getAndPredicate (part) → E

Class part

returns E

getWhereCondition (part) → E

Class part

returns E

getDeleteWhereCondition (part) → E

Class part

returns E

MergeOperation

provides: MergeDelete, MergeInsert, MergeUpdate,

Marker interface to cover MergeDelete, MergeUpdate and MergeInsert

accept (mergeOperationVisitor)

MergeOperationVisitor mergeOperationVisitor

MergeOperationVisitor

provides: MergeDeParser, MergeOperationVisitorAdapter, MergeValidator,

visit (mergeDelete)

MergeDelete mergeDelete

visit (mergeUpdate)

MergeUpdate mergeUpdate

visit (mergeInsert)

MergeInsert mergeInsert

statement.refresh

RefreshMode

[DEFAULT, WITH_DATA, WITH_NO_DATA]

RefreshMaterializedViewStatement

extends: Object implements: Statement

REFRESH MATERIALIZED VIEW [ CONCURRENTLY ] name [ WITH [ NO ] DATA ]

https://www.postgresql.org/docs/16/sql-refreshmaterializedview.html

RefreshMaterializedViewStatement ()

RefreshMaterializedViewStatement (view, concurrently, refreshMode)

Table view

boolean concurrently

RefreshMode refreshMode

getView () → Table

returns Table

setView (view)

Table view

getRefreshMode () → RefreshMode

returns RefreshMode

setRefreshMode (refreshMode)

RefreshMode refreshMode

isConcurrently () → boolean

returns boolean

setConcurrently (concurrently)

boolean concurrently

@SuppressWarnings,| @Override

toString () → String

returns String

@Override

accept (statementVisitor)

StatementVisitor statementVisitor

withTableName (view) → RefreshMaterializedViewStatement

Table view

returns RefreshMaterializedViewStatement

withConcurrently (concurrently) → RefreshMaterializedViewStatement

boolean concurrently

returns RefreshMaterializedViewStatement

statement.select

First.Keyword

[FIRST, LIMIT]

ForClause.ForOption

[BROWSE, XML, JSON]

ForMode

[UPDATE, SHARE, NO_KEY_UPDATE, KEY_SHARE]

KSQLWindow.TimeUnit

[DAY, HOUR, MINUTE, SECOND, MILLISECOND, DAYS, HOURS, MINUTES, SECONDS, MILLISECONDS]

KSQLWindow.WindowType

[HOPPING, SESSION, TUMBLING]

MySqlSqlCacheFlags

[SQL_CACHE, SQL_NO_CACHE]

OrderByElement.NullOrdering

[NULLS_FIRST, NULLS_LAST]

SampleClause.SampleKeyword

[SAMPLE, TABLESAMPLE]

SampleClause.SampleMethod

[BERNOULLI, SYSTEM, BLOCK]

SetOperationList.SetOperationType

[INTERSECT, EXCEPT, MINUS, UNION]

AllColumns

extends: ASTNodeAccessImpl implements: Expression provides: AllTableColumns

AllColumns (exceptColumns, replaceExpressions)

ExpressionList exceptColumns

List replaceExpressions

AllColumns ()

getExceptColumns () → ExpressionList

returns ExpressionList

addExceptColumn (jdbcColumn) → ExpressionList

Column jdbcColumn

returns ExpressionList

setExceptColumns (exceptColumns) → AllColumns

ExpressionList exceptColumns

returns AllColumns

getReplaceExpressions () → List

returns List

addReplaceExpression (selectItem) → List

SelectItem selectItem

returns List

setReplaceExpressions (replaceExpressions) → AllColumns

List replaceExpressions

returns AllColumns

appendTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

@Override

toString () → String

returns String

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

AllTableColumns

extends: AllColumns

AllTableColumns (jdbcTable, exceptColumns, replaceExpressions)

Table jdbcTable

ExpressionList exceptColumns

List replaceExpressions

AllTableColumns (jdbcTable)

Table jdbcTable

AllTableColumns (jdbcTable, allColumns)

Table jdbcTable

AllColumns allColumns

getTable () → Table

returns Table

setTable (jdbcTable)

Table jdbcTable

withTable (jdbcTable) → AllTableColumns

Table jdbcTable

returns AllTableColumns

@Override

appendTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

Distinct

extends: Object implements: Serializable

Distinct ()

Distinct (useUnique)

boolean useUnique

getOnSelectItems () → List

returns List

setOnSelectItems (list)

List list

isUseUnique () → boolean

returns boolean

setUseUnique (useUnique)

boolean useUnique

@Override

toString () → String

returns String

withOnSelectItems (onSelectItems) → Distinct

List onSelectItems

returns Distinct

withUseUnique (useUnique) → Distinct

boolean useUnique

returns Distinct

addOnSelectItems (onSelectItems) → Distinct

SelectItem onSelectItems

returns Distinct

addOnSelectItems (onSelectItems) → Distinct

Collection onSelectItems

returns Distinct

ExceptOp

extends: SetOperation

ExceptOp ()

Fetch

extends: Object implements: Serializable

Fetch ()

@Deprecated

getRowCount () → long

returns long

@Deprecated

setRowCount (l)

long l

getExpression () → Expression

returns Expression

setExpression (expression)

Expression expression

withExpression (expression) → Fetch

Expression expression

returns Fetch

@Deprecated

getFetchJdbcParameter () → JdbcParameter

returns JdbcParameter

addFetchParameter (parameter) → Fetch

String parameter

returns Fetch

getFetchParameters () → List

returns List

@Deprecated

getFetchParam () → String

returns String

isFetchParamFirst () → boolean

returns boolean

@Deprecated

setFetchJdbcParameter (jdbc)

JdbcParameter jdbc

@Deprecated

setFetchParam (s)

String s

setFetchParamFirst (b)

boolean b

appendTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

@Override

toString () → String

returns String

@Deprecated

withRowCount (rowCount) → Fetch

long rowCount

returns Fetch

@Deprecated

withFetchJdbcParameter (fetchJdbcParameter) → Fetch

JdbcParameter fetchJdbcParameter

returns Fetch

@Deprecated

withFetchParam (fetchParam) → Fetch

String fetchParam

returns Fetch

First

extends: Object implements: Serializable

First ()

getRowCount () → Long

returns Long

setRowCount (rowCount)

Long rowCount

getJdbcParameter () → JdbcParameter

returns JdbcParameter

setJdbcParameter (jdbcParameter)

JdbcParameter jdbcParameter

getKeyword () → Keyword

returns Keyword

setKeyword (keyword)

Keyword keyword

getVariable () → String

returns String

setVariable (variable)

String variable

@Override

toString () → String

returns String

withKeyword (keyword) → First

Keyword keyword

returns First

withRowCount (rowCount) → First

Long rowCount

returns First

withJdbcParameter (jdbcParameter) → First

JdbcParameter jdbcParameter

returns First

withVariable (variable) → First

String variable

returns First

ForClause

extends: ASTNodeAccessImpl

ForClause ()

getForOption () → ForOption

returns ForOption

setForOption (forOption) → ForClause

String forOption

returns ForClause

@Override

toString () → String

returns String

FromItemVisitorAdapter

extends: Object implements: FromItemVisitor

FromItemVisitorAdapter ()

@Override

visit (jdbcTable)

Table jdbcTable

@Override

visit (selectBody)

ParenthesedSelect selectBody

@Override

visit (lateralSubSelect)

LateralSubSelect lateralSubSelect

@Override

visit (valuesList)

TableFunction valuesList

@Override

visit (aThis)

ParenthesedFromItem aThis

GroupByElement

extends: Object implements: Serializable

GroupByElement ()

isUsingBrackets () → boolean

returns boolean

accept (groupByVisitor)

GroupByVisitor groupByVisitor

getGroupByExpressionList () → ExpressionList

returns ExpressionList

setGroupByExpressions (groupByExpressions)

ExpressionList groupByExpressions

@Deprecated

getGroupByExpressions () → ExpressionList

returns ExpressionList

@Deprecated

addGroupByExpression (groupByExpression)

Expression groupByExpression

getGroupingSets () → List

returns List

setGroupingSets (groupingSets)

List groupingSets

addGroupingSet (list)

ExpressionList list

@Override,| @SuppressWarnings

toString () → String

returns String

withGroupByExpressions (groupByExpressions) → GroupByElement

ExpressionList groupByExpressions

returns GroupByElement

withGroupingSets (groupingSets) → GroupByElement

List groupingSets

returns GroupByElement

addGroupByExpressions (groupByExpressions) → GroupByElement

Expression groupByExpressions

returns GroupByElement

addGroupByExpressions (groupByExpressions) → GroupByElement

Collection groupByExpressions

returns GroupByElement

addGroupingSets (groupingSets) → GroupByElement

Object groupingSets

returns GroupByElement

addGroupingSets (groupingSets) → GroupByElement

Collection groupingSets

returns GroupByElement

isMysqlWithRollup () → boolean

returns boolean

setMysqlWithRollup (mysqlWithRollup) → GroupByElement

boolean mysqlWithRollup

returns GroupByElement

IntersectOp

extends: SetOperation

IntersectOp ()

IntoTableVisitorAdapter

extends: Object implements: IntoTableVisitor

IntoTableVisitorAdapter ()

@Override

visit (tableName)

Table tableName

Join

extends: ASTNodeAccessImpl

Join ()

isSimple () → boolean

returns boolean

withSimple (b) → Join

boolean b

returns Join

setSimple (b)

boolean b

isInnerJoin () → boolean

A JOIN means INNER when the INNER keyword is set or when no other qualifier has been set.

returns boolean | Tells, if a JOIN means a qualified INNER JOIN.

isInner () → boolean

returns boolean | Tells, if the INNER keyword has been set.

withInner (b) → Join

boolean b

returns Join

setInner (b)

Sets the INNER keyword and switches off any contradicting qualifiers automatically.

boolean b

isStraight () → boolean

returns boolean

withStraight (b) → Join

boolean b

returns Join

setStraight (b)

boolean b

isOuter () → boolean

Whether is a “OUTER” join

returns boolean | true if is a “OUTER” join

withOuter (b) → Join

boolean b

returns Join

setOuter (b)

Sets the OUTER keyword and switches off any contradicting qualifiers automatically.

boolean b

isApply () → boolean

returns boolean

withApply (apply) → Join

boolean apply

returns Join

setApply (apply)

boolean apply

isSemi () → boolean

Whether is a “SEMI” join

returns boolean | true if is a “SEMI” join

withSemi (b) → Join

boolean b

returns Join

setSemi (b)

boolean b

isLeft () → boolean

Whether is a “LEFT” join

returns boolean | true if is a “LEFT” join

withLeft (b) → Join

boolean b

returns Join

setLeft (b)

Sets the LEFT keyword and switches off any contradicting qualifiers automatically.

boolean b

isRight () → boolean

Whether is a “RIGHT” join

returns boolean | true if is a “RIGHT” join

withRight (b) → Join

boolean b

returns Join

setRight (b)

Sets the RIGHT keyword and switches off any contradicting qualifiers automatically.

boolean b

isNatural () → boolean

Whether is a “NATURAL” join

returns boolean | true if is a “NATURAL” join

isGlobal () → boolean

returns boolean

withNatural (b) → Join

boolean b

returns Join

setNatural (b)

boolean b

setGlobal (b)

boolean b

isFull () → boolean

Whether is a “FULL” join

returns boolean | true if is a “FULL” join

withFull (b) → Join

boolean b

returns Join

setFull (b)

boolean b

isCross () → boolean

returns boolean

withCross (cross) → Join

boolean cross

returns Join

setCross (cross)

boolean cross

getRightItem () → FromItem

Returns the right item of the join

returns FromItem

@Deprecated

withRightItem (item) → Join

FromItem item

returns Join

setRightItem (item)

FromItem item

getFromItem () → FromItem

returns FromItem

setFromItem (fromItem) → Join

FromItem fromItem

returns Join

@Deprecated

getOnExpression () → Expression

Returns the “ON” expression (if any)

returns Expression

getOnExpressions () → Collection

returns Collection

@Deprecated

withOnExpression (expression) → Join

Expression expression

returns Join

@Deprecated

setOnExpression (expression)

Expression expression

addOnExpression (expression) → Join

Expression expression

returns Join

setOnExpressions (expressions) → Join

Collection expressions

returns Join

getUsingColumns () → List

Returns the “USING” list of `net.sf.jsqlparser.jdbcSchema.Column`s (if any)

returns List

withUsingColumns (list) → Join

List list

returns Join

setUsingColumns (list)

List list

isWindowJoin () → boolean

returns boolean

getJoinWindow () → KSQLJoinWindow

Return the “WITHIN” join window (if any)

returns KSQLJoinWindow |

withJoinWindow (joinWindow) → Join

KSQLJoinWindow joinWindow

returns Join

setJoinWindow (joinWindow)

KSQLJoinWindow joinWindow

getJoinHint () → JoinHint

returns JoinHint

setJoinHint (joinHint) → Join

JoinHint joinHint

returns Join

@Override,| @SuppressWarnings

toString () → String

returns String

addUsingColumns (usingColumns) → Join

Column usingColumns

returns Join

addUsingColumns (usingColumns) → Join

Collection usingColumns

returns Join

JoinHint

extends: Object

Hints (Transact-SQL) - Join

JoinHint (keyword)

String keyword

@Override

toString () → String

returns String

KSQLJoinWindow

extends: ASTNodeAccessImpl

KSQLJoinWindow ()

isBeforeAfterWindow () → boolean

returns boolean

setBeforeAfterWindow (beforeAfter)

boolean beforeAfter

getDuration () → long

returns long

setDuration (duration)

long duration

getTimeUnit () → TimeUnit

returns TimeUnit

setTimeUnit (timeUnit)

TimeUnit timeUnit

getBeforeDuration () → long

returns long

setBeforeDuration (beforeDuration)

long beforeDuration

getBeforeTimeUnit () → TimeUnit

returns TimeUnit

setBeforeTimeUnit (beforeTimeUnit)

TimeUnit beforeTimeUnit

getAfterDuration () → long

returns long

setAfterDuration (afterDuration)

long afterDuration

getAfterTimeUnit () → TimeUnit

returns TimeUnit

setAfterTimeUnit (afterTimeUnit)

TimeUnit afterTimeUnit

@Override

toString () → String

returns String

withDuration (duration) → KSQLJoinWindow

long duration

returns KSQLJoinWindow

withTimeUnit (timeUnit) → KSQLJoinWindow

TimeUnit timeUnit

returns KSQLJoinWindow

withBeforeDuration (beforeDuration) → KSQLJoinWindow

long beforeDuration

returns KSQLJoinWindow

withBeforeTimeUnit (beforeTimeUnit) → KSQLJoinWindow

TimeUnit beforeTimeUnit

returns KSQLJoinWindow

withAfterDuration (afterDuration) → KSQLJoinWindow

long afterDuration

returns KSQLJoinWindow

withAfterTimeUnit (afterTimeUnit) → KSQLJoinWindow

TimeUnit afterTimeUnit

returns KSQLJoinWindow

from (timeUnitStr) → TimeUnit

String timeUnitStr

returns TimeUnit

KSQLWindow

extends: ASTNodeAccessImpl

KSQLWindow ()

isHoppingWindow () → boolean

returns boolean

setHoppingWindow (hopping)

boolean hopping

isTumblingWindow () → boolean

returns boolean

setTumblingWindow (tumbling)

boolean tumbling

isSessionWindow () → boolean

returns boolean

setSessionWindow (session)

boolean session

getSizeDuration () → long

returns long

setSizeDuration (sizeDuration)

long sizeDuration

getSizeTimeUnit () → TimeUnit

returns TimeUnit

setSizeTimeUnit (sizeTimeUnit)

TimeUnit sizeTimeUnit

getAdvanceDuration () → long

returns long

setAdvanceDuration (advanceDuration)

long advanceDuration

getAdvanceTimeUnit () → TimeUnit

returns TimeUnit

setAdvanceTimeUnit (advanceTimeUnit)

TimeUnit advanceTimeUnit

@Override

toString () → String

returns String

withSizeDuration (sizeDuration) → KSQLWindow

long sizeDuration

returns KSQLWindow

withSizeTimeUnit (sizeTimeUnit) → KSQLWindow

TimeUnit sizeTimeUnit

returns KSQLWindow

withAdvanceDuration (advanceDuration) → KSQLWindow

long advanceDuration

returns KSQLWindow

withAdvanceTimeUnit (advanceTimeUnit) → KSQLWindow

TimeUnit advanceTimeUnit

returns KSQLWindow

LateralSubSelect

extends: ParenthesedSelect

lateral sub select

LateralSubSelect ()

LateralSubSelect (prefix)

String prefix

getPrefix () → String

returns String

setPrefix (prefix)

String prefix

withPrefix (prefix) → LateralSubSelect

String prefix

returns LateralSubSelect

withSelect (select) → LateralSubSelect

Select select

returns LateralSubSelect

toString () → String

returns String

accept (selectVisitor)

SelectVisitor selectVisitor

@Override

accept (fromItemVisitor)

FromItemVisitor fromItemVisitor

LateralView

extends: Object implements: Serializable

LateralView (useOuter, generatorFunction, tableAlias, columnAlias)

boolean useOuter

Function generatorFunction

Alias tableAlias

Alias columnAlias

isUsingOuter () → boolean

returns boolean

setUsingOuter (useOuter)

boolean useOuter

withOuter (useOuter) → LateralView

boolean useOuter

returns LateralView

getGeneratorFunction () → Function

returns Function

setGeneratorFunction (generatorFunction)

Function generatorFunction

withGeneratorFunction (generatorFunction) → LateralView

Function generatorFunction

returns LateralView

getTableAlias () → Alias

returns Alias

setTableAlias (tableAlias)

Alias tableAlias

withTableAlias (tableAlias) → LateralView

Alias tableAlias

returns LateralView

getColumnAlias () → Alias

returns Alias

setColumnAlias (columnAlias)

Alias columnAlias

withColumnAlias (columnAlias) → LateralView

Alias columnAlias

returns LateralView

appendTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

@Override

toString () → String

returns String

Limit

extends: ASTNodeAccessImpl

Limit ()

getOffset () → Expression

returns Expression

getRowCount () → Expression

returns Expression

setOffset (l)

Expression l

setRowCount (l)

Expression l

@Deprecated

isLimitAll () → boolean

returns boolean

@Deprecated

setLimitAll (b)

boolean b

@Deprecated

isLimitNull () → boolean

returns boolean

@Deprecated

setLimitNull (b)

boolean b

@Override

toString () → String

returns String

withRowCount (rowCount) → Limit

Expression rowCount

returns Limit

withOffset (offset) → Limit

Expression offset

returns Limit

@Deprecated

withLimitAll (limitAll) → Limit

boolean limitAll

returns Limit

@Deprecated

withLimitNull (limitNull) → Limit

boolean limitNull

returns Limit

getOffset (part) → E

Class part

returns E

getRowCount (part) → E

Class part

returns E

getByExpressions () → ExpressionList

returns ExpressionList

setByExpressions (byExpressions)

ExpressionList byExpressions

setByExpressions (byExpressions)

Expression byExpressions

addByExpression (byExpression)

Expression byExpression

withByExpressions (byExpressions) → Limit

ExpressionList byExpressions

returns Limit

withByExpressions (byExpressions) → Limit

Expression byExpressions

returns Limit

MinusOp

extends: SetOperation

MinusOp ()

Offset

extends: Object implements: Serializable

Offset ()

getOffset () → Expression

returns Expression

getOffsetParam () → String

returns String

setOffset (offsetExpression)

Expression offsetExpression

setOffsetParam (s)

String s

@Override

toString () → String

returns String

withOffset (offsetExpression) → Offset

Expression offsetExpression

returns Offset

withOffsetParam (offsetParam) → Offset

String offsetParam

returns Offset

getOffset (part) → E

Class part

returns E

OptimizeFor

extends: Object implements: Serializable

A optimize for clause.

OptimizeFor (rowCount)

long rowCount

getRowCount () → long

returns long

setRowCount (l)

long l

@Override

toString () → String

returns String

withRowCount (rowCount) → OptimizeFor

long rowCount

returns OptimizeFor

OrderByElement

extends: Object implements: Serializable

OrderByElement ()

isAsc () → boolean

returns boolean

getNullOrdering () → NullOrdering

returns NullOrdering

setNullOrdering (nullOrdering)

NullOrdering nullOrdering

setAsc (asc)

boolean asc

setAscDescPresent (ascDescPresent)

boolean ascDescPresent

isAscDescPresent () → boolean

returns boolean

accept (orderByVisitor)

OrderByVisitor orderByVisitor

getExpression () → Expression

returns Expression

setExpression (expression)

Expression expression

@Override

toString () → String

returns String

withExpression (expression) → OrderByElement

Expression expression

returns OrderByElement

withAsc (asc) → OrderByElement

boolean asc

returns OrderByElement

withAscDescPresent (ascDescPresent) → OrderByElement

boolean ascDescPresent

returns OrderByElement

withNullOrdering (nullOrdering) → OrderByElement

NullOrdering nullOrdering

returns OrderByElement

getExpression (part) → E

Class part

returns E

isMysqlWithRollup () → boolean

returns boolean

setMysqlWithRollup (mysqlWithRollup) → OrderByElement

boolean mysqlWithRollup

returns OrderByElement

OrderByVisitorAdapter

extends: Object implements: OrderByVisitor

OrderByVisitorAdapter ()

@Override

visit (orderBy)

OrderByElement orderBy

ParenthesedFromItem

extends: Object implements: FromItem

ParenthesedFromItem ()

ParenthesedFromItem (fromItem)

FromItem fromItem

getFromItem () → FromItem

returns FromItem

setFromItem (fromItem)

FromItem fromItem

getJoins () → List

returns List

getJoin (jdbcIndex) → Join

int jdbcIndex

returns Join

addJoins (joins) → FromItem

Join joins

returns FromItem

withJoins (joins) → FromItem

List joins

returns FromItem

setJoins (list)

List list

@Override

accept (fromItemVisitor)

FromItemVisitor fromItemVisitor

appendTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

@Override

toString () → String

returns String

@Override

getAlias () → Alias

returns Alias

@Override

setAlias (alias)

Alias alias

@Override

getPivot () → Pivot

returns Pivot

@Override

setPivot (pivot)

Pivot pivot

@Override

getUnPivot () → UnPivot

returns UnPivot

@Override

setUnPivot (unpivot)

UnPivot unpivot

withFromItem (fromItem) → ParenthesedFromItem

FromItem fromItem

returns ParenthesedFromItem

@Override

withAlias (alias) → ParenthesedFromItem

Alias alias

returns ParenthesedFromItem

getFromItem (part) → E

Class part

returns E

ParenthesedSelect

extends: Select implements: FromItem provides: LateralSubSelect, WithItem

ParenthesedSelect ()

@Override

getAlias () → Alias

returns Alias

@Override

setAlias (alias)

Alias alias

withAlias (alias) → ParenthesedSelect

Alias alias

returns ParenthesedSelect

@Override

getPivot () → Pivot

returns Pivot

@Override

setPivot (pivot)

Pivot pivot

getUnPivot () → UnPivot

returns UnPivot

setUnPivot (unPivot)

UnPivot unPivot

getSelect () → Select

returns Select

getValues () → Values

returns Values

getPlainSelect () → PlainSelect

returns PlainSelect

getSetOperationList () → SetOperationList

returns SetOperationList

setSelect (select)

Select select

withSelect (selectBody) → ParenthesedSelect

Select selectBody

returns ParenthesedSelect

@Override

accept (selectVisitor)

SelectVisitor selectVisitor

@Override

accept (fromItemVisitor)

FromItemVisitor fromItemVisitor

appendSelectBodyTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

Pivot

extends: Object implements: Serializable provides: PivotXml

Pivot ()

accept (pivotVisitor)

PivotVisitor pivotVisitor

getSingleInItems () → List

returns List

setSingleInItems (singleInItems)

List singleInItems

getMultiInItems () → List

returns List

setMultiInItems (multiInItems)

List multiInItems

getFunctionItems () → List

returns List

setFunctionItems (functionItems)

List functionItems

getForColumns () → ExpressionList

returns ExpressionList

setForColumns (forColumns)

ExpressionList forColumns

getInItems () → List

returns List

getAlias () → Alias

returns Alias

setAlias (alias)

Alias alias

@Override

toString () → String

returns String

withFunctionItems (functionItems) → Pivot

List functionItems

returns Pivot

withForColumns (forColumns) → Pivot

ExpressionList forColumns

returns Pivot

withSingleInItems (singleInItems) → Pivot

List singleInItems

returns Pivot

withMultiInItems (multiInItems) → Pivot

List multiInItems

returns Pivot

withAlias (alias) → Pivot

Alias alias

returns Pivot

addFunctionItems (functionItems) → Pivot

SelectItem functionItems

returns Pivot

addFunctionItems (functionItems) → Pivot

Collection functionItems

returns Pivot

addForColumns (forColumns) → Pivot

Column forColumns

returns Pivot

addForColumns (forColumns) → Pivot

Collection forColumns

returns Pivot

addSingleInItems (singleInItems) → Pivot

SelectItem singleInItems

returns Pivot

addSingleInItems (singleInItems) → Pivot

Collection singleInItems

returns Pivot

addMultiInItems (multiInItems) → Pivot

SelectItem multiInItems

returns Pivot

addMultiInItems (multiInItems) → Pivot

Collection multiInItems

returns Pivot

PivotVisitorAdapter

extends: Object implements: PivotVisitor

PivotVisitorAdapter ()

@Override

visit (pivot)

Pivot pivot

@Override

visit (pivot)

PivotXml pivot

@Override

visit (unpivot)

UnPivot unpivot

PivotXml

extends: Pivot

PivotXml ()

@Override

accept (pivotVisitor)

PivotVisitor pivotVisitor

getInSelect () → Select

returns Select

setInSelect (inSelect)

Select inSelect

isInAny () → boolean

returns boolean

setInAny (inAny)

boolean inAny

@Override

toString () → String

returns String

withInSelect (inSelect) → PivotXml

Select inSelect

returns PivotXml

withInAny (inAny) → PivotXml

boolean inAny

returns PivotXml

getInSelect (part) → E

Class part

returns E

@Override

withAlias (alias) → PivotXml

Alias alias

returns PivotXml

@Override

withFunctionItems (functionItems) → PivotXml

List functionItems

returns PivotXml

@Override

withForColumns (forColumns) → PivotXml

ExpressionList forColumns

returns PivotXml

@Override

withSingleInItems (singleInItems) → PivotXml

List singleInItems

returns PivotXml

@Override

withMultiInItems (multiInItems) → PivotXml

List multiInItems

returns PivotXml

@Override

addFunctionItems (functionItems) → PivotXml

Collection functionItems

returns PivotXml

@Override

addFunctionItems (functionItems) → PivotXml

SelectItem functionItems

returns PivotXml

@Override

addForColumns (forColumns) → PivotXml

Collection forColumns

returns PivotXml

@Override

addForColumns (forColumns) → PivotXml

Column forColumns

returns PivotXml

@Override

addSingleInItems (singleInItems) → PivotXml

Collection singleInItems

returns PivotXml

@Override

addSingleInItems (singleInItems) → PivotXml

SelectItem singleInItems

returns PivotXml

@Override

addMultiInItems (multiInItems) → PivotXml

SelectItem multiInItems

returns PivotXml

@Override

addMultiInItems (multiInItems) → PivotXml

Collection multiInItems

returns PivotXml

PlainSelect

extends: Select

PlainSelect ()

@Deprecated

isUseBrackets () → boolean

returns boolean

getFromItem () → FromItem

returns FromItem

getIntoTables () → List

returns List

getSelectItems () → List

returns List

getSelectItem (jdbcIndex) → SelectItem

int jdbcIndex

returns SelectItem

getWhere () → Expression

returns Expression

withFromItem (item) → PlainSelect

FromItem item

returns PlainSelect

setFromItem (item)

FromItem item

setIntoTables (intoTables)

List intoTables

withSelectItems (list) → PlainSelect

List list

returns PlainSelect

setSelectItems (list)

List list

addSelectItems (items) → PlainSelect

SelectItem items

returns PlainSelect

addSelectItems (expressions) → PlainSelect

Expression expressions

returns PlainSelect

addSelectItem (expression, alias) → PlainSelect

Expression expression

Alias alias

returns PlainSelect

addSelectItem (expression) → PlainSelect

Expression expression

returns PlainSelect

setWhere (where)

Expression where

getLateralViews () → List

returns List

setLateralViews (lateralViews)

Collection lateralViews

addLateralView (lateralView) → PlainSelect

LateralView lateralView

returns PlainSelect

withLateralViews (lateralViews) → PlainSelect

Collection lateralViews

returns PlainSelect

getJoins () → List

The list of `Join`s

returns List | the list of `Join`s

getJoin (jdbcIndex) → Join

int jdbcIndex

returns Join

addJoins (joins) → PlainSelect

Join joins

returns PlainSelect

withJoins (joins) → PlainSelect

List joins

returns PlainSelect

setJoins (list)

List list

isUsingFinal () → boolean

returns boolean

setUsingFinal (usingFinal)

boolean usingFinal

withUsingFinal (usingFinal) → PlainSelect

boolean usingFinal

returns PlainSelect

isUsingOnly () → boolean

returns boolean

setUsingOnly (usingOnly)

boolean usingOnly

withUsingOnly (usingOnly) → PlainSelect

boolean usingOnly

returns PlainSelect

isUseWithNoLog () → boolean

returns boolean

setUseWithNoLog (useWithNoLog)

boolean useWithNoLog

withUseWithNoLog (useWithNoLog) → PlainSelect

boolean useWithNoLog

returns PlainSelect

getIntoTempTable () → Table

returns Table

setIntoTempTable (intoTempTable)

Table intoTempTable

withIntoTempTable (intoTempTable) → PlainSelect

Table intoTempTable

returns PlainSelect

@Override

accept (selectVisitor)

SelectVisitor selectVisitor

getOptimizeFor () → OptimizeFor

returns OptimizeFor

setOptimizeFor (optimizeFor)

OptimizeFor optimizeFor

getTop () → Top

returns Top

setTop (top)

Top top

getSkip () → Skip

returns Skip

setSkip (skip)

Skip skip

getMySqlHintStraightJoin () → boolean

returns boolean

setMySqlHintStraightJoin (mySqlHintStraightJoin)

boolean mySqlHintStraightJoin

getFirst () → First

returns First

setFirst (first)

First first

getDistinct () → Distinct

returns Distinct

setDistinct (distinct)

Distinct distinct

getHaving () → Expression

returns Expression

setHaving (expression)

Expression expression

getQualify () → Expression

returns Expression

setQualify (qualify) → PlainSelect

Expression qualify

returns PlainSelect

getGroupBy () → GroupByElement

A list of `Expression`s of the GROUP BY clause. It is null in case there is no GROUP BY clause

returns GroupByElement | a list of `Expression`s

setGroupByElement (groupBy)

GroupByElement groupBy

addGroupByColumnReference (expr) → PlainSelect

Expression expr

returns PlainSelect

getOracleHierarchical () → OracleHierarchicalExpression

returns OracleHierarchicalExpression

setOracleHierarchical (oracleHierarchical)

OracleHierarchicalExpression oracleHierarchical

getForMode () → ForMode

returns ForMode

setForMode (forMode)

ForMode forMode

getForUpdateTable () → Table

returns Table

setForUpdateTable (forUpdateTable)

Table forUpdateTable

getOracleHint () → OracleHint

returns OracleHint

setOracleHint (oracleHint)

OracleHint oracleHint

setWait (wait)

Sets the Wait for this SELECT

Wait wait | wait the Wait for this SELECT

getWait () → Wait

Returns the value of the Wait set for this SELECT

returns Wait | the value of the Wait set for this SELECT

getForXmlPath () → String

returns String

setForXmlPath (forXmlPath)

String forXmlPath

getKsqlWindow () → KSQLWindow

returns KSQLWindow

setKsqlWindow (ksqlWindow)

KSQLWindow ksqlWindow

setEmitChanges (emitChanges)

boolean emitChanges

isEmitChanges () → boolean

returns boolean

getWindowDefinitions () → List

returns List

setWindowDefinitions (windowDefinitions)

List windowDefinitions

isSkipLocked () → boolean

returns boolean

setSkipLocked (skipLocked)

boolean skipLocked

@SuppressWarnings

appendSelectBodyTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

@Override,| @SuppressWarnings

toString () → String

returns String

withMySqlSqlCalcFoundRows (mySqlCalcFoundRows) → PlainSelect

boolean mySqlCalcFoundRows

returns PlainSelect

withMySqlSqlNoCache (mySqlCacheFlag) → PlainSelect

MySqlSqlCacheFlags mySqlCacheFlag

returns PlainSelect

setMySqlSqlCalcFoundRows (mySqlCalcFoundRows)

boolean mySqlCalcFoundRows

setMySqlSqlCacheFlag (sqlCacheFlag)

MySqlSqlCacheFlags sqlCacheFlag

getMySqlSqlCalcFoundRows () → boolean

returns boolean

getMySqlSqlCacheFlag () → MySqlSqlCacheFlags

returns MySqlSqlCacheFlags

setNoWait (noWait)

boolean noWait

isNoWait () → boolean

returns boolean

withDistinct (distinct) → PlainSelect

Distinct distinct

returns PlainSelect

withIntoTables (intoTables) → PlainSelect

List intoTables

returns PlainSelect

withWhere (where) → PlainSelect

Expression where

returns PlainSelect

withOptimizeFor (optimizeFor) → PlainSelect

OptimizeFor optimizeFor

returns PlainSelect

withSkip (skip) → PlainSelect

Skip skip

returns PlainSelect

withMySqlHintStraightJoin (mySqlHintStraightJoin) → PlainSelect

boolean mySqlHintStraightJoin

returns PlainSelect

withFirst (first) → PlainSelect

First first

returns PlainSelect

withTop (top) → PlainSelect

Top top

returns PlainSelect

withOracleHierarchical (oracleHierarchical) → PlainSelect

OracleHierarchicalExpression oracleHierarchical

returns PlainSelect

withOracleHint (oracleHint) → PlainSelect

OracleHint oracleHint

returns PlainSelect

withOracleSiblings (oracleSiblings) → PlainSelect

boolean oracleSiblings

returns PlainSelect

withForMode (forMode) → PlainSelect

ForMode forMode

returns PlainSelect

withForUpdateTable (forUpdateTable) → PlainSelect

Table forUpdateTable

returns PlainSelect

withForXmlPath (forXmlPath) → PlainSelect

String forXmlPath

returns PlainSelect

withKsqlWindow (ksqlWindow) → PlainSelect

KSQLWindow ksqlWindow

returns PlainSelect

withNoWait (noWait) → PlainSelect

boolean noWait

returns PlainSelect

withSkipLocked (skipLocked) → PlainSelect

boolean skipLocked

returns PlainSelect

withHaving (having) → PlainSelect

Expression having

returns PlainSelect

withWait (wait) → PlainSelect

Wait wait

returns PlainSelect

addSelectItems (selectItems) → PlainSelect

Collection selectItems

returns PlainSelect

addIntoTables (intoTables) → PlainSelect

Table intoTables

returns PlainSelect

addIntoTables (intoTables) → PlainSelect

Collection intoTables

returns PlainSelect

addJoins (joins) → PlainSelect

Collection joins

returns PlainSelect

getFromItem (part) → E

Class part

returns E

getWhere (part) → E

Class part

returns E

getHaving (part) → E

Class part

returns E

SampleClause

extends: Object

SampleClause (keyword, method, percentageArgument, repeatArgument, seedArgument)

String keyword

String method

Number percentageArgument

Number repeatArgument

Number seedArgument

SampleClause ()

SampleClause (keyword)

String keyword

getKeyword () → SampleKeyword

returns SampleKeyword

setKeyword (keyword) → SampleClause

SampleKeyword keyword

returns SampleClause

getPercentageArgument () → Number

returns Number

setPercentageArgument (percentageArgument) → SampleClause

Number percentageArgument

returns SampleClause

getRepeatArgument () → Number

returns Number

setRepeatArgument (repeatArgument) → SampleClause

Number repeatArgument

returns SampleClause

getSeedArgument () → Number

returns Number

setSeedArgument (seedArgument) → SampleClause

Number seedArgument

returns SampleClause

getMethod () → SampleMethod

returns SampleMethod

setMethod (method) → SampleClause

SampleMethod method

returns SampleClause

setMethod (method) → SampleClause

String method

returns SampleClause

appendTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

toString () → String

returns String

Select

extends: ASTNodeAccessImpl implements: Statement, Expression provides: ParenthesedSelect, PlainSelect, SetOperationList, TableStatement, Values

Select ()

orderByToString (orderByElements) → String

List orderByElements

returns String

orderByToString (oracleSiblings, orderByElements) → String

boolean oracleSiblings

List orderByElements

returns String

getFormattedList (list, expression) → String

List list

String expression

returns String

getFormattedList (list, expression, useComma, useBrackets) → String

List list

String expression

boolean useComma

boolean useBrackets

returns String

getStringList (list) → String

List the toString out put of the objects in the List comma separated. If the List is null or empty an empty string is returned.

The same as getStringList(list, true, false)

List list | list list of objects with toString methods

returns String | comma separated list of the elements in the list

getStringList (list, useComma, useBrackets) → String

List the toString out put of the objects in the List that can be comma separated. If the List is null or empty an empty string is returned.

List list | list list of objects with toString methods

boolean useComma | useComma true if the list has to be comma separated

boolean useBrackets | useBrackets true if the list has to be enclosed in brackets

returns String | comma separated list of the elements in the list

appendStringListTo (builder, list, useComma, useBrackets) → StringBuilder

Append the toString out put of the objects in the List (that can be comma separated). If the List is null or empty an empty string is returned.

StringBuilder builder

List list | list list of objects with toString methods

boolean useComma | useComma true if the list has to be comma separated

boolean useBrackets | useBrackets true if the list has to be enclosed in brackets

returns StringBuilder | comma separated list of the elements in the list

getWithItemsList () → List

returns List

setWithItemsList (withItemsList)

List withItemsList

withWithItemsList (withItemsList) → Select

List withItemsList

returns Select

addWithItemsList (withItemsList) → Select

Collection withItemsList

returns Select

addWithItemsList (withItemsList) → Select

WithItem withItemsList

returns Select

isOracleSiblings () → boolean

returns boolean

setOracleSiblings (oracleSiblings)

boolean oracleSiblings

withOracleSiblings (oracleSiblings) → Select

boolean oracleSiblings

returns Select

getForClause () → ForClause

returns ForClause

setForClause (forClause) → Select

ForClause forClause

returns Select

getOrderByElements () → List

returns List

setOrderByElements (orderByElements)

List orderByElements

withOrderByElements (orderByElements) → Select

List orderByElements

returns Select

addOrderByElements (orderByElements) → Select

Collection orderByElements

returns Select

addOrderByElements (orderByElements) → Select

OrderByElement orderByElements

returns Select

getLimit () → Limit

returns Limit

setLimit (limit)

Limit limit

withLimit (limit) → Select

Limit limit

returns Select

getLimitBy () → Limit

returns Limit

setLimitBy (limitBy)

Limit limitBy

withLimitBy (part, limitBy) → E

Class part

Limit limitBy

returns E

getOffset () → Offset

returns Offset

setOffset (offset)

Offset offset

withOffset (offset) → Select

Offset offset

returns Select

getFetch () → Fetch

returns Fetch

setFetch (fetch)

Fetch fetch

withFetch (fetch) → Select

Fetch fetch

returns Select

getIsolation () → WithIsolation

returns WithIsolation

setIsolation (isolation)

WithIsolation isolation

withIsolation (isolation) → Select

WithIsolation isolation

returns Select

appendSelectBodyTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

@SuppressWarnings

appendTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

@Override

toString () → String

returns String

accept (selectVisitor)

SelectVisitor selectVisitor

accept (statementVisitor)

StatementVisitor statementVisitor

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

@Deprecated

getSelectBody () → Select

returns Select

getValues () → Values

returns Values

getPlainSelect () → PlainSelect

returns PlainSelect

getSetOperationList () → SetOperationList

returns SetOperationList

as (part) → E

Class part

returns E

SelectItem

extends: ASTNodeAccessImpl

SelectItem (expression, alias)

T expression

Alias alias

SelectItem ()

SelectItem (expression)

T expression

from (expression, alias) → SelectItem

Expression expression

Alias alias

returns SelectItem

from (expression) → SelectItem

Expression expression

returns SelectItem

getAlias () → Alias

returns Alias

setAlias (alias)

Alias alias

getExpression () → T

returns T

setExpression (expression)

T expression

accept (selectItemVisitor)

SelectItemVisitor selectItemVisitor

@Override

toString () → String

returns String

withExpression (expression) → SelectItem

T expression

returns SelectItem

withAlias (alias) → SelectItem

Alias alias

returns SelectItem

getExpression (part) → E

Class part

returns E

SelectItemVisitorAdapter

extends: Object implements: SelectItemVisitor

SelectItemVisitorAdapter ()

@Override

visit (item)

SelectItem item

SelectVisitorAdapter

extends: Object implements: SelectVisitor

SelectVisitorAdapter ()

@Override

visit (parenthesedSelect)

ParenthesedSelect parenthesedSelect

@Override

visit (plainSelect)

PlainSelect plainSelect

@Override

visit (setOpList)

SetOperationList setOpList

@Override

visit (withItem)

WithItem withItem

@Override

visit (aThis)

Values aThis

@Override

visit (lateralSubSelect)

LateralSubSelect lateralSubSelect

@Override

visit (tableStatement)

TableStatement tableStatement

SetOperation

extends: ASTNodeAccessImpl provides: ExceptOp, IntersectOp, MinusOp, UnionOp

SetOperation (part)

SetOperationType part

@Override

toString () → String

returns String

SetOperationList

extends: Select

SetOperationList ()

@Override

accept (selectVisitor)

SelectVisitor selectVisitor

getOrderByElements () → List

returns List

getSelects () → List

returns List

getSelect (jdbcIndex) → Select

int jdbcIndex

returns Select

setSelects (selects)

List selects

setOperations (operations)

List operations

getOperations () → List

returns List

getOperation (jdbcIndex) → SetOperation

int jdbcIndex

returns SetOperation

setOrderByElements (orderByElements)

List orderByElements

setBracketsOpsAndSelects (select, ops)

List select

List ops

@Override

appendSelectBodyTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

withOperations (operationList) → SetOperationList

List operationList

returns SetOperationList

withSelects (selects) → SetOperationList

List selects

returns SetOperationList

addSelects (selects) → SetOperationList

Select selects

returns SetOperationList

addSelects (selects) → SetOperationList

Collection selects

returns SetOperationList

addOperations (operationList) → SetOperationList

SetOperation operationList

returns SetOperationList

addOperations (operationList) → SetOperationList

Collection operationList

returns SetOperationList

Skip

extends: Object implements: Serializable

Skip ()

getRowCount () → Long

returns Long

setRowCount (rowCount)

Long rowCount

getJdbcParameter () → JdbcParameter

returns JdbcParameter

setJdbcParameter (jdbcParameter)

JdbcParameter jdbcParameter

getVariable () → String

returns String

setVariable (variable)

String variable

@Override

toString () → String

returns String

withRowCount (rowCount) → Skip

Long rowCount

returns Skip

withJdbcParameter (jdbcParameter) → Skip

JdbcParameter jdbcParameter

returns Skip

withVariable (variable) → Skip

String variable

returns Skip

TableFunction

extends: Function implements: FromItem

TableFunction (function)

Function function

TableFunction (prefix, function)

String prefix

Function function

getFunction () → Function

returns Function

@Deprecated

getExpression () → Function

returns Function

setFunction (function) → TableFunction

Function function

returns TableFunction

getPrefix () → String

returns String

setPrefix (prefix) → TableFunction

String prefix

returns TableFunction

@Override

accept (fromItemVisitor)

FromItemVisitor fromItemVisitor

@Override

getAlias () → Alias

returns Alias

@Override

setAlias (alias)

Alias alias

@Override

withAlias (alias) → TableFunction

Alias alias

returns TableFunction

@Override

getPivot () → Pivot

returns Pivot

@Override

setPivot (pivot)

Pivot pivot

@Override

withPivot (pivot) → TableFunction

Pivot pivot

returns TableFunction

@Override

getUnPivot () → UnPivot

returns UnPivot

@Override

setUnPivot (unPivot)

UnPivot unPivot

@Override

withUnPivot (unpivot) → TableFunction

UnPivot unpivot

returns TableFunction

appendTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

@Override

toString () → String

returns String

TableStatement

extends: Select

TableStatement ()

getTable () → Table

returns Table

setTable (jdbcTable)

Table jdbcTable

@Override

appendSelectBodyTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

@SuppressWarnings,| @Override

appendTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

@Override

accept (selectVisitor)

SelectVisitor selectVisitor

Top

extends: Object implements: Serializable

Top ()

getExpression () → Expression

returns Expression

setExpression (expression)

Expression expression

hasParenthesis () → boolean

returns boolean

setParenthesis (hasParenthesis)

boolean hasParenthesis

isPercentage () → boolean

returns boolean

setPercentage (percentage)

boolean percentage

setWithTies (withTies)

boolean withTies

isWithTies () → boolean

returns boolean

@Override

toString () → String

returns String

withExpression (expression) → Top

Expression expression

returns Top

getExpression (part) → E

Class part

returns E

UnPivot

extends: Object implements: Serializable

UnPivot ()

accept (pivotVisitor)

PivotVisitor pivotVisitor

getIncludeNulls () → boolean

returns boolean

setIncludeNulls (includeNulls)

boolean includeNulls

getIncludeNullsSpecified () → boolean

returns boolean

getUnPivotClause () → List

returns List

setUnPivotClause (unpivotClause)

ExpressionList unpivotClause

getUnPivotForClause () → List

returns List

setUnPivotForClause (forColumns)

ExpressionList forColumns

getUnPivotInClause () → List

returns List

setUnPivotInClause (unpivotInClause)

List unpivotInClause

@Override

toString () → String

returns String

withIncludeNulls (includeNulls) → UnPivot

boolean includeNulls

returns UnPivot

getAlias () → Alias

returns Alias

setAlias (alias)

Alias alias

UnionOp

extends: SetOperation

UnionOp ()

isAll () → boolean

returns boolean

setAll (all)

boolean all

isDistinct () → boolean

returns boolean

setDistinct (distinct)

boolean distinct

@Override

toString () → String

returns String

withDistinct (distinct) → UnionOp

boolean distinct

returns UnionOp

withAll (all) → UnionOp

boolean all

returns UnionOp

Values

extends: Select

Values ()

Values (expressions)

ExpressionList expressions

getExpressions () → ExpressionList

returns ExpressionList

setExpressions (expressions)

ExpressionList expressions

@Override

appendSelectBodyTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

@Override

accept (selectVisitor)

SelectVisitor selectVisitor

withExpressions (expressions) → Values

ExpressionList expressions

returns Values

addExpressions (expressions) → Values

Expression expressions

returns Values

addExpressions (expressions) → Values

Collection expressions

returns Values

Wait

extends: Object implements: Serializable

Wait ()

getTimeout () → long

returns long

setTimeout (timeout)

long timeout

@Override

toString () → String

Returns a String containing the WAIT clause and its timeout, where TIMEOUT is specified by #getTimeout(). The returned string will null be:" WAIT <TIMEOUT>"

returns String

withTimeout (timeout) → Wait

long timeout

returns Wait

WithIsolation

extends: Object implements: Serializable

WithIsolation ()

getIsolation () → String

returns String

setIsolation (s)

String s

@Override

toString () → String

returns String

WithItem

extends: ParenthesedSelect

WithItem ()

isRecursive () → boolean

returns boolean

setRecursive (recursive)

boolean recursive

getWithItemList () → List

The `SelectItem`s in this WITH (for example the A,B,C in “WITH mywith (A,B,C) AS …”)

returns List | a list of `SelectItem`s

setWithItemList (withItemList)

List withItemList

@Override,| @SuppressWarnings

appendSelectBodyTo (builder) → StringBuilder

StringBuilder builder

returns StringBuilder

@Override

accept (visitor)

SelectVisitor visitor

withWithItemList (withItemList) → WithItem

List withItemList

returns WithItem

withRecursive (recursive) → WithItem

boolean recursive

returns WithItem

addWithItemList (withItemList) → WithItem

SelectItem withItemList

returns WithItem

addWithItemList (withItemList) → WithItem

Collection withItemList

returns WithItem

FromItem

implements: Model provides: ParenthesedFromItem, ParenthesedSelect, Table, TableFunction,

accept (fromItemVisitor)

FromItemVisitor fromItemVisitor

getAlias () → Alias

returns Alias

withAlias (alias) → FromItem

Alias alias

returns FromItem

setAlias (alias)

Alias alias

getPivot () → Pivot

returns Pivot

withPivot (pivot) → FromItem

Pivot pivot

returns FromItem

setPivot (pivot)

Pivot pivot

getUnPivot () → UnPivot

returns UnPivot

withUnPivot (unpivot) → FromItem

UnPivot unpivot

returns FromItem

setUnPivot (unpivot)

UnPivot unpivot

FromItemVisitor

provides: FromItemVisitorAdapter, SelectDeParser, SelectValidator, TablesNamesFinder,

visit (tableName)

Table tableName

visit (selectBody)

ParenthesedSelect selectBody

visit (lateralSubSelect)

LateralSubSelect lateralSubSelect

visit (tableFunction)

TableFunction tableFunction

visit (aThis)

ParenthesedFromItem aThis

GroupByVisitor

provides: GroupByValidator,

visit (groupBy)

GroupByElement groupBy

IntoTableVisitor

provides: IntoTableVisitorAdapter,

visit (tableName)

Table tableName

OrderByVisitor

provides: OrderByValidator, OrderByVisitorAdapter, UpdateDeParser,

visit (orderBy)

OrderByElement orderBy

PivotVisitor

provides: ExpressionVisitorAdapter, PivotVisitorAdapter, SelectDeParser, SelectValidator,

visit (pivot)

Pivot pivot

visit (pivot)

PivotXml pivot

visit (unpivot)

UnPivot unpivot

SelectItemVisitor

provides: AddAliasesVisitor, ConnectExpressionsVisitor, ExpressionVisitorAdapter, SelectDeParser, SelectItemVisitorAdapter, SelectValidator, TablesNamesFinder,

visit (selectItem)

SelectItem selectItem

SelectVisitor

provides: AddAliasesVisitor, ConnectExpressionsVisitor, SelectDeParser, SelectValidator, SelectVisitorAdapter, TableStatementDeParser, TablesNamesFinder,

visit (parenthesedSelect)

ParenthesedSelect parenthesedSelect

visit (plainSelect)

PlainSelect plainSelect

visit (setOpList)

SetOperationList setOpList

visit (withItem)

WithItem withItem

visit (aThis)

Values aThis

visit (lateralSubSelect)

LateralSubSelect lateralSubSelect

visit (tableStatement)

TableStatement tableStatement

statement.show

ShowTablesStatement.Modifiers

[EXTENDED, FULL]

ShowTablesStatement.SelectionMode

[FROM, IN]

ShowIndexStatement

extends: Object implements: Statement

ShowIndexStatement ()

ShowIndexStatement (tableName)

String tableName

getTableName () → String

returns String

setTableName (tableName)

String tableName

@Override

toString () → String

returns String

@Override

accept (statementVisitor)

StatementVisitor statementVisitor

withTableName (tableName) → ShowIndexStatement

String tableName

returns ShowIndexStatement

ShowTablesStatement

extends: Object implements: Statement

A SHOW TABLES statement

ShowTablesStatement ()

getModifiers () → EnumSet

returns EnumSet

setModifiers (modifiers)

EnumSet modifiers

getSelectionMode () → SelectionMode

returns SelectionMode

setSelectionMode (selectionMode)

SelectionMode selectionMode

getDbName () → String

returns String

setDbName (dbName)

String dbName

getLikeExpression () → Expression

returns Expression

setLikeExpression (likeExpression)

Expression likeExpression

getWhereCondition () → Expression

returns Expression

setWhereCondition (whereCondition)

Expression whereCondition

@Override

toString () → String

returns String

@Override

accept (statementVisitor)

StatementVisitor statementVisitor

statement.truncate

Truncate

extends: Object implements: Statement

Truncate ()

@Override

accept (statementVisitor)

StatementVisitor statementVisitor

getTable () → Table

returns Table

setTable (jdbcTable)

Table jdbcTable

getCascade () → boolean

returns boolean

setCascade (c)

boolean c

@Override

toString () → String

returns String

isTableToken () → boolean

returns boolean

setTableToken (hasTable)

boolean hasTable

isOnly () → boolean

returns boolean

setOnly (only)

boolean only

withTableToken (hasTableToken) → Truncate

boolean hasTableToken

returns Truncate

withTable (jdbcTable) → Truncate

Table jdbcTable

returns Truncate

withCascade (cascade) → Truncate

boolean cascade

returns Truncate

withOnly (only) → Truncate

boolean only

returns Truncate

statement.update

UpdateModifierPriority

[LOW_PRIORITY]

Update

extends: Object implements: Statement

Update ()

getOutputClause () → OutputClause

returns OutputClause

setOutputClause (outputClause)

OutputClause outputClause

getUpdateSets () → List

returns List

getUpdateSet (jdbcIndex) → UpdateSet

int jdbcIndex

returns UpdateSet

setUpdateSets (updateSets)

List updateSets

withUpdateSets (updateSets) → Update

List updateSets

returns Update

@Override

accept (statementVisitor)

StatementVisitor statementVisitor

getWithItemsList () → List

returns List

setWithItemsList (withItemsList)

List withItemsList

withWithItemsList (withItemsList) → Update

List withItemsList

returns Update

addWithItemsList (withItemsList) → Update

WithItem withItemsList

returns Update

addWithItemsList (withItemsList) → Update

Collection withItemsList

returns Update

getTable () → Table

returns Table

getWhere () → Expression

returns Expression

setTable (jdbcTable)

Table jdbcTable

setWhere (expression)

Expression expression

getOracleHint () → OracleHint

returns OracleHint

setOracleHint (oracleHint)

OracleHint oracleHint

addUpdateSet (jdbcColumn, expression) → Update

Column jdbcColumn

Expression expression

returns Update

addUpdateSet (updateSet) → Update

UpdateSet updateSet

returns Update

@Deprecated

getColumns () → List

returns List

@Deprecated

getExpressions () → List

returns List

@Deprecated

setColumns (list)

List list

@Deprecated

setExpressions (list)

List list

getFromItem () → FromItem

returns FromItem

setFromItem (fromItem)

FromItem fromItem

getJoins () → List

returns List

setJoins (joins)

List joins

getStartJoins () → List

returns List

setStartJoins (startJoins)

List startJoins

@Deprecated

getSelect () → Select

returns Select

@Deprecated

setSelect (select)

Select select

@Deprecated

isUseColumnsBrackets () → boolean

returns boolean

@Deprecated

setUseColumnsBrackets (useColumnsBrackets)

boolean useColumnsBrackets

@Deprecated

isUseSelect () → boolean

returns boolean

@Deprecated

setUseSelect (useSelect)

boolean useSelect

setOrderByElements (orderByElements)

List orderByElements

setLimit (limit)

Limit limit

getOrderByElements () → List

returns List

getLimit () → Limit

returns Limit

getReturningClause () → ReturningClause

returns ReturningClause

setReturningClause (returningClause) → Update

ReturningClause returningClause

returns Update

getModifierPriority () → UpdateModifierPriority

returns UpdateModifierPriority

setModifierPriority (modifierPriority)

UpdateModifierPriority modifierPriority

isModifierIgnore () → boolean

returns boolean

setModifierIgnore (modifierIgnore)

boolean modifierIgnore

@Override,| @SuppressWarnings

toString () → String

returns String

withTable (jdbcTable) → Update

Table jdbcTable

returns Update

withFromItem (fromItem) → Update

FromItem fromItem

returns Update

withJoins (joins) → Update

List joins

returns Update

withStartJoins (startJoins) → Update

List startJoins

returns Update

withSelect (select) → Update

Select select

returns Update

withUseColumnsBrackets (useColumnsBrackets) → Update

boolean useColumnsBrackets

returns Update

withUseSelect (useSelect) → Update

boolean useSelect

returns Update

withOrderByElements (orderByElements) → Update

List orderByElements

returns Update

withLimit (limit) → Update

Limit limit

returns Update

withWhere (where) → Update

Expression where

returns Update

withColumns (jdbcColumns) → Update

List jdbcColumns

returns Update

withExpressions (expressions) → Update

List expressions

returns Update

withModifierPriority (modifierPriority) → Update

UpdateModifierPriority modifierPriority

returns Update

withModifierIgnore (modifierIgnore) → Update

boolean modifierIgnore

returns Update

addColumns (jdbcColumns) → Update

Column jdbcColumns

returns Update

addColumns (jdbcColumns) → Update

Collection jdbcColumns

returns Update

addExpressions (expressions) → Update

Expression expressions

returns Update

addExpressions (expressions) → Update

Collection expressions

returns Update

addJoins (joins) → Update

Join joins

returns Update

addJoins (joins) → Update

Collection joins

returns Update

addStartJoins (startJoins) → Update

Join startJoins

returns Update

addStartJoins (startJoins) → Update

Collection startJoins

returns Update

addOrderByElements (orderByElements) → Update

OrderByElement orderByElements

returns Update

addOrderByElements (orderByElements) → Update

Collection orderByElements

returns Update

getWhere (part) → E

Class part

returns E

getFromItem (part) → E

Class part

returns E

UpdateSet

extends: Object implements: Serializable

UpdateSet ()

UpdateSet (jdbcColumn)

Column jdbcColumn

UpdateSet (jdbcColumn, value)

Column jdbcColumn

Expression value

getColumns () → ExpressionList

returns ExpressionList

getColumn (jdbcIndex) → Column

int jdbcIndex

returns Column

setColumns (jdbcColumns)

ExpressionList jdbcColumns

getValues () → ExpressionList

returns ExpressionList

getValue (jdbcIndex) → Expression

int jdbcIndex

returns Expression

setValues (values)

ExpressionList values

add (jdbcColumn, value)

Column jdbcColumn

Expression value

add (jdbcColumn)

Add another jdbcColumn to the existing jdbcColumn list. Transform this list into a ParenthesedExpression list when needed.

Column jdbcColumn

add (expression)

Add another expression to the existing value list. Transform this list into a ParenthesedExpression list when needed.

Expression expression

add (expressionList)

ExpressionList expressionList

appendUpdateSetsTo (builder, updateSets) → StringBuilder

StringBuilder builder

Collection updateSets

returns StringBuilder

statement.upsert

UpsertType

[UPSERT, REPLACE, REPLACE_SET, INSERT_OR_ABORT, INSERT_OR_FAIL, INSERT_OR_IGNORE, INSERT_OR_REPLACE, INSERT_OR_ROLLBACK]

Upsert

extends: Object implements: Statement

Upsert ()

getUpdateSets () → List

returns List

setUpdateSets (updateSets) → Upsert

List updateSets

returns Upsert

getDuplicateUpdateSets () → List

returns List

setDuplicateUpdateSets (duplicateUpdateSets) → Upsert

List duplicateUpdateSets

returns Upsert

@Override

accept (statementVisitor)

StatementVisitor statementVisitor

getUpsertType () → UpsertType

returns UpsertType

setUpsertType (upsertType)

UpsertType upsertType

withUpsertType (upsertType) → Upsert

UpsertType upsertType

returns Upsert

isUsingInto () → boolean

returns boolean

setUsingInto (useInto)

boolean useInto

withUsingInto (useInto) → Upsert

boolean useInto

returns Upsert

getTable () → Table

returns Table

setTable (name)

Table name

getColumns () → ExpressionList

returns ExpressionList

setColumns (list)

ExpressionList list

getExpressions () → ExpressionList

returns ExpressionList

setExpressions (list)

ExpressionList list

@Deprecated

getSetExpressions () → ExpressionList

returns ExpressionList

getSelect () → Select

returns Select

setSelect (select)

Select select

getValues () → Values

returns Values

getPlainSelect () → PlainSelect

returns PlainSelect

getSetOperationList () → SetOperationList

returns SetOperationList

@Override,| @SuppressWarnings

toString () → String

returns String

withSelect (select) → Upsert

Select select

returns Upsert

withTable (jdbcTable) → Upsert

Table jdbcTable

returns Upsert

withColumns (jdbcColumns) → Upsert

ExpressionList jdbcColumns

returns Upsert

withExpressions (expressions) → Upsert

ExpressionList expressions

returns Upsert

addColumns (jdbcColumns) → Upsert

Column jdbcColumns

returns Upsert

addColumns (jdbcColumns) → Upsert

Collection jdbcColumns

returns Upsert

util

AddAliasesVisitor

extends: Object implements: SelectVisitor, SelectItemVisitor

Add aliases to every jdbcColumn and expression selected by a select - statement. Existing aliases are recognized and preserved. This class standard uses a prefix of A and a counter to generate new aliases (e.g. A1, A5, …). This behaviour can be altered.

AddAliasesVisitor ()

@Override

visit (parenthesedSelect)

ParenthesedSelect parenthesedSelect

@Override

visit (plainSelect)

PlainSelect plainSelect

@Override

visit (setOpList)

SetOperationList setOpList

@Override

visit (selectExpressionItem)

SelectItem selectExpressionItem

returns String

setPrefix (prefix)

String prefix

@Override

visit (withItem)

WithItem withItem

@Override

visit (aThis)

Values aThis

@Override

visit (lateralSubSelect)

LateralSubSelect lateralSubSelect

@Override

visit (tableStatement)

TableStatement tableStatement

ConnectExpressionsVisitor

extends: Object implements: SelectVisitor, SelectItemVisitor

Connect all selected expressions with a binary expression. Out of select a,b from jdbcTable one gets select a || b as expr from jdbcTable. The part of binary expression is set by overwriting this class abstract method createBinaryExpression.

ConnectExpressionsVisitor ()

ConnectExpressionsVisitor (alias)

String alias

returns BinaryExpression

@Override

visit (parenthesedSelect)

ParenthesedSelect parenthesedSelect

@Override

visit (lateralSubSelect)

LateralSubSelect lateralSubSelect

@Override

visit (plainSelect)

PlainSelect plainSelect

@Override

visit (setOpList)

SetOperationList setOpList

@Override

visit (withItem)

WithItem withItem

@Override

visit (selectItem)

SelectItem selectItem

@Override

visit (aThis)

Values aThis

@Override

visit (tableStatement)

TableStatement tableStatement

PerformanceTest

extends: Object

PerformanceTest ()

@SuppressWarnings

main (args)

String args

SelectUtils

extends: Object

buildSelectFromTableAndExpressions (jdbcTable, expr) → Select

Table jdbcTable

Expression expr

returns Select

buildSelectFromTableAndExpressions (jdbcTable, expr) → Select

Table jdbcTable

String expr

returns Select

buildSelectFromTableAndSelectItems (jdbcTable, selectItems) → Select

Table jdbcTable

SelectItem selectItems

returns Select

buildSelectFromTable (jdbcTable) → Select

Builds select * from jdbcTable.

Table jdbcTable

returns Select |

addExpression (select, expr)

Adds an expression to select statements. E.g. a simple jdbcColumn is an expression.

Select select

Expression expr

addJoin (select, jdbcTable, onExpression) → Join

Adds a simple join to a select statement. The introduced join is returned for more configuration settings on it (e.g. left join, right join).

Select select

Table jdbcTable

Expression onExpression

returns Join |

addGroupBy (select, expr)

Adds group by to a plain select statement.

Select select

Expression expr

TablesNamesFinder

extends: Object implements: SelectVisitor, FromItemVisitor, ExpressionVisitor, SelectItemVisitor, StatementVisitor

Find all used jdbcTables within an select statement.

Override extractTableName method to modify the extracted jdbcTable names (e.g. without jdbcSchema).

TablesNamesFinder ()

@Deprecated

getTableList (statement) → List

Statement statement

returns List

getTables (statement) → Set

Statement statement

returns Set

findTables (sqlStr) → Set

String sqlStr

returns Set

@Override

visit (select)

Select select

@Override

visit (transcodingFunction)

TranscodingFunction transcodingFunction

@Override

visit (trimFunction)

TrimFunction trimFunction

@Override

visit (rangeExpression)

RangeExpression rangeExpression

@Deprecated

getTableList (expr) → List

Main entry for this Tool class. A list of found jdbcTables is returned.

Expression expr

returns List

getTables (expr) → Set

Expression expr

returns Set

findTablesInExpression (exprStr) → Set

String exprStr

returns Set

@Override

visit (withItem)

WithItem withItem

@Override

visit (selectBody)

ParenthesedSelect selectBody

@Override

visit (plainSelect)

PlainSelect plainSelect

Override to adapt the tableName generation (e.g. with / without jdbcSchema).

Table jdbcTable

returns String |

@Override

visit (tableName)

Table tableName

@Override

visit (addition)

Addition addition

@Override

visit (andExpression)

AndExpression andExpression

@Override

visit (between)

Between between

@Override

visit (overlapsCondition)

OverlapsCondition overlapsCondition

@Override

visit (tableColumn)

Column tableColumn

@Override

visit (division)

Division division

@Override

visit (division)

IntegerDivision division

@Override

visit (doubleValue)

DoubleValue doubleValue

@Override

visit (equalsTo)

EqualsTo equalsTo

@Override

visit (function)

Function function

@Override

visit (greaterThan)

GreaterThan greaterThan

@Override

visit (greaterThanEquals)

GreaterThanEquals greaterThanEquals

@Override

visit (inExpression)

InExpression inExpression

@Override

visit (fullTextSearch)

FullTextSearch fullTextSearch

@Override

visit (signedExpression)

SignedExpression signedExpression

@Override

visit (isNullExpression)

IsNullExpression isNullExpression

@Override

visit (isBooleanExpression)

IsBooleanExpression isBooleanExpression

@Override

visit (jdbcParameter)

JdbcParameter jdbcParameter

@Override

visit (likeExpression)

LikeExpression likeExpression

@Override

visit (existsExpression)

ExistsExpression existsExpression

@Override

visit (memberOfExpression)

MemberOfExpression memberOfExpression

@Override

visit (longValue)

LongValue longValue

@Override

visit (minorThan)

MinorThan minorThan

@Override

visit (minorThanEquals)

MinorThanEquals minorThanEquals

@Override

visit (multiplication)

Multiplication multiplication

@Override

visit (notEqualsTo)

NotEqualsTo notEqualsTo

@Override

visit (doubleAnd)

DoubleAnd doubleAnd

@Override

visit (contains)

Contains contains

@Override

visit (containedBy)

ContainedBy containedBy

@Override

visit (nullValue)

NullValue nullValue

@Override

visit (orExpression)

OrExpression orExpression

@Override

visit (xorExpression)

XorExpression xorExpression

@Override

visit (parenthesis)

Parenthesis parenthesis

@Override

visit (stringValue)

StringValue stringValue

@Override

visit (subtraction)

Subtraction subtraction

@Override

visit (notExpr)

NotExpression notExpr

@Override

visit (expr)

BitwiseRightShift expr

@Override

visit (expr)

BitwiseLeftShift expr

visitBinaryExpression (binaryExpression)

BinaryExpression binaryExpression

@Override

visit (expressionList)

ExpressionList expressionList

@Override

visit (dateValue)

DateValue dateValue

@Override

visit (timestampValue)

TimestampValue timestampValue

@Override

visit (timeValue)

TimeValue timeValue

@Override

visit (caseExpression)

CaseExpression caseExpression

@Override

visit (whenClause)

WhenClause whenClause

@Override

visit (anyComparisonExpression)

AnyComparisonExpression anyComparisonExpression

@Override

visit (concat)

Concat concat

@Override

visit (matches)

Matches matches

@Override

visit (bitwiseAnd)

BitwiseAnd bitwiseAnd

@Override

visit (bitwiseOr)

BitwiseOr bitwiseOr

@Override

visit (bitwiseXor)

BitwiseXor bitwiseXor

@Override

visit (cast)

CastExpression cast

@Override

visit (modulo)

Modulo modulo

@Override

visit (analytic)

AnalyticExpression analytic

@Override

visit (list)

SetOperationList list

@Override

visit (eexpr)

ExtractExpression eexpr

@Override

visit (lateralSubSelect)

LateralSubSelect lateralSubSelect

@Override

visit (tableStatement)

TableStatement tableStatement

Initializes jdbcTable names collector. Important is the usage of Column instances to find jdbcTable

names. This is only allowed for expression parsing, where a better place for tablenames could not be there. For complete statements only from items are used to avoid some alias as tablenames.

boolean allowColumnProcessing

returns void

@Override

visit (iexpr)

IntervalExpression iexpr

@Override

visit (jdbcNamedParameter)

JdbcNamedParameter jdbcNamedParameter

@Override

visit (oexpr)

OracleHierarchicalExpression oexpr

@Override

visit (rexpr)

RegExpMatchOperator rexpr

@Override

visit (jsonExpr)

JsonExpression jsonExpr

@Override

visit (jsonExpr)

JsonOperator jsonExpr

@Override

visit (allColumns)

AllColumns allColumns

@Override

visit (allTableColumns)

AllTableColumns allTableColumns

@Override

visit (allValue)

AllValue allValue

@Override

visit (isDistinctExpression)

IsDistinctExpression isDistinctExpression

@Override

visit (item)

SelectItem item

@Override

visit (var)

UserVariable var

@Override

visit (bind)

NumericBind bind

@Override

visit (aexpr)

KeepExpression aexpr

@Override

visit (groupConcat)

MySQLGroupConcat groupConcat

@Override

visit (delete)

Delete delete

@Override

visit (update)

Update update

@Override

visit (insert)

Insert insert

visit (analyze)

Analyze analyze

@Override

visit (drop)

Drop drop

@Override

visit (truncate)

Truncate truncate

@Override

visit (createIndex)

CreateIndex createIndex

@Override

visit (aThis)

CreateSchema aThis

@Override

visit (create)

CreateTable create

@Override

visit (createView)

CreateView createView

@Override

visit (alter)

Alter alter

@Override

visit (stmts)

Statements stmts

@Override

visit (execute)

Execute execute

@Override

visit (set)

SetStatement set

@Override

visit (reset)

ResetStatement reset

@Override

visit (set)

ShowColumnsStatement set

@Override

visit (showIndex)

ShowIndexStatement showIndex

@Override

visit (rowConstructor)

RowConstructor rowConstructor

@Override

visit (rowGetExpression)

RowGetExpression rowGetExpression

@Override

visit (hexValue)

HexValue hexValue

@Override

visit (merge)

Merge merge

@Override

visit (hint)

OracleHint hint

@Override

visit (tableFunction)

TableFunction tableFunction

@Override

visit (alterView)

AlterView alterView

@Override

visit (materializedView)

RefreshMaterializedViewStatement materializedView

@Override

visit (timeKeyExpression)

TimeKeyExpression timeKeyExpression

@Override

visit (literal)

DateTimeLiteralExpression literal

@Override

visit (commit)

Commit commit

@Override

visit (upsert)

Upsert upsert

@Override

visit (use)

UseStatement use

@Override

visit (parenthesis)

ParenthesedFromItem parenthesis

@Override

visit (block)

Block block

@Override

visit (comment)

Comment comment

@Override

visit (values)

Values values

@Override

visit (describe)

DescribeStatement describe

@Override

visit (explain)

ExplainStatement explain

@Override

visit (nextVal)

NextValExpression nextVal

@Override

visit (col)

CollateExpression col

@Override

visit (aThis)

ShowStatement aThis

@Override

visit (expr)

SimilarToExpression expr

@Override

visit (aThis)

DeclareStatement aThis

@Override

visit (grant)

Grant grant

@Override

visit (array)

ArrayExpression array

@Override

visit (array)

ArrayConstructor array

@Override

visit (createSequence)

CreateSequence createSequence

@Override

visit (alterSequence)

AlterSequence alterSequence

@Override

visit (createFunctionalStatement)

CreateFunctionalStatement createFunctionalStatement

@Override

visit (showTables)

ShowTablesStatement showTables

@Override

visit (tsqlLeftJoin)

TSQLLeftJoin tsqlLeftJoin

@Override

visit (tsqlRightJoin)

TSQLRightJoin tsqlRightJoin

@Override

visit (var)

VariableAssignment var

@Override

visit (aThis)

XMLSerializeExpr aThis

@Override

visit (createSynonym)

CreateSynonym createSynonym

@Override

visit (aThis)

TimezoneExpression aThis

@Override

visit (savepointStatement)

SavepointStatement savepointStatement

@Override

visit (rollbackStatement)

RollbackStatement rollbackStatement

@Override

visit (alterSession)

AlterSession alterSession

@Override

visit (expression)

JsonAggregateFunction expression

@Override

visit (expression)

JsonFunction expression

@Override

visit (connectByRootOperator)

ConnectByRootOperator connectByRootOperator

visit (ifElseStatement)

IfElseStatement ifElseStatement

visit (oracleNamedFunctionParameter)

OracleNamedFunctionParameter oracleNamedFunctionParameter

@Override

visit (renameTableStatement)

RenameTableStatement renameTableStatement

@Override

visit (purgeStatement)

PurgeStatement purgeStatement

@Override

visit (alterSystemStatement)

AlterSystemStatement alterSystemStatement

@Override

visit (unsupportedStatement)

UnsupportedStatement unsupportedStatement

@Override

visit (geometryDistance)

GeometryDistance geometryDistance

util.cnfexpression

CNFConverter

extends: Object

This class handles the conversion from a normal expression tree into the CNF form. Here is the definition of CNF form: https://en.wikipedia.org/wiki/Conjunctive_normal_form Basically it will follow these steps: To help understanding, I will generate an example: Here is the original tree: OR / OR NOT / | NOT H AND | / NOT G OR | / F H NOT | OR / AND L / ( ) ( ) | | J K 1. rebuild the tree by replacing the “and” and “or” operators (which are binary) into their counterparts node that could hold multiple elements. Also, leave out the parenthesis node between the conditional operators to make the tree uniform. After the transform, the result should be like this: OR(M) / OR(M) NOT / | NOT H AND(M) | / NOT G OR(M) | / F H NOT | OR(M) / AND(M) L / J K 2. push the not operators into the bottom of the expression. That means the not operator will be the root of the expression tree where no “and” or “or” exists. Be sure use the De Morgan’s law and double not law. How to use De Morgan law: For example, here is the original expression tree: NOT | AND(M) / G H After we use the De Morgan law, the result should be like this: OR(M) / NOT NOT | | G H After the transform, the result should be like this: OR(M) / OR(M) OR(M) / / F H NOT AND(M) | / G NOT OR(M) | / H AND(M) L / J K 3. gather all the adjacent “and” or “or” operator together. After doing that, the expression tree will be presented as: all the and expression will be in either odd or even levels, this will be the same for the or operator. After the transform, the expression tree should be like this: OR(M) / / F H NOT AND(M) | / G NOT OR(M) | / H AND(M) L / J K 4. push the and operator upwards until the root is an and operator and all the children are or operators with multiple components. At this time we get the result: an expression in CNF form. How do we push and up? Use distribution law! For example, here is the way to push the and up and merge them. OR / AND L / J K In the normal form, it could be: (J AND K) OR L. If we apply the distribution law, we will get the result like this: (J OR L) AND (K OR L), the tree form of this should be like: AND / OR OR / / J L K L So after we push the AND at the deepest level up and merge it with the existing add, we get this result. OR(M) / / F H NOT AND(M) | / | G NOT OR(M) OR(M) | / / H J L K L Now let us push the and up and we will get the result like this: AND(M) / | OR(M) OR(M) OR(M) / / / / | / / | F H NOT NOT F H NOT J L F H NOT K L | | | | G H G G 5. The last step, convert the Multiple Expression back to the binary form. Note the final tree shall be left-inclined. The final expression tree shall be like this: AND / AND ( ) / | ( ) ( ) part1 | | OR part2 / OR NOT / | OR NOT H / | F H G part1: OR / OR L / OR K / OR NOT / | F H G part2: OR / OR L / OR J / OR NOT / | F H G

CNFConverter ()

convertToCNF (expr) → Expression

Expression expr

returns Expression

MultiAndExpression

extends: MultipleExpression

This helper class is mainly used for handling the CNF conversion.

MultiAndExpression (childlist)

List childlist

@Override

getStringExpression () → String

returns String

MultiOrExpression

extends: MultipleExpression

MultiOrExpression (childlist)

List childlist

@Override

getStringExpression () → String

returns String

MultipleExpression

extends: ASTNodeAccessImpl implements: Expression provides: MultiAndExpression, MultiOrExpression

This is a helper class that mainly used for handling the CNF conversion.

MultipleExpression (childlist)

List childlist

size () → int

returns int

@Override

accept (expressionVisitor)

ExpressionVisitor expressionVisitor

getList () → List

returns List

getChild (jdbcIndex) → Expression

int jdbcIndex

returns Expression

removeChild (jdbcIndex) → Expression

int jdbcIndex

returns Expression

setChild (jdbcIndex, express)

int jdbcIndex

Expression express

getIndex (express) → int

Expression express

returns int

addChild (jdbcIndex, express)

int jdbcIndex

Expression express

getStringExpression () → String

returns String

@Override

toString () → String

returns String

util.deparser

AlterDeParser

extends: AbstractDeParser

AlterDeParser (buffer)

StringBuilder buffer

@Override

deParse (alter)

Alter alter

AlterSequenceDeParser

extends: AbstractDeParser

A class to de-parse (that is, transform from JSqlParser hierarchy into a string) a net.sf.jsqlparser.statement.alter.sequence.AlterSequence

AlterSequenceDeParser (buffer)

StringBuilder buffer | buffer the buffer that will be filled with the AlterSequence

@Override

deParse (statement)

AlterSequence statement

AlterSessionDeParser

extends: AbstractDeParser

AlterSessionDeParser (buffer)

StringBuilder buffer

@Override

deParse (alterSession)

AlterSession alterSession

AlterViewDeParser

extends: AbstractDeParser

AlterViewDeParser (buffer)

StringBuilder buffer

AlterViewDeParser (buffer, selectVisitor)

StringBuilder buffer

SelectVisitor selectVisitor

@Override

deParse (alterView)

AlterView alterView

CreateIndexDeParser

extends: AbstractDeParser

CreateIndexDeParser (buffer)

StringBuilder buffer

@Override

deParse (createIndex)

CreateIndex createIndex

CreateSequenceDeParser

extends: AbstractDeParser

A class to de-parse (that is, transform from JSqlParser hierarchy into a string) a net.sf.jsqlparser.statement.create.sequence.CreateSequence

CreateSequenceDeParser (buffer)

StringBuilder buffer | buffer the buffer that will be filled with the CreatSequence

@Override

deParse (statement)

CreateSequence statement

CreateSynonymDeparser

extends: AbstractDeParser

A class to de-parse (that is, transform from JSqlParser hierarchy into a string) a CreateSynonym

CreateSynonymDeparser (buffer)

StringBuilder buffer

CreateTableDeParser

extends: AbstractDeParser

CreateTableDeParser (buffer)

StringBuilder buffer

CreateTableDeParser (statementDeParser, buffer)

StatementDeParser statementDeParser

StringBuilder buffer

@Override,| @SuppressWarnings

deParse (createTable)

CreateTable createTable

CreateViewDeParser

extends: AbstractDeParser

CreateViewDeParser (buffer)

StringBuilder buffer

CreateViewDeParser (buffer, selectVisitor)

StringBuilder buffer

SelectVisitor selectVisitor

@Override,| @SuppressWarnings

deParse (createView)

CreateView createView

DeclareStatementDeParser

extends: AbstractDeParser

DeclareStatementDeParser (expressionVisitor, buffer)

ExpressionVisitor expressionVisitor

StringBuilder buffer

@Override,| @SuppressWarnings

deParse (declare)

DeclareStatement declare

getExpressionVisitor () → ExpressionVisitor

returns ExpressionVisitor

setExpressionVisitor (visitor)

ExpressionVisitor visitor

DeleteDeParser

extends: AbstractDeParser

DeleteDeParser ()

DeleteDeParser (expressionVisitor, buffer)

ExpressionVisitor expressionVisitor

StringBuilder buffer

@Override,| @SuppressWarnings

deParse (delete)

Delete delete

getExpressionVisitor () → ExpressionVisitor

returns ExpressionVisitor

setExpressionVisitor (visitor)

ExpressionVisitor visitor

DropDeParser

extends: AbstractDeParser

DropDeParser (buffer)

StringBuilder buffer

@Override

deParse (drop)

Drop drop

ExecuteDeParser

extends: AbstractDeParser

ExecuteDeParser (expressionVisitor, buffer)

ExpressionVisitor expressionVisitor

StringBuilder buffer

@Override

deParse (execute)

Execute execute

getExpressionVisitor () → ExpressionVisitor

returns ExpressionVisitor

setExpressionVisitor (visitor)

ExpressionVisitor visitor

ExpressionDeParser

extends: AbstractDeParser implements: ExpressionVisitor

ExpressionDeParser ()

ExpressionDeParser (selectVisitor, buffer)

SelectVisitor selectVisitor

StringBuilder buffer

@Override

visit (addition)

Addition addition

@Override

visit (andExpression)

AndExpression andExpression

@Override

visit (between)

Between between

@Override

visit (overlapsCondition)

OverlapsCondition overlapsCondition

@Override

visit (equalsTo)

EqualsTo equalsTo

@Override

visit (division)

Division division

@Override

visit (division)

IntegerDivision division

@Override

visit (doubleValue)

DoubleValue doubleValue

@Override

visit (hexValue)

HexValue hexValue

@Override

visit (notExpr)

NotExpression notExpr

@Override

visit (expr)

BitwiseRightShift expr

@Override

visit (expr)

BitwiseLeftShift expr

visitOldOracleJoinBinaryExpression (expression, operator)

OldOracleJoinBinaryExpression expression

String operator

@Override

visit (greaterThan)

GreaterThan greaterThan

@Override

visit (greaterThanEquals)

GreaterThanEquals greaterThanEquals

@Override

visit (inExpression)

InExpression inExpression

@Override

visit (fullTextSearch)

FullTextSearch fullTextSearch

@Override

visit (signedExpression)

SignedExpression signedExpression

@Override

visit (isNullExpression)

IsNullExpression isNullExpression

@Override

visit (isBooleanExpression)

IsBooleanExpression isBooleanExpression

@Override

visit (jdbcParameter)

JdbcParameter jdbcParameter

@Override

visit (likeExpression)

LikeExpression likeExpression

@Override

visit (existsExpression)

ExistsExpression existsExpression

@Override

visit (memberOfExpression)

MemberOfExpression memberOfExpression

@Override

visit (longValue)

LongValue longValue

@Override

visit (minorThan)

MinorThan minorThan

@Override

visit (minorThanEquals)

MinorThanEquals minorThanEquals

@Override

visit (multiplication)

Multiplication multiplication

@Override

visit (notEqualsTo)

NotEqualsTo notEqualsTo

@Override

visit (doubleAnd)

DoubleAnd doubleAnd

@Override

visit (contains)

Contains contains

@Override

visit (containedBy)

ContainedBy containedBy

@Override

visit (nullValue)

NullValue nullValue

@Override

visit (orExpression)

OrExpression orExpression

@Override

visit (xorExpression)

XorExpression xorExpression

@Override

visit (parenthesis)

Parenthesis parenthesis

@Override

visit (stringValue)

StringValue stringValue

@Override

visit (subtraction)

Subtraction subtraction

BinaryExpression binaryExpression

String operator

returns void

@Override

visit (selectBody)

Select selectBody

@Override

visit (transcodingFunction)

TranscodingFunction transcodingFunction

visit (trimFunction)

TrimFunction trimFunction

@Override

visit (rangeExpression)

RangeExpression rangeExpression

@Override

visit (tableColumn)

Column tableColumn

@Override,| @SuppressWarnings

visit (function)

Function function

@Override

visit (selectBody)

ParenthesedSelect selectBody

getSelectVisitor () → SelectVisitor

returns SelectVisitor

setSelectVisitor (visitor)

SelectVisitor visitor

@Override

visit (dateValue)

DateValue dateValue

@Override

visit (timestampValue)

TimestampValue timestampValue

@Override

visit (timeValue)

TimeValue timeValue

@Override

visit (caseExpression)

CaseExpression caseExpression

@Override

visit (whenClause)

WhenClause whenClause

@Override

visit (anyComparisonExpression)

AnyComparisonExpression anyComparisonExpression

@Override

visit (concat)

Concat concat

@Override

visit (matches)

Matches matches

@Override

visit (bitwiseAnd)

BitwiseAnd bitwiseAnd

@Override

visit (bitwiseOr)

BitwiseOr bitwiseOr

@Override

visit (bitwiseXor)

BitwiseXor bitwiseXor

@Override

visit (cast)

CastExpression cast

@Override

visit (modulo)

Modulo modulo

@Override,| @SuppressWarnings

visit (aexpr)

AnalyticExpression aexpr

@Override

visit (eexpr)

ExtractExpression eexpr

@Override

visit (intervalExpression)

IntervalExpression intervalExpression

@Override

visit (jdbcNamedParameter)

JdbcNamedParameter jdbcNamedParameter

@Override

visit (oexpr)

OracleHierarchicalExpression oexpr

@Override

visit (rexpr)

RegExpMatchOperator rexpr

@Override

visit (jsonExpr)

JsonExpression jsonExpr

@Override

visit (jsonExpr)

JsonOperator jsonExpr

@Override

visit (var)

UserVariable var

@Override

visit (bind)

NumericBind bind

@Override

visit (aexpr)

KeepExpression aexpr

@Override

visit (groupConcat)

MySQLGroupConcat groupConcat

@Override

visit (expressionList)

ExpressionList expressionList

@Override

visit (rowConstructor)

RowConstructor rowConstructor

@Override

visit (rowGetExpression)

RowGetExpression rowGetExpression

@Override

visit (hint)

OracleHint hint

@Override

visit (timeKeyExpression)

TimeKeyExpression timeKeyExpression

@Override

visit (literal)

DateTimeLiteralExpression literal

@Override

visit (nextVal)

NextValExpression nextVal

@Override

visit (col)

CollateExpression col

@Override

visit (expr)

SimilarToExpression expr

@Override

visit (array)

ArrayExpression array

@Override

visit (aThis)

ArrayConstructor aThis

@Override

visit (var)

VariableAssignment var

@Override

visit (expr)

XMLSerializeExpr expr

@Override

visit (var)

TimezoneExpression var

@Override

visit (expression)

JsonAggregateFunction expression

@Override

visit (expression)

JsonFunction expression

@Override

visit (connectByRootOperator)

ConnectByRootOperator connectByRootOperator

@Override

visit (oracleNamedFunctionParameter)

OracleNamedFunctionParameter oracleNamedFunctionParameter

@Override

visit (allColumns)

AllColumns allColumns

@Override

visit (allTableColumns)

AllTableColumns allTableColumns

@Override

visit (allValue)

AllValue allValue

@Override

visit (isDistinctExpression)

IsDistinctExpression isDistinctExpression

@Override

visit (geometryDistance)

GeometryDistance geometryDistance

@Override

visit (tsqlLeftJoin)

TSQLLeftJoin tsqlLeftJoin

@Override

visit (tsqlRightJoin)

TSQLRightJoin tsqlRightJoin

ExpressionListDeParser

extends: AbstractDeParser

ExpressionListDeParser (expressionVisitor, builder)

ExpressionVisitor expressionVisitor

StringBuilder builder

@Override

deParse (expressionList)

ExpressionList expressionList

GrantDeParser

extends: AbstractDeParser

GrantDeParser (buffer)

StringBuilder buffer

@Override

deParse (grant)

Grant grant

GroupByDeParser

extends: AbstractDeParser

GroupByDeParser (expressionVisitor, buffer)

ExpressionVisitor expressionVisitor

StringBuilder buffer

@Override,| @SuppressWarnings

deParse (groupBy)

GroupByElement groupBy

InsertDeParser

extends: AbstractDeParser

InsertDeParser ()

InsertDeParser (expressionVisitor, selectVisitor, buffer)

ExpressionVisitor expressionVisitor

SelectVisitor selectVisitor

StringBuilder buffer

@Override,| @SuppressWarnings

deParse (insert)

Insert insert

getExpressionVisitor () → ExpressionVisitor

returns ExpressionVisitor

getSelectVisitor () → SelectVisitor

returns SelectVisitor

setExpressionVisitor (visitor)

ExpressionVisitor visitor

setSelectVisitor (visitor)

SelectVisitor visitor

LimitDeparser

extends: AbstractDeParser

LimitDeparser (expressionVisitor, buffer)

ExpressionVisitor expressionVisitor

StringBuilder buffer

@Override

deParse (limit)

Limit limit

getExpressionVisitor () → ExpressionVisitor

returns ExpressionVisitor

setExpressionVisitor (expressionVisitor)

ExpressionVisitor expressionVisitor

MergeDeParser

extends: AbstractDeParser implements: MergeOperationVisitor

MergeDeParser (expressionDeParser, selectDeParser, buffer)

ExpressionDeParser expressionDeParser

SelectDeParser selectDeParser

StringBuilder buffer

@Override

visit (mergeDelete)

MergeDelete mergeDelete

@Override

visit (mergeUpdate)

MergeUpdate mergeUpdate

@Override

visit (mergeInsert)

MergeInsert mergeInsert

OrderByDeParser

extends: AbstractDeParser

OrderByDeParser (expressionVisitor, buffer)

ExpressionVisitor expressionVisitor

StringBuilder buffer

@Override

deParse (orderByElementList)

List orderByElementList

deParse (oracleSiblings, orderByElementList)

boolean oracleSiblings

List orderByElementList

deParseElement (orderBy)

OrderByElement orderBy

RefreshMaterializedViewStatementDeParser

extends: AbstractDeParser

RefreshMaterializedViewStatementDeParser (buffer)

StringBuilder buffer

@SuppressWarnings,| @Override

deParse (view)

RefreshMaterializedViewStatement view

ResetStatementDeParser

extends: AbstractDeParser

ResetStatementDeParser (expressionVisitor, buffer)

ExpressionVisitor expressionVisitor

StringBuilder buffer

@Override

deParse (set)

ResetStatement set

getExpressionVisitor () → ExpressionVisitor

returns ExpressionVisitor

setExpressionVisitor (visitor)

ExpressionVisitor visitor

SelectDeParser

extends: AbstractDeParser implements: SelectVisitor, SelectItemVisitor, FromItemVisitor, PivotVisitor

SelectDeParser ()

SelectDeParser (buffer)

StringBuilder buffer

SelectDeParser (expressionVisitor, buffer)

ExpressionVisitor expressionVisitor

StringBuilder buffer

@Override

visit (selectBody)

ParenthesedSelect selectBody

@Override,| @SuppressWarnings

visit (plainSelect)

PlainSelect plainSelect

@Override

visit (selectExpressionItem)

SelectItem selectExpressionItem

@Override

visit (tableName)

Table tableName

@Override

visit (pivot)

Pivot pivot

@Override

visit (unpivot)

UnPivot unpivot

@Override

visit (pivot)

PivotXml pivot

visit (offset)

Offset offset

visit (fetch)

Fetch fetch

getExpressionVisitor () → ExpressionVisitor

returns ExpressionVisitor

setExpressionVisitor (visitor)

ExpressionVisitor visitor

@SuppressWarnings

deparseJoin (join)

Join join

deparseLateralView (lateralView)

LateralView lateralView

@Override

visit (list)

SetOperationList list

@Override

visit (withItem)

WithItem withItem

@Override

visit (lateralSubSelect)

LateralSubSelect lateralSubSelect

@Override

visit (tableStatement)

TableStatement tableStatement

@Override

visit (tableFunction)

TableFunction tableFunction

@Override

visit (fromItem)

ParenthesedFromItem fromItem

@Override

visit (values)

Values values

SetStatementDeParser

extends: AbstractDeParser

SetStatementDeParser (expressionVisitor, buffer)

ExpressionVisitor expressionVisitor

StringBuilder buffer

@Override

deParse (set)

SetStatement set

getExpressionVisitor () → ExpressionVisitor

returns ExpressionVisitor

setExpressionVisitor (visitor)

ExpressionVisitor visitor

ShowColumnsStatementDeParser

extends: AbstractDeParser

ShowColumnsStatementDeParser (buffer)

StringBuilder buffer

@Override

deParse (show)

ShowColumnsStatement show

ShowIndexStatementDeParser

extends: AbstractDeParser

ShowIndexStatementDeParser (buffer)

StringBuilder buffer

@Override

deParse (show)

ShowIndexStatement show

ShowStatementDeParser

extends: AbstractDeParser

ShowStatementDeParser (buffer)

StringBuilder buffer

@Override

deParse (show)

ShowStatement show

ShowTablesStatementDeparser

extends: AbstractDeParser

ShowTablesStatementDeparser (buffer)

StringBuilder buffer

StatementDeParser

extends: AbstractDeParser implements: StatementVisitor

StatementDeParser (buffer)

StringBuilder buffer

StatementDeParser (expressionDeParser, selectDeParser, buffer)

ExpressionDeParser expressionDeParser

SelectDeParser selectDeParser

StringBuilder buffer

@Override

visit (createIndex)

CreateIndex createIndex

@Override

visit (createTable)

CreateTable createTable

@Override

visit (createView)

CreateView createView

@Override

visit (materializedViewStatement)

RefreshMaterializedViewStatement materializedViewStatement

@Override

visit (alterView)

AlterView alterView

@Override

visit (delete)

Delete delete

@Override

visit (drop)

Drop drop

@Override

visit (insert)

Insert insert

@Override

visit (select)

Select select

@Override

visit (truncate)

Truncate truncate

@Override

visit (update)

Update update

visit (analyzer)

Analyze analyzer

@Override

visit (alter)

Alter alter

@Override

visit (stmts)

Statements stmts

@Override

visit (execute)

Execute execute

@Override

visit (set)

SetStatement set

@Override

visit (reset)

ResetStatement reset

@SuppressWarnings,| @Override

visit (merge)

Merge merge

@Override

visit (savepointStatement)

SavepointStatement savepointStatement

@Override

visit (rollbackStatement)

RollbackStatement rollbackStatement

@Override

visit (commit)

Commit commit

@Override

visit (upsert)

Upsert upsert

@Override

visit (use)

UseStatement use

@Override

visit (show)

ShowColumnsStatement show

@Override

visit (showIndexes)

ShowIndexStatement showIndexes

@Override

visit (showTables)

ShowTablesStatement showTables

@Override

visit (block)

Block block

@Override

visit (comment)

Comment comment

@Override

visit (describe)

DescribeStatement describe

@Override

visit (explain)

ExplainStatement explain

@Override

visit (show)

ShowStatement show

@Override

visit (declare)

DeclareStatement declare

@Override

visit (grant)

Grant grant

@Override

visit (aThis)

CreateSchema aThis

@Override

visit (createSequence)

CreateSequence createSequence

@Override

visit (alterSequence)

AlterSequence alterSequence

@Override

visit (createFunctionalStatement)

CreateFunctionalStatement createFunctionalStatement

@Override

visit (createSynonym)

CreateSynonym createSynonym

@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

TableStatementDeParser

extends: AbstractDeParser implements: SelectVisitor

TableStatementDeParser (expressionVisitor, buffer)

ExpressionVisitor expressionVisitor

StringBuilder buffer

@Override

deParse (tableStatement)

TableStatement tableStatement

visit (offset)

Offset offset

@Override

visit (parenthesedSelect)

ParenthesedSelect parenthesedSelect

@Override

visit (plainSelect)

PlainSelect plainSelect

@Override

visit (setOpList)

SetOperationList setOpList

@Override

visit (withItem)

WithItem withItem

@Override

visit (aThis)

Values aThis

@Override

visit (lateralSubSelect)

LateralSubSelect lateralSubSelect

@Override

visit (tableStatement)

TableStatement tableStatement

UpdateDeParser

extends: AbstractDeParser implements: OrderByVisitor

UpdateDeParser ()

UpdateDeParser (expressionVisitor, buffer)

ExpressionVisitor expressionVisitor

StringBuilder buffer

@Override,| @SuppressWarnings

deParse (update)

Update update

getExpressionVisitor () → ExpressionVisitor

returns ExpressionVisitor

setExpressionVisitor (visitor)

ExpressionVisitor visitor

@Override

visit (orderBy)

OrderByElement orderBy

UpsertDeParser

extends: AbstractDeParser

UpsertDeParser (expressionVisitor, selectVisitor, buffer)

ExpressionDeParser expressionVisitor

SelectDeParser selectVisitor

StringBuilder buffer

@Override,| @SuppressWarnings

deParse (upsert)

Upsert upsert

getExpressionVisitor () → ExpressionVisitor

returns ExpressionVisitor

getSelectVisitor () → SelectVisitor

returns SelectVisitor

setExpressionVisitor (visitor)

ExpressionDeParser visitor

setSelectVisitor (visitor)

SelectDeParser visitor

UseStatementDeParser

extends: AbstractDeParser

UseStatementDeParser (buffer)

StringBuilder buffer

@Override

deParse (set)

UseStatement set

ValuesStatementDeParser

extends: AbstractDeParser

ValuesStatementDeParser (expressionVisitor, buffer)

ExpressionVisitor expressionVisitor

StringBuilder buffer

@Override

deParse (values)

Values values

util.validation

ParseException

extends: ValidationException

wraps a JSQLParserException to add to the errors collected by validation

ParseException (message, cause)

String message

Throwable cause

ParseException (message)

String message

ParseException (cause)

Throwable cause

UnexpectedValidationException

extends: ValidationException

can be used on unexpected errors during validation

UnexpectedValidationException (message, cause)

String message

Throwable cause

UnexpectedValidationException (message)

String message

UnexpectedValidationException (cause)

Throwable cause

Validation

extends: Object

Parses the given statement list with ParseCapability and performs validation with configured ValidationCapability’s. Errors are are reported by calling #validate().

Validation (capabilities, statements)

Collection capabilities

String statements

Validation (featureConfiguration, capabilities, statements)

FeatureConfiguration featureConfiguration

Collection capabilities

String statements

validate () → List

returns List | the errors - may be an empty list.

getFeatureConfiguration () → FeatureConfiguration

returns FeatureConfiguration

getCapabilities () → Collection

returns Collection

getStatements () → List

returns List

getErrors () → List

returns List

getParsedStatements () → Statements

returns Statements

validate (capabilities, statements) → List

Collection capabilities

String statements

returns List | a list of ValidationError’s

createValidationContext (config, capabilities) → ValidationContext

FeatureConfiguration config

Collection capabilities

returns ValidationContext | a ValidationContext of the given config and capabilities

toValidationErrors (statements, parsedStatement, errorMap) → List

String statements

Statement parsedStatement

Map errorMap

returns List | a list of ValidationError’

validate (statement, context) → Map

Statement statement

ValidationContext context

returns Map | a map mapping the ValidationCapability to a set of `ValidationException`s

ValidationContext

extends: Object

ValidationContext ()

put (key, value) → ValidationContext

ContextKey key

Object value

returns ValidationContext

get (key, part) → T

ContextKey key

Class part

returns T

getOptional (key, part) → T

ContextKey key

Class part

returns T

reinit (reInit) → ValidationContext

boolean reInit

returns ValidationContext

setConfiguration (configuration) → ValidationContext

FeatureConfiguration configuration

returns ValidationContext

getConfiguration () → FeatureConfiguration

returns FeatureConfiguration

getAsBoolean (f) → boolean

Feature f

returns boolean

getAsString (f) → String

Feature f

returns String

getCapabilities () → Collection

returns Collection

setCapabilities (capabilities) → ValidationContext

Collection capabilities

returns ValidationContext

ValidationError

extends: Object

ValidationError (statements)

String statements

addError (error) → ValidationError

ValidationException error

returns ValidationError

addErrors (errors) → ValidationError

Collection errors

returns ValidationError

getErrors () → Set

returns Set | the set of ValidationException’s (no duplicates)

getCapability () → ValidationCapability

returns ValidationCapability | the ValidationCapability which produced this error

getParsedStatement () → Statement

returns Statement | the parsed Statement, if parsing was possible

getStatements () → String

returns String | the statements (may be more than one) given for validation

setCapability (databaseType)

ValidationCapability databaseType

setParsedStatement (parsedStatement)

Statement parsedStatement

withCapability (databaseType) → ValidationError

ValidationCapability databaseType

returns ValidationError

withParsedStatement (parsedStatement) → ValidationError

Statement parsedStatement

returns ValidationError

@Override

toString () → String

returns String

ValidationException

extends: RuntimeException provides: DatabaseException, ParseException, UnexpectedValidationException

ValidationException (message, cause)

String message

Throwable cause

ValidationException (message)

String message

ValidationException (cause)

Throwable cause

@Override

equals (o) → boolean

Object o

returns boolean

@Override

hashCode () → int

returns int

@Override

toString () → String

returns String

ValidationUtil

extends: Object

map (list, fn) → List

List list

Function fn

returns List

getAlias (alias) → String

Alias alias

returns String

ContextKey

provides: AllowedTypesContext, FeatureContext, MetadataContext,

the context key - a ValidationCapability should define constants of expected context - values needed for validation.

ValidationCapability

provides: AllowedTypesValidation, DatabaseMetaDataValidation, FeatureSetValidation,

getName () → String

returns String | a name of this ValidationCapability

validate (context, errorConsumer)

Validate and add ValidationException’s to given consumer.

ValidationContext context

Consumer errorConsumer

toError (message) → ValidationException

String message

returns ValidationException

toError (message, th) → ValidationException

String message

Throwable th

returns ValidationException

Validator

provides: AbstractValidator,

isValid () → boolean

returns boolean | true, all ValidationCapability’s have no errors

isValid (capabilities) → boolean

ValidationCapability capabilities

returns boolean | true, if the given ValidationCapability’s have no errors. false otherwise.

getValidationErrors () → Map

returns Map | the ValidationCapability’s requested mapped to a set of error-messages

getValidationErrors (capabilities) → Map

ValidationCapability capabilities

returns Map | the filtered view of requested ValidationCapability’s mapped to a set of error-messages

getValidationErrors (capabilities) → Map

Collection capabilities

returns Map | the filtered view of requested ValidationCapability’s mapped to a set of error-messages

setContext (ctx)

ValidationContext ctx

validate (statement)

validates given statement.

S statement

util.validation.allowedtypes

AllowedTypesContext

[allowed_types, argument, allow_null]

AllowedTypesValidation

extends: Object implements: ValidationCapability

AllowedTypesValidation ()

@Override

validate (context, errorConsumer)

ValidationContext context

Consumer errorConsumer

@Override

getName () → String

returns String

util.validation.feature

DatabaseType

[ANSI_SQL, ORACLE, MYSQL, SQLSERVER, MARIADB, POSTGRESQL, H2]

The DatabaseType is named like the identifier used within the jdbc-connection-url (upper case), this may change in future, therefore use #get(String) to retrieve the DatabaseType.

FeatureContext

[feature]

H2Version

[V_1_4_200]

Please add Features supported and place a link to public documentation

MariaDbVersion

[V10_5_4, ORACLE_MODE]

Please add Features supported and place a link to public documentation

MySqlVersion

[V8_0]

Please add Features supported and place a link to public documentation

OracleVersion

[V19C]

Please add Features supported and place a link to public documentation

PostgresqlVersion

[V10, V11, V12, V13, V14]

Please add Features supported and place a link to public documentation

SQLVersion

[SQL1986, SQL1989, SQL1992, SQL1999, SQL2003, SQL2006, SQL2008, SQL2011, SQL2016, SQL2019]

Enum containing the ANSI SQL Standard Versions - features are not guaranteed to be complete, just add them if you are sure they are part of the standard :)

SqlServerVersion

[V2019]

Please add Features supported and place a link to public documentation

FeaturesAllowed

extends: Object implements: FeatureSetValidation, ModifyableFeatureSet

Privileges/Features allowed

FeaturesAllowed (features)

Feature features

FeaturesAllowed (name, features)

String name

Feature features

@Override

add (featureSets) → FeaturesAllowed

FeatureSet featureSets

returns FeaturesAllowed | this

@Override

add (features) → FeaturesAllowed

Feature features

returns FeaturesAllowed | this

@Override

add (features) → FeaturesAllowed

Collection features

returns FeaturesAllowed | this

@Override

remove (featureSets) → FeaturesAllowed

FeatureSet featureSets

returns FeaturesAllowed | this

@Override

remove (features) → FeaturesAllowed

Feature features

returns FeaturesAllowed | this

@Override

remove (features) → FeaturesAllowed

Collection features

returns FeaturesAllowed | this

@Override

copy () → FeaturesAllowed

returns FeaturesAllowed | returns a modifiable copy of this FeaturesAllowed object

@Override

unmodifyable () → FeaturesAllowed

makes the inner Feature-set unmodifiable

returns FeaturesAllowed | this

@Override

getMessage (feature) → ValidationException

Feature feature

returns ValidationException | featureName + " not allowed."

@Override

getName () → String

returns String

@Override

getFeatures () → Set

returns Set

FeatureSetValidation

implements: ValidationCapability, FeatureSet provides: DatabaseType, FeaturesAllowed, Version,

@Override

validate (context, errorConsumer)

ValidationContext context

Consumer errorConsumer

@Override

getFeatures () → Set

returns Set | all supported Feature’s

getMessage (feature) → ValidationException

Feature feature

returns ValidationException | the default message if not contained in the feature set

@Override

getName () → String

returns String

Version

implements: FeatureSetValidation provides: DatabaseType, H2Version, MariaDbVersion, MySqlVersion, OracleVersion, PostgresqlVersion, SQLVersion, SqlServerVersion,

getVersionString () → String

returns String | the version string

@Override

getMessage (feature) → ValidationException

Feature feature

returns ValidationException | featureName + " not supported."

util.validation.metadata

MetadataContext

[named, exists]

NamedObject

[database, jdbcSchema, jdbcTable, view, jdbcColumn, jdbcIndex, constraint, uniqueConstraint, sequence, synonym, procedure, user, role, trigger, alias]

NamesLookup

[UPPERCASE, LOWERCASE, NO_TRANSFORMATION]

A strategy for transformation of database-names before lookup in database-jdbcCatalog-metadata

AbstractDatabaseMetaDataCapability

extends: Object implements: DatabaseMetaDataValidation provides: JdbcDatabaseMetaDataCapability

Adapter class always throwing UnsupportedOperationException for all exists - methods.

AbstractDatabaseMetaDataCapability (connection, namesLookup)

With caching enabled - see #isCacheResults()

Connection connection

UnaryOperator namesLookup | namesLookup - see NamesLookup

AbstractDatabaseMetaDataCapability (connection, namesLookup, cacheResults)

Connection connection

UnaryOperator namesLookup | namesLookup - see NamesLookup

boolean cacheResults | cacheResults - whether the results should be cached for later lookups

getNamesLookup () → UnaryOperator

returns UnaryOperator

getConnection () → Connection

returns Connection

isCacheResults () → boolean

returns boolean

clearCache () → AbstractDatabaseMetaDataCapability

returns AbstractDatabaseMetaDataCapability

@Override,| @SuppressWarnings

exists (named) → boolean

Named named

returns boolean

Named named

BiPredicate fn

returns boolean

Map results

Named name

returns boolean

Map results

Named name

returns boolean

Map results

Named name

returns boolean

Map results

Named name

returns boolean

Map results

Named name

returns boolean

Map results

Named name

returns boolean

Map results

Named name

returns boolean

Map results

Named name

returns boolean

Map results

Named name

returns boolean

Map results

Named name

returns boolean

Named name

returns UnsupportedOperationException

DatabaseException

extends: ValidationException

database-errors wrapping a SQLException or PersistenceException

DatabaseException (message, cause)

String message

Throwable cause

DatabaseException (message)

String message

DatabaseException (cause)

Throwable cause

JdbcDatabaseMetaDataCapability

extends: AbstractDatabaseMetaDataCapability

Validates against jdbcSchema by jdbc-metadata in a very basic way with simple caching and comparing names by String#equalsIgnoreCase(String)

JdbcDatabaseMetaDataCapability (connection, namesLookup)

Connection connection

UnaryOperator namesLookup | namesLookup - see NamesLookup

JdbcDatabaseMetaDataCapability (connection, namesLookup, cacheResults)

Connection connection

UnaryOperator namesLookup | namesLookup - see NamesLookup

boolean cacheResults | cacheResults - whether the results should be cached for later lookups

Map results

Named named

returns boolean

PMD.CyclomaticComplexity

Map results

Named named

returns boolean

Map results

Named named

returns boolean

Named named

String part

returns boolean

PMD.CyclomaticComplexity

Named

extends: Object

Named (namedObject, fqn)

NamedObject namedObject

String fqn

getFqn () → String

returns String

getAlias () → String

returns String

setAlias (alias) → Named

String alias

returns Named

getNamedObject () → NamedObject

returns NamedObject

getParents () → List

returns List

setParents (parents) → Named

List parents

returns Named

setFqnLookup (fqnLookup) → Named

String fqnLookup

returns Named

setAliasLookup (aliasLookup) → Named

String aliasLookup

returns Named

getFqnLookup () → String

returns String | the fqn transformed for jdbcCatalog-lookup (uppercase/lowercase/.. depends on database)

getAliasLookup () → String

returns String | the alias transformed for jdbcCatalog-lookup (uppercase/lowercase/.. depends on database)

@Override

hashCode () → int

returns int

@Override

equals (obj) → boolean

Object obj

returns boolean

@Override

toString () → String

returns String

DatabaseMetaDataValidation

implements: ValidationCapability provides: AbstractDatabaseMetaDataCapability,

@Override

validate (context, errorConsumer)

ValidationContext context

Consumer errorConsumer

exists (named) → boolean

Named named

returns boolean | true, if the object exists, false otherwise.

getErrorMessage (named, checkForExists) → ValidationException

Named named

boolean checkForExists

returns ValidationException | a new ValidationException

getUnexpectedErrorMessage (named, cause) → ValidationException

Named named

Exception cause

returns ValidationException | a new ValidationException

@Override

getName () → String

returns String

util.validation.validator

AbstractValidator

extends: Object implements: Validator provides: AlterSequenceValidator, AlterSessionValidator, AlterValidator, AlterViewValidator, AnalyzeValidator, CreateIndexValidator, CreateSequenceValidator, CreateSynonymValidator, CreateTableValidator, CreateViewValidator, DeclareStatementValidator, DeleteValidator, DropValidator, ExecuteValidator, ExpressionValidator, GrantValidator, GroupByValidator, InsertValidator, LimitValidator, MergeValidator, OrderByValidator, RefreshMaterializedViewStatementValidator, ResetStatementValidator, SelectValidator, SetStatementValidator, ShowColumnsStatementValidator, ShowIndexStatementValidator, ShowStatementValidator, ShowTablesStatementValidator, StatementValidator, TableStatementValidator, UpdateValidator, UpsertValidator, UseStatementValidator, ValuesStatementValidator

A abstract base for a Validation

AbstractValidator ()

getValidator (part) → T

Class part

returns T

ValidationCapability c

returns Consumer

returns ValidationContext

boolean reInit

returns ValidationContext

adds an error for this {@link ValidationCapability}

ValidationCapability capability

ValidationException error

returns void

@Override

getValidationErrors () → Map

returns Map

getCapabilities () → Collection

returns Collection

@Override

setContext (context)

ValidationContext context

E element

Consumer elementConsumer

returns void

List elementList

Supplier validatorSupplier

BiConsumer elementConsumer

returns void

Expression expression

returns void

Expression expression

ExpressionValidator v

returns void

List expressions

returns void

FromItem fromItems

returns void

List fromItems

returns void

List orderByElements

returns void

FromItem fromItem

returns void

FromItem fromItem

SelectValidator v

returns void

Iterates through all {@link ValidationCapability} and validates the feature with

{@link #validateFeature(ValidationCapability, Feature)}

Feature feature

returns void

Iterates through all {@link ValidationCapability} and validates

<ul> <li>the name with {@link #validateName(ValidationCapability, NamedObject, String)}</li> <li>the feature with {@link #validateFeature(ValidationCapability, Feature)}</li> </ul>

Feature feature

NamedObject namedObject

String fqn | fqn - fully qualified name of named object

returns void

Iterates through all {@link ValidationCapability} and validates

<ul> <li>the name with {@link #validateName(ValidationCapability, NamedObject, String)}</li> <li>the feature with {@link #validateFeature(ValidationCapability, Feature)}</li> </ul>

Feature feature

NamedObject namedObject

String fqn | fqn - fully qualified name of named object

String alias

returns void

Iterates through all {@link ValidationCapability} and validates for the name with

{@link #validateName(ValidationCapability, NamedObject, String)}

NamedObject namedObject

String fqn | fqn - fully qualified name of named object

returns void

Iterates through all {@link ValidationCapability} and validates for the name with

{@link #validateName(ValidationCapability, NamedObject, String)}

NamedObject namedObject

String fqn | fqn - fully qualified name of named object

String alias

returns void

Validates the feature if given {@link ValidationCapability} is a {@link FeatureSetValidation}

and condition is <code>true</code>

ValidationCapability capability

boolean condition

Feature feature

returns void

validates for the feature if given elements is not empty - see

{@link #isNotEmpty(Collection)}

ValidationCapability capability

List elements

Feature feature

returns void

Validates for the feature if given element is not <code>null</code>

ValidationCapability capability

Object element

Feature feature

returns void

Validates if given {@link ValidationCapability} is a {@link FeatureSetValidation}

ValidationCapability capability

Feature feature

returns void

Validates if given {@link ValidationCapability} is a {@link DatabaseMetaDataValidation}

ValidationCapability capability

NamedObject namedObject

String fqn | fqn - fully qualified name of named object

String alias

returns void

ValidationCapability capability

NamedObject namedObject

String fqn | fqn - fully qualified name of named object

returns void

Validates if given {@link ValidationCapability} is a {@link DatabaseMetaDataValidation}

ValidationCapability capability

NamedObject namedObject

String fqn | fqn - fully qualified name of named object

String alias

boolean exists | exists - true, check for existence, false, check for non-existence

NamedObject parents

returns void

ValidationCapability capability

NamedObject namedObject

String fqn | fqn - fully qualified name of named object

boolean exists

NamedObject parents

returns void

ValidationCapability capability

String name

returns void

ValidationCapability capability

String name

String alias

returns void

ValidationCapability capability

List columnNames

NamedObject parents

returns void

ValidationCapability capability

List columnNames

boolean exists

NamedObject parents

returns void

ValidationCapability capability

NamedObject namedObject

String name

String alias

NamedObject parents

returns void

ValidationCapability capability

NamedObject namedObject

String name

NamedObject parents

returns void

ValidationCapability capability

NamedObject namedObject

String name

String alias

boolean exists

NamedObject parents

returns void

Collection c

returns boolean

String c

returns boolean

AlterSequenceValidator

extends: AbstractValidator

AlterSequenceValidator ()

@Override

validate (statement)

AlterSequence statement

AlterSessionValidator

extends: AbstractValidator

AlterSessionValidator ()

@Override

validate (statement)

AlterSession statement

AlterValidator

extends: AbstractValidator

AlterValidator ()

@Override

validate (alter)

Alter alter

validate (alter, e)

Alter alter

AlterExpression e

AlterViewValidator

extends: AbstractValidator

AlterViewValidator ()

@Override

validate (alterView)

AlterView alterView

AnalyzeValidator

extends: AbstractValidator

AnalyzeValidator ()

@Override

validate (analyze)

Analyze analyze

CreateIndexValidator

extends: AbstractValidator

CreateIndexValidator ()

@Override

validate (createIndex)

CreateIndex createIndex

CreateSequenceValidator

extends: AbstractValidator

CreateSequenceValidator ()

@Override

validate (statement)

CreateSequence statement

CreateSynonymValidator

extends: AbstractValidator

CreateSynonymValidator ()

@Override

validate (statement)

CreateSynonym statement

CreateTableValidator

extends: AbstractValidator

CreateTableValidator ()

@Override

validate (createTable)

CreateTable createTable

CreateViewValidator

extends: AbstractValidator

CreateViewValidator ()

@Override

validate (createView)

CreateView createView

DeclareStatementValidator

extends: AbstractValidator

DeclareStatementValidator ()

@Override

validate (declare)

DeclareStatement declare

DeleteValidator

extends: AbstractValidator

DeleteValidator ()

@Override

validate (delete)

Delete delete

DropValidator

extends: AbstractValidator

DropValidator ()

@Override

validate (drop)

Drop drop

ExecuteValidator

extends: AbstractValidator

ExecuteValidator ()

@Override

validate (execute)

Execute execute

ExpressionValidator

extends: AbstractValidator implements: ExpressionVisitor

ExpressionValidator ()

@Override

visit (addition)

Addition addition

@Override

visit (andExpression)

AndExpression andExpression

@Override

visit (between)

Between between

@Override

visit (overlapsCondition)

OverlapsCondition overlapsCondition

@Override

visit (equalsTo)

EqualsTo equalsTo

@Override

visit (division)

Division division

@Override

visit (division)

IntegerDivision division

@Override

visit (doubleValue)

DoubleValue doubleValue

@Override

visit (hexValue)

HexValue hexValue

@Override

visit (notExpr)

NotExpression notExpr

@Override

visit (expr)

BitwiseRightShift expr

@Override

visit (expr)

BitwiseLeftShift expr

visitOldOracleJoinBinaryExpression (expression, operator)

OldOracleJoinBinaryExpression expression

String operator

@Override

visit (greaterThan)

GreaterThan greaterThan

@Override

visit (greaterThanEquals)

GreaterThanEquals greaterThanEquals

@Override

visit (inExpression)

InExpression inExpression

@Override

visit (fullTextSearch)

FullTextSearch fullTextSearch

@Override

visit (signedExpression)

SignedExpression signedExpression

@Override

visit (isNullExpression)

IsNullExpression isNullExpression

@Override

visit (isBooleanExpression)

IsBooleanExpression isBooleanExpression

@Override

visit (jdbcParameter)

JdbcParameter jdbcParameter

@Override

visit (likeExpression)

LikeExpression likeExpression

@Override

visit (existsExpression)

ExistsExpression existsExpression

@Override

visit (memberOfExpression)

MemberOfExpression memberOfExpression

@Override

visit (longValue)

LongValue longValue

@Override

visit (minorThan)

MinorThan minorThan

@Override

visit (minorThanEquals)

MinorThanEquals minorThanEquals

@Override

visit (multiplication)

Multiplication multiplication

@Override

visit (notEqualsTo)

NotEqualsTo notEqualsTo

@Override

visit (doubleAnd)

DoubleAnd doubleAnd

@Override

visit (contains)

Contains contains

@Override

visit (containedBy)

ContainedBy containedBy

@Override

visit (nullValue)

NullValue nullValue

@Override

visit (orExpression)

OrExpression orExpression

@Override

visit (xorExpression)

XorExpression xorExpression

@Override

visit (parenthesis)

Parenthesis parenthesis

@Override

visit (stringValue)

StringValue stringValue

@Override

visit (subtraction)

Subtraction subtraction

BinaryExpression binaryExpression

String operator

returns void

@Override

visit (selectBody)

ParenthesedSelect selectBody

@Override

visit (tableColumn)

Column tableColumn

@Override

visit (function)

Function function

@Override

visit (dateValue)

DateValue dateValue

@Override

visit (timestampValue)

TimestampValue timestampValue

@Override

visit (timeValue)

TimeValue timeValue

@Override

visit (caseExpression)

CaseExpression caseExpression

@Override

visit (whenClause)

WhenClause whenClause

@Override

visit (anyComparisonExpression)

AnyComparisonExpression anyComparisonExpression

@Override

visit (concat)

Concat concat

@Override

visit (matches)

Matches matches

@Override

visit (bitwiseAnd)

BitwiseAnd bitwiseAnd

@Override

visit (bitwiseOr)

BitwiseOr bitwiseOr

@Override

visit (bitwiseXor)

BitwiseXor bitwiseXor

@Override

visit (cast)

CastExpression cast

@Override

visit (modulo)

Modulo modulo

@Override

visit (aexpr)

AnalyticExpression aexpr

@Override

visit (eexpr)

ExtractExpression eexpr

@Override

visit (iexpr)

IntervalExpression iexpr

@Override

visit (jdbcNamedParameter)

JdbcNamedParameter jdbcNamedParameter

@Override

visit (oexpr)

OracleHierarchicalExpression oexpr

@Override

visit (rexpr)

RegExpMatchOperator rexpr

@Override

visit (jsonExpr)

JsonExpression jsonExpr

@Override

visit (jsonExpr)

JsonOperator jsonExpr

@Override

visit (var)

UserVariable var

@Override

visit (bind)

NumericBind bind

@Override

visit (aexpr)

KeepExpression aexpr

@Override

visit (groupConcat)

MySQLGroupConcat groupConcat

@Override

visit (expressionList)

ExpressionList expressionList

@Override

visit (rowConstructor)

RowConstructor rowConstructor

@Override

visit (rowGetExpression)

RowGetExpression rowGetExpression

@Override

visit (hint)

OracleHint hint

@Override

visit (timeKeyExpression)

TimeKeyExpression timeKeyExpression

@Override

visit (literal)

DateTimeLiteralExpression literal

@Override

visit (nextVal)

NextValExpression nextVal

@Override

visit (col)

CollateExpression col

@Override

visit (expr)

SimilarToExpression expr

@Override

visit (array)

ArrayExpression array

@Override

visit (aThis)

ArrayConstructor aThis

@Override

validate (expression)

Expression expression

@Override

visit (a)

VariableAssignment a

@Override

visit (a)

TimezoneExpression a

@Override

visit (xml)

XMLSerializeExpr xml

@Override

visit (expression)

JsonAggregateFunction expression

@Override

visit (expression)

JsonFunction expression

@Override

visit (connectByRootOperator)

ConnectByRootOperator connectByRootOperator

@Override

visit (oracleNamedFunctionParameter)

OracleNamedFunctionParameter oracleNamedFunctionParameter

@Override

visit (allColumns)

AllColumns allColumns

@Override

visit (allTableColumns)

AllTableColumns allTableColumns

@Override

visit (allValue)

AllValue allValue

@Override

visit (isDistinctExpression)

IsDistinctExpression isDistinctExpression

@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

GrantValidator

extends: AbstractValidator

GrantValidator ()

@Override

validate (grant)

Grant grant

GroupByValidator

extends: AbstractValidator implements: GroupByVisitor

GroupByValidator ()

@Override

validate (groupBy)

GroupByElement groupBy

@Override

visit (groupBy)

GroupByElement groupBy

InsertValidator

extends: AbstractValidator

InsertValidator ()

@Override

validate (insert)

Insert insert

LimitValidator

extends: AbstractValidator

LimitValidator ()

@Override

validate (limit)

Limit limit

MergeValidator

extends: AbstractValidator implements: MergeOperationVisitor

MergeValidator ()

@Override

validate (merge)

Merge merge

@Override

visit (mergeDelete)

MergeDelete mergeDelete

@Override

visit (mergeUpdate)

MergeUpdate mergeUpdate

@Override

visit (mergeInsert)

MergeInsert mergeInsert

OrderByValidator

extends: AbstractValidator implements: OrderByVisitor

OrderByValidator ()

@Override

validate (element)

OrderByElement element

@Override

visit (orderBy)

OrderByElement orderBy

RefreshMaterializedViewStatementValidator

extends: AbstractValidator

RefreshMaterializedViewStatementValidator ()

@Override

validate (viewStatement)

RefreshMaterializedViewStatement viewStatement

ReplaceValidator

extends: UpsertValidator

ReplaceValidator ()

ResetStatementValidator

extends: AbstractValidator

ResetStatementValidator ()

@Override

validate (reset)

ResetStatement reset

SelectValidator

extends: AbstractValidator implements: SelectVisitor, SelectItemVisitor, FromItemVisitor, PivotVisitor

SelectValidator ()

@SuppressWarnings,| @Override

visit (plainSelect)

PlainSelect plainSelect

@Override

visit (selectExpressionItem)

SelectItem selectExpressionItem

@Override

visit (selectBody)

ParenthesedSelect selectBody

@Override

visit (jdbcTable)

Table jdbcTable

@Override

visit (pivot)

Pivot pivot

@Override

visit (unpivot)

UnPivot unpivot

@Override

visit (pivot)

PivotXml pivot

validateOffset (offset)

Offset offset

validateFetch (fetch)

Fetch fetch

validateOptionalJoins (joins)

List joins

validateOptionalJoin (join)

Join join

@Override

visit (setOperation)

SetOperationList setOperation

@Override

visit (withItem)

WithItem withItem

@Override

visit (lateralSubSelect)

LateralSubSelect lateralSubSelect

@Override

visit (tableStatement)

TableStatement tableStatement

@Override

visit (tableFunction)

TableFunction tableFunction

@Override

visit (parenthesis)

ParenthesedFromItem parenthesis

@Override

visit (values)

Values values

@Override

validate (statement)

SelectItem statement

SetStatementValidator

extends: AbstractValidator

SetStatementValidator ()

@Override

validate (set)

SetStatement set

ShowColumnsStatementValidator

extends: AbstractValidator

ShowColumnsStatementValidator ()

@Override

validate (show)

ShowColumnsStatement show

ShowIndexStatementValidator

extends: AbstractValidator

ShowIndexStatementValidator ()

@Override

validate (show)

ShowIndexStatement show

ShowStatementValidator

extends: AbstractValidator

ShowStatementValidator ()

@Override

validate (show)

ShowStatement show

ShowTablesStatementValidator

extends: AbstractValidator

ShowTablesStatementValidator ()

@Override

validate (show)

ShowTablesStatement show

StatementValidator

extends: AbstractValidator implements: StatementVisitor

StatementValidator ()

@Override

visit (createIndex)

CreateIndex createIndex

@Override

visit (createTable)

CreateTable createTable

@Override

visit (createView)

CreateView createView

@Override

visit (alterView)

AlterView alterView

@Override

visit (materializedView)

RefreshMaterializedViewStatement materializedView

@Override

visit (delete)

Delete delete

@Override

visit (drop)

Drop drop

@Override

visit (insert)

Insert insert

@Override

visit (select)

Select select

@Override

visit (truncate)

Truncate truncate

@Override

visit (update)

Update update

@Override

visit (alter)

Alter alter

@Override

visit (stmts)

Statements stmts

@Override

visit (execute)

Execute execute

@Override

visit (set)

SetStatement set

@Override

visit (reset)

ResetStatement reset

@Override

visit (merge)

Merge merge

@Override

visit (commit)

Commit commit

@Override

visit (upsert)

Upsert upsert

@Override

visit (use)

UseStatement use

@Override

visit (show)

ShowStatement show

@Override

visit (show)

ShowColumnsStatement show

@Override

visit (show)

ShowIndexStatement show

@Override

visit (showTables)

ShowTablesStatement showTables

@Override

visit (block)

Block block

@Override

visit (comment)

Comment comment

@Override

visit (describe)

DescribeStatement describe

@Override

visit (explain)

ExplainStatement explain

@Override

visit (declare)

DeclareStatement declare

@Override

visit (grant)

Grant grant

@Override

visit (aThis)

CreateSchema aThis

@Override

visit (createSequence)

CreateSequence createSequence

@Override

visit (alterSequence)

AlterSequence alterSequence

@Override

visit (createFunctionalStatement)

CreateFunctionalStatement createFunctionalStatement

@Override

validate (statement)

Statement statement

@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

visit (renameTableStatement)

RenameTableStatement renameTableStatement

@Override

visit (purgeStatement)

PurgeStatement purgeStatement

@Override

visit (alterSystemStatement)

AlterSystemStatement alterSystemStatement

@Override

visit (unsupportedStatement)

UnsupportedStatement unsupportedStatement

TableStatementValidator

extends: AbstractValidator

TableStatementValidator ()

@Override

validate (statement)

TableStatement statement

UpdateValidator

extends: AbstractValidator

UpdateValidator ()

@Override

validate (update)

Update update

UpsertValidator

extends: AbstractValidator provides: ReplaceValidator

UpsertValidator ()

@Override

validate (upsert)

Upsert upsert

UseStatementValidator

extends: AbstractValidator

UseStatementValidator ()

@Override

validate (set)

UseStatement set

ValuesStatementValidator

extends: AbstractValidator

ValuesStatementValidator ()

@Override

validate (values)

Values values