Top Fields Constructors Methods
org.jooq.impl

pack-priv final Class InsertQueryImpl<R extends org.jooq.Record>

extends AbstractStoreQuery<R extends Record, Field<?>, Field<?>>
implements InsertQuery<R extends Record>, QOM.Insert<R extends Record>
Class Inheritance
All Implemented Interfaces
org.jooq.impl.QOM.Insert, org.jooq.DMLQuery, org.jooq.RowCountQuery, org.jooq.Publisher, java.util.concurrent.Flow.Publisher, org.reactivestreams.Publisher, org.jooq.Query, org.jooq.AttachableQueryPart, org.jooq.QueryPart, java.io.Serializable, org.jooq.Attachable, org.jooq.Statement, org.jooq.InsertQuery, org.jooq.ConditionProvider, org.jooq.Insert, org.jooq.StoreQuery
Static Imports
java.lang.Boolean.TRUE, java.util.Arrays.asList, .Collections.nCopies, .Collections.singletonList, java.util.stream.Collectors.toList, org.jooq.Clause.INSERT, .Clause.INSERT_INSERT_INTO, .Clause.INSERT_ON_DUPLICATE_KEY_UPDATE, .Clause.INSERT_ON_DUPLICATE_KEY_UPDATE_ASSIGNMENT, .Clause.INSERT_RETURNING, .SQLDialect.DERBY, .SQLDialect.H2, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, org.jooq.conf.ParamType.INLINED, org.jooq.impl.ConditionProviderImpl.extractCondition, .DSL.constraint, .DSL.falseCondition, .DSL.name, .DSL.one, .DSL.row, .DSL.select, .DSL.selectFrom, .DSL.selectOne, .FieldMapsForInsert.toSQLInsertSelect, .Keywords.K_AS, .Keywords.K_DEFAULT, .Keywords.K_DEFAULT_VALUES, .Keywords.K_DO_NOTHING, .Keywords.K_DO_UPDATE, .Keywords.K_IGNORE, .Keywords.K_INSERT, .Keywords.K_INTO, .Keywords.K_ON_CONFLICT, .Keywords.K_ON_CONSTRAINT, .Keywords.K_ON_DUPLICATE_KEY_UPDATE, .Keywords.K_SET, .Keywords.K_VALUES, .Keywords.K_WHERE, .QueryPartListView.wrap, .Tools.aliasedFields, .Tools.anyMatch, .Tools.collect, .Tools.degree, .Tools.flattenCollection, .Tools.map, .Tools.orElse, .Tools.qualify, .Tools.unqualified, .Tools.BooleanDataKey.DATA_CONSTRAINT_REFERENCE, .Tools.BooleanDataKey.DATA_INSERT_SELECT, .Tools.BooleanDataKey.DATA_INSERT_SELECT_WITHOUT_INSERT_COLUMN_LIST, .Tools.BooleanDataKey.DATA_MANDATORY_WHERE_CLAUSE, .Tools.SimpleDataKey.DATA_ON_DUPLICATE_KEY_WHERE

Deprecated

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

Author
Lukas Eder

Field Summary

Modifier and TypeField and Description
pack-priv static final Clause[]
CLAUSES

Deprecated as a consequence of Clause being deprecated.
pack-priv boolean
defaultValues

pack-priv final FieldMapsForInsert
insertMaps

Deprecated as a consequence of FieldMapsForInsert being deprecated.
pack-priv static final Set<SQLDialect>
NO_SUPPORT_DERIVED_COLUMN_LIST_IN_MERGE_USING

pack-priv static final Set<SQLDialect>
NO_SUPPORT_SUBQUERY_IN_MERGE_USING

pack-priv QueryPartList<Field<?>>
onConflict

pack-priv final ConditionProviderImpl
onConflictWhere

Deprecated as a consequence of ConditionProviderImpl being deprecated.
pack-priv Constraint
onConstraint

Deprecated as a consequence of Constraint being deprecated.
pack-priv UniqueKey<R>
onConstraintUniqueKey

pack-priv boolean
onDuplicateKeyIgnore

pack-priv boolean
onDuplicateKeyUpdate

pack-priv static final Set<SQLDialect>
REQUIRE_NEW_MYSQL_EXCLUDED_EMULATION

pack-priv Select<?>
select

pack-priv static final Set<SQLDialect>
SUPPORT_INSERT_IGNORE

pack-priv static final Set<SQLDialect>
SUPPORTS_OPTIONAL_DO_UPDATE_CONFLICT_TARGETS

pack-priv final FieldMapForUpdate
updateMap

pack-priv final ConditionProviderImpl
updateWhere

Deprecated as a consequence of ConditionProviderImpl being deprecated.

Constructor Summary

AccessConstructor and Description
pack-priv
InsertQueryImpl(Configuration configuration, WithImpl with, Table<R> into)

Method Summary

Modifier and TypeMethod and Description
public final QOM.UnmodifiableList<? extends Field<?>>
$columns()

Implements org.jooq.impl.QOM.Insert.$columns.

public final QOM.Insert<?>
$columns(Collection<? extends Field<?>> columns)

Implements org.jooq.impl.QOM.Insert.$columns.

public final boolean
$defaultValues()

Implements org.jooq.impl.QOM.Insert.$defaultValues.

public final QOM.Insert<?>
$defaultValues(boolean newDefaultValues)

Implements org.jooq.impl.QOM.Insert.$defaultValues.

public final Table<R>
$into()

Implements org.jooq.impl.QOM.Insert.$into.

public final QOM.Insert<?>
$into(Table<?> newInto)

Implements org.jooq.impl.QOM.Insert.$into.

public final QOM.UnmodifiableList<? extends Field<?>>
$onConflict()

Implements org.jooq.impl.QOM.Insert.$onConflict.

public final QOM.Insert<?>
$onConflict(Collection<? extends Field<?>> newOnConflict)

Implements org.jooq.impl.QOM.Insert.$onConflict.

public final Condition
$onConflictWhere()

Implements org.jooq.impl.QOM.Insert.$onConflictWhere.

Deprecated as a consequence of Condition being deprecated.
public final QOM.Insert<?>
$onConflictWhere(Condition newWhere)

Implements org.jooq.impl.QOM.Insert.$onConflictWhere.

Deprecated as a consequence of Condition being deprecated.
public final boolean
$onDuplicateKeyIgnore()

Implements org.jooq.impl.QOM.Insert.$onDuplicateKeyIgnore.

public final QOM.Insert<?>
$onDuplicateKeyIgnore(boolean newOnDuplicateKeyIgnore)

Implements org.jooq.impl.QOM.Insert.$onDuplicateKeyIgnore.

public final boolean
$onDuplicateKeyUpdate()

Implements org.jooq.impl.QOM.Insert.$onDuplicateKeyUpdate.

public final QOM.Insert<?>
$onDuplicateKeyUpdate(boolean newOnDuplicateKeyUpdate)

Implements org.jooq.impl.QOM.Insert.$onDuplicateKeyUpdate.

public final Select<?>
$select()

Implements org.jooq.impl.QOM.Insert.$select.

public final QOM.Insert<?>
$select(Select<?> newSelect)

Implements org.jooq.impl.QOM.Insert.$select.

public final QOM.UnmodifiableMap<? extends FieldOrRow, ? extends FieldOrRowOrSelect>
$updateSet()

Implements org.jooq.impl.QOM.Insert.$updateSet.

public final QOM.Insert<?>
$updateSet(Map<? extends FieldOrRow, ? extends FieldOrRowOrSelect> newUpdateSet)

Implements org.jooq.impl.QOM.Insert.$updateSet.

public final Condition
$updateWhere()

Implements org.jooq.impl.QOM.Insert.$updateWhere.

Deprecated as a consequence of Condition being deprecated.
public final QOM.Insert<?>
$updateWhere(Condition newWhere)

Implements org.jooq.impl.QOM.Insert.$updateWhere.

Deprecated as a consequence of Condition being deprecated.
public final QOM.UnmodifiableList<? extends Row>
$values()

Implements org.jooq.impl.QOM.Insert.$values.

public final QOM.Insert<?>
$values(Collection<? extends Row> values)

Implements org.jooq.impl.QOM.Insert.$values.

public final WithImpl
$with()

