com.exasol.sql.dml.merge

Class MergeUpdateClause

java.lang.Object

com.exasol.sql.AbstractFragment

com.exasol.sql.dml.merge.MergeMethodDefinition

com.exasol.sql.dml.merge.MergeUpdateClause

All Implemented Interfaces:

MergeFragment, Fragment

public class MergeUpdateClause
extends MergeMethodDefinition
implements MergeFragment

Represents the MERGE strategy of updating matched rows.

Field Summary

Fields inherited from class com.exasol.sql.dml.merge.MergeMethodDefinition

where

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.
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	set(String column, ValueExpression expression) Update a column with a value expression.
MergeUpdateClause	setToDefault(String column) Update a column with the default value defined for that column.

Methods inherited from class com.exasol.sql.dml.merge.MergeMethodDefinition

getWhere, hasWhere, where

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,
                             ValueExpression expression)

Update a column with a value expression.

Parameters:

column - column to be updated

expression - value expression

Returns:

this for fluent programming

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

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