Package gudusoft.gsqlparser.resolver2

Class ScopeBuildResult

Object

gudusoft.gsqlparser.resolver2.ScopeBuildResult

public class ScopeBuildResult
extends Object

Result of scope building by ScopeBuilder. Contains the complete scope tree and column mappings.

Constructor Summary

Constructors

Constructor	Description
ScopeBuildResult(GlobalScope globalScope, Map<TObjectName,IScope> columnToScopeMap, List<TObjectName> allColumnReferences, Map<TSelectSqlStatement,SelectScope> statementScopeMap, Map<TObjectName,TTable> usingColumnToRightTable)
ScopeBuildResult(GlobalScope globalScope, Map<TObjectName,IScope> columnToScopeMap, List<TObjectName> allColumnReferences, Map<TSelectSqlStatement,SelectScope> statementScopeMap, Map<TObjectName,TTable> usingColumnToRightTable, Map<TObjectName,TTable> usingColumnToLeftTable)
ScopeBuildResult(GlobalScope globalScope, Map<TObjectName,IScope> columnToScopeMap, List<TObjectName> allColumnReferences, Map<TSelectSqlStatement,SelectScope> statementScopeMap, Map<TObjectName,TTable> usingColumnToRightTable, Map<TObjectName,TTable> usingColumnToLeftTable, Map<TTable,INamespace> tableToNamespaceMap)
ScopeBuildResult(GlobalScope globalScope, Map<TObjectName,IScope> columnToScopeMap, List<TObjectName> allColumnReferences, Map<TSelectSqlStatement,SelectScope> statementScopeMap, Map<TObjectName,TTable> usingColumnToRightTable, Map<TObjectName,TTable> usingColumnToLeftTable, Map<TTable,INamespace> tableToNamespaceMap, Set<TTable> ctasTargetTables)

Method Summary

Modifier and Type	Method	Description
void	addColumnReferences(List<TObjectName> columns)	Add column references to the internal list.
String	dumpColumnReferences()	Dump all column references for debugging
String	dumpScopeTree()	Dump scope tree for debugging
List<TObjectName>	getAllColumnReferences()
Map<TObjectName,IScope>	getColumnToScopeMap()
Set<TTable>	getCTASTargetTables()	Get all CTAS target tables
Map<String,CTENamespace>	getCTENamespaces()	Get all CTENamespaces from the scope tree.
GlobalScope	getGlobalScope()
INamespace	getNamespaceForTable(TTable table)	Get the namespace for a specific table.
List<PivotNamespace>	getPivotNamespaces()	Get all PivotNamespaces from the scope tree.
IScope	getScopeForColumn(TObjectName column)	Get the scope for a specific column reference
SelectScope	getScopeForStatement(TSelectSqlStatement stmt)	Get the SelectScope for a specific statement
Map<TSelectSqlStatement,SelectScope>	getStatementScopeMap()
String	getStatistics()	Get statistics about the build result
Map<TTable,INamespace>	getTableToNamespaceMap()	Get all TTable -> INamespace mappings
TTable	getUsingColumnLeftTable(TObjectName column)	Get the left-side table for a USING column.
TTable	getUsingColumnRightTable(TObjectName column)	Get the right-side table for a USING column.
Map<TObjectName,TTable>	getUsingColumnToLeftTable()	Get all USING column -> left-side table mappings
Map<TObjectName,TTable>	getUsingColumnToRightTable()	Get all USING column -> right-side table mappings
boolean	isCTASTargetTable(TTable table)	Check if a table is a CTAS target table (table being created by CREATE TABLE AS SELECT).
String	toString()

Methods inherited from class java.lang.Object

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

Constructor Details

ScopeBuildResult

public ScopeBuildResult(GlobalScope globalScope,
 Map<TObjectName,IScope> columnToScopeMap,
 List<TObjectName> allColumnReferences,
 Map<TSelectSqlStatement,SelectScope> statementScopeMap,
 Map<TObjectName,TTable> usingColumnToRightTable)

ScopeBuildResult

public ScopeBuildResult(GlobalScope globalScope,
 Map<TObjectName,IScope> columnToScopeMap,
 List<TObjectName> allColumnReferences,
 Map<TSelectSqlStatement,SelectScope> statementScopeMap,
 Map<TObjectName,TTable> usingColumnToRightTable,
 Map<TObjectName,TTable> usingColumnToLeftTable)