Implements org.jooq.impl.QOM.Insert.$with.

pack-priv final void
accept0(Context<?> ctx)

Implements abstract org.jooq.impl.AbstractDMLQuery.accept0.

private final void
acceptDefaultValuesEmulation(Context<?> ctx, int length)

private final void
acceptInsertSelect(Context<?> ctx)

private final void
acceptMerge(Context<?> ctx)

private final void
acceptMerge0(Context<?> ctx)

private final void
acceptOnConflictWhere(Context<?> ctx)

public final void
addConditions(Condition
The condition
conditions)

Implements org.jooq.InsertQuery.addConditions.

Deprecated as a consequence of Condition being deprecated.
Adds a new condition to the query, connecting it to existing conditions with Operator#AND.
public final void
addConditions(Condition...
The condition
conditions)

Implements org.jooq.InsertQuery.addConditions.

Deprecated as a consequence of Condition being deprecated.
Adds new conditions to the query, connecting them to existing conditions with Operator#AND.
public final void
addConditions(Collection<? extends Condition>
The condition
conditions)

Implements org.jooq.InsertQuery.addConditions.

Adds new conditions to the query, connecting them to existing conditions with Operator#AND.
public final void
addConditions(Operator operator, Condition
The condition
conditions)

Implements org.jooq.InsertQuery.addConditions.

Deprecated as a consequence of Condition being deprecated.
Adds a new condition to the query, connecting it to existing conditions with the provided operator.
public final void
addConditions(Operator operator, Condition...
The condition
conditions)

Implements org.jooq.InsertQuery.addConditions.

Deprecated as a consequence of Condition being deprecated.
Adds new conditions to the query, connecting them to existing conditions with the provided operator.
public final void
addConditions(Operator operator, Collection<? extends Condition>
The condition
conditions)

Implements org.jooq.InsertQuery.addConditions.

Adds new conditions to the query, connecting them to existing conditions with the provided operator.
public final void
addRecord(R
The record to add to this insert statement.
record)

Implements org.jooq.InsertQuery.addRecord.

Short for calling newRecord(); setRecord(record);
public final <T> void
addValueForUpdate(Field<T> field, T value)

Implements org.jooq.InsertQuery.addValueForUpdate.

Deprecated as a consequence of Field being deprecated.
Add a value to the ON DUPLICATE KEY UPDATE clause of this INSERT statement, where this is supported.
public final <T> void
addValueForUpdate(Field<T> field, Field<T> value)

Implements org.jooq.InsertQuery.addValueForUpdate, org.jooq.InsertQuery.addValueForUpdate.

Deprecated as a consequence of Field being deprecated.
Add a value to the ON DUPLICATE KEY UPDATE clause of this INSERT statement, where this is supported.
public final void
addValues(Map<?, ?> map)

Implements org.jooq.StoreQuery.addValues.

Add multiple values to the store statement.
public final void
addValuesForUpdate(Map<?, ?> map)

Implements org.jooq.InsertQuery.addValuesForUpdate.

Add multiple values to the ON DUPLICATE KEY UPDATE clause of this INSERT statement, where this is supported.
public final Clause[]
clauses(Context<?> ctx)

Overrides org.jooq.impl.AbstractQueryPart.clauses.

Implements org.jooq.QueryPartInternal.clauses.

Deprecated as a consequence of Clause being deprecated.
The Clauses that are represented by this query part.
private final List<List<? extends Field<?>>>
conflictingKeys(Context<?> ctx)

pack-priv final InsertQueryImpl<R>
copy(Consumer<? super InsertQueryImpl<R>> finisher)

Deprecated as a consequence of InsertQueryImpl being deprecated.
pack-priv final <O extends Record> InsertQueryImpl<O>
copy(Consumer<? super InsertQueryImpl<O>> finisher, Table<O> t)

Deprecated as a consequence of InsertQueryImpl being deprecated.
private final boolean
defaultValues(Configuration c)

pack-priv final FieldMapsForInsert
getInsertMaps()

Deprecated as a consequence of FieldMapsForInsert being deprecated.
pack-priv final Select<?>
getSelect()

protected final Map<Field<?>, Field<?>>
getValues()

