/*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
* Other licenses:
* -----------------------------------------------------------------------------
* Commercial licenses for this work are available. These replace the above
* ASL 2.0 and offer limited warranties, support, maintenance, and commercial
* database integrations.
*
* For more information, please visit: http://www.jooq.org/licenses
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*/
package org.jooq;
import static org.jooq.SQLDialect.CUBRID;
// ...
import static org.jooq.SQLDialect.DERBY;
import static org.jooq.SQLDialect.FIREBIRD;
import static org.jooq.SQLDialect.H2;
// ...
import static org.jooq.SQLDialect.HSQLDB;
// ...
// ...
// ...
// ...
// ...
import java.util.Collection;
import org.jetbrains.annotations.NotNull;
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();
Author: Lukas Eder
/**
* This type is used for the {@link Merge}'s DSL API.
* <p>
* Example: <code><pre>
* 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();
* </pre></code>
*
* @author Lukas Eder
*/
public interface MergeNotMatchedStep<R extends Record> extends MergeFinalStep<R> {
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement.
Unlike the whenNotMatchedThenInsert(Field...)
and whenNotMatchedThenInsert(Collection)
methods, this will give access to a MySQL-like API allowing for INSERT SET a = x, b = y
syntax.
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement.
* <p>
* Unlike the {@link #whenNotMatchedThenInsert(Field...)} and
* {@link #whenNotMatchedThenInsert(Collection)} methods, this will give
* access to a MySQL-like API allowing for
* <code>INSERT SET a = x, b = y</code> syntax.
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
MergeNotMatchedSetStep<R> whenNotMatchedThenInsert();
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1> MergeNotMatchedValuesStep1<R, T1> whenNotMatchedThenInsert(Field<T1> field1);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2> MergeNotMatchedValuesStep2<R, T1, T2> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3> MergeNotMatchedValuesStep3<R, T1, T2, T3> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4> MergeNotMatchedValuesStep4<R, T1, T2, T3, T4> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5> MergeNotMatchedValuesStep5<R, T1, T2, T3, T4, T5> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6> MergeNotMatchedValuesStep6<R, T1, T2, T3, T4, T5, T6> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7> MergeNotMatchedValuesStep7<R, T1, T2, T3, T4, T5, T6, T7> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8> MergeNotMatchedValuesStep8<R, T1, T2, T3, T4, T5, T6, T7, T8> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8, T9> MergeNotMatchedValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> MergeNotMatchedValuesStep10<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> MergeNotMatchedValuesStep11<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> MergeNotMatchedValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> MergeNotMatchedValuesStep13<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> MergeNotMatchedValuesStep14<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> MergeNotMatchedValuesStep15<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> MergeNotMatchedValuesStep16<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> MergeNotMatchedValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> MergeNotMatchedValuesStep18<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> MergeNotMatchedValuesStep19<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> MergeNotMatchedValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> MergeNotMatchedValuesStep21<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> MergeNotMatchedValuesStep22<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22);
Add the WHEN NOT MATCHED THEN INSERT
clause to the
MERGE
statement
/**
* Add the <code>WHEN NOT MATCHED THEN INSERT</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
MergeNotMatchedValuesStepN<R> whenNotMatchedThenInsert(Field<?>... fields);
Add the WHEN MATCHED THEN UPDATE
clause to the
MERGE
statement
/**
* Add the <code>WHEN MATCHED THEN UPDATE</code> clause to the
* <code>MERGE</code> statement
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB })
MergeNotMatchedValuesStepN<R> whenNotMatchedThenInsert(Collection<? extends Field<?>> fields);
}