Top Fields Constructors Methods
org.jooq.impl

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

extends AbstractDMLQuery<R extends Record>
implements DeleteQuery<R extends Record>, QOM.Delete<R extends Record>
Class Inheritance
All Implemented Interfaces
org.jooq.impl.QOM.Delete, 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.DeleteQuery, org.jooq.Delete, org.jooq.ConditionProvider
Static Imports
org.jooq.Clause.DELETE, .Clause.DELETE_DELETE, .Clause.DELETE_RETURNING, .Clause.DELETE_WHERE, .SQLDialect.CUBRID, .SQLDialect.DERBY, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.HSQLDB, .SQLDialect.IGNITE, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB, org.jooq.conf.SettingsTools.getExecuteDeleteWithoutWhere, org.jooq.impl.ConditionProviderImpl.extractCondition, .DSL.row, .DSL.select, .DSL.trueCondition, .Keywords.K_DELETE, .Keywords.K_FROM, .Keywords.K_LIMIT, .Keywords.K_ORDER_BY, .Keywords.K_USING, .Keywords.K_WHERE, .Tools.containsDeclaredTable, .Tools.traverseJoins

Deprecated

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

Author
Lukas Eder

Field Summary

Modifier and TypeField and Description
private static final Clause[]
CLAUSES

Deprecated as a consequence of Clause being deprecated.
private final ConditionProviderImpl
condition

Deprecated as a consequence of ConditionProviderImpl being deprecated.
private Field<? extends Number>
limit

Deprecated as a consequence of Field being deprecated.
private static final Set<SQLDialect>
NO_SUPPORT_LIMIT

private static final Set<SQLDialect>
NO_SUPPORT_ORDER_BY_LIMIT

private static final Set<SQLDialect>
NO_SUPPORT_REPEAT_FROM_IN_USING

private final SortFieldList
orderBy

private static final Set<SQLDialect>
REQUIRE_REPEAT_FROM_IN_USING

private static final Set<SQLDialect>
SPECIAL_DELETE_AS_SYNTAX

private static final Set<SQLDialect>
SUPPORT_MULTITABLE_DELETE

private final TableList
using

Inherited from org.jooq.impl.AbstractDMLQuery:
returnedreturnedResultreturningreturningResolvedAsteriskstablewith

Constructor Summary

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

Method Summary

Modifier and TypeMethod and Description
public final Table<R>
$from()

Implements org.jooq.impl.QOM.Delete.$from.

public final QOM.Delete<?>
$from(Table<?> newFrom)

Implements org.jooq.impl.QOM.Delete.$from.

public final Field<? extends Number>
$limit()

Implements org.jooq.impl.QOM.Delete.$limit.

Deprecated as a consequence of Field being deprecated.
public final QOM.Delete<R>
$limit(Field<? extends Number> newLimit)

Implements org.jooq.impl.QOM.Delete.$limit.

Deprecated as a consequence of Field being deprecated.
public final QOM.UnmodifiableList<? extends SortField<?>>
$orderBy()

Implements org.jooq.impl.QOM.Delete.$orderBy.

public final QOM.Delete<R>
$orderBy(Collection<? extends SortField<?>> newOrderBy)

Implements org.jooq.impl.QOM.Delete.$orderBy.

public final QOM.UnmodifiableList<? extends Table<?>>
$using()

Implements org.jooq.impl.QOM.Delete.$using.

public final QOM.Delete<R>
$using(Collection<? extends Table<?>> using)

Implements org.jooq.impl.QOM.Delete.$using.

public final Condition
$where()

Implements org.jooq.impl.QOM.Delete.$where.

Deprecated as a consequence of Condition being deprecated.
public final QOM.Delete<R>
$where(Condition newWhere)

Implements org.jooq.impl.QOM.Delete.$where.

Deprecated as a consequence of Condition being deprecated.
public final WithImpl
$with()

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

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

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

public final void
addConditions(Collection<? extends Condition>
The condition
conditions)

