Package net.sf.jsqlparser.util
Class TablesNamesFinder
java.lang.Object
net.sf.jsqlparser.util.TablesNamesFinder
- All Implemented Interfaces:
ExpressionVisitor
,FromItemVisitor
,SelectItemVisitor
,SelectVisitor
,StatementVisitor
public class TablesNamesFinder
extends Object
implements SelectVisitor, FromItemVisitor, ExpressionVisitor, SelectItemVisitor, StatementVisitor
Find all used tables within an select statement.
Override extractTableName method to modify the extracted table names (e.g. without schema).
-
Field Summary
Fields -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionprotected String
extractTableName
(Table table) Override to adapt the tableName generation (e.g.findTables
(String sqlStr) findTablesInExpression
(String exprStr) getTableList
(Expression expr) Deprecated.getTableList
(Statement statement) Deprecated.getTables
(Expression expr) protected void
init
(boolean allowColumnProcessing) Initializes table names collector.private static <T> void
throwUnsupported
(T type) void
void
visit
(AnalyticExpression analytic) void
visit
(AnyComparisonExpression anyComparisonExpression) void
visit
(ArrayConstructor array) void
visit
(ArrayExpression array) void
visit
(CaseExpression caseExpression) void
visit
(CastExpression cast) void
visit
(CollateExpression col) void
visit
(ConnectByRootOperator connectByRootOperator) void
visit
(DateTimeLiteralExpression literal) void
void
visit
(DoubleValue doubleValue) void
visit
(ExtractExpression eexpr) void
void
void
visit
(IntervalExpression iexpr) void
visit
(JdbcNamedParameter jdbcNamedParameter) void
visit
(JdbcParameter jdbcParameter) void
visit
(JsonAggregateFunction expression) void
visit
(JsonExpression jsonExpr) void
visit
(JsonFunction expression) void
visit
(KeepExpression aexpr) void
void
visit
(MySQLGroupConcat groupConcat) void
visit
(NextValExpression nextVal) void
visit
(NotExpression notExpr) void
void
visit
(NumericBind bind) void
void
visit
(BitwiseAnd bitwiseAnd) void
visit
(BitwiseLeftShift expr) void
void
visit
(BitwiseRightShift expr) void
visit
(BitwiseXor bitwiseXor) void
void
void
visit
(IntegerDivision division) void
void
visit
(Multiplication multiplication) void
visit
(Subtraction subtraction) void
visit
(AndExpression andExpression) void
visit
(OrExpression orExpression) void
visit
(XorExpression xorExpression) void
void
visit
(ContainedBy containedBy) void
void
void
void
visit
(ExistsExpression existsExpression) void
visit
(ExpressionList<?> expressionList) void
visit
(FullTextSearch fullTextSearch) void
visit
(GeometryDistance geometryDistance) void
visit
(GreaterThan greaterThan) void
visit
(GreaterThanEquals greaterThanEquals) void
visit
(InExpression inExpression) void
visit
(IsBooleanExpression isBooleanExpression) void
visit
(IsDistinctExpression isDistinctExpression) void
visit
(IsNullExpression isNullExpression) void
visit
(JsonOperator jsonExpr) void
visit
(LikeExpression likeExpression) void
void
visit
(MemberOfExpression memberOfExpression) void
void
visit
(MinorThanEquals minorThanEquals) void
visit
(NotEqualsTo notEqualsTo) void
visit
(RegExpMatchOperator rexpr) void
visit
(SimilarToExpression expr) void
visit
(TSQLLeftJoin tsqlLeftJoin) void
visit
(TSQLRightJoin tsqlRightJoin) void
void
visit
(OracleHint hint) void
visit
(OracleNamedFunctionParameter oracleNamedFunctionParameter) void
visit
(OverlapsCondition overlapsCondition) void
visit
(Parenthesis parenthesis) void
visit
(RangeExpression rangeExpression) void
visit
(RowConstructor<?> rowConstructor) void
visit
(RowGetExpression rowGetExpression) void
visit
(SignedExpression signedExpression) void
visit
(StringValue stringValue) void
visit
(TimeKeyExpression timeKeyExpression) void
visit
(TimestampValue timestampValue) void
void
visit
(TimezoneExpression aThis) void
visit
(TranscodingFunction transcodingFunction) void
visit
(TrimFunction trimFunction) void
visit
(UserVariable var) void
visit
(VariableAssignment var) void
visit
(WhenClause whenClause) void
visit
(XMLSerializeExpr aThis) void
void
void
void
visit
(AlterSession alterSession) void
visit
(AlterSystemStatement alterSystemStatement) void
visit
(RenameTableStatement renameTableStatement) void
visit
(AlterSequence alterSequence) void
void
void
void
void
visit
(CreateIndex createIndex) void
visit
(CreateSchema aThis) void
visit
(CreateSequence createSequence) void
visit
(CreateSynonym createSynonym) void
visit
(CreateTable create) void
void
visit
(CreateView createView) void
visit
(CreateFunctionalStatement createFunctionalStatement) void
visit
(DeclareStatement aThis) void
void
visit
(DescribeStatement describe) void
void
void
visit
(ExplainStatement explain) void
void
visit
(IfElseStatement ifElseStatement) void
void
void
visit
(PurgeStatement purgeStatement) void
visit
(RefreshMaterializedViewStatement materializedView) void
visit
(ResetStatement reset) void
visit
(RollbackStatement rollbackStatement) void
visit
(SavepointStatement savepointStatement) void
visit
(AllColumns allColumns) void
visit
(AllTableColumns allTableColumns) void
visit
(LateralSubSelect lateralSubSelect) void
visit
(ParenthesedFromItem parenthesis) void
visit
(ParenthesedSelect selectBody) void
visit
(PlainSelect plainSelect) void
void
visit
(SelectItem item) void
visit
(SetOperationList list) void
visit
(TableFunction tableFunction) void
visit
(TableStatement tableStatement) void
void
void
visit
(SetStatement set) void
visit
(ShowIndexStatement showIndex) void
visit
(ShowTablesStatement showTables) void
void
visit
(ShowStatement aThis) void
visit
(Statements stmts) void
void
visit
(UnsupportedStatement unsupportedStatement) void
void
void
visit
(UseStatement use) void
visitBinaryExpression
(BinaryExpression binaryExpression) private void
visitJoins
(List<Join> parenthesis) visit join block
-
Field Details
-
NOT_SUPPORTED_YET
- See Also:
-
tables
-
allowColumnProcessing
private boolean allowColumnProcessing -
otherItemNames
-
-
Constructor Details
-
TablesNamesFinder
public TablesNamesFinder()
-
-
Method Details
-
getTableList
Deprecated. -
getTables
-
findTables
- Throws:
JSQLParserException
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
getTableList
Deprecated.Main entry for this Tool class. A list of found tables is returned. -
getTables
-
findTablesInExpression
- Throws:
JSQLParserException
-
visit
- Specified by:
visit
in interfaceSelectVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
- Specified by:
visit
in interfaceFromItemVisitor
- Specified by:
visit
in interfaceSelectVisitor
-
visit
- Specified by:
visit
in interfaceSelectVisitor
-
extractTableName
Override to adapt the tableName generation (e.g. with / without schema).- Parameters:
table
-- Returns:
-
visit
- Specified by:
visit
in interfaceFromItemVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visitBinaryExpression
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceSelectVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceFromItemVisitor
- Specified by:
visit
in interfaceSelectVisitor
-
visit
- Specified by:
visit
in interfaceSelectVisitor
-
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
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceSelectItemVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceFromItemVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceFromItemVisitor
-
visitJoins
visit join block- Parameters:
parenthesis
- join sql block
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceSelectVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
throwUnsupported
private static <T> void throwUnsupported(T type) -
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceStatementVisitor
-
visit
- Specified by:
visit
in interfaceExpressionVisitor
-