com.exasol.sql.dml.merge

Class MatchedClause

java.lang.Object

com.exasol.sql.AbstractFragment

com.exasol.sql.dml.merge.MatchedClause

All Implemented Interfaces:

MergeFragment, Fragment

public class MatchedClause
extends AbstractFragment
implements MergeFragment

Representation of the WHEN MATCHED part of an SQL MERGE statement.

This class supports two different strategies, updating matching rows or deleting matching rows.

Field Summary

Fields inherited from class com.exasol.sql.AbstractFragment

root

Constructor Summary

Constructors

Constructor and Description
MatchedClause(Fragment root) Create a new instance of a MatchedClause.

Method Summary

Modifier and Type	Method and Description
void	accept(MergeVisitor visitor) Accept a visitor (e.g.
MergeDeleteClause	thenDelete() Select deleting as merge strategy for rows where that are considered matches between source and destination.
MergeUpdateClause	thenUpdate() Select updating as merge strategy for rows where that are considered matches between source and destination.

Methods inherited from class com.exasol.sql.AbstractFragment

getRoot

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.exasol.sql.Fragment

getRoot

Constructor Detail

MatchedClause

public MatchedClause(Fragment root)

Create a new instance of a MatchedClause.

Parameters:

root - root SQL statement this WHEN MATCHED clause belongs to

Method Detail

thenUpdate

public MergeUpdateClause thenUpdate()

Select updating as merge strategy for rows where that are considered matches between source and destination.

Returns:

update clause

thenDelete

public MergeDeleteClause thenDelete()

Select deleting as merge strategy for rows where that are considered matches between source and destination.

Returns:

delete clause

accept

public void accept(MergeVisitor visitor)

Description copied from interface: MergeFragment

Accept a visitor (e.g. a renderer or validator).

Specified by:

accept in interface MergeFragment

Parameters:

visitor - visitor to accept