Package com.exasol.sql.dml.merge
Class MergeInsertClause
- 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 theMERGE
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 aMergeInsertClause
.
-
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 theWHERE
clause of the insert definition.boolean
hasWhere()
Check if theWHERE
clause exists.protected MergeInsertClause
self()
Generic self pointer.Merge
where(BooleanExpression expression)
Add aWHERE
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
-
-
-
-
Field Detail
-
where
protected WhereClause where
WHERE
clause
-
-
Constructor Detail
-
MergeInsertClause
public MergeInsertClause(Fragment root)
Create a new instance of aMergeInsertClause
.- Parameters:
root
- root SQL statement thisTHEN INSERT
clause belongs to
-
-
Method Detail
-
self
protected MergeInsertClause self()
Description copied from class:AbstractInsertValueTable
Generic self pointer.- Specified by:
self
in classAbstractInsertValueTable<MergeInsertClause>
- Returns:
- self pointer.
-
where
public Merge where(BooleanExpression expression)
Add aWHERE
clause insertion definition.- Parameters:
expression
- filter expression- Returns:
- parent
MERGE
statement
-
getWhere
public WhereClause getWhere()
Get theWHERE
clause of the insert definition.- Returns:
WHERE
clause
-
hasWhere
public boolean hasWhere()
Check if theWHERE
clause exists.- Returns:
true
if theWHERE
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 interfaceMergeFragment
- Parameters:
visitor
- visitor to accept
-
-