MergeInsertClause (Exasol SQL Statement Builder 4.5.3 API)

java.lang.Object
- com.exasol.sql.AbstractFragment
- - com.exasol.sql.dml.insert.AbstractInsertValueTable<MergeInsertClause>
  - - com.exasol.sql.dml.merge.MergeInsertClause

All Implemented Interfaces:

MergeFragment, Fragment
```
public class MergeInsertClause
extends AbstractInsertValueTable<MergeInsertClause>
implements MergeFragment
```
Represents the MERGE strategy of inserting rows from the source that do not match any row in the destination.

Field Summary

Fields
Modifier and Type Field Description

protected WhereClause where
WHERE clause
- Fields inherited from class com.exasol.sql.dml.insert.AbstractInsertValueTable
  insertFields, insertValueTable
- Fields inherited from class com.exasol.sql.AbstractFragment
  root

Constructor Summary

Constructors
Constructor Description

MergeInsertClause(Fragment root)
Create a new instance of a MergeInsertClause.

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`void`	`accept(MergeVisitor visitor)`	Accept a visitor (e.g.
`WhereClause`	`getWhere()`	Get the `WHERE` clause of the insert definition.
`boolean`	`hasWhere()`	Check if the `WHERE` clause exists.
`protected MergeInsertClause`	`self()`	Generic self pointer.
`Merge`	`where(BooleanExpression expression)`	Add a `WHERE` clause insertion definition.

Methods inherited from class com.exasol.sql.dml.insert.AbstractInsertValueTable
createInsertValueInstanceIfItDoesNotExist, field, hasFields, hasValues, valuePlaceholder, valuePlaceholders, values, values, values, valueTable

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

- Field Detail
  - where
```
protected WhereClause where
```
    WHERE clause
- Constructor Detail
  - MergeInsertClause
```
public MergeInsertClause(Fragment root)
```
    Create a new instance of a MergeInsertClause.
    
    Parameters:
    
    root - root SQL statement this THEN INSERT clause belongs to
- Method Detail
  - self
```
protected MergeInsertClause self()
```
    Description copied from class: AbstractInsertValueTable
    
    Generic self pointer.
    
    Specified by:
    
    self in class AbstractInsertValueTable<MergeInsertClause>
    
    Returns:
    
    self pointer.
  - where
```
public Merge where(BooleanExpression expression)
```
    Add a WHERE clause insertion definition.
    
    Parameters:
    
    expression - filter expression
    
    Returns:
    
    parent MERGE statement
  - getWhere
```
public WhereClause getWhere()
```
    Get the WHERE clause of the insert definition.
    
    Returns:
    
    WHERE clause
  - hasWhere
```
public boolean hasWhere()
```
    Check if the WHERE clause exists.
    
    Returns:
    
    true if the WHERE clause exists
  - 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