com.exasol.sql.dml.merge

Class MergeUpdateClause

java.lang.Object

com.exasol.sql.AbstractFragment

com.exasol.sql.dml.merge.MergeUpdateClause

All Implemented Interfaces:

MergeFragment, Fragment

public class MergeUpdateClause
extends AbstractFragment
implements MergeFragment

Represents the MERGE strategy of updating matched rows.

Field Summary

Fields inherited from class com.exasol.sql.AbstractFragment

root

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
void	accept(MergeVisitor visitor) Accept a visitor (e.g.
protected void	addColumnUpdate(String column, ValueExpression expression)
MergeUpdateClause	set(String column, int literal) Update a column with an integer value.
MergeUpdateClause	set(String column, String literal) Update a column with a string value.
MergeUpdateClause	setToDefault(String column) Update a column with the default value defined for that column.

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

MergeUpdateClause

public MergeUpdateClause(Fragment root)

Create a new instance of a MergeUpdateClause.

Parameters:

root - root SQL statement this THEN UPDATE clause belongs to

Method Detail

set

public MergeUpdateClause set(String column,
                             String literal)

Update a column with a string value.

Parameters:

column - column to be updated

literal - string literal

Returns:

this for fluent programming

addColumnUpdate

protected void addColumnUpdate(String column,
                               ValueExpression expression)

set

public MergeUpdateClause set(String column,
                             int literal)

Update a column with an integer value.

Parameters:

column - column to be updated

literal - integer literal

Returns:

this for fluent programming

setToDefault

public MergeUpdateClause setToDefault(String column)

Update a column with the default value defined for that column.

Parameters:

column - column to be updated

Returns:

this for fluent programming

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