gudusoft.gsqlparser.resolver2.scope

Class CTEScope

Object

gudusoft.gsqlparser.resolver2.scope.AbstractScope

gudusoft.gsqlparser.resolver2.scope.ListBasedScope

gudusoft.gsqlparser.resolver2.scope.CTEScope

All Implemented Interfaces:

IScope

public class CTEScope
extends ListBasedScope

Scope for Common Table Expressions (WITH clause). Manages visibility of CTEs defined in a WITH clause.

Example:

 WITH
   cte1 AS (SELECT id, name FROM users),
   cte2 AS (SELECT * FROM cte1 WHERE id > 100)  -- can reference cte1
 SELECT * FROM cte2;  -- can reference both cte1 and cte2
 

Key features: - Multiple CTEs in same WITH clause - CTEs can reference earlier CTEs in the same WITH clause - Recursive CTE support (same CTE references itself) - CTEs are visible to the main query and to later CTEs

Field Summary

Fields inherited from class gudusoft.gsqlparser.resolver2.scope.ListBasedScope

children

Fields inherited from class gudusoft.gsqlparser.resolver2.scope.AbstractScope

node, parent, scopeType

Constructor Summary

Constructors

Constructor and Description
CTEScope(IScope parent, TCTEList cteList)

Method Summary

Modifier and Type	Method and Description
void	addCTE(String cteName, CTENamespace cteNamespace) Add a CTE to this scope.
List<CTENamespace>	getAllCTEs() Get all CTEs in this scope.
CTENamespace	getCTE(String cteName) Get a CTE namespace by name.
int	getCTECount() Get the number of CTEs in this scope.
TCTEList	getCTEList()
List<CTENamespace>	getRecursiveCTEs() Get all recursive CTEs in this scope.
boolean	hasCTE(String cteName) Check if a CTE with the given name exists in this scope.
boolean	hasRecursiveCTE() Check if this scope contains a recursive CTE.
INamespace	resolveTable(String tableName) Resolve a table name, checking CTEs first before delegating to parent.
String	toString()

Methods inherited from class gudusoft.gsqlparser.resolver2.scope.ListBasedScope

addChild, getChildren, getVisibleNamespaces, resolve, resolveInNamespace

Methods inherited from class gudusoft.gsqlparser.resolver2.scope.AbstractScope

fullyQualify, getNode, getParent, getScopeType, isWithin

Methods inherited from class Object

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

Constructor Detail

CTEScope

public CTEScope(IScope parent,
                TCTEList cteList)

Method Detail

addCTE

public void addCTE(String cteName,
                   CTENamespace cteNamespace)

Add a CTE to this scope. CTEs are added in order, allowing later CTEs to reference earlier ones.

Parameters:

cteName - the CTE name (alias)

cteNamespace - the CTE namespace

hasCTE

public boolean hasCTE(String cteName)

Check if a CTE with the given name exists in this scope.

Parameters:

cteName - the CTE name to check

Returns:

true if CTE exists, false otherwise

getCTE

public CTENamespace getCTE(String cteName)

Get a CTE namespace by name.

Parameters:

cteName - the CTE name

Returns:

the CTENamespace, or null if not found

getAllCTEs

public List<CTENamespace> getAllCTEs()

Get all CTEs in this scope.

Returns:

list of all CTE namespaces in definition order

getCTECount

public int getCTECount()

Get the number of CTEs in this scope.

Returns:

CTE count

resolveTable

public INamespace resolveTable(String tableName)

Resolve a table name, checking CTEs first before delegating to parent. This allows CTEs to shadow real tables.

Specified by:

resolveTable in interface IScope

Overrides:

resolveTable in class ListBasedScope

Parameters:

tableName - the table name to resolve

Returns:

the namespace for the CTE or table, or null if not found

hasRecursiveCTE

public boolean hasRecursiveCTE()

Check if this scope contains a recursive CTE. A recursive CTE is one that references itself in its definition.

Returns:

true if any CTE in this scope is recursive

getRecursiveCTEs

public List<CTENamespace> getRecursiveCTEs()

Get all recursive CTEs in this scope.

Returns:

list of recursive CTE namespaces

getCTEList

public TCTEList getCTEList()

toString

public String toString()

Overrides:

toString in class ListBasedScope