org.jooq.MergeNotMatchedStep Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of adyen-plugin Show documentation
Kill Bill ADYEN SA plugin
There is a newer version: 0.10.0
/**
 * Copyright (c) 2009-2014, Data Geekery GmbH (http://www.datageekery.com)
 * All rights reserved.
 *
 * This work is dual-licensed
 * - under the Apache Software License 2.0 (the "ASL")
 * - under the jOOQ License and Maintenance Agreement (the "jOOQ License")
 * =============================================================================
 * You may choose which license applies to you:
 *
 * - If you're using this work with Open Source databases, you may choose
 *   either ASL or jOOQ License.
 * - If you're using this work with at least one commercial database, you must
 *   choose jOOQ License
 *
 * For more information, please visit http://www.jooq.org/licenses
 *
 * Apache Software License 2.0:
 * -----------------------------------------------------------------------------
 * 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.
 *
 * jOOQ License and Maintenance Agreement:
 * -----------------------------------------------------------------------------
 * Data Geekery grants the Customer the non-exclusive, timely limited and
 * non-transferable license to install and use the Software under the terms of
 * the jOOQ License and Maintenance Agreement.
 *
 * This library is distributed with a LIMITED WARRANTY. See the jOOQ License
 * and Maintenance Agreement for more details: http://www.jooq.org/licensing
 */
package org.jooq;

import static org.jooq.SQLDialect.CUBRID;
// ...
import static org.jooq.SQLDialect.HSQLDB;
// ...
// ...
// ...

import java.util.Collection;

import javax.annotation.Generated;

/**
 * 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
 */
@Generated("This class was generated using jOOQ-tools")
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.
     */
    @Support({ CUBRID, HSQLDB })
    MergeNotMatchedSetStep whenNotMatchedThenInsert();

    /**
     * Add the WHEN NOT MATCHED THEN INSERT clause to the
     * MERGE statement
     */
    @Support({ CUBRID, HSQLDB })
     MergeNotMatchedValuesStep1 whenNotMatchedThenInsert(Field field1);

    /**
     * Add the WHEN NOT MATCHED THEN INSERT clause to the
     * MERGE statement
     */
    @Support({ CUBRID, HSQLDB })
     MergeNotMatchedValuesStep2 whenNotMatchedThenInsert(Field field1, Field field2);

    /**
     * Add the WHEN NOT MATCHED THEN INSERT clause to the
     * MERGE statement
     */
    @Support({ CUBRID, HSQLDB })
     MergeNotMatchedValuesStep3 whenNotMatchedThenInsert(Field field1, Field field2, Field field3);

    /**
     * Add the WHEN NOT MATCHED THEN INSERT clause to the
     * MERGE statement
     */
    @Support({ CUBRID, HSQLDB })
     MergeNotMatchedValuesStep4 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4);

    /**
     * Add the WHEN NOT MATCHED THEN INSERT clause to the
     * MERGE statement
     */
    @Support({ CUBRID, HSQLDB })
     MergeNotMatchedValuesStep5 whenNotMatchedThenInsert(Field field1, Field field2, Field field3, Field field4, Field field5);

    /**
     * Add the WHEN NOT MATCHED THEN INSERT clause to the
     * MERGE statement
     */
    @Support({ CUBRID, HSQLDB })
     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
     */
    @Support({ CUBRID, HSQLDB })
     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
     */
    @Support({ CUBRID, HSQLDB })
     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
     */
    @Support({ CUBRID, HSQLDB })
     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
     */
    @Support({ CUBRID, HSQLDB })
     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
     */
    @Support({ CUBRID, HSQLDB })
     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
     */
    @Support({ CUBRID, HSQLDB })
     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
     */
    @Support({ CUBRID, HSQLDB })
     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
     */
    @Support({ CUBRID, HSQLDB })
     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
     */
    @Support({ CUBRID, HSQLDB })
     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
     */
    @Support({ CUBRID, HSQLDB })
     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
     */
    @Support({ CUBRID, HSQLDB })
     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
     */
    @Support({ CUBRID, HSQLDB })
     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
     */
    @Support({ CUBRID, HSQLDB })
     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
     */
    @Support({ CUBRID, HSQLDB })
     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 field17, Field field18, Field field19, Field field20);

    /**
     * Add the WHEN NOT MATCHED THEN INSERT clause to the
     * MERGE statement
     */
    @Support({ CUBRID, HSQLDB })
     MergeNotMatchedValuesStep21 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, Field field20, Field field21);

    /**
     * Add the WHEN NOT MATCHED THEN INSERT clause to the
     * MERGE statement
     */
    @Support({ CUBRID, HSQLDB })
     MergeNotMatchedValuesStep22 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, Field field20, Field field21, Field field22);

    /**
     * Add the WHEN NOT MATCHED THEN INSERT clause to the
     * MERGE statement
     */
    @Support({ CUBRID, HSQLDB })
    MergeNotMatchedValuesStepN whenNotMatchedThenInsert(Field... fields);

    /**
     * Add the WHEN MATCHED THEN UPDATE clause to the
     * MERGE statement
     */
    @Support({ CUBRID, HSQLDB })
    MergeNotMatchedValuesStepN whenNotMatchedThenInsert(Collection> fields);
}