Implements org.jooq.DeleteQuery.addConditions.

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

Implements org.jooq.DeleteQuery.addConditions.

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

Implements org.jooq.DeleteQuery.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(Operator operator, Condition
The condition
conditions)

Implements org.jooq.DeleteQuery.addConditions.

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

Implements org.jooq.DeleteQuery.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.DeleteQuery.addConditions.

Adds new conditions to the query, connecting them to existing conditions with the provided operator.
public final void
addLimit(Number
The number of rows to return
numberOfRows)

Implements org.jooq.DeleteQuery.addLimit.

Limit the results of this select.
public final void
addLimit(Field<? extends Number>
The number of rows to return
numberOfRows)

Implements org.jooq.DeleteQuery.addLimit.

Deprecated as a consequence of Field being deprecated.
Limit the results of this select.
public final void
addOrderBy(OrderField<?>...
The ordering fields
fields)

Implements org.jooq.DeleteQuery.addOrderBy.

Adds ordering fields.
public final void
addOrderBy(Collection<? extends OrderField<?>>
The ordering fields
fields)

Implements org.jooq.DeleteQuery.addOrderBy.

Adds ordering fields.
public final void
addUsing(Collection<? extends TableLike<?>> f)

Implements org.jooq.DeleteQuery.addUsing.

Add tables to the USING clause.
public final void
addUsing(TableLike<?> f)

Implements org.jooq.DeleteQuery.addUsing.

Add tables to the USING clause.
public final void
addUsing(TableLike<?>... f)

Implements org.jooq.DeleteQuery.addUsing.

Add tables to the USING clause.
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.
pack-priv final DeleteQueryImpl<R>
copy(Consumer<? super DeleteQueryImpl<R>> finisher)

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

Deprecated as a consequence of DeleteQueryImpl being deprecated.
pack-priv final TableList
getUsing()

pack-priv final Condition
getWhere()

Deprecated as a consequence of Condition being deprecated.
pack-priv final boolean
hasWhere()

public final boolean
isExecutable()

Overrides org.jooq.impl.AbstractQuery.isExecutable.

Implements org.jooq.Query.isExecutable.

Whether this query is executable in its current state.
Inherited from org.jooq.impl.AbstractDMLQuery:
acceptexecuteexecuteWithoutWheregetFieldsgetRecordTypegetResultgetReturnedRecordgetReturnedRecordsnativeSupportReturningnativeSupportReturningOrDataChangeDeltaTablepreparesetReturningsetReturningsetReturningsetReturningtabletabletoSQLReturning

Field Detail

CLAUSESback to summary
private static final Clause[] CLAUSES

Deprecated

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

conditionback to summary
private final ConditionProviderImpl condition

Deprecated

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

limitback to summary
private Field<? extends Number> limit

Deprecated

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

NO_SUPPORT_LIMITback to summary
private static final Set<SQLDialect> NO_SUPPORT_LIMIT
NO_SUPPORT_ORDER_BY_LIMITback to summary
private static final Set<SQLDialect> NO_SUPPORT_ORDER_BY_LIMIT
NO_SUPPORT_REPEAT_FROM_IN_USINGback to summary
private static final Set<SQLDialect> NO_SUPPORT_REPEAT_FROM_IN_USING
orderByback to summary
private final SortFieldList orderBy
REQUIRE_REPEAT_FROM_IN_USINGback to summary
private static final Set<SQLDialect> REQUIRE_REPEAT_FROM_IN_USING
SPECIAL_DELETE_AS_SYNTAXback to summary
private static final Set<SQLDialect> SPECIAL_DELETE_AS_SYNTAX
SUPPORT_MULTITABLE_DELETEback to summary
private static final Set<SQLDialect> SUPPORT_MULTITABLE_DELETE
usingback to summary
private final TableList using

Constructor Detail

DeleteQueryImplback to summary
pack-priv DeleteQueryImpl(Configuration configuration, WithImpl with, Table<R> table)

