Package gudusoft.gsqlparser.stmt

Class TAlterDatabaseStmt

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.TAlterDatabaseStmt

All Implemented Interfaces:

IRelation, Visitable, Iterator<TSourceToken>

public class TAlterDatabaseStmt
extends TCustomSqlStatement

SQL alter database statement.

getDatabaseName() returns the database name.

Example:

 ALTER DATABASE CURRENT SET COMPATIBILITY_LEVEL = 110
 Database name: getDatabaseName()
 

 alter database ticket rename to newticket
 Redshift new database name: getNewDatabaseName()
 

 alter database ticket owner to dwuser;
 Redshift owner name: getOwnerName()
 

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
TAlterDatabaseStmt(EDbVendor dbvendor)

Method Summary

Modifier and Type	Method	Description
void	accept(TParseTreeVisitor v)	Accept a visitor
void	acceptChildern(TParseTreeVisitor v)
int	doParseStatement(TCustomSqlStatement psql)
TObjectName	getDatabaseName()	database name to be altered.
TPTNodeList<THiveKeyValueProperty>	getDbProperties()	Hive, db properties in set dbproperties clause.
TObjectName	getNewDatabaseName()	Netezza,Redshift,Snowflake, new database name in rename to clause.
TObjectName	getOwnerName()	Netezza,Redshift, owner name in owner to clause.
void	setDatabaseName(TObjectName databaseName)
void	setDbProperties(TPTNodeList<THiveKeyValueProperty> dbProperties)
void	setNewDatabaseName(TObjectName newDatabaseName)
void	setOwnerName(TObjectName ownerName)

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

acceptChildren, 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

TAlterDatabaseStmt

public TAlterDatabaseStmt(EDbVendor dbvendor)

Method Details

getNewDatabaseName

public TObjectName getNewDatabaseName()

Netezza,Redshift,Snowflake, new database name in rename to clause.

Returns:

new database name

getOwnerName

public TObjectName getOwnerName()

Netezza,Redshift, owner name in owner to clause.

Returns:

owner name in owner to clause.

getDatabaseName

public TObjectName getDatabaseName()

database name to be altered.

Returns:

database name

getDbProperties

public TPTNodeList<THiveKeyValueProperty> getDbProperties()

Hive, db properties in set dbproperties clause.

Returns:

db properties in set dbproperties clause.

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)

Overrides:

doParseStatement in class TCustomSqlStatement

setDatabaseName

public void setDatabaseName(TObjectName databaseName)

setDbProperties

public void setDbProperties(TPTNodeList<THiveKeyValueProperty> dbProperties)

setNewDatabaseName

public void setNewDatabaseName(TObjectName newDatabaseName)

setOwnerName

public void setOwnerName(TObjectName ownerName)

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

acceptChildern

public void acceptChildern(TParseTreeVisitor v)