Package gudusoft.gsqlparser.stmt

Class TRoutine

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.TBlockSqlStatement

gudusoft.gsqlparser.stmt.TStoredProcedureSqlStatement

gudusoft.gsqlparser.stmt.TCommonStoredProcedureSqlStatement

gudusoft.gsqlparser.stmt.TRoutine

All Implemented Interfaces:

IRelation, Visitable, Iterator<TSourceToken>

Direct Known Subclasses:

TCreateFunctionStmt, TCreateProcedureStmt, TDoExecuteBlockStmt

public class TRoutine
extends TCommonStoredProcedureSqlStatement

Base class of procedure and function.

Nested Class Summary

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

TCustomSqlStatement.SqlNormalizationProfile

Field Summary

Fields

Modifier and Type	Field	Description
protected int	language
static final int	LANGUAGE_PLPGSQL
static final int	LANGUAGE_SQL
static final int	LANGUAGE_UNKNOWN
protected TTypeName	returnDataType

Fields inherited from class gudusoft.gsqlparser.stmt.TBlockSqlStatement

blockBody, bodyStatements, declareStatements, exceptionClause

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

Method Summary

Modifier and Type	Method	Description
TTypeName	getReturnDataType()
String	getRoutineBody()
TConstant	getRoutineBodyInConstant()
String	getRoutineLanguage()
TConstant	getRoutineLanguageInConstant()
TObjectName	getRoutineName()
boolean	isBodyInSQL()
boolean	isGaussDBSpInOracle()
void	setReturnDataType(TTypeName returnDataType)
void	setRoutineBody(String routineBody)
void	setRoutineBodyInConstant(TConstant routineBodyInConstant)
void	setRoutineLanguage(String routineLanguage)
void	setRoutineLanguageInConstant(TConstant routineLanguageInConstant)
void	setRoutineName(TObjectName routineName)

Methods inherited from class gudusoft.gsqlparser.stmt.TCommonStoredProcedureSqlStatement

doParseStatement, isWrapped, setWrapped

Methods inherited from class gudusoft.gsqlparser.stmt.TStoredProcedureSqlStatement

getParameterDeclarations, getProcHandle, getStoredProcedureName, setParameterDeclarations, setProcHandle

Methods inherited from class gudusoft.gsqlparser.stmt.TBlockSqlStatement

accept, acceptChildren, getBlockBody, getBodyStatements, getDeclareStatements, getEndlabelName, getExceptionClause, getLabelName, getLabelNameStr, setBodyStatements, setDeclareStatements, setExceptionClause

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, getErrorCount, getErrormessage, getExpandedResultColumns, getFirstPhysicalTable, getFrameStack, getFromClause, getFromSourceJoin, getFromSourceTable, getGlobalScope, getIndexColumns, getJoins, 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

Field Details

LANGUAGE_UNKNOWN

public static final int LANGUAGE_UNKNOWN

See Also:

• Constant Field Values

LANGUAGE_SQL

public static final int LANGUAGE_SQL

See Also:

• Constant Field Values

LANGUAGE_PLPGSQL

public static final int LANGUAGE_PLPGSQL

See Also:

• Constant Field Values

language

protected int language

returnDataType

protected TTypeName returnDataType

Constructor Details

TRoutine

public TRoutine(EDbVendor dbvendor)

Method Details

getReturnDataType

public TTypeName getReturnDataType()

setReturnDataType

public void setReturnDataType(TTypeName returnDataType)

setRoutineName

public void setRoutineName(TObjectName routineName)

getRoutineName

public TObjectName getRoutineName()

setRoutineLanguage

public void setRoutineLanguage(String routineLanguage)

getRoutineLanguage

public String getRoutineLanguage()

setRoutineLanguageInConstant

public void setRoutineLanguageInConstant(TConstant routineLanguageInConstant)

getRoutineLanguageInConstant

public TConstant getRoutineLanguageInConstant()

setRoutineBody

public void setRoutineBody(String routineBody)

getRoutineBody

public String getRoutineBody()

setRoutineBodyInConstant

public void setRoutineBodyInConstant(TConstant routineBodyInConstant)

getRoutineBodyInConstant

public TConstant getRoutineBodyInConstant()

isBodyInSQL

public boolean isBodyInSQL()

isGaussDBSpInOracle

public boolean isGaussDBSpInOracle()