net.sf.jsqlparser.util

Class TablesNamesFinder

java.lang.Object

net.sf.jsqlparser.util.TablesNamesFinder

All Implemented Interfaces:

ExpressionVisitor, ItemsListVisitor, FromItemVisitor, SelectItemVisitor, SelectVisitor, StatementVisitor

public class TablesNamesFinder
extends Object
implements SelectVisitor, FromItemVisitor, ExpressionVisitor, ItemsListVisitor, SelectItemVisitor, StatementVisitor

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 and Description
TablesNamesFinder()

Method Summary

Modifier and Type	Method and Description
protected String	extractTableName(Table table) Override to adapt the tableName generation (e.g. with / without schema).
List<String>	getTableList(Expression expr) Main entry for this Tool class.
List<String>	getTableList(Statement statement) Main entry for this Tool class.
protected void	init(boolean allowColumnProcessing) Initializes table names collector.
void	visit(Addition addition)
void	visit(AllColumns allColumns)
void	visit(AllComparisonExpression allComparisonExpression)
void	visit(AllTableColumns allTableColumns)
void	visit(Alter alter)
void	visit(AlterView alterView)
void	visit(AnalyticExpression analytic)
void	visit(AndExpression andExpression)
void	visit(AnyComparisonExpression anyComparisonExpression)
void	visit(Between between)
void	visit(BitwiseAnd bitwiseAnd)
void	visit(BitwiseLeftShift expr)
void	visit(BitwiseOr bitwiseOr)
void	visit(BitwiseRightShift expr)
void	visit(BitwiseXor bitwiseXor)
void	visit(Block block)
void	visit(CaseExpression caseExpression)
void	visit(CastExpression cast)
void	visit(Column tableColumn)
void	visit(Comment comment)
void	visit(Commit commit)
void	visit(Concat concat)
void	visit(CreateIndex createIndex)
void	visit(CreateTable create)
void	visit(CreateView createView)
void	visit(DateTimeLiteralExpression literal)
void	visit(DateValue dateValue)
void	visit(Delete delete)
void	visit(Division division)
void	visit(DoubleValue doubleValue)
void	visit(Drop drop)
void	visit(EqualsTo equalsTo)
void	visit(Execute execute)
void	visit(ExistsExpression existsExpression)
void	visit(ExpressionList expressionList)
void	visit(ExtractExpression eexpr)
void	visit(Function function)
void	visit(GreaterThan greaterThan)
void	visit(GreaterThanEquals greaterThanEquals)
void	visit(HexValue hexValue)
void	visit(InExpression inExpression)
void	visit(Insert insert)
void	visit(IntervalExpression iexpr)
void	visit(IsNullExpression isNullExpression)
void	visit(JdbcNamedParameter jdbcNamedParameter)
void	visit(JdbcParameter jdbcParameter)
void	visit(JsonExpression jsonExpr)
void	visit(JsonOperator jsonExpr)
void	visit(KeepExpression aexpr)
void	visit(LateralSubSelect lateralSubSelect)
void	visit(LikeExpression likeExpression)
void	visit(LongValue longValue)
void	visit(Matches matches)
void	visit(Merge merge)
void	visit(MinorThan minorThan)
void	visit(MinorThanEquals minorThanEquals)
void	visit(Modulo modulo)
void	visit(MultiExpressionList multiExprList)
void	visit(Multiplication multiplication)
void	visit(MySQLGroupConcat groupConcat)
void	visit(NamedExpressionList namedExpressionList)
void	visit(NotEqualsTo notEqualsTo)
void	visit(NotExpression notExpr)
void	visit(NullValue nullValue)
void	visit(NumericBind bind)
void	visit(OracleHierarchicalExpression oexpr)
void	visit(OracleHint hint)
void	visit(OrExpression orExpression)
void	visit(Parenthesis parenthesis)
void	visit(ParenthesisFromItem parenthesis)
void	visit(PlainSelect plainSelect)
void	visit(RegExpMatchOperator rexpr)
void	visit(RegExpMySQLOperator rexpr)
void	visit(Replace replace)
void	visit(RowConstructor rowConstructor)
void	visit(Select select)
void	visit(SelectExpressionItem item)
void	visit(SetOperationList list)
void	visit(SetStatement set)
void	visit(ShowStatement set)
void	visit(SignedExpression signedExpression)
void	visit(Statements stmts)
void	visit(StringValue stringValue)
void	visit(SubJoin subjoin)
void	visit(SubSelect subSelect)
void	visit(Subtraction subtraction)
void	visit(Table tableName)
void	visit(TableFunction valuesList)
void	visit(TimeKeyExpression timeKeyExpression)
void	visit(TimestampValue timestampValue)
void	visit(TimeValue timeValue)
void	visit(Truncate truncate)
void	visit(Update update)
void	visit(Upsert upsert)
void	visit(UserVariable var)
void	visit(UseStatement use)
void	visit(ValueListExpression valueList)
void	visit(ValuesList valuesList)
void	visit(ValuesStatement values)
void	visit(WhenClause whenClause)
void	visit(WithItem withItem)
void	visitBinaryExpression(BinaryExpression binaryExpression)

