com.exasol.sql.dml.merge

Class Merge

java.lang.Object

com.exasol.sql.AbstractFragment

com.exasol.sql.dml.merge.Merge

All Implemented Interfaces:

MergeFragment, Fragment, SqlStatement

public class Merge
extends AbstractFragment
implements SqlStatement, MergeFragment

This class implements an SQL Merge statement which is a combination of INSERT, UPDATE and DELETE.

Field Summary

Fields inherited from class com.exasol.sql.AbstractFragment

root

Constructor Summary

Constructors

Constructor and Description
Merge(String destinationTable) Create a new instance of a Merge.
Merge(String destinationTable, String alias) Create a new instance of a Merge.

Method Summary

Modifier and Type	Method and Description
void	accept(MergeVisitor visitor) Accept a visitor (e.g.
BooleanExpression	getCondition() Get the merge condition.
UsingClause	getUsing() Get the USING clause of the MERGE statement.
Merge	on(BooleanExpression condition) Define the merge criteria.
Merge	using(String sourceTable) Define the data source.
Merge	using(String sourceTable, String as) Define the data source.
MatchedClause	whenMatched() Define the merge strategy if the match criteria is met.
NotMatchedClause	whenNotMatched() Define the merge strategy if the match criteria is not met.

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

Merge

public Merge(String destinationTable)

Create a new instance of a Merge.

Parameters:

destinationTable - table into which the data should be merged

Merge

public Merge(String destinationTable,
             String alias)

Create a new instance of a Merge.

Parameters:

destinationTable - table into which the data should be merged

alias - table alias

Method Detail

using

public Merge using(String sourceTable)

Define the data source.

Parameters:

sourceTable - table where the data to be merged originates

Returns:

this for fluent programming

using

public Merge using(String sourceTable,
                   String as)

Define the data source.

Parameters:

sourceTable - table where the data to be merged originates

as - table alias

Returns:

this for fluent programming

on

public Merge on(BooleanExpression condition)

Define the merge criteria.

Parameters:

condition - criteria that must be met for the rows in source and destination to be considered a match.

Returns:

this for fluent programming

whenMatched

public MatchedClause whenMatched()

Define the merge strategy if the match criteria is met.

Returns:

match strategy

whenNotMatched

public NotMatchedClause whenNotMatched()

Define the merge strategy if the match criteria is not met.

Returns:

not matched strategy

getUsing

public UsingClause getUsing()

Get the USING clause of the MERGE statement.

Returns:

destination table

getCondition

public BooleanExpression getCondition()

Get the merge condition.

Returns:

criteria that must be met for the rows in source and destination to be considered a match.

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