Top Description Methods
org.jooq

public Interface InsertValuesStep17<R extends org.jooq.Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>

extends InsertOnDuplicateStep<R extends Record>
Known Direct Implementers
org.jooq.impl.InsertImpl
Imports
java.util.Collection, java.util.function.Function, org.jetbrains.annotations.NotNull

Deprecated

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

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

Example: 


using(configuration)
      .insertInto(table, field1, field2, field3, .., field16, field17)
      .values(valueA1, valueA2, valueA3, .., valueA16, valueA17)
      .values(valueB1, valueB2, valueB3, .., valueB16, valueB17)
      .onDuplicateKeyUpdate()
      .set(field1, value1)
      .set(field2, value2)
      .execute();
Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull InsertOnDuplicateStep<R>
select(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select)

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
Use a SELECT statement as the source of values for the INSERT statement

This variant of the INSERT … SELECT statement expects a select returning exactly as many fields as specified previously in the INTO clause: DSLContext#insertInto(Table, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)

public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
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)

Deprecated as a consequence of InsertValuesStep17 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
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)

Deprecated as a consequence of Field and InsertValuesStep17 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
values(Collection<?> values)

Deprecated as a consequence of InsertValuesStep17 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
values(Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> values)

Deprecated as a consequence of InsertValuesStep17 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
values(Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> values)

Deprecated as a consequence of InsertValuesStep17 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
valuesOfRecords(Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>... values)

Deprecated as a consequence of InsertValuesStep17 being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
valuesOfRecords(Collection<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> values)

Deprecated as a consequence of InsertValuesStep17 being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
valuesOfRows(Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>... values)

Deprecated as a consequence of InsertValuesStep17 being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
valuesOfRows(Collection<? extends Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> values)

Deprecated as a consequence of InsertValuesStep17 being deprecated.
Add multiple rows of values to the insert statement.
Inherited from org.jooq.InsertOnDuplicateStep:
onConflictonConflictonConflictDoNothingonConflictOnConstraintonConflictOnConstraintonConflictOnConstraintonDuplicateKeyIgnoreonDuplicateKeyUpdate

Method Detail

selectback to summary
public @NotNull InsertOnDuplicateStep<R> select(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select)

Deprecated

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

Use a SELECT statement as the source of values for the INSERT statement

This variant of the INSERT … SELECT statement expects a select returning exactly as many fields as specified previously in the INTO clause: DSLContext#insertInto(Table, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)

Annotations
@NotNull
@CheckReturnValue
@Support
valuesback to summary
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> 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)

Deprecated

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

Add a single row of values to the insert statement.

Annotations
@NotNull
@CheckReturnValue
@Support
valuesback to summary
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> 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)

Deprecated

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

Add a single row of values to the insert statement.

Annotations
@NotNull
@CheckReturnValue
@Support
valuesback to summary
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> values(Collection<?> values)

Deprecated

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

Add a single row of values to the insert statement.

Annotations
@NotNull
@CheckReturnValue
@Support
valuesback to summary
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> values(Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> values)

Deprecated

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

Add a single row of values to the insert statement.

Annotations
@NotNull
@CheckReturnValue
@Support
valuesback to summary
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> values(Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> values)

Deprecated

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

Add a single row of values to the insert statement.

Annotations
@NotNull
@CheckReturnValue
@Support
valuesOfRecordsback to summary
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> valuesOfRecords(Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>... values)

Deprecated

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

Add multiple rows of values to the insert statement.

This is equivalent to calling the other values clauses multiple times, but allows for dynamic construction of row arrays.

Note

Irrespective of individual Record#changed() flag values, all record values are copied to the VALUES clause using Record#intoArray(), to match insert columns by position, not by name.

Annotations
@NotNull
@CheckReturnValue
@Support
@SuppressWarnings:unchecked
valuesOfRecordsback to summary
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> valuesOfRecords(Collection<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> values)

Deprecated

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

Add multiple rows of values to the insert statement.

This is equivalent to calling the other values clauses multiple times, but allows for dynamic construction of row arrays.

Note

Irrespective of individual Record#changed() flag values, all record values are copied to the VALUES clause using Record#intoArray(), to match insert columns by position, not by name.

Annotations
@NotNull
@CheckReturnValue
@Support
valuesOfRowsback to summary
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> valuesOfRows(Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>... values)

Deprecated

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

Add multiple rows of values to the insert statement.

This is equivalent to calling the other values clauses multiple times, but allows for dynamic construction of row arrays.

Annotations
@NotNull
@CheckReturnValue
@Support
@SuppressWarnings:unchecked
See Also
Rows#toRowArray(Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function)
valuesOfRowsback to summary
public @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> valuesOfRows(Collection<? extends Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> values)

Deprecated

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

Add multiple rows of values to the insert statement.

This is equivalent to calling the other values clauses multiple times, but allows for dynamic construction of row arrays.

Annotations
@NotNull
@CheckReturnValue
@Support
See Also
Rows#toRowList(Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function, Function)