Methods inherited from class java.lang.Object

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

Constructor Detail

TablesNamesFinder

public TablesNamesFinder()

Method Detail

getTableList

public List<String> getTableList(Statement statement)

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

visit

public void visit(Select select)

Specified by:

visit in interface StatementVisitor

getTableList

public List<String> getTableList(Expression expr)

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

visit

public void visit(WithItem withItem)

Specified by:

visit in interface SelectVisitor

visit

public void visit(PlainSelect plainSelect)

Specified by:

visit in interface SelectVisitor

extractTableName

protected String extractTableName(Table table)

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

Parameters:

table -

Returns:

visit

public void visit(Table tableName)

Specified by:

visit in interface FromItemVisitor

visit

public void visit(SubSelect subSelect)

Specified by:

visit in interface ExpressionVisitor

Specified by:

visit in interface ItemsListVisitor

Specified by:

visit in interface FromItemVisitor

visit

public void visit(Addition addition)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(AndExpression andExpression)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(Between between)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(Column tableColumn)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(Division division)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(DoubleValue doubleValue)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(EqualsTo equalsTo)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(Function function)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(GreaterThan greaterThan)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(GreaterThanEquals greaterThanEquals)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(InExpression inExpression)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(SignedExpression signedExpression)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(IsNullExpression isNullExpression)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(JdbcParameter jdbcParameter)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(LikeExpression likeExpression)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(ExistsExpression existsExpression)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(LongValue longValue)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(MinorThan minorThan)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(MinorThanEquals minorThanEquals)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(Multiplication multiplication)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(NotEqualsTo notEqualsTo)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(NullValue nullValue)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(OrExpression orExpression)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(Parenthesis parenthesis)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(StringValue stringValue)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(Subtraction subtraction)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(NotExpression notExpr)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(BitwiseRightShift expr)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(BitwiseLeftShift expr)

Specified by:

visit in interface ExpressionVisitor

visitBinaryExpression

public void visitBinaryExpression(BinaryExpression binaryExpression)

visit

public void visit(ExpressionList expressionList)

Specified by:

visit in interface ItemsListVisitor

visit

public void visit(NamedExpressionList namedExpressionList)

Specified by:

visit in interface ItemsListVisitor

visit

public void visit(DateValue dateValue)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(TimestampValue timestampValue)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(TimeValue timeValue)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(CaseExpression caseExpression)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(WhenClause whenClause)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(AllComparisonExpression allComparisonExpression)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(AnyComparisonExpression anyComparisonExpression)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(SubJoin subjoin)

Specified by:

visit in interface FromItemVisitor

visit

