Package gudusoft.gsqlparser.stmt

Class TCreateTriggerStmt

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.TBlockSqlStatement

gudusoft.gsqlparser.stmt.TStoredProcedureSqlStatement

gudusoft.gsqlparser.stmt.TCreateTriggerStmt

All Implemented Interfaces:

IRelation, Visitable, Iterator<TSourceToken>

public class TCreateTriggerStmt
extends TStoredProcedureSqlStatement

Create trigger statement. supported databases:

• DB2
• Hana
• Greenplum, represented by TPlsqlCreateTrigger
• Informix
• MySQL
• Openedge
• Oracle, represented by TPlsqlCreateTrigger support dml, non-dml and database trigger.
• PostgreSQL
• SQL Server, support dml, ddl trigger
• Sybase
• Teradata

See Also:

• TTriggeringClause

Nested Class Summary

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

TCustomSqlStatement.SqlNormalizationProfile

Field Summary

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
TCreateTriggerStmt(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)
TSourceTokenList	getDmlTpyes()	Deprecated. As of v1.7.2.5, replaced by ETriggerDmlType
EnumSet<ETriggerDmlType>	getDmlTypes()	Deprecated. As of v2.0.1.0, replaced by getTriggeringClause()
int	getFireMode()	Deprecated. As of v1.7.2.5, replaced by ETriggerTimingPoint
TFunctionCall	getFunctionCall()	Greenplum,postgresql executed function
TTable	getOnTable()	Deprecated. As of v2.0.1.0, use getTriggeringClause() instead
TObjectName	getStoredProcedureName()
ETriggerTimingPoint	getTimingPoint()	Deprecated. As of v2.0.1.0, replaced by getTriggeringClause()
TTriggeringClause	getTriggeringClause()
TObjectName	getTriggerName()
TExpression	getWhenCondition()	When condition
boolean	isAlterTrigger()
void	setAlterTrigger(boolean alterTrigger)
void	setDmlTypes(EnumSet<ETriggerDmlType> dmlTypes)
void	setFireMode(int fireMode)
void	setFunctionCall(TFunctionCall functionCall)
void	setOnTable(TTable onTable)
void	setTimingPoint(ETriggerTimingPoint timingPoint)
void	setTriggeringClause(TTriggeringClause triggeringClause)
void	setTriggerName(TObjectName triggerName)

Methods inherited from class gudusoft.gsqlparser.stmt.TStoredProcedureSqlStatement

getParameterDeclarations, getProcHandle, setParameterDeclarations, setProcHandle

Methods inherited from class gudusoft.gsqlparser.stmt.TBlockSqlStatement

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

Constructor Details

TCreateTriggerStmt

public TCreateTriggerStmt(EDbVendor dbvendor)

Method Details

setTriggeringClause

public void setTriggeringClause(TTriggeringClause triggeringClause)

getWhenCondition

public TExpression getWhenCondition()

When condition

Returns:

when condition

setAlterTrigger

public void setAlterTrigger(boolean alterTrigger)

isAlterTrigger

public boolean isAlterTrigger()

getStoredProcedureName

public TObjectName getStoredProcedureName()

Overrides:

getStoredProcedureName in class TStoredProcedureSqlStatement

getOnTable

public TTable getOnTable()

Deprecated.

As of v2.0.1.0, use getTriggeringClause() instead

Returns:

onTable

getTriggerName

public TObjectName getTriggerName()

setTimingPoint

public void setTimingPoint(ETriggerTimingPoint timingPoint)

setDmlTypes

public void setDmlTypes(EnumSet<ETriggerDmlType> dmlTypes)

getTimingPoint

public ETriggerTimingPoint getTimingPoint()

Deprecated.

As of v2.0.1.0, replaced by getTriggeringClause()

Returns:

timing point

getDmlTypes

public EnumSet<ETriggerDmlType> getDmlTypes()

Deprecated.

As of v2.0.1.0, replaced by getTriggeringClause()

Returns:

dml

setFunctionCall

public void setFunctionCall(TFunctionCall functionCall)

getFunctionCall

public TFunctionCall getFunctionCall()

Greenplum,postgresql executed function

Returns:

function call

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)

Overrides:

doParseStatement in class TBlockSqlStatement

getTriggeringClause

public TTriggeringClause getTriggeringClause()

getDmlTpyes

public TSourceTokenList getDmlTpyes()

Deprecated.

As of v1.7.2.5, replaced by ETriggerDmlType

Returns:

insert/delete/update action

getFireMode

public int getFireMode()

Deprecated.

As of v1.7.2.5, replaced by ETriggerTimingPoint

Returns:

trigger timing point

accept

public void accept(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor

Specified by:

accept in interface Visitable

Overrides:

accept in class TBlockSqlStatement

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 TBlockSqlStatement

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

setOnTable

public void setOnTable(TTable onTable)

setTriggerName

public void setTriggerName(TObjectName triggerName)

setFireMode

public void setFireMode(int fireMode)