ScopeBuildResult

public ScopeBuildResult(GlobalScope globalScope,
 Map<TObjectName,IScope> columnToScopeMap,
 List<TObjectName> allColumnReferences,
 Map<TSelectSqlStatement,SelectScope> statementScopeMap,
 Map<TObjectName,TTable> usingColumnToRightTable,
 Map<TObjectName,TTable> usingColumnToLeftTable,
 Map<TTable,INamespace> tableToNamespaceMap)

ScopeBuildResult

public ScopeBuildResult(GlobalScope globalScope,
 Map<TObjectName,IScope> columnToScopeMap,
 List<TObjectName> allColumnReferences,
 Map<TSelectSqlStatement,SelectScope> statementScopeMap,
 Map<TObjectName,TTable> usingColumnToRightTable,
 Map<TObjectName,TTable> usingColumnToLeftTable,
 Map<TTable,INamespace> tableToNamespaceMap,
 Set<TTable> ctasTargetTables)

Method Details

getGlobalScope

public GlobalScope getGlobalScope()

getColumnToScopeMap

public Map<TObjectName,IScope> getColumnToScopeMap()

getAllColumnReferences

public List<TObjectName> getAllColumnReferences()

addColumnReferences

public void addColumnReferences(List<TObjectName> columns)

Add column references to the internal list. Used by TSQLResolver2 to add cloned columns for star column tracing.

Parameters:

columns - the column references to add

getStatementScopeMap

public Map<TSelectSqlStatement,SelectScope> getStatementScopeMap()

getScopeForColumn

public IScope getScopeForColumn(TObjectName column)

Get the scope for a specific column reference

getScopeForStatement

public SelectScope getScopeForStatement(TSelectSqlStatement stmt)

Get the SelectScope for a specific statement

getUsingColumnRightTable

public TTable getUsingColumnRightTable(TObjectName column)

Get the right-side table for a USING column. In JOIN...USING syntax, USING columns should preferentially resolve to the right-side (physical) table.

Parameters:

column - the USING column TObjectName

Returns:

the right-side TTable, or null if not a USING column

getUsingColumnToRightTable

public Map<TObjectName,TTable> getUsingColumnToRightTable()

Get all USING column -> right-side table mappings

getUsingColumnLeftTable

public TTable getUsingColumnLeftTable(TObjectName column)

Get the left-side table for a USING column. In JOIN...USING syntax, the USING column also applies to the left-side table.

Parameters:

column - the USING column TObjectName

Returns:

the left-side TTable, or null if not a USING column

getUsingColumnToLeftTable

public Map<TObjectName,TTable> getUsingColumnToLeftTable()

Get all USING column -> left-side table mappings

getNamespaceForTable

public INamespace getNamespaceForTable(TTable table)

Get the namespace for a specific table. Used for legacy compatibility to fill TTable.getAttributes().

Parameters:

table - the TTable to look up

Returns:

the INamespace for this table, or null if not found

getTableToNamespaceMap

public Map<TTable,INamespace> getTableToNamespaceMap()

Get all TTable -> INamespace mappings

isCTASTargetTable

public boolean isCTASTargetTable(TTable table)

Check if a table is a CTAS target table (table being created by CREATE TABLE AS SELECT). CTAS target tables are DDL targets, not existing physical tables.

Parameters:

table - the TTable to check

Returns:

true if this is a CTAS target table

getCTASTargetTables

public Set<TTable> getCTASTargetTables()

Get all CTAS target tables

getCTENamespaces

public Map<String,CTENamespace> getCTENamespaces()

Get all CTENamespaces from the scope tree. Searches through all scopes to find CTE namespaces.

Returns:

Map of CTE name -> CTENamespace

getPivotNamespaces

public List<PivotNamespace> getPivotNamespaces()

Get all PivotNamespaces from the scope tree. Searches through all scopes to find PIVOT namespaces.

Returns:

List of PivotNamespace objects

getStatistics

public String getStatistics()

Get statistics about the build result

dumpScopeTree

public String dumpScopeTree()

Dump scope tree for debugging

dumpColumnReferences

public String dumpColumnReferences()

Dump all column references for debugging

toString

public String toString()

Overrides:

toString in class Object