org.jooq
Interface DeleteConditionStep

All Superinterfaces:

Adapter, Attachable, Delete, DeleteFinalStep, Query, QueryPart, Serializable

public interface DeleteConditionStep
extends DeleteFinalStep

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

Example:

 Factory create = new Factory();

 create.delete(table)
       .where(field1.greaterThan(100))
       .execute();
 

Author:

Lukas Eder

Method Summary

DeleteConditionStep	and(Condition condition) Combine the currently assembled conditions with another one using the Operator.AND operator
DeleteConditionStep	and(String sql) Combine the currently assembled conditions with another one using the Operator.AND operator
DeleteConditionStep	and(String sql, Object... bindings) Combine the currently assembled conditions with another one using the Operator.AND operator
DeleteConditionStep	andExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator
DeleteConditionStep	andNot(Condition condition) Combine the currently assembled conditions with a negated other one using the Operator.AND operator
DeleteConditionStep	andNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator
DeleteConditionStep	or(Condition condition) Combine the currently assembled conditions with another one using the Operator.OR operator
DeleteConditionStep	or(String sql) Combine the currently assembled conditions with another one using the Operator.OR operator
DeleteConditionStep	or(String sql, Object... bindings) Combine the currently assembled conditions with another one using the Operator.OR operator
DeleteConditionStep	orExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator
DeleteConditionStep	orNot(Condition condition) Combine the currently assembled conditions with a negated other one using the Operator.OR operator
DeleteConditionStep	orNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator

Methods inherited from interface org.jooq.Query

execute

Methods inherited from interface org.jooq.QueryPart

getSQL

Methods inherited from interface org.jooq.Attachable

attach, getConfiguration

Methods inherited from interface org.jooq.Adapter

internalAPI

Method Detail

and

DeleteConditionStep and(Condition condition)

Combine the currently assembled conditions with another one using the Operator.AND operator

and

DeleteConditionStep and(String sql)

Combine the currently assembled conditions with another one using the Operator.AND operator

See Also:

Factory.plainSQLCondition(String)

and

DeleteConditionStep and(String sql,
                        Object... bindings)

Combine the currently assembled conditions with another one using the Operator.AND operator

See Also:

Factory.plainSQLCondition(String, Object...)

andNot

DeleteConditionStep andNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.AND operator

andExists

DeleteConditionStep andExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator

andNotExists

DeleteConditionStep andNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator

or

DeleteConditionStep or(Condition condition)

Combine the currently assembled conditions with another one using the Operator.OR operator

or

DeleteConditionStep or(String sql)

Combine the currently assembled conditions with another one using the Operator.OR operator

See Also:

Factory.plainSQLCondition(String)

or

DeleteConditionStep or(String sql,
                       Object... bindings)

Combine the currently assembled conditions with another one using the Operator.OR operator

See Also:

Factory.plainSQLCondition(String, Object...)

orNot

DeleteConditionStep orNot(Condition condition)

Combine the currently assembled conditions with a negated other one using the Operator.OR operator

orExists

DeleteConditionStep orExists(Select<?> select)

Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator

orNotExists

DeleteConditionStep orNotExists(Select<?> select)

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator