Top Description Methods
org.jooq

public Interface InsertValuesStep9<R extends org.jooq.Record, T1, T2, T3, T4, T5, T6, T7, T8, T9>

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, .., field8, field9)
      .values(valueA1, valueA2, valueA3, .., valueA8, valueA9)
      .values(valueB1, valueB2, valueB3, .., valueB8, valueB9)
      .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 Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> 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)

public @NotNull InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9>
values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9)

Deprecated as a consequence of InsertValuesStep9 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9>
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)

Deprecated as a consequence of Field and InsertValuesStep9 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9>
values(Collection<?> values)

Deprecated as a consequence of InsertValuesStep9 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9>
values(Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> values)

Deprecated as a consequence of InsertValuesStep9 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9>
values(Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9> values)

Deprecated as a consequence of InsertValuesStep9 being deprecated.
Add a single row of values to the insert statement.
public @NotNull InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9>
valuesOfRecords(Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>... values)

Deprecated as a consequence of InsertValuesStep9 being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9>
valuesOfRecords(Collection<? extends Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> values)

Deprecated as a consequence of InsertValuesStep9 being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9>
valuesOfRows(Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9>... values)

Deprecated as a consequence of InsertValuesStep9 being deprecated.
Add multiple rows of values to the insert statement.
public @NotNull InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9>
valuesOfRows(Collection<? extends Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> values)

Deprecated as a consequence of InsertValuesStep9 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 Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> 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)

Annotations
@NotNull
@CheckReturnValue
@Support
valuesback to summary
public @NotNull InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9> values(T1 value1, T2 value2, T3 value3, T4 value4, T5 value5, T6 value6, T7 value7, T8 value8, T9 value9)

Deprecated

as a consequence of InsertValuesStep9 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 InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9> 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)

Deprecated

as a consequence of Field and InsertValuesStep9 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 InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9> values(Collection<?> values)

Deprecated

as a consequence of InsertValuesStep9 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 InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9> values(Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> values)

Deprecated

as a consequence of InsertValuesStep9 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 InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9> values(Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9> values)

Deprecated

as a consequence of InsertValuesStep9 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 InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9> valuesOfRecords(Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>... values)

Deprecated

as a consequence of InsertValuesStep9 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 InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9> valuesOfRecords(Collection<? extends Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> values)

Deprecated

as a consequence of InsertValuesStep9 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 InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9> valuesOfRows(Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9>... values)

Deprecated

as a consequence of InsertValuesStep9 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)
valuesOfRowsback to summary
public @NotNull InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9> valuesOfRows(Collection<? extends Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> values)

Deprecated

as a consequence of InsertValuesStep9 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)