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