org.jooq

Interface DeleteQuery<R extends Record>

Type Parameters:

R - The record type of the table being deleted from

All Superinterfaces:

Attachable, AutoCloseable, ConditionProvider, Delete<R>, Query, QueryPart, Serializable

public interface DeleteQuery<R extends Record>
extends ConditionProvider, Delete<R>

A query used for deletion of data

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
void	addConditions(Collection<? extends Condition> conditions) Adds new conditions to the query, connecting them to existing conditions with Operator.AND
void	addConditions(Condition... conditions) Adds new conditions to the query, connecting them to existing conditions with Operator.AND
void	addConditions(Operator operator, Collection<? extends Condition> conditions) Adds new conditions to the query, connecting them to existing conditions with the provided operator
void	addConditions(Operator operator, Condition... conditions) Adds new conditions to the query, connecting them to existing conditions with the provided operator
R	getReturnedRecord() The record holding returned values as specified by any of the setReturning() methods.
Result<R>	getReturnedRecords() The records holding returned values as specified by any of the setReturning() methods.
void	setReturning() Configure the DELETE statement to return all fields in R.
void	setReturning(Collection<? extends Field<?>> fields) Configure the DELETE statement to return a list of fields in R.
void	setReturning(Field<?>... fields) Configure the DELETE statement to return a list of fields in R.

Methods inherited from interface org.jooq.Query

bind, bind, cancel, close, execute, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Methods inherited from interface org.jooq.Attachable

attach, detach

Method Detail

addConditions

@Support
void addConditions(Condition... conditions)

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

Specified by:

addConditions in interface ConditionProvider

Parameters:

conditions - The condition

addConditions

@Support
void addConditions(Collection<? extends Condition> conditions)

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

Specified by:

addConditions in interface ConditionProvider

Parameters:

conditions - The condition

addConditions

@Support
void addConditions(Operator operator,
                             Condition... conditions)

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

Specified by:

addConditions in interface ConditionProvider

conditions - The condition

addConditions

@Support
void addConditions(Operator operator,
                             Collection<? extends Condition> conditions)

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

Specified by:

addConditions in interface ConditionProvider

conditions - The condition

setReturning

@Support(value={DB2,FIREBIRD,POSTGRES})
void setReturning()

Configure the DELETE statement to return all fields in R.

See Also:

getReturnedRecords()

setReturning

@Support(value={DB2,FIREBIRD,POSTGRES})
void setReturning(Field<?>... fields)

Configure the DELETE statement to return a list of fields in R.

Parameters:

fields - Fields to be returned

See Also:

getReturnedRecords()

setReturning

@Support(value={DB2,FIREBIRD,POSTGRES})
void setReturning(Collection<? extends Field<?>> fields)

Configure the DELETE statement to return a list of fields in R.

Parameters:

fields - Fields to be returned

See Also:

getReturnedRecords()

getReturnedRecord

@Support(value={DB2,FIREBIRD,POSTGRES})
R getReturnedRecord()

The record holding returned values as specified by any of the setReturning() methods.

If the DELETE statement returns several records, this is the same as calling getReturnedRecords().get(0)

This implemented differently for every dialect:

• Firebird and Postgres have native support for DELETE .. RETURNING clauses

Returns:

The returned value as specified by any of the setReturning() methods. This may return null in case jOOQ could not retrieve any generated keys from the JDBC driver.

See Also:

getReturnedRecords()

getReturnedRecords

@Support(value={DB2,FIREBIRD,POSTGRES})
Result<R> getReturnedRecords()

The records holding returned values as specified by any of the setReturning() methods.

If the DELETE statement returns several records, this is the same as calling getReturnedRecords().get(0)

This implemented differently for every dialect:

• Firebird and Postgres have native support for DELETE .. RETURNING clauses

Returns:

The returned values as specified by any of the setReturning() methods. Note:

• Not all databases / JDBC drivers support returning several values on multi-row inserts!
• This may return an empty Result in case jOOQ could not retrieve any generated keys from the JDBC driver.