/* * 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.impl; import static org.jooq.impl.DSL.condition; import static org.jooq.impl.DSL.exists; import static org.jooq.impl.DSL.not; import static org.jooq.impl.DSL.notExists; import static org.jooq.impl.Tools.EMPTY_FIELD; import java.util.Arrays; import java.util.Collection; import java.util.List; import java.util.Map; import java.util.Optional; import javax.annotation.Generated; import org.jooq.Condition; import org.jooq.Configuration; import org.jooq.Field; import org.jooq.FieldLike; import org.jooq.InsertOnDuplicateSetMoreStep; import org.jooq.InsertOnConflictConditionStep; import org.jooq.InsertOnConflictDoUpdateStep; import org.jooq.InsertQuery; import org.jooq.InsertResultStep; import org.jooq.InsertSetMoreStep; import org.jooq.InsertSetStep; import org.jooq.InsertValuesStep1; import org.jooq.InsertValuesStep2; import org.jooq.InsertValuesStep3; import org.jooq.InsertValuesStep4; import org.jooq.InsertValuesStep5; import org.jooq.InsertValuesStep6; import org.jooq.InsertValuesStep7; import org.jooq.InsertValuesStep8; import org.jooq.InsertValuesStep9; import org.jooq.InsertValuesStep10; import org.jooq.InsertValuesStep11; import org.jooq.InsertValuesStep12; import org.jooq.InsertValuesStep13; import org.jooq.InsertValuesStep14; import org.jooq.InsertValuesStep15; import org.jooq.InsertValuesStep16; import org.jooq.InsertValuesStep17; import org.jooq.InsertValuesStep18; import org.jooq.InsertValuesStep19; import org.jooq.InsertValuesStep20; import org.jooq.InsertValuesStep21; import org.jooq.InsertValuesStep22; import org.jooq.InsertValuesStepN; import org.jooq.Operator; import org.jooq.QueryPart; import org.jooq.Record; import org.jooq.Record1; import org.jooq.Result; import org.jooq.Select; import org.jooq.SQL; import org.jooq.Table; /** * @author Lukas Eder */ @SuppressWarnings({ "rawtypes", "unchecked" }) @Generated("This class was generated using jOOQ-tools") class InsertImpl<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> extends AbstractDelegatingQuery<InsertQuery<R>> implements // Cascading interface implementations for Insert behaviour InsertValuesStep1<R, T1>, InsertValuesStep2<R, T1, T2>, InsertValuesStep3<R, T1, T2, T3>, InsertValuesStep4<R, T1, T2, T3, T4>, InsertValuesStep5<R, T1, T2, T3, T4, T5>, InsertValuesStep6<R, T1, T2, T3, T4, T5, T6>, InsertValuesStep7<R, T1, T2, T3, T4, T5, T6, T7>, InsertValuesStep8<R, T1, T2, T3, T4, T5, T6, T7, T8>, InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9>, InsertValuesStep10<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>, InsertValuesStep11<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>, InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>, InsertValuesStep13<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>, InsertValuesStep14<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>, InsertValuesStep15<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>, InsertValuesStep16<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>, InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>, InsertValuesStep18<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>, InsertValuesStep19<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>, InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>, InsertValuesStep21<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>, InsertValuesStep22<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>, InsertValuesStepN<R>, InsertSetStep<R>, InsertSetMoreStep<R>, InsertOnDuplicateSetMoreStep<R>, InsertOnConflictDoUpdateStep<R>, InsertOnConflictConditionStep<R>, InsertResultStep<R> { /** * Generated UID */ private static final long serialVersionUID = 4222898879771679107L; private final Table<R> into; private Field<?>[] fields; private boolean onDuplicateKeyUpdate; InsertImpl(Configuration configuration, WithImpl with, Table<R> into) { super(new InsertQueryImpl<R>(configuration, with, into)); this.into = into; } InsertImpl(Configuration configuration, WithImpl with, Table<R> into, Collection<? extends Field<?>> fields) { this(configuration, with, into); columns(fields); } // ------------------------------------------------------------------------- // The DSL API // ------------------------------------------------------------------------- @Override public final InsertImpl select(Select select) { getDelegate().setSelect(fields, select); return this; } @Override public final InsertImpl values(T1 value1) { return values(new Object[] { value1 }); } @Override public final InsertImpl values(T1 value1, T2 value2) { return values(new Object[] { value1, value2 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3) { return values(new Object[] { value1, value2, value3 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4) { return values(new Object[] { value1, value2, value3, value4 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5) { return values(new Object[] { value1, value2, value3, value4, value5 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6) { return values(new Object[] { value1, value2, value3, value4, value5, value6 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8, value9 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13, T14 value14) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13, T14 value14, T15 value15) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13, T14 value14, T15 value15, T16 value16) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13, T14 value14, T15 value15, T16 value16, T17 value17) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13, T14 value14, T15 value15, T16 value16, T17 value17, T18 value18) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17, value18 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13, T14 value14, T15 value15, T16 value16, T17 value17, T18 value18, T19 value19) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17, value18, value19 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13, T14 value14, T15 value15, T16 value16, T17 value17, T18 value18, T19 value19, T20 value20) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17, value18, value19, value20 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13, T14 value14, T15 value15, T16 value16, T17 value17, T18 value18, T19 value19, T20 value20, T21 value21) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17, value18, value19, value20, value21 }); } @Override public final InsertImpl values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9, T10 value10, T11 value11, T12 value12, T13 value13, T14 value14, T15 value15, T16 value16, T17 value17, T18 value18, T19 value19, T20 value20, T21 value21, T22 value22) { return values(new Object[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17, value18, value19, value20, value21, value22 }); } @Override public final InsertImpl values(Object... values) { if (fields.length != values.length) { throw new IllegalArgumentException("The number of values must match the number of fields"); } getDelegate().newRecord(); for (int i = 0; i < fields.length; i++) { addValue(getDelegate(), fields[i], values[i]); } return this; } @Override public final InsertImpl values(Collection<?> values) { return values(values.toArray()); } private <T> void addValue(InsertQuery<R> delegate, Field<T> field, Object object) { // [#1343] Only convert non-jOOQ objects if (object instanceof Field) { delegate.addValue(field, (Field<T>) object); } else if (object instanceof FieldLike) { delegate.addValue(field, ((FieldLike) object).<T>asField()); } else { delegate.addValue(field, field.getDataType().convert(object)); } } @Override public final InsertImpl values(Field<T1> value1) { return values(new Field[] { value1 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2) { return values(new Field[] { value1, value2 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3) { return values(new Field[] { value1, value2, value3 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4) { return values(new Field[] { value1, value2, value3, value4 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5) { return values(new Field[] { value1, value2, value3, value4, value5 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6) { return values(new Field[] { value1, value2, value3, value4, value5, value6 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8, value9 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13, Field<T14> value14) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13, Field<T14> value14, Field<T15> value15) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13, Field<T14> value14, Field<T15> value15, Field<T16> value16) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13, Field<T14> value14, Field<T15> value15, Field<T16> value16, Field<T17> value17) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13, Field<T14> value14, Field<T15> value15, Field<T16> value16, Field<T17> value17, Field<T18> value18) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17, value18 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13, Field<T14> value14, Field<T15> value15, Field<T16> value16, Field<T17> value17, Field<T18> value18, Field<T19> value19) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17, value18, value19 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13, Field<T14> value14, Field<T15> value15, Field<T16> value16, Field<T17> value17, Field<T18> value18, Field<T19> value19, Field<T20> value20) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17, value18, value19, value20 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13, Field<T14> value14, Field<T15> value15, Field<T16> value16, Field<T17> value17, Field<T18> value18, Field<T19> value19, Field<T20> value20, Field<T21> value21) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17, value18, value19, value20, value21 }); } @Override public final InsertImpl values(Field<T1> value1, Field<T2> value2, Field<T3> value3, Field<T4> value4, Field<T5> value5, Field<T6> value6, Field<T7> value7, Field<T8> value8, Field<T9> value9, Field<T10> value10, Field<T11> value11, Field<T12> value12, Field<T13> value13, Field<T14> value14, Field<T15> value15, Field<T16> value16, Field<T17> value17, Field<T18> value18, Field<T19> value19, Field<T20> value20, Field<T21> value21, Field<T22> value22) { return values(new Field[] { value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15, value16, value17, value18, value19, value20, value21, value22 }); } @Override public final InsertImpl values(Field<?>... values) { List<Field<?>> values1 = Arrays.asList(values); if (fields.length != values1.size()) { throw new IllegalArgumentException("The number of values must match the number of fields"); } getDelegate().newRecord(); for (int i = 0; i < fields.length; i++) { // javac has trouble when inferring Object for T. Use Void instead getDelegate().addValue((Field<Void>) fields[i], (Field<Void>) values1.get(i)); } return this; } @Override @SuppressWarnings("hiding") public final <T1> InsertImpl columns(Field<T1> field1) { return columns(new Field[] { field1 }); } @Override @SuppressWarnings("hiding") public final <T1, T2> InsertImpl columns(Field<T1> field1, Field<T2> field2) { return columns(new Field[] { field1, field2 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3> InsertImpl columns(Field<T1> field1, Field<T2> field2, Field<T3> field3) { return columns(new Field[] { field1, field2, field3 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4> InsertImpl columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) { return columns(new Field[] { field1, field2, field3, field4 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5> InsertImpl columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) { return columns(new Field[] { field1, field2, field3, field4, field5 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6> InsertImpl columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) { return columns(new Field[] { field1, field2, field3, field4, field5, field6 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7> InsertImpl columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8> InsertImpl columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8, T9> InsertImpl columns(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) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8, field9 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> InsertImpl columns(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) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8, field9, field10 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> InsertImpl columns(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) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> InsertImpl columns(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) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> InsertImpl columns(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) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> InsertImpl columns(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) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> InsertImpl columns(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) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14, field15 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> InsertImpl columns(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) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14, field15, field16 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> InsertImpl columns(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) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14, field15, field16, field17 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> InsertImpl columns(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) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14, field15, field16, field17, field18 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> InsertImpl columns(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) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14, field15, field16, field17, field18, field19 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> InsertImpl columns(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) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14, field15, field16, field17, field18, field19, field20 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> InsertImpl columns(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) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14, field15, field16, field17, field18, field19, field20, field21 }); } @Override @SuppressWarnings("hiding") public final <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> InsertImpl columns(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) { return columns(new Field[] { field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14, field15, field16, field17, field18, field19, field20, field21, field22 }); } @Override public final InsertImpl columns(Field<?>... f) { this.fields = (f == null || f.length == 0) ? into.fields() : f; return this; } @Override public final InsertImpl columns(Collection<? extends Field<?>> f) { return columns(f.toArray(EMPTY_FIELD)); } /** * Add an empty record with default values. */ @Override public final InsertImpl defaultValues() { getDelegate().setDefaultValues(); return this; } @Override public final InsertImpl doUpdate() { return onDuplicateKeyUpdate(); } @Override public final InsertImpl doNothing() { return onDuplicateKeyIgnore(); } @Override public final InsertImpl onConflict(Field<?>... keys) { return onConflict(Arrays.asList(keys)); } @Override public final InsertImpl onConflict(Collection<? extends Field<?>> keys) { getDelegate().onConflict(keys); return this; } @Override public final InsertImpl onConflictDoNothing() { onConflict().doNothing(); return this; } @Override public final InsertImpl onDuplicateKeyUpdate() { onDuplicateKeyUpdate = true; getDelegate().onDuplicateKeyUpdate(true); return this; } @Override public final InsertImpl onDuplicateKeyIgnore() { getDelegate().onDuplicateKeyIgnore(true); return this; } @Override public final <T> InsertImpl set(Field<T> field, T value) { if (onDuplicateKeyUpdate) { getDelegate().addValueForUpdate(field, value); } else { getDelegate().addValue(field, value); } return this; } @Override public final <T> InsertImpl set(Field<T> field, Field<T> value) { if (onDuplicateKeyUpdate) { getDelegate().addValueForUpdate(field, value); } else { getDelegate().addValue(field, value); } return this; } @Override public final <T> InsertImpl set(Field<T> field, Select<? extends Record1<T>> value) { return set(field, value.<T>asField()); } @Override public final InsertImpl set(Map<? extends Field<?>, ?> map) { if (onDuplicateKeyUpdate) { getDelegate().addValuesForUpdate(map); } else { getDelegate().addValues(map); } return this; } @Override public final InsertImpl set(Record record) { return set(Tools.mapOfChangedValues(record)); } @Override public final InsertImpl and(Condition condition) { getDelegate().addConditions(condition); return this; } @Override public final InsertImpl and(Field<Boolean> condition) { return and(condition(condition)); } @Override public final InsertImpl and(SQL sql) { return and(condition(sql)); } @Override public final InsertImpl and(String sql) { return and(condition(sql)); } @Override public final InsertImpl and(String sql, Object... bindings) { return and(condition(sql, bindings)); } @Override public final InsertImpl and(String sql, QueryPart... parts) { return and(condition(sql, parts)); } @Override public final InsertImpl andNot(Condition condition) { return and(not(condition)); } @Override public final InsertImpl andNot(Field<Boolean> condition) { return and(not(condition(condition))); } @Override public final InsertImpl andExists(Select<?> select) { return and(exists(select)); } @Override public final InsertImpl andNotExists(Select<?> select) { return and(notExists(select)); } @Override public final InsertImpl or(Condition condition) { getDelegate().addConditions(Operator.OR, condition); return this; } @Override public final InsertImpl or(Field<Boolean> condition) { return or(condition(condition)); } @Override public final InsertImpl or(SQL sql) { return or(condition(sql)); } @Override public final InsertImpl or(String sql) { return or(condition(sql)); } @Override public final InsertImpl or(String sql, Object... bindings) { return or(condition(sql, bindings)); } @Override public final InsertImpl or(String sql, QueryPart... parts) { return or(condition(sql, parts)); } @Override public final InsertImpl orNot(Condition condition) { return or(not(condition)); } @Override public final InsertImpl orNot(Field<Boolean> condition) { return or(not(condition(condition))); } @Override public final InsertImpl orExists(Select<?> select) { return or(exists(select)); } @Override public final InsertImpl orNotExists(Select<?> select) { return or(notExists(select)); } @Override public final InsertImpl where(Condition... conditions) { getDelegate().addConditions(conditions); return this; } @Override public final InsertImpl where(Collection<? extends Condition> conditions) { getDelegate().addConditions(conditions); return this; } @Override public final InsertImpl where(Field<Boolean> field) { return where(condition(field)); } @Override public final InsertImpl where(SQL sql) { return where(condition(sql)); } @Override public final InsertImpl where(String sql) { return where(condition(sql)); } @Override public final InsertImpl where(String sql, Object... bindings) { return where(condition(sql, bindings)); } @Override public final InsertImpl where(String sql, QueryPart... parts) { return where(condition(sql, parts)); } @Override public final InsertImpl whereExists(Select<?> select) { return where(exists(select)); } @Override public final InsertImpl whereNotExists(Select<?> select) { return where(notExists(select)); } @Override public final InsertImpl newRecord() { getDelegate().newRecord(); return this; } @Override public final InsertImpl returning() { getDelegate().setReturning(); return this; } @Override public final InsertImpl returning(Field<?>... f) { getDelegate().setReturning(f); return this; } @Override public final InsertImpl returning(Collection<? extends Field<?>> f) { getDelegate().setReturning(f); return this; } @Override public final Result<R> fetch() { getDelegate().execute(); return getDelegate().getReturnedRecords(); } @Override public final R fetchOne() { getDelegate().execute(); return getDelegate().getReturnedRecord(); } @Override public final Optional<R> fetchOptional() { return Optional.ofNullable(fetchOne()); } }