Package 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	Description
MergeUpdateClause(Fragment root)	Create a new instance of a MergeUpdateClause.

Method Summary

Modifier and Type	Method	Description
void	accept(MergeVisitor visitor)	Accept a visitor (e.g.
MergeUpdateClause	set(String column, boolean literal)	Update a column with a boolean value.
MergeUpdateClause	set(String column, char literal)	Update a column with a char value.
MergeUpdateClause	set(String column, double literal)	Update a column with a double value.
MergeUpdateClause	set(String column, float literal)	Update a column with a float value.
MergeUpdateClause	set(String column, int literal)	Update a column with an integer value.
MergeUpdateClause	set(String column, long literal)	Update a column with a long value.
MergeUpdateClause	set(String column, ValueExpression expression)	Update a column with a value expression.
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.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,
                             char literal)

Update a column with a char value.

Parameters:

column - column to be updated

literal - char 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

set

public MergeUpdateClause set(String column,
                             long literal)

Update a column with a long value.

Parameters:

column - column to be updated

literal - long literal

Returns:

this for fluent programming

set

public MergeUpdateClause set(String column,
                             double literal)

Update a column with a double value.

Parameters:

column - column to be updated

literal - double literal

Returns:

this for fluent programming

set

public MergeUpdateClause set(String column,
                             float literal)

Update a column with a float value.

Parameters:

column - column to be updated

literal - float literal

Returns:

this for fluent programming

set

public MergeUpdateClause set(String column,
                             boolean literal)

Update a column with a boolean value.

Parameters:

column - column to be updated

literal - boolean 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