jOOQ 3.18.7 · org.jooq.MergeMatchedStep

This type is used for the Merge's DSL API.

Example:


DSLContext create = DSL.using(configuration);

create.mergeInto(table)
      .using(select)
      .on(condition)
      .whenMatchedThenUpdate()
      .set(field1, value1)
      .set(field2, value2)
      .whenNotMatchedThenInsert(field1, field2)
      .values(value1, value2)
      .execute();

Referencing `XYZ*Step` types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

They're operating on mutable implementations (as of jOOQ 3.x)
They're less composable and not easy to get right when dynamic SQL gets complex
They're less readable
They might have binary incompatible changes between minor releases

Modifier and Type	Method and Description
public @NotNull MergeMatchedThenStep<R>	whenMatchedAnd(Condition condition) Deprecated as a consequence of `Condition` being deprecated. Add the `WHEN MATCHED AND` clause to the `MERGE` statement.
public @NotNull MergeMatchedThenStep<R>	whenMatchedAnd(Field<Boolean> condition) Deprecated as a consequence of `Field` being deprecated. Add the `WHEN MATCHED AND` clause to the `MERGE` statement.
public @NotNull MergeMatchedThenStep<R>	whenMatchedAnd(SQL sql) Add the `WHEN MATCHED AND` clause to the `MERGE` statement.
public @NotNull MergeMatchedThenStep<R>	whenMatchedAnd(String sql) Add the `WHEN MATCHED AND` clause to the `MERGE` statement.
public @NotNull MergeMatchedThenStep<R>	whenMatchedAnd(String sql, Object... bindings) Add the `WHEN MATCHED AND` clause to the `MERGE` statement.
public @NotNull MergeMatchedThenStep<R>	whenMatchedAnd(String sql, QueryPart... parts) Add the `WHEN MATCHED AND` clause to the `MERGE` statement.
public @NotNull MergeMatchedStep<R>	whenMatchedThenDelete() Deprecated as a consequence of `MergeMatchedStep` being deprecated. Add the `WHEN MATCHED THEN DELETE` clause to the `MERGE` statement.
public @NotNull MergeMatchedSetStep<R>	whenMatchedThenUpdate() Add the `WHEN MATCHED THEN UPDATE` clause to the `MERGE` statement.

Method Detail

whenMatchedAnd back to summary

whenMatchedAnd	back to summary
public @NotNull MergeMatchedThenStep<R> whenMatchedAnd(Condition condition) Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Add the `WHEN MATCHED AND` clause to the `MERGE` statement. Annotations @NotNull @CheckReturnValue @Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES

public @NotNull MergeMatchedThenStep<R> whenMatchedAnd(Condition condition)

Deprecated

as a consequence of Condition being deprecated. See corresponding docs for further information.

Add the WHEN MATCHED AND clause to the MERGE statement.

Annotations

@NotNull
@CheckReturnValue
@Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES

whenMatchedAnd back to summary

whenMatchedAnd	back to summary
public @NotNull MergeMatchedThenStep<R> whenMatchedAnd(Field<Boolean> condition) Deprecated as a consequence of `Field` being deprecated. See corresponding docs for further information. Add the `WHEN MATCHED AND` clause to the `MERGE` statement. Annotations @NotNull @CheckReturnValue @Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES

public @NotNull MergeMatchedThenStep<R> whenMatchedAnd(Field<Boolean> condition)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN MATCHED AND clause to the MERGE statement.

Annotations

@NotNull
@CheckReturnValue
@Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES

whenMatchedAnd back to summary

whenMatchedAnd	back to summary
public @NotNull MergeMatchedThenStep<R> whenMatchedAnd(SQL sql) Add the `WHEN MATCHED AND` clause to the `MERGE` statement. Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! Annotations @PlainSQL @NotNull @CheckReturnValue @Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES See Also `DSL#condition(SQL)`, `SQL`

public @NotNull MergeMatchedThenStep<R> whenMatchedAnd(SQL sql)

