org.jooq

Interface Merge<R extends Record>

All Superinterfaces:

Attachable, AutoCloseable, org.reactivestreams.Publisher<Integer>, Query, QueryPart, RowCountQuery, Serializable, Statement

All Known Subinterfaces:

MergeFinalStep<R>, MergeMatchedDeleteStep<R>, MergeMatchedSetMoreStep<R>, MergeMatchedStep<R>, MergeMatchedWhereStep<R>, MergeNotMatchedSetMoreStep<R>, MergeNotMatchedStep<R>, MergeNotMatchedWhereStep<R>, MergeOnConditionStep<R>

public interface Merge<R extends Record>
extends RowCountQuery

A MERGE statement.

Example:

 // Assuming import static org.jooq.impl.DSL.*;

 using(configuration)
    .mergeInto(CUSTOMER)
    .using(selectFrom(CUSTOMER_IMPORT))
    .on(CUSTOMER.ID.eq(CUSTOMER_IMPORT.ID))
    .whenMatchedThenUpdate()
    .set(CUSTOMER.FIRST_NAME, CUSTOMER_IMPORT.FIRST_NAME)
    .set(CUSTOMER.LAST_NAME, CUSTOMER_IMPORT.LAST_NAME)
    .whenNotMatchedThenInsert(CUSTOMER.FIRST_NAME, CUSTOMER.LAST_NAME)
    .values(CUSTOMER_IMPORT.FIRST_NAME, CUSTOMER_IMPORT.LAST_NAME)
    .execute();
 

Instances can be created using DSL.mergeInto(Table) and overloads.

Author:

Lukas Eder

Method Summary

Methods inherited from interface org.jooq.Query

bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, poolable, queryTimeout

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Methods inherited from interface org.jooq.Attachable

attach, configuration, detach

Methods inherited from interface org.reactivestreams.Publisher

subscribe