Package gudusoft.gsqlparser.stmt

Class TCreateViewSqlStatement

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.TCreateViewSqlStatement

All Implemented Interfaces:

IRelation, Visitable, Iterator<TSourceToken>

public class TCreateViewSqlStatement
extends TCustomSqlStatement

Define a view, which is a logical table based on one or more tables or views.

Nested Class Summary

Nested classes/interfaces inherited from class gudusoft.gsqlparser.TCustomSqlStatement

TCustomSqlStatement.SqlNormalizationProfile

Field Summary

Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement

dummytag, fromClause, fromSourceJoin, fromSourceTable, isctequery, isparsed, joins, parser, plsqlparser, relationAttributes, rootNode, semicolonended, sourcetokenlist, sqlstatementtype, stmtScope, tables

Fields inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

dbvendor, doubleLinkedTokenListToString, nodeActionAppend, nodeActionInsert, nodeActionRemove, nodeActionUnknown, nodeActionUpdate, nodeActionUpdateText, nodeChangeEndToken, nodeChangeStartToken

Constructor Summary

Constructors

Constructor	Description
TCreateViewSqlStatement(EDbVendor dbvendor)

Method Summary

Modifier and Type	Method	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
int	doParseStatement(TCustomSqlStatement psql)
TObjectName	getComment()
TRestrictionClause	getRestrictionClause()	Oracle, DB2 restriction clause
TObjectName	getRowTypeName()
TSourceToken	getStForce()
TSourceToken	getStReplace()
TSelectSqlStatement	getSubquery()
ETableKind	getTableKind()
TViewAliasClause	getViewAliasClause()
TObjectNameList	getViewAttributeList()
TObjectName	getViewName()
boolean	isForce()
boolean	isNoForce()
boolean	isRecursive()
boolean	isSecure()
void	setForce(boolean isForce)
void	setNoForce(boolean isNoForce)
void	setRestrictionClause(TRestrictionClause restrictionClause)
void	setRowTypeName(TObjectName rowTypeName)
void	setStForce(TSourceToken stForce)
void	setStReplace(TSourceToken stReplace)
void	setSubquery(TSelectSqlStatement subquery)
void	setViewAliasClause(TViewAliasClause viewAliasClause)
void	setViewAttributeList(TObjectNameList viewAttributeList)
void	setViewName(TObjectName viewName)

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement

addToTables, addWhereClause, analyzeFromTable, analyzeFromTable, analyzeJoin, analyzeTablename, analyzeTableOrJoin, asCanonical, checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt, clearError, computeSqlHash, dochecksyntax, findTable, fireOnMetaDatabaseTableColumn, getAncestorStmt, getAttributes, getColumnsInTable, getColumnsInTable, getCteIncludeThisStmt, getCteList, getDaxFunctionStack, getEndlabelName, getErrorCount, getErrormessage, getExpandedResultColumns, getFirstPhysicalTable, getFrameStack, getFromClause, getFromSourceJoin, getFromSourceTable, getGlobalScope, getIndexColumns, getJoins, getLabelName, getOrphanColumns, getOutputClause, getParentObjectName, getParentStmt, getQueryId, getRelationName, getRelations, getResultColumnList, getReturningClause, getSqlEnv, getSqlHash, getSqlHash, getStatements, getStmtScope, getSymbolTable, getSyntaxErrors, getSyntaxHints, getTables, getTargetTable, getTokenList, getTopClause, getTopStatement, getUsingVariableList, getVariableStack, getWhereClause, isathenaplsql, isBigQueryplsql, isdatabricksplsql, isGaussDBStoredProcedure, isgreeplumplsql, isnzplsql, isoracleplsql, ispgplsql, isprestoplsql, issnowflakeplsql, isTableACTE, isverticaplsql, linkColumnReferenceToTable, linkColumnToTable, linkToFirstTable, locateVariableOrParameter, locateVariableOrParameter, OracleStatementCanBeSeparatedByBeginEndPair, parseerrormessagehandle, parsestatement, parsestatement, searchCTEList, searchDaxVariableInStack, searchFunctionInSQLEnv, setAlreadyAddToParent, setCteIncludeThisStmt, setCteList, setEndlabelName, setFrameStack, setFromClause, setLabelName, setOutputClause, setParentStmt, setParentStmtToNull, setQueryId, setResultColumnList, setReturningClause, setSqlHash, setStmtScope, setTargetTable, setTopClause, setUsingVariableList, setVariableStack, setWhereClause, size, toNormalizedSql, toScript, VerticaStatementCanBeSeparatedByBeginEndPair

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, addToTokenChain, appendNewNode, calculateTokenCount, doAppendNewNode, doParse, fastSetString, getAnchorNode, getColumnNo, getCommentAfterNode, getCommentBeforeNode, getCompactString, getDummyTag, getEndToken, getEvaluateDatatype, getEvalValue, getGsqlparser, getLineNo, getLocation, getMd5, getNodeStatus, getNodeType, getPlainText, getStartToken, getTokenCount, hasNext, init, init, init, init, init, init, insertAfterAToken, insertNewNodeBeforeMe, isChanged, isTokensInChain, next, refreshAllNodesTokenCount, remove, removeAllMyTokensFromTokenList, removeTokens, removeTokensBetweenNodes, removeTokensBetweenToken, replaceWithNewNode, resetIterator, setAnchorNode, setChanged, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setEndToken, setEndTokenDirectly, setEvaluateDatatype, setEvalValue, setGsqlparser, setIncludingComment, setLocation, setNewSubNode, setNodeStatus, setNodeType, setParent, setPlainText, setStartToken, setStartToken, setStartToken, setStartToken, setStartTokenDirectly, setString, setString2, subNodeInNode, toString, toString2

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.util.Iterator

forEachRemaining

Constructor Details

TCreateViewSqlStatement

public TCreateViewSqlStatement(EDbVendor dbvendor)

Method Details

isSecure

public boolean isSecure()

isRecursive

public boolean isRecursive()

getTableKind

public ETableKind getTableKind()

getComment

public TObjectName getComment()

setForce

public void setForce(boolean isForce)

setNoForce

public void setNoForce(boolean isNoForce)

isForce

public boolean isForce()

isNoForce

public boolean isNoForce()

setViewAttributeList

public void setViewAttributeList(TObjectNameList viewAttributeList)

getViewAttributeList

public TObjectNameList getViewAttributeList()

setSubquery

public void setSubquery(TSelectSqlStatement subquery)

setViewAliasClause

public void setViewAliasClause(TViewAliasClause viewAliasClause)

setStForce

public void setStForce(TSourceToken stForce)

setStReplace

public void setStReplace(TSourceToken stReplace)

setRowTypeName

public void setRowTypeName(TObjectName rowTypeName)

setRestrictionClause

public void setRestrictionClause(TRestrictionClause restrictionClause)

setViewName

public void setViewName(TObjectName viewName)

getRowTypeName

public TObjectName getRowTypeName()

getStForce

public TSourceToken getStForce()

getStReplace

public TSourceToken getStReplace()

getRestrictionClause

public TRestrictionClause getRestrictionClause()

Oracle, DB2 restriction clause

Returns:

DB2 restriction clause

getViewAliasClause

public TViewAliasClause getViewAliasClause()

getSubquery

public TSelectSqlStatement getSubquery()

Returns:

a subquery that identifies columns and rows of the table(s) that the view is based on.

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)

Overrides:

doParseStatement in class TCustomSqlStatement

getViewName

public TObjectName getViewName()

Returns:

the name of the view or the object view.

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