Module net.sf.jsqlparser

Package net.sf.jsqlparser.util

Class TablesNamesFinder<Void>

java.lang.Object

net.sf.jsqlparser.util.TablesNamesFinder<Void>

All Implemented Interfaces:

ExpressionVisitor<Void>, FromItemVisitor<Void>, SelectItemVisitor<Void>, SelectVisitor<Void>, StatementVisitor<Void>

public class TablesNamesFinder<Void>
extends Object
implements SelectVisitor<Void>, FromItemVisitor<Void>, ExpressionVisitor<Void>, SelectItemVisitor<Void>, StatementVisitor<Void>

Find all used tables within an select statement.

Override extractTableName method to modify the extracted table names (e.g. without schema).

Constructor Summary

Constructors

Constructor	Description
TablesNamesFinder()

Method Summary

Modifier and Type	Method	Description
protected String	extractTableName(Table table)	Override to adapt the tableName generation (e.g. with / without schema).
static Set<String>	findTables(String sqlStr)
static Set<String>	findTablesInExpression(String exprStr)
static Set<String>	findTablesOrOtherSources(String sqlStr)
List<String>	getTableList(Expression expr)	Deprecated.
List<String>	getTableList(Statement statement)	Deprecated.
Set<String>	getTables(Expression expr)
Set<String>	getTables(Statement statement)
Set<String>	getTablesOrOtherSources(Statement statement)
protected void	init(boolean allowColumnProcessing)	Initializes table names collector.
<S> Void	visit(AllValue allValue, S context)
<S> Void	visit(AnalyticExpression analytic, S context)
<S> Void	visit(AnyComparisonExpression anyComparisonExpression, S context)
<S> Void	visit(ArrayConstructor array, S context)
<S> Void	visit(ArrayExpression array, S context)
<S> Void	visit(BooleanValue booleanValue, S context)
<S> Void	visit(CaseExpression caseExpression, S context)
<S> Void	visit(CastExpression cast, S context)
<S> Void	visit(CollateExpression collateExpression, S context)
<S> Void	visit(ConnectByPriorOperator connectByPriorOperator, S context)
<S> Void	visit(ConnectByRootOperator connectByRootOperator, S context)
<S> Void	visit(DateTimeLiteralExpression literal, S context)
<S> Void	visit(DateValue dateValue, S context)
<S> Void	visit(DoubleValue doubleValue, S context)
<S> Void	visit(ExtractExpression eexpr, S context)
<S> Void	visit(Function function, S context)
<S> Void	visit(HexValue hexValue, S context)
<S> Void	visit(HighExpression highExpression, S context)
<S> Void	visit(IntervalExpression intervalExpression, S context)
<S> Void	visit(Inverse inverse, S context)
<S> Void	visit(JdbcNamedParameter jdbcNamedParameter, S context)
<S> Void	visit(JdbcParameter jdbcParameter, S context)
<S> Void	visit(JsonAggregateFunction expression, S context)
<S> Void	visit(JsonExpression jsonExpr, S context)
<S> Void	visit(JsonFunction expression, S context)
<S> Void	visit(KeepExpression keepExpression, S context)
<S> Void	visit(LambdaExpression lambdaExpression, S context)
<S> Void	visit(LongValue longValue, S context)
<S> Void	visit(LowExpression lowExpression, S context)
<S> Void	visit(MySQLGroupConcat groupConcat, S context)
<S> Void	visit(NextValExpression nextVal, S context)
<S> Void	visit(NotExpression notExpr, S context)
<S> Void	visit(NullValue nullValue, S context)
<S> Void	visit(NumericBind numericBind, S context)
<S> Void	visit(Addition addition, S context)
<S> Void	visit(BitwiseAnd bitwiseAnd, S context)
<S> Void	visit(BitwiseLeftShift expr, S context)
<S> Void	visit(BitwiseOr bitwiseOr, S context)
<S> Void	visit(BitwiseRightShift expr, S context)
<S> Void	visit(BitwiseXor bitwiseXor, S context)
<S> Void	visit(Concat concat, S context)
<S> Void	visit(Division division, S context)
<S> Void	visit(IntegerDivision division, S context)
<S> Void	visit(Modulo modulo, S context)
<S> Void	visit(Multiplication multiplication, S context)
<S> Void	visit(Subtraction subtraction, S context)
<S> Void	visit(AndExpression andExpression, S context)
<S> Void	visit(OrExpression orExpression, S context)
<S> Void	visit(XorExpression xorExpression, S context)
<S> Void	visit(Between between, S context)
<S> Void	visit(ContainedBy containedBy, S context)
<S> Void	visit(Contains contains, S context)
<S> Void	visit(CosineSimilarity cosineSimilarity, S context)
<S> Void	visit(DoubleAnd doubleAnd, S context)
<S> Void	visit(EqualsTo equalsTo, S context)
<S> Void	visit(ExcludesExpression excludesExpression, S context)
<S> Void	visit(ExistsExpression existsExpression, S context)
<S> Void	visit(ExpressionList<?> expressionList, S context)
<S> Void	visit(FullTextSearch fullTextSearch, S context)
<S> Void	visit(GeometryDistance geometryDistance, S context)
<S> Void	visit(GreaterThanEquals greaterThanEquals, S context)
<S> Void	visit(GreaterThan greaterThan, S context)
<S> Void	visit(IncludesExpression includesExpression, S context)
<S> Void	visit(InExpression inExpression, S context)
<S> Void	visit(IsBooleanExpression isBooleanExpression, S context)
<S> Void	visit(IsDistinctExpression isDistinctExpression, S context)
<S> Void	visit(IsNullExpression isNullExpression, S context)
<S> Void	visit(IsUnknownExpression isUnknownExpression, S context)
<S> Void	visit(JsonOperator jsonExpr, S context)
<S> Void	visit(LikeExpression likeExpression, S context)
<S> Void	visit(Matches matches, S context)
<S> Void	visit(MemberOfExpression memberOfExpression, S context)
<S> Void	visit(MinorThanEquals minorThanEquals, S context)
<S> Void	visit(MinorThan minorThan, S context)
<S> Void	visit(NotEqualsTo notEqualsTo, S context)
<S> Void	visit(Plus plus, S context)
<S> Void	visit(PriorTo priorTo, S context)
<S> Void	visit(RegExpMatchOperator regExpMatchOperator, S context)
<S> Void	visit(SimilarToExpression expr, S context)
<S> Void	visit(TSQLLeftJoin tsqlLeftJoin, S context)
<S> Void	visit(TSQLRightJoin tsqlRightJoin, S context)
<S> Void	visit(OracleHierarchicalExpression hierarchicalExpression, S context)
<S> Void	visit(OracleHint hint, S context)
<S> Void	visit(OracleNamedFunctionParameter oracleNamedFunctionParameter, S context)
<S> Void	visit(OverlapsCondition overlapsCondition, S context)
<S> Void	visit(RangeExpression rangeExpression, S context)
<S> Void	visit(RowConstructor<?> rowConstructor, S context)
<S> Void	visit(RowGetExpression rowGetExpression, S context)
<S> Void	visit(SignedExpression signedExpression, S context)
<S> Void	visit(StringValue stringValue, S context)
<S> Void	visit(StructType structType, S context)
<S> Void	visit(TimeKeyExpression timeKeyExpression, S context)
<S> Void	visit(TimestampValue timestampValue, S context)
<S> Void	visit(TimeValue timeValue, S context)
<S> Void	visit(TimezoneExpression timezoneExpression, S context)
<S> Void	visit(TranscodingFunction transcodingFunction, S context)
<S> Void	visit(TrimFunction trimFunction, S context)
<S> Void	visit(UserVariable userVariable, S context)
<S> Void	visit(VariableAssignment variableAssignment, S context)
<S> Void	visit(WhenClause whenClause, S context)
<S> Void	visit(XMLSerializeExpr xmlSerializeExpr, S context)
<S> Void	visit(Column tableColumn, S context)
void	visit(Table tableName)
<S> Void	visit(Table table, S context)
void	visit(Alter alter)
<S> Void	visit(Alter alter, S context)
void	visit(AlterSession alterSession)
<S> Void	visit(AlterSession alterSession, S context)
void	visit(AlterSystemStatement alterSystemStatement)
<S> Void	visit(AlterSystemStatement alterSystemStatement, S context)
void	visit(RenameTableStatement renameTableStatement)
<S> Void	visit(RenameTableStatement renameTableStatement, S context)
void	visit(AlterSequence alterSequence)
<S> Void	visit(AlterSequence alterSequence, S context)
void	visit(Analyze analyze)
<S> Void	visit(Analyze analyze, S context)
void	visit(Block block)
<S> Void	visit(Block block, S context)
void	visit(Comment comment)
<S> Void	visit(Comment comment, S context)
void	visit(Commit commit)
<S> Void	visit(Commit commit, S context)
void	visit(CreateIndex createIndex)
<S> Void	visit(CreateIndex createIndex, S context)
void	visit(CreateSchema createSchema)
<S> Void	visit(CreateSchema createSchema, S context)
void	visit(CreateSequence createSequence)
<S> Void	visit(CreateSequence createSequence, S context)
void	visit(CreateSynonym createSynonym)
<S> Void	visit(CreateSynonym createSynonym, S context)
void	visit(CreateTable createTable)
<S> Void	visit(CreateTable create, S context)
void	visit(AlterView alterView)
<S> Void	visit(AlterView alterView, S context)
void	visit(CreateView createView)
<S> Void	visit(CreateView create, S context)
void	visit(CreateFunctionalStatement createFunctionalStatement)
<S> Void	visit(CreateFunctionalStatement createFunctionalStatement, S context)
void	visit(DeclareStatement declareStatement)
<S> Void	visit(DeclareStatement declareStatement, S context)
void	visit(Delete delete)
<S> Void	visit(Delete delete, S context)
<S> Void	visit(ParenthesedDelete delete, S context)
void	visit(DescribeStatement describe)
<S> Void	visit(DescribeStatement describe, S context)
void	visit(Drop drop)
<S> Void	visit(Drop drop, S context)
void	visit(Execute execute)
<S> Void	visit(Execute execute, S context)
void	visit(ExplainStatement explainStatement)
<S> Void	visit(ExplainStatement explainStatement, S context)
void	visit(Grant grant)
<S> Void	visit(Grant grant, S context)
void	visit(IfElseStatement ifElseStatement)
<S> Void	visit(IfElseStatement ifElseStatement, S context)
void	visit(Insert insert)
<S> Void	visit(Insert insert, S context)
<S> Void	visit(ParenthesedInsert insert, S context)
void	visit(Merge merge)
<S> Void	visit(Merge merge, S context)
<S> Void	visit(FromQuery fromQuery, S context)
void	visit(PurgeStatement purgeStatement)
<S> Void	visit(PurgeStatement purgeStatement, S context)
void	visit(RefreshMaterializedViewStatement materializedView)
<S> Void	visit(RefreshMaterializedViewStatement materializedView, S context)
void	visit(ResetStatement reset)
<S> Void	visit(ResetStatement reset, S context)
void	visit(RollbackStatement rollbackStatement)
<S> Void	visit(RollbackStatement rollbackStatement, S context)
void	visit(SavepointStatement savepointStatement)
<S> Void	visit(SavepointStatement savepointStatement, S context)
<S> Void	visit(AllColumns allColumns, S context)
<S> Void	visit(AllTableColumns allTableColumns, S context)
<S> Void	visit(FunctionAllColumns functionAllColumns, S context)
void	visit(LateralSubSelect lateralSubSelect)
<S> Void	visit(LateralSubSelect lateralSubSelect, S context)
void	visit(ParenthesedFromItem parenthesedFromItem)
<S> Void	visit(ParenthesedFromItem parenthesis, S context)
void	visit(ParenthesedSelect parenthesedSelect)
<S> Void	visit(ParenthesedSelect select, S context)
void	visit(PlainSelect plainSelect)
<S> Void	visit(PlainSelect plainSelect, S context)
void	visit(Select select)
<S> Void	visit(SelectItem<?> item, S context)
void	visit(SelectItem<? extends Expression> selectItem)
<S> Void	visit(Select select, S context)
void	visit(SetOperationList setOpList)
<S> Void	visit(SetOperationList list, S context)
void	visit(TableFunction tableFunction)
<S> Void	visit(TableFunction tableFunction, S context)
void	visit(TableStatement tableStatement)
<S> Void	visit(TableStatement tableStatement, S context)
void	visit(Values values)
<S> Void	visit(Values values, S context)
void	visit(WithItem<?> withItem)
<S> Void	visit(WithItem<?> withItem, S context)
void	visit(SetStatement set)
<S> Void	visit(SetStatement setStatement, S context)
void	visit(ShowIndexStatement showIndex)
<S> Void	visit(ShowIndexStatement showIndex, S context)
void	visit(ShowTablesStatement showTables)
<S> Void	visit(ShowTablesStatement showTables, S context)
void	visit(ShowColumnsStatement showColumns)
<S> Void	visit(ShowColumnsStatement showColumnsStatement, S context)
void	visit(ShowStatement showStatement)
<S> Void	visit(ShowStatement showStatement, S context)
void	visit(Statements statements)
<S> Void	visit(Statements statements, S context)
void	visit(Truncate truncate)
<S> Void	visit(Truncate truncate, S context)
void	visit(UnsupportedStatement unsupportedStatement)
<S> Void	visit(UnsupportedStatement unsupportedStatement, S context)
<S> Void	visit(ParenthesedUpdate update, S context)
void	visit(Update update)
<S> Void	visit(Update update, S context)
void	visit(Upsert upsert)
<S> Void	visit(Upsert upsert, S context)
void	visit(UseStatement use)
<S> Void	visit(UseStatement use, S context)
void	visitBinaryExpression(BinaryExpression binaryExpression)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface net.sf.jsqlparser.expression.ExpressionVisitor

visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit

Methods inherited from interface net.sf.jsqlparser.statement.StatementVisitor

visit, visit, visit

Constructor Detail

TablesNamesFinder

public TablesNamesFinder()

Method Detail

findTables

public static Set<String> findTables(String sqlStr)
                              throws JSQLParserException

Throws:

JSQLParserException

findTablesOrOtherSources

public static Set<String> findTablesOrOtherSources(String sqlStr)
                                            throws JSQLParserException

Throws:

JSQLParserException

findTablesInExpression

public static Set<String> findTablesInExpression(String exprStr)
                                          throws JSQLParserException

Throws:

JSQLParserException

getTableList

@Deprecated
public List<String> getTableList(Statement statement)

Deprecated.

getTables

public Set<String> getTables(Statement statement)

getTablesOrOtherSources

public Set<String> getTablesOrOtherSources(Statement statement)

visit

public <S> Void visit(Select select,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Select select)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(TranscodingFunction transcodingFunction,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(TrimFunction trimFunction,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(RangeExpression rangeExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

getTableList

@Deprecated
public List<String> getTableList(Expression expr)

Deprecated.

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

getTables

public Set<String> getTables(Expression expr)

visit

public <S> Void visit(WithItem<?> withItem,
                      S context)

Specified by:

visit in interface SelectVisitor<Void>

visit

public void visit(WithItem<?> withItem)

Specified by:

visit in interface SelectVisitor<Void>

visit

public <S> Void visit(ParenthesedSelect select,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

Specified by:

visit in interface FromItemVisitor<Void>

Specified by:

visit in interface SelectVisitor<Void>

visit

public void visit(ParenthesedSelect parenthesedSelect)

Specified by:

visit in interface FromItemVisitor<Void>

Specified by:

visit in interface SelectVisitor<Void>

visit

public <S> Void visit(PlainSelect plainSelect,
                      S context)

Specified by:

visit in interface FromItemVisitor<Void>

Specified by:

visit in interface SelectVisitor<Void>

visit

public void visit(PlainSelect plainSelect)

Specified by:

visit in interface FromItemVisitor<Void>

Specified by:

visit in interface SelectVisitor<Void>

extractTableName

protected String extractTableName(Table table)

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

Parameters:

table -

Returns:

visit

public <S> Void visit(Table table,
                      S context)

Specified by:

visit in interface FromItemVisitor<Void>

visit

public void visit(Table tableName)

Specified by:

visit in interface FromItemVisitor<Void>

visit

public <S> Void visit(Addition addition,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(AndExpression andExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Between between,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(OverlapsCondition overlapsCondition,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Column tableColumn,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Division division,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(IntegerDivision division,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(DoubleValue doubleValue,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(EqualsTo equalsTo,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Function function,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(GreaterThan greaterThan,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(GreaterThanEquals greaterThanEquals,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(InExpression inExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(IncludesExpression includesExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(ExcludesExpression excludesExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(FullTextSearch fullTextSearch,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(SignedExpression signedExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(IsNullExpression isNullExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(IsBooleanExpression isBooleanExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(IsUnknownExpression isUnknownExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(JdbcParameter jdbcParameter,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(LikeExpression likeExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(ExistsExpression existsExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(MemberOfExpression memberOfExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(LongValue longValue,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(MinorThan minorThan,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(MinorThanEquals minorThanEquals,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Multiplication multiplication,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(NotEqualsTo notEqualsTo,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(DoubleAnd doubleAnd,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Contains contains,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(ContainedBy containedBy,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(NullValue nullValue,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(OrExpression orExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(XorExpression xorExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(StringValue stringValue,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(BooleanValue booleanValue,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Subtraction subtraction,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(NotExpression notExpr,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(BitwiseRightShift expr,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(BitwiseLeftShift expr,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visitBinaryExpression

public void visitBinaryExpression(BinaryExpression binaryExpression)

visit

public <S> Void visit(ExpressionList<?> expressionList,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(DateValue dateValue,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(TimestampValue timestampValue,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(TimeValue timeValue,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(CaseExpression caseExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(WhenClause whenClause,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(AnyComparisonExpression anyComparisonExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Concat concat,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Matches matches,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(BitwiseAnd bitwiseAnd,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(BitwiseOr bitwiseOr,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(BitwiseXor bitwiseXor,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(CastExpression cast,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Modulo modulo,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(AnalyticExpression analytic,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(SetOperationList list,
                      S context)

Specified by:

visit in interface FromItemVisitor<Void>

Specified by:

visit in interface SelectVisitor<Void>

visit

public void visit(SetOperationList setOpList)

Specified by:

visit in interface FromItemVisitor<Void>

Specified by:

visit in interface SelectVisitor<Void>

visit

public <S> Void visit(ExtractExpression eexpr,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(LateralSubSelect lateralSubSelect,
                      S context)

Specified by:

visit in interface FromItemVisitor<Void>

Specified by:

visit in interface SelectVisitor<Void>

visit

public void visit(LateralSubSelect lateralSubSelect)

Specified by:

visit in interface FromItemVisitor<Void>

Specified by:

visit in interface SelectVisitor<Void>

visit

public <S> Void visit(TableStatement tableStatement,
                      S context)

Specified by:

visit in interface FromItemVisitor<Void>

Specified by:

visit in interface SelectVisitor<Void>

visit

public void visit(TableStatement tableStatement)

Specified by:

visit in interface FromItemVisitor<Void>

Specified by:

visit in interface SelectVisitor<Void>

visit

public <S> Void visit(FromQuery fromQuery,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

Specified by:

visit in interface FromItemVisitor<Void>

Specified by:

visit in interface SelectVisitor<Void>

init

protected void init(boolean allowColumnProcessing)

Initializes table names collector. Important is the usage of Column instances to find table 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.

Parameters:

allowColumnProcessing -

visit

public <S> Void visit(IntervalExpression intervalExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(JdbcNamedParameter jdbcNamedParameter,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(OracleHierarchicalExpression hierarchicalExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(RegExpMatchOperator regExpMatchOperator,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(JsonExpression jsonExpr,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(JsonOperator jsonExpr,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(AllColumns allColumns,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(AllTableColumns allTableColumns,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(FunctionAllColumns functionAllColumns,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(AllValue allValue,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(IsDistinctExpression isDistinctExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(SelectItem<?> item,
                      S context)

Specified by:

visit in interface SelectItemVisitor<Void>

visit

public void visit(SelectItem<? extends Expression> selectItem)

Specified by:

visit in interface SelectItemVisitor<Void>

visit

public <S> Void visit(UserVariable userVariable,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(NumericBind numericBind,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(KeepExpression keepExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(MySQLGroupConcat groupConcat,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Delete delete,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Delete delete)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(ParenthesedDelete delete,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(Update update,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(ParenthesedUpdate update,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Update update)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(Insert insert,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(ParenthesedInsert insert,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Insert insert)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(Analyze analyze,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Analyze analyze)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(Drop drop,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Drop drop)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(Truncate truncate,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Truncate truncate)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(CreateIndex createIndex,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(CreateIndex createIndex)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(CreateSchema createSchema,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(CreateSchema createSchema)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(CreateTable create,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(CreateTable createTable)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(CreateView create,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(CreateView createView)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(Alter alter,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Alter alter)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(Statements statements,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Statements statements)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(Execute execute,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Execute execute)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(SetStatement setStatement,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(SetStatement set)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(ResetStatement reset,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(ResetStatement reset)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(ShowColumnsStatement showColumnsStatement,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(ShowColumnsStatement showColumns)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(ShowIndexStatement showIndex,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(ShowIndexStatement showIndex)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(RowConstructor<?> rowConstructor,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(RowGetExpression rowGetExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(HexValue hexValue,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Merge merge,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Merge merge)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(OracleHint hint,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(TableFunction tableFunction,
                      S context)

Specified by:

visit in interface FromItemVisitor<Void>

visit

public void visit(TableFunction tableFunction)

Specified by:

visit in interface FromItemVisitor<Void>

visit

public <S> Void visit(AlterView alterView,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(AlterView alterView)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(RefreshMaterializedViewStatement materializedView,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(RefreshMaterializedViewStatement materializedView)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(TimeKeyExpression timeKeyExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(DateTimeLiteralExpression literal,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Commit commit,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Commit commit)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(Upsert upsert,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Upsert upsert)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(UseStatement use,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(UseStatement use)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(ParenthesedFromItem parenthesis,
                      S context)

Specified by:

visit in interface FromItemVisitor<Void>

visit

public void visit(ParenthesedFromItem parenthesedFromItem)

Specified by:

visit in interface FromItemVisitor<Void>

visit

public <S> Void visit(Block block,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Block block)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(Comment comment,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Comment comment)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(Values values,
                      S context)

Specified by:

visit in interface FromItemVisitor<Void>

Specified by:

visit in interface SelectVisitor<Void>

visit

public void visit(Values values)

Specified by:

visit in interface FromItemVisitor<Void>

Specified by:

visit in interface SelectVisitor<Void>

visit

public <S> Void visit(DescribeStatement describe,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(DescribeStatement describe)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(ExplainStatement explainStatement,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(ExplainStatement explainStatement)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(NextValExpression nextVal,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(CollateExpression collateExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(ShowStatement showStatement,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(ShowStatement showStatement)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(SimilarToExpression expr,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(DeclareStatement declareStatement,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(DeclareStatement declareStatement)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(Grant grant,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(Grant grant)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(ArrayExpression array,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(ArrayConstructor array,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(CreateSequence createSequence,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(CreateSequence createSequence)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(AlterSequence alterSequence,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(AlterSequence alterSequence)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(CreateFunctionalStatement createFunctionalStatement,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(CreateFunctionalStatement createFunctionalStatement)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(ShowTablesStatement showTables,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(ShowTablesStatement showTables)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(TSQLLeftJoin tsqlLeftJoin,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(TSQLRightJoin tsqlRightJoin,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(StructType structType,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(LambdaExpression lambdaExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(HighExpression highExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(LowExpression lowExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Plus plus,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(PriorTo priorTo,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(Inverse inverse,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(CosineSimilarity cosineSimilarity,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(VariableAssignment variableAssignment,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(XMLSerializeExpr xmlSerializeExpr,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(CreateSynonym createSynonym,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(CreateSynonym createSynonym)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(TimezoneExpression timezoneExpression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(SavepointStatement savepointStatement,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(SavepointStatement savepointStatement)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(RollbackStatement rollbackStatement,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(RollbackStatement rollbackStatement)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(AlterSession alterSession,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(AlterSession alterSession)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(JsonAggregateFunction expression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(JsonFunction expression,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(ConnectByRootOperator connectByRootOperator,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(ConnectByPriorOperator connectByPriorOperator,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(IfElseStatement ifElseStatement,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(IfElseStatement ifElseStatement)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(OracleNamedFunctionParameter oracleNamedFunctionParameter,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>

visit

public <S> Void visit(RenameTableStatement renameTableStatement,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(RenameTableStatement renameTableStatement)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(PurgeStatement purgeStatement,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(PurgeStatement purgeStatement)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(AlterSystemStatement alterSystemStatement,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(AlterSystemStatement alterSystemStatement)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(UnsupportedStatement unsupportedStatement,
                      S context)

Specified by:

visit in interface StatementVisitor<Void>

visit

public void visit(UnsupportedStatement unsupportedStatement)

Specified by:

visit in interface StatementVisitor<Void>

visit

public <S> Void visit(GeometryDistance geometryDistance,
                      S context)

Specified by:

visit in interface ExpressionVisitor<Void>