Method Detail

$fromback to summary
public final Table<R> $from()

Implements org.jooq.impl.QOM.Delete.$from.

Annotations
@Override
$fromback to summary
public final QOM.Delete<?> $from(Table<?> newFrom)

Implements org.jooq.impl.QOM.Delete.$from.

Annotations
@Override
$limitback to summary
public final Field<? extends Number> $limit()

Implements org.jooq.impl.QOM.Delete.$limit.

Deprecated

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

Annotations
@Override
$limitback to summary
public final QOM.Delete<R> $limit(Field<? extends Number> newLimit)

Implements org.jooq.impl.QOM.Delete.$limit.

Deprecated

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

Annotations
@Override
$orderByback to summary
public final QOM.UnmodifiableList<? extends SortField<?>> $orderBy()

Implements org.jooq.impl.QOM.Delete.$orderBy.

Annotations
@Override
$orderByback to summary
public final QOM.Delete<R> $orderBy(Collection<? extends SortField<?>> newOrderBy)

Implements org.jooq.impl.QOM.Delete.$orderBy.

Annotations
@Override
$usingback to summary
public final QOM.UnmodifiableList<? extends Table<?>> $using()

Implements org.jooq.impl.QOM.Delete.$using.

Annotations
@Override
$usingback to summary
public final QOM.Delete<R> $using(Collection<? extends Table<?>> using)

Implements org.jooq.impl.QOM.Delete.$using.

Annotations
@Override
$whereback to summary
public final Condition $where()

Implements org.jooq.impl.QOM.Delete.$where.

Deprecated

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

Annotations
@Override
$whereback to summary
public final QOM.Delete<R> $where(Condition newWhere)

Implements org.jooq.impl.QOM.Delete.$where.

Deprecated

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

Annotations
@Override
$withback to summary
public final WithImpl $with()

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

Annotations
@Override
accept0back to summary
pack-priv final void accept0(Context<?> ctx)

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

Annotations
@SuppressWarnings:unchecked, rawtypes
@Override
addConditionsback to summary
public final void addConditions(Collection<? extends Condition> conditions)

Implements org.jooq.DeleteQuery.addConditions.

Doc from org.jooq.ConditionProvider.addConditions.

Adds new conditions to the query, connecting them to existing conditions with Operator#AND.

Parameters
conditions:Collection<? extends Condition>

The condition

Annotations
@Override
addConditionsback to summary
public final void addConditions(Condition conditions)

Implements org.jooq.DeleteQuery.addConditions.

Doc from org.jooq.ConditionProvider.addConditions.

Deprecated

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

Adds a new condition to the query, connecting them to existing conditions with Operator#AND.

Parameters
conditions:Condition

The condition

Annotations
@Override
addConditionsback to summary
public final void addConditions(Condition... conditions)

Implements org.jooq.DeleteQuery.addConditions.

Doc from org.jooq.ConditionProvider.addConditions.

Deprecated

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

Adds new conditions to the query, connecting them to existing conditions with Operator#AND.

Parameters
conditions:Condition[]

The condition

Annotations
@Override
addConditionsback to summary
public final void addConditions(Operator operator, Condition conditions)

Implements org.jooq.DeleteQuery.addConditions.

Doc from org.jooq.ConditionProvider.addConditions.

Deprecated

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

Adds a new condition to the query, connecting them to existing conditions with the provided operator.

Parameters
conditions:Condition

The condition

Annotations
@Override
addConditionsback to summary
public final void addConditions(Operator operator, Condition... conditions)

Implements org.jooq.DeleteQuery.addConditions.

Doc from org.jooq.ConditionProvider.addConditions.

Deprecated

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

Adds new conditions to the query, connecting them to existing conditions with the provided operator.

Parameters
conditions:Condition[]

The condition

Annotations
@Override
addConditionsback to summary
public final void addConditions(Operator operator, Collection<? extends Condition> conditions)

