Class TMergeWhenClause

Namespace

gudusoft.gsqlparser.nodes

Assembly

gudusoft.gsqlparser.dll

when [not] matched clause in merge statement.

    merge into ....
    [when matched [and search_conditions ] then update set {col_name = expression} | delete]
    [when not matched [and search_conditions ] then insert [(column_list)] values (value_list)]

call method Condition to return search_condition if any.

call method UpdateClause, DeleteClause and InsertClause separately to get related update clause, delete clause and insert clause.

public class TMergeWhenClause : TParseTreeNode, Visitable

Inheritance

object

TParseTreeNode

TMergeWhenClause

Implements

Visitable

Inherited Members

TParseTreeNode.dbvendor

TParseTreeNode.IsIncludingOriginalTokens()

TParseTreeNode.setChanged()

TParseTreeNode.IsUnderlyingTokenChanged()

TParseTreeNode.Gsqlparser

TParseTreeNode.IncludingComment

TParseTreeNode.DummyTag

TParseTreeNode.startToken

TParseTreeNode.getStartToken()

TParseTreeNode.getEndToken()

TParseTreeNode.endToken

TParseTreeNode.ColumnNo

TParseTreeNode.LineNo

TParseTreeNode.NodeType

TParseTreeNode.init(object)

TParseTreeNode.init(object, object, object)

TParseTreeNode.init(object, object, object, object)

TParseTreeNode.init(object, object, object, object, object)

TParseTreeNode.init(object, object, object, object, object, object)

TParseTreeNode.setStartToken(TSourceToken)

TParseTreeNode.setStartToken(TParseTreeNode)

TParseTreeNode.setStartToken<T>(List<T>)

TParseTreeNode.setEndToken(TSourceToken)

TParseTreeNode.setEndToken(TParseTreeNode)

TParseTreeNode.setEndToken<T>(List<T>)

TParseTreeNode._stringValue

TParseTreeNode.String

TParseTreeNode.SourceTokenList

TParseTreeNode.ToString(bool)

TParseTreeNode.ToString()

TParseTreeNode.ToScript()

TParseTreeNode.addAllMyTokensToTokenList(TSourceTokenList, int)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

Fields

matched

public const int matched = 1

Field Value

int

matched_with_condition

public const int matched_with_condition = 3

Field Value

int

not_matched

public const int not_matched = 2

Field Value

int

not_matched_by_source

public const int not_matched_by_source = 7

Field Value

int

not_matched_by_source_with_condition

public const int not_matched_by_source_with_condition = 8

Field Value

int

not_matched_by_target

public const int not_matched_by_target = 5

Field Value

int

not_matched_by_target_with_condition

public const int not_matched_by_target_with_condition = 6

Field Value

int

not_matched_with_condition

public const int not_matched_with_condition = 4

Field Value

int

Properties

Condition

public virtual TExpression Condition { get; set; }

Property Value

TExpression

DeleteClause

public virtual TMergeDeleteClause DeleteClause { get; set; }

Property Value

TMergeDeleteClause

InsertClause

public virtual TMergeInsertClause InsertClause { get; set; }

Property Value

TMergeInsertClause

Type

public virtual int Type { get; set; }

Property Value

int

UpdateClause

public virtual TMergeUpdateClause UpdateClause { get; set; }

Property Value

TMergeUpdateClause

Methods

accept(TParseTreeVisitor)

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor)

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

doParse(TCustomSqlStatement, ESqlClause)

analyze this node

public override void doParse(TCustomSqlStatement psql, ESqlClause plocation)

Parameters

psql TCustomSqlStatement

plocation ESqlClause

init(object, object)

public override void init(object arg1, object arg2)

Parameters

arg1 object

arg2 object

See Also

TMergeUpdateClause

TMergeDeleteClause

TMergeInsertClause