gudusoft.gsqlparser.nodes

Class TCTE

java.lang.Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.nodes.TCTE

All Implemented Interfaces:

Visitable

public class TCTE
extends TParseTreeNode

A common table expression permits defining a result table with a table-name that can be specified as a table name in any FROM clause of the fullselect that follows.

Multiple common table expressions can be specified following the single WITH keyword.

Each common table expression specified can also be referenced by name in the FROM clause of subsequent common table expressions.

Syntax:

 table-name [column-name [,...n]] AS (fullselect)
 

Constructor Summary

Constructors

Constructor and Description
TCTE()

Method Summary

Modifier and Type	Method and Description
void	accept(TParseTreeVisitor v) Accept a visitor
void	acceptChildren(TParseTreeVisitor v) Accept a visitor to iterate this class and sub-nodes of this class
void	doParse(TCustomSqlStatement psql, ESqlClause plocation) Analyze the sub-nodes inside this node.
TObjectNameList	getColumnList()
TDeleteSqlStatement	getDeleteStmt()
TInsertSqlStatement	getInsertStmt()
TCustomSqlStatement	getPreparableStmt() preparable statement can be:
TSelectSqlStatement	getSubquery() fullselect of this common table expression.
TObjectName	getTableName()
TUpdateSqlStatement	getUpdateStmt()
void	init(Object arg1, Object arg2)
boolean	searchColumnInResultSet(TCustomSqlStatement pSql, TTable pTable, TObjectName pColumn, boolean pMustIn)
void	setColumnList(TObjectNameList columnList)
void	setDeleteStmt(TDeleteSqlStatement deleteStmt)
void	setInsertStmt(TInsertSqlStatement insertStmt)
void	setPreparableStmt(TCustomSqlStatement preparableStmt)
void	setSubquery(TSelectSqlStatement subquery)
void	setTableName(TObjectName tableName)
void	setUpdateStmt(TUpdateSqlStatement updateStmt)

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, appendString, fastSetString, getColumnNo, getDummyTag, getEndToken, getGsqlparser, getLineNo, getNodeType, getStartToken, init, init, init, init, init, removeAllMyTokensFromTokenList, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setGsqlparser, setIncludingComment, setNodeType, setStartToken, setStartToken, setStartToken, setStartToken, setString, toScript, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

TCTE

public TCTE()

Method Detail

searchColumnInResultSet

public boolean searchColumnInResultSet(TCustomSqlStatement pSql,
                                       TTable pTable,
                                       TObjectName pColumn,
                                       boolean pMustIn)

getPreparableStmt

public TCustomSqlStatement getPreparableStmt()

preparable statement can be:

getSubquery()

orgetUpdateStmt()

orgetInsertStmt()

orgetDeleteStmt()

Returns:

getUpdateStmt

public TUpdateSqlStatement getUpdateStmt()

getInsertStmt

public TInsertSqlStatement getInsertStmt()

getDeleteStmt

public TDeleteSqlStatement getDeleteStmt()

getTableName

public TObjectName getTableName()

Returns:

table name of this common table expression.

setColumnList

public void setColumnList(TObjectNameList columnList)

getSubquery

public TSelectSqlStatement getSubquery()

fullselect of this common table expression.

Returns:

getColumnList

public TObjectNameList getColumnList()

Returns:

List of column name of this common table expression.

init

public void init(Object arg1,
                 Object arg2)

Overrides:

init in class TParseTreeNode

doParse

public void doParse(TCustomSqlStatement psql,
                    ESqlClause plocation)

Description copied from class: TParseTreeNode

Analyze the sub-nodes inside this node. Such as build the relationship between table and column.

Overrides:

doParse in class TParseTreeNode

Parameters:

psql - SQL statement this node belongs to

plocation - SQL clause this node belongs to

accept

public void accept(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor

Specified by:

accept in interface Visitable

Overrides:

accept in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

acceptChildren

public void acceptChildren(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor to iterate this class and sub-nodes of this class

Specified by:

acceptChildren in interface Visitable

Overrides:

acceptChildren in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

setSubquery

public void setSubquery(TSelectSqlStatement subquery)

setInsertStmt

public void setInsertStmt(TInsertSqlStatement insertStmt)

setUpdateStmt

public void setUpdateStmt(TUpdateSqlStatement updateStmt)

setDeleteStmt

public void setDeleteStmt(TDeleteSqlStatement deleteStmt)

setPreparableStmt

public void setPreparableStmt(TCustomSqlStatement preparableStmt)

setTableName

public void setTableName(TObjectName tableName)