Implements abstract org.jooq.impl.AbstractStoreQuery.getValues.

public final boolean
isExecutable()

Overrides org.jooq.impl.AbstractQuery.isExecutable.

Implements org.jooq.Query.isExecutable.

Whether this query is executable in its current state.
private final <T> Condition
matchByConflictingKey(Context<?> ctx, Field<T> f, Field<T> v)

Deprecated as a consequence of Field and Condition being deprecated.
private final Condition
matchByConflictingKeys(Context<?> ctx, Map<Field<?>, Field<?>> map)

Deprecated as a consequence of Condition being deprecated.
Produce a Condition that matches existing rows by the inserted or updated primary key values.
private final Condition
matchByConflictingKeys(Context<?> ctx, Table<?> s)

Deprecated as a consequence of Condition being deprecated.
Produce a Condition that matches existing rows by the inserted or updated primary key values.
public final void
newRecord()

Implements org.jooq.InsertQuery.newRecord.

Adds a new Record to the insert statement for multi-record inserts

Calling this method will cause subsequent calls to addValue(Field, Object) (and similar) to fill the next record.

public final void
onConflict(Field<?>... fields)

Implements org.jooq.InsertQuery.onConflict.

Deprecated as a consequence of Field being deprecated.
Whether a ON CONFLICT clause should be added to this INSERT statement.
public final void
onConflict(Collection<? extends Field<?>> fields)

Implements org.jooq.InsertQuery.onConflict.

Whether a ON CONFLICT clause should be added to this INSERT statement.
public final void
onConflictOnConstraint(Constraint constraint)

Implements org.jooq.InsertQuery.onConflictOnConstraint.

Deprecated as a consequence of Constraint being deprecated.
Whether use a ON CONFLICT or ON CONFLICT ON CONSTRAINT clause in this INSERT statement.
public void
onConflictOnConstraint(UniqueKey<R> constraint)

Implements org.jooq.InsertQuery.onConflictOnConstraint.

Whether use a ON CONFLICT or ON CONFLICT ON CONSTRAINT clause in this INSERT statement.
public final void
onConflictOnConstraint(Name constraint)

Implements org.jooq.InsertQuery.onConflictOnConstraint.

Whether use a ON CONFLICT or ON CONFLICT ON CONSTRAINT clause in this INSERT statement.
private final void
onConflictOnConstraint0(Constraint constraint)

Deprecated as a consequence of Constraint being deprecated.
public final void
onConflictWhere(Condition
The condition
conditions)

Implements org.jooq.InsertQuery.onConflictWhere.

Deprecated as a consequence of Condition being deprecated.
Adds a new condition the onConflict(Field...) clause.
public final void
onDuplicateKeyIgnore(boolean flag)

Implements org.jooq.InsertQuery.onDuplicateKeyIgnore.

Whether an ON DUPLICATE KEY IGNORE clause should be added to this INSERT statement.
public final void
onDuplicateKeyUpdate(boolean flag)

Implements org.jooq.InsertQuery.onDuplicateKeyUpdate.

Whether a ON DUPLICATE KEY UPDATE clause should be added to this INSERT statement.
public final void
setDefaultValues()

Implements org.jooq.InsertQuery.setDefaultValues.

Set an empty record with the DEFAULT VALUES clause.
public final void
setSelect(Field<?>[] f, Select<?> s)

Implements org.jooq.InsertQuery.setSelect.

Deprecated as a consequence of Field being deprecated.
Use a SELECT statement as the source of values for the INSERT statement.
public final void
setSelect(Collection<? extends Field<?>> f, Select<?> s)

Implements org.jooq.InsertQuery.setSelect.

Use a SELECT statement as the source of values for the INSERT statement.
private final Set<Field<?>>
toSQLInsert(Context<?> ctx, boolean requireNewMySQLExcludedEmulation)

private final FieldMapForUpdate
updateMapComputedOnClientStored(Context<?> ctx)

private final FieldMapForUpdate
updateMapComputedOnClientStored(Context<?> ctx, FieldMapForUpdate um)

Inherited from org.jooq.impl.AbstractStoreQuery:
addValueaddValueaddValueaddValuesetRecord