Add the WHEN MATCHED AND clause to the MERGE statement.

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Annotations

@PlainSQL
@NotNull
@CheckReturnValue
@Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES

See Also

DSL#condition(SQL), SQL

whenMatchedAnd back to summary

whenMatchedAnd	back to summary
public @NotNull MergeMatchedThenStep<R> whenMatchedAnd(String sql) Add the `WHEN MATCHED AND` clause to the `MERGE` statement. Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! Annotations @PlainSQL @NotNull @CheckReturnValue @Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES See Also `DSL#condition(String)`, `SQL`

public @NotNull MergeMatchedThenStep<R> whenMatchedAnd(String sql)

Add the WHEN MATCHED AND clause to the MERGE statement.

Note

Annotations

@PlainSQL
@NotNull
@CheckReturnValue
@Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES

See Also

DSL#condition(String), SQL

whenMatchedAnd back to summary

whenMatchedAnd	back to summary
public @NotNull MergeMatchedThenStep<R> whenMatchedAnd(String sql, Object... bindings) Add the `WHEN MATCHED AND` clause to the `MERGE` statement. Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! Annotations @PlainSQL @NotNull @CheckReturnValue @Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES See Also `DSL#condition(String, Object...)`, `DSL#sql(String, Object...)`, `SQL`

public @NotNull MergeMatchedThenStep<R> whenMatchedAnd(String sql, Object... bindings)

Add the WHEN MATCHED AND clause to the MERGE statement.

Note

Annotations

@PlainSQL
@NotNull
@CheckReturnValue
@Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES

whenMatchedAnd back to summary

whenMatchedAnd	back to summary
public @NotNull MergeMatchedThenStep<R> whenMatchedAnd(String sql, QueryPart... parts) Add the `WHEN MATCHED AND` clause to the `MERGE` statement. Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! Annotations @PlainSQL @NotNull @CheckReturnValue @Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES See Also `DSL#condition(String, QueryPart...)`, `DSL#sql(String, QueryPart...)`, `SQL`

public @NotNull MergeMatchedThenStep<R> whenMatchedAnd(String sql, QueryPart... parts)

Add the WHEN MATCHED AND clause to the MERGE statement.

Note

Annotations

@PlainSQL
@NotNull
@CheckReturnValue
@Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES

whenMatchedThenDelete back to summary

whenMatchedThenDelete	back to summary
public @NotNull MergeMatchedStep<R> whenMatchedThenDelete() Deprecated as a consequence of `MergeMatchedStep` being deprecated. See corresponding docs for further information. Add the `WHEN MATCHED THEN DELETE` clause to the `MERGE` statement. Annotations @NotNull @CheckReturnValue @Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES

public @NotNull MergeMatchedStep<R> whenMatchedThenDelete()

Deprecated

as a consequence of MergeMatchedStep being deprecated. See corresponding docs for further information.

Add the WHEN MATCHED THEN DELETE clause to the MERGE statement.

Annotations

@NotNull
@CheckReturnValue
@Support:DERBY, FIREBIRD, H2, HSQLDB, POSTGRES

whenMatchedThenUpdate back to summary

whenMatchedThenUpdate	back to summary
public @NotNull MergeMatchedSetStep<R> whenMatchedThenUpdate() Add the `WHEN MATCHED THEN UPDATE` clause to the `MERGE` statement. Annotations @NotNull @CheckReturnValue @Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES

public @NotNull MergeMatchedSetStep<R> whenMatchedThenUpdate()

Add the WHEN MATCHED THEN UPDATE clause to the MERGE statement.

Annotations

@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES

public Interface MergeMatchedStep<R extends org.jooq.Record>

Referencing `XYZ*Step` types directly from client code

Method Summary

Method Detail

public Interface MergeMatchedStep<R extends org.jooq.Record>

Referencing XYZ*Step types directly from client code

Method Summary

Method Detail

Referencing `XYZ*Step` types directly from client code