TableExtract

Deals with extracting all TABLE names referenece inside SELECT.

Constructor

new TableExtract()

Source:

Sql.js, line 789

Methods

(static) extractAstTables(ast, tableSet)

Description:

Search for all referenced tables in SELECT.

Source:

Sql.js, line 832

Parameters:

Name	Type	Description
`ast`	Object	AST for SELECT.
`tableSet`	Map.<String, String>	Function updates this map of table names and alias name.

(static) getReferencedTableNames(statement) → {Array.<Array.<String>>}

Description:

Create table definition array from select string.

Source:

Sql.js, line 795

Parameters:

Name	Type	Description
`statement`	String	full sql select statement.

Returns:

table definition array.

Type: Array.<Array.<String>>

(static) getReferencedTableNamesFromAst(ast) → {Array.<any>}

Description:

Create table definition array from select AST.

Source:

Sql.js, line 809

Parameters:

Name	Type	Description
`ast`	Object	AST for SELECT.

Returns:

table definition array.

[0] - table name.
[1] - sheet tab name
[2] - cache seconds
[3] - output column title flag

Type: Array.<any>

(static) getTableNamesCorrelatedSelect(ast, tableSet)

Description:

Search CORRELATES sub-query for table names.

Source:

Sql.js, line 952

Parameters:

Name	Type	Description
`ast`	*	AST to search
`tableSet`	*	Function updates this map of table names and alias name.

(static) getTableNamesFrom(ast, tableSet)

Description:

Search for referenced table in FROM or JOIN part of select.

Source:

Sql.js, line 846

Parameters:

Name	Type	Description
`ast`	Object	AST for SELECT.
`tableSet`	Map.<String, String>	Function updates this map of table names and alias name.

(static) getTableNamesJoin(ast, tableSet)

Description:

Search for referenced table in FROM or JOIN part of select.

Source:

Sql.js, line 865

Parameters:

Name	Type	Description
`ast`	Object	AST for SELECT.
`tableSet`	Map.<String, String>	Function updates this map of table names and alias name.

(static) getTableNamesUnion(ast, tableSet)

Description:

Searches for table names within SELECT (union, intersect, except) statements.

Source:

Sql.js, line 884

Parameters:

Name	Type	Description
`ast`	Object	AST for SELECT
`tableSet`	Map.<String, String>	Function updates this map of table names and alias name.

(static) getTableNamesWhereCondition(ast, tableSet)

Description:

Search for table references in the WHERE condition.

Source:

Sql.js, line 931

Parameters:

Name	Type	Description
`ast`	Object	AST to search.
`tableSet`	Map.<String, String>	Function updates this map of table names and alias name.

(static) getTableNamesWhereIn(ast, tableSet)

Description:

Searches for tables names within SELECT (in, exists) statements.

Source:

Sql.js, line 901

Parameters:

Name	Type	Description
`ast`	Object	AST for SELECT
`tableSet`	Map.<String, String>	Function updates this map of table names and alias name.

(static) getTableNamesWhereTerms(ast, tableSet)

Description:

Search WHERE to find referenced table names.

Source:

Sql.js, line 918

Parameters:

Name	Type	Description
`ast`	Object	AST to search.
`tableSet`	Map.<String, String>	Function updates this map of table names and alias name.