org.jooq.MergeNotMatchedStep Maven / Gradle / Ivy
/*
* 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
*
* https://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: https://www.jooq.org/legal/licensing
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*/
package org.jooq;
import static org.jooq.SQLDialect.*;
import java.util.Collection;
import org.jetbrains.annotations.NotNull;
/**
* This type is used for the {@link 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
*/
public interface MergeNotMatchedStep extends MergeFinalStep {
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement.
*
* Unlike the {@link #whenNotMatchedThenInsert(Field...)} and
* {@link #whenNotMatchedThenInsert(Collection)} methods, this will give
* access to a MySQL-like API allowing for
* INSERT SET a = x, b = y syntax.
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedSetStep whenNotMatchedThenInsert();
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep1 whenNotMatchedThenInsert(Field field1);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep2 whenNotMatchedThenInsert(Field field1, Field field2);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep3 whenNotMatchedThenInsert(Field field1, Field field2, Field field3);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep4 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep5 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep6 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep7 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6, Field field7);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep8 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6, Field field7, Field field8);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep9 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6, Field field7, Field field8, Field field9);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep10 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6, Field field7, Field field8, Field field9, Field field10);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep11 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6, Field field7, Field field8, Field field9, Field field10, Field field11);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep12 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6, Field field7, Field field8, Field field9, Field field10, Field field11, Field field12);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep13 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6, Field field7, Field field8, Field field9, Field field10, Field field11, Field field12, Field field13);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep14 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6, Field field7, Field field8, Field field9, Field field10, Field field11, Field field12, Field field13, Field field14);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep15 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6, Field field7, Field field8, Field field9, Field field10, Field field11, Field field12, Field field13, Field field14, Field field15);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep16 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6, Field field7, Field field8, Field field9, Field field10, Field field11, Field field12, Field field13, Field field14, Field field15, Field field16);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep17 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6, Field field7, Field field8, Field field9, Field field10, Field field11, Field field12, Field field13, Field field14, Field field15, Field field16, Field field17);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep18 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6, Field field7, Field field8, Field field9, Field field10, Field field11, Field field12, Field field13, Field field14, Field field15, Field field16, Field field17, Field field18);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep19 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6, Field field7, Field field8, Field field9, Field field10, Field field11, Field field12, Field field13, Field field14, Field field15, Field field16, Field field17, Field field18, Field field19);
/**
* Add the WHEN NOT MATCHED THEN INSERT clause to the
* MERGE statement
*/
@NotNull @CheckReturnValue
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES })
MergeNotMatchedValuesStep20 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5, Field field6, Field field7, Field field8, Field field9, Field field10, Field field11, Field field12, Field field13, Field field14, Field field15, Field field16, Field