public void visit(Concat concat)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(Matches matches)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(BitwiseAnd bitwiseAnd)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(BitwiseOr bitwiseOr)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(BitwiseXor bitwiseXor)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(CastExpression cast)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(Modulo modulo)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(AnalyticExpression analytic)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(SetOperationList list)

Specified by:

visit in interface SelectVisitor

visit

public void visit(ExtractExpression eexpr)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(LateralSubSelect lateralSubSelect)

Specified by:

visit in interface FromItemVisitor

visit

public void visit(MultiExpressionList multiExprList)

Specified by:

visit in interface ItemsListVisitor

visit

public void visit(ValuesList valuesList)

Specified by:

visit in interface FromItemVisitor

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 void visit(IntervalExpression iexpr)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(JdbcNamedParameter jdbcNamedParameter)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(OracleHierarchicalExpression oexpr)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(RegExpMatchOperator rexpr)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(RegExpMySQLOperator rexpr)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(JsonExpression jsonExpr)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(JsonOperator jsonExpr)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(AllColumns allColumns)

Specified by:

visit in interface SelectItemVisitor

visit

public void visit(AllTableColumns allTableColumns)

Specified by:

visit in interface SelectItemVisitor

visit

public void visit(SelectExpressionItem item)

Specified by:

visit in interface SelectItemVisitor

visit

public void visit(UserVariable var)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(NumericBind bind)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(KeepExpression aexpr)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(MySQLGroupConcat groupConcat)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(ValueListExpression valueList)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(Delete delete)

Specified by:

visit in interface StatementVisitor

visit

public void visit(Update update)

Specified by:

visit in interface StatementVisitor

visit

public void visit(Insert insert)

Specified by:

visit in interface StatementVisitor

visit

public void visit(Replace replace)

Specified by:

visit in interface StatementVisitor

visit

public void visit(Drop drop)

Specified by:

visit in interface StatementVisitor

visit

public void visit(Truncate truncate)

Specified by:

visit in interface StatementVisitor

visit

public void visit(CreateIndex createIndex)

Specified by:

visit in interface StatementVisitor

visit

public void visit(CreateTable create)

Specified by:

visit in interface StatementVisitor

visit

public void visit(CreateView createView)

Specified by:

visit in interface StatementVisitor

visit

public void visit(Alter alter)

Specified by:

visit in interface StatementVisitor

visit

public void visit(Statements stmts)

Specified by:

visit in interface StatementVisitor

visit

public void visit(Execute execute)

Specified by:

visit in interface StatementVisitor

visit

public void visit(SetStatement set)

Specified by:

visit in interface StatementVisitor

visit

public void visit(ShowStatement set)

Specified by:

visit in interface StatementVisitor

visit

public void visit(RowConstructor rowConstructor)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(HexValue hexValue)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(Merge merge)

Specified by:

visit in interface StatementVisitor

visit

public void visit(OracleHint hint)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(TableFunction valuesList)

Specified by:

visit in interface FromItemVisitor

visit

public void visit(AlterView alterView)

Specified by:

visit in interface StatementVisitor

visit

public void visit(TimeKeyExpression timeKeyExpression)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(DateTimeLiteralExpression literal)

Specified by:

visit in interface ExpressionVisitor

visit

public void visit(Commit commit)

Specified by:

visit in interface StatementVisitor

visit

public void visit(Upsert upsert)

Specified by:

visit in interface StatementVisitor

visit

public void visit(UseStatement use)

Specified by:

visit in interface StatementVisitor

visit

public void visit(ParenthesisFromItem parenthesis)

Specified by:

visit in interface FromItemVisitor

visit

public void visit(Block block)

Specified by:

visit in interface StatementVisitor

visit

public void visit(Comment comment)

Specified by:

visit in interface StatementVisitor

visit

public void visit(ValuesStatement values)

Specified by:

visit in interface SelectVisitor

Specified by:

visit in interface StatementVisitor