Implements org.jooq.DeleteQuery.addConditions.

Doc from org.jooq.ConditionProvider.addConditions.

Adds new conditions to the query, connecting them to existing conditions with the provided operator.

Parameters
conditions:Collection<? extends Condition>

The condition

Annotations
@Override
addLimitback to summary
public final void addLimit(Number numberOfRows)

Implements org.jooq.DeleteQuery.addLimit.

Doc from org.jooq.DeleteQuery.addLimit.

Limit the results of this select.

Parameters
numberOfRows:Number

The number of rows to return

Annotations
@Override
addLimitback to summary
public final void addLimit(Field<? extends Number> numberOfRows)

Implements org.jooq.DeleteQuery.addLimit.

Doc from org.jooq.DeleteQuery.addLimit.

Deprecated

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

Limit the results of this select.

Parameters
numberOfRows:Field<? extends Number>

The number of rows to return

Annotations
@Override
addOrderByback to summary
public final void addOrderBy(OrderField<?>... fields)

Implements org.jooq.DeleteQuery.addOrderBy.

Doc from org.jooq.DeleteQuery.addOrderBy.

Adds ordering fields.

Parameters
fields:OrderField<?>[]

The ordering fields

Annotations
@Override
addOrderByback to summary
public final void addOrderBy(Collection<? extends OrderField<?>> fields)

Implements org.jooq.DeleteQuery.addOrderBy.

Doc from org.jooq.DeleteQuery.addOrderBy.

Adds ordering fields.

Parameters
fields:Collection<? extends OrderField<?>>

The ordering fields

Annotations
@Override
addUsingback to summary
public final void addUsing(Collection<? extends TableLike<?>> f)

Implements org.jooq.DeleteQuery.addUsing.

Doc from org.jooq.DeleteQuery.addUsing.

Add tables to the USING clause.

Annotations
@Override
addUsingback to summary
public final void addUsing(TableLike<?> f)

Implements org.jooq.DeleteQuery.addUsing.

Doc from org.jooq.DeleteQuery.addUsing.

Add tables to the USING clause.

Annotations
@Override
addUsingback to summary
public final void addUsing(TableLike<?>... f)

Implements org.jooq.DeleteQuery.addUsing.

Doc from org.jooq.DeleteQuery.addUsing.

Add tables to the USING clause.

Annotations
@Override
clausesback to summary
public final Clause[] clauses(Context<?> ctx)

Overrides org.jooq.impl.AbstractQueryPart.clauses.

Implements org.jooq.QueryPartInternal.clauses.

Doc from org.jooq.QueryPartInternal.clauses.

Deprecated

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

The Clauses that are represented by this query part.

QueryParts can specify several Clauses for which an event will be emitted before (in forward order) and after (in reverse order) visiting the the query part through Context#visit(QueryPart)

This method is for JOOQ INTERNAL USE only. Do not reference directly

Returns:Clause[]

The Clauses represented by this query part or null or an empty array if this query part does not represent a clause.

Annotations
@Override
copyback to summary
pack-priv final DeleteQueryImpl<R> copy(Consumer<? super DeleteQueryImpl<R>> finisher)

Deprecated

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

copyback to summary
pack-priv final <O extends Record> DeleteQueryImpl<O> copy(Consumer<? super DeleteQueryImpl<O>> finisher, Table<O> t)

Deprecated

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

getUsingback to summary
pack-priv final TableList getUsing()
getWhereback to summary
pack-priv final Condition getWhere()

Deprecated

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

hasWhereback to summary
pack-priv final boolean hasWhere()
isExecutableback to summary
public final boolean isExecutable()

Overrides org.jooq.impl.AbstractQuery.isExecutable.

Implements org.jooq.Query.isExecutable.

Doc from org.jooq.Query.isExecutable.

Whether this query is executable in its current state.

DML queries may be incomplete in structure and thus not executable. Calling execute() on such queries has no effect, but beware that getSQL() may not render valid SQL!

Annotations
@Override