- All Implemented Interfaces:
Serializable
,Condition
,QueryPart
,QueryPartInternal
Condition
implementations in client code.
Client code may provide proper Condition
implementations extending
this useful base class. All necessary parts of the Condition
interface are already implemented. Only this method needs further
implementation: accept(Context)
.
Refer to that methods' Javadoc for further details about their expected behaviour.
- Author:
- Lukas Eder
- See Also:
- Serialized Form
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionabstract void
Subclasses must implement this method.Combine this condition with another one using theOperator.AND
operator.Combine this condition with another one using theOperator.AND
operator.Combine this condition with another one using theOperator.AND
operator.Combine this condition with another one using theOperator.AND
operator.Combine this condition with another one using theOperator.AND
operator.Combine this condition with another one using theOperator.AND
operator.Combine this condition with an EXISTS clause using theOperator.AND
operator.Combine this condition with a negated other one using theOperator.AND
operator.Combine this condition with a negated other one using theOperator.AND
operator.andNotExists(Select<?> select)
Combine this condition with a NOT EXIST clause using theOperator.AND
operator.Clause[]
TheClause
s that are represented by this query part.protected DSLContext
create()
Deprecated.protected DSLContext
create(Configuration configuration)
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.protected DSLContext
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.boolean
Subclasses may override thisboolean
Subclasses may override thisboolean
Subclasses may override thisboolean
Subclasses may override thisboolean
Subclasses may override thisboolean
Check whether thisQueryPart
can be considered equal to anotherQueryPart
.boolean
Subclasses may override thisint
hashCode()
Generate a hash code from thisQueryPart
.not()
Invert this conditionstatic CustomCondition
Create aCustomCondition
from a lambda expression.Combine this condition with another one using theOperator.OR
operator.Combine this condition with another one using theOperator.OR
operator.Combine this condition with another one using theOperator.OR
operator.Combine this condition with another one using theOperator.OR
operator.Combine this condition with another one using theOperator.OR
operator.Combine this condition with another one using theOperator.OR
operator.Combine this condition with an EXISTS clause using theOperator.OR
operator.Combine this condition with a negated other one using theOperator.OR
operator.Combine this condition with a negated other one using theOperator.OR
operator.orNotExists(Select<?> select)
Combine this condition with a NOT EXIST clause using theOperator.OR
operator.boolean
rendersContent(Context<?> ctx)
Subclasses may override thistoString()
Render a SQL string representation of thisQueryPart
.protected DataAccessException
translate(String sql, SQLException e)
Internal convenience method
-
Constructor Details
-
CustomCondition
protected CustomCondition()
-
-
Method Details
-
of
Create aCustomCondition
from a lambda expression. -
accept
-
clauses
Description copied from interface:QueryPartInternal
TheClause
s that are represented by this query part.QueryPart
s can specify severalClause
s for which an event will be emittedbefore
(in forward order) andafter
(in reverse order) visiting the the query part throughContext.visit(QueryPart)
This method is for JOOQ INTERNAL USE only. Do not reference directly
- Specified by:
clauses
in interfaceQueryPartInternal
- Returns:
- The
Clause
s represented by this query part ornull
or an empty array if this query part does not represent a clause.
-
declaresFields
public final boolean declaresFields()Subclasses may override this- Specified by:
declaresFields
in interfaceQueryPartInternal
-
declaresTables
public final boolean declaresTables()Subclasses may override this- Specified by:
declaresTables
in interfaceQueryPartInternal
-
and
Description copied from interface:Condition
Combine this condition with another one using theOperator.AND
operator. -
and
Description copied from interface:Condition
Combine this condition with another one using theOperator.AND
operator. -
or
Description copied from interface:Condition
Combine this condition with another one using theOperator.OR
operator. -
or
Description copied from interface:Condition
Combine this condition with another one using theOperator.OR
operator. -
and
Description copied from interface:Condition
Combine this condition with another one using theOperator.AND
operator.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- Specified by:
and
in interfaceCondition
- Parameters:
sql
- The other condition- Returns:
- The combined condition
- See Also:
DSL.condition(SQL)
,SQL
-
and
Description copied from interface:Condition
Combine this condition with another one using theOperator.AND
operator.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- Specified by:
and
in interfaceCondition
- Parameters:
sql
- The other condition- Returns:
- The combined condition
- See Also:
DSL.condition(String)
,SQL
-
and
Description copied from interface:Condition
Combine this condition with another one using theOperator.AND
operator.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- Specified by:
and
in interfaceCondition
- Parameters:
sql
- The other conditionbindings
- The bindings- Returns:
- The combined condition
- See Also:
DSL.condition(String, Object...)
,DSL.sql(String, Object...)
,SQL
-
and
Description copied from interface:Condition
Combine this condition with another one using theOperator.AND
operator.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- Specified by:
and
in interfaceCondition
- Parameters:
sql
- The SQL clause, containing {numbered placeholders} where query parts can be injectedparts
- TheQueryPart
objects that are rendered at the {numbered placeholder} locations- Returns:
- The combined condition
- See Also:
DSL.condition(String, QueryPart...)
,DSL.sql(String, QueryPart...)
,SQL
-
or
Description copied from interface:Condition
Combine this condition with another one using theOperator.OR
operator.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- Specified by:
or
in interfaceCondition
- Parameters:
sql
- The other condition- Returns:
- The combined condition
- See Also:
DSL.condition(SQL)
,SQL
-
or
Description copied from interface:Condition
Combine this condition with another one using theOperator.OR
operator.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- Specified by:
or
in interfaceCondition
- Parameters:
sql
- The other condition- Returns:
- The combined condition
- See Also:
DSL.condition(String)
,SQL
-
or
Description copied from interface:Condition
Combine this condition with another one using theOperator.OR
operator.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- Specified by:
or
in interfaceCondition
- Parameters:
sql
- The other conditionbindings
- The bindings- Returns:
- The combined condition
- See Also:
DSL.condition(String, Object...)
,DSL.sql(String, Object...)
,SQL
-
or
Description copied from interface:Condition
Combine this condition with another one using theOperator.OR
operator.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- Specified by:
or
in interfaceCondition
- Parameters:
sql
- The SQL clause, containing {numbered placeholders} where query parts can be injectedparts
- TheQueryPart
objects that are rendered at the {numbered placeholder} locations- Returns:
- The combined condition
- See Also:
DSL.condition(String, Object...)
,DSL.sql(String, QueryPart...)
,SQL
-
andNot
Description copied from interface:Condition
Combine this condition with a negated other one using theOperator.AND
operator. -
andNot
Description copied from interface:Condition
Combine this condition with a negated other one using theOperator.AND
operator. -
orNot
Description copied from interface:Condition
Combine this condition with a negated other one using theOperator.OR
operator. -
orNot
Description copied from interface:Condition
Combine this condition with a negated other one using theOperator.OR
operator. -
andExists
Description copied from interface:Condition
Combine this condition with an EXISTS clause using theOperator.AND
operator. -
andNotExists
Description copied from interface:Condition
Combine this condition with a NOT EXIST clause using theOperator.AND
operator.- Specified by:
andNotExists
in interfaceCondition
- Parameters:
select
- The EXISTS's subquery- Returns:
- The combined condition
-
orExists
Description copied from interface:Condition
Combine this condition with an EXISTS clause using theOperator.OR
operator. -
orNotExists
Description copied from interface:Condition
Combine this condition with a NOT EXIST clause using theOperator.OR
operator.- Specified by:
orNotExists
in interfaceCondition
- Parameters:
select
- The EXISTS's subquery- Returns:
- The combined condition
-
not
Description copied from interface:Condition
Invert this conditionThis is the same as calling
DSL.not(Condition)
-
rendersContent
Subclasses may override this- Specified by:
rendersContent
in interfaceQueryPartInternal
-
declaresWindows
public boolean declaresWindows()Subclasses may override this- Specified by:
declaresWindows
in interfaceQueryPartInternal
-
declaresCTE
public boolean declaresCTE()Subclasses may override this- Specified by:
declaresCTE
in interfaceQueryPartInternal
-
declaresParameters
Subclasses may override this- Specified by:
declaresParameters
in interfaceQueryPartInternal
-
generatesCast
public boolean generatesCast()Subclasses may override this- Specified by:
generatesCast
in interfaceQueryPartInternal
-
equals
Description copied from interface:QueryPart
Check whether thisQueryPart
can be considered equal to anotherQueryPart
.In general,
QueryPart
equality is defined in terms ofQueryPart.toString()
equality. In other words, two query parts are considered equal if their rendered SQL (with inlined bind variables) is equal. This means that the two query parts do not necessarily have to be of the same type.Some
QueryPart
implementations may choose to override this behaviour for improved performance, asQueryPart.toString()
is an expensive operation, if called many times. -
hashCode
public int hashCode()Description copied from interface:QueryPart
Generate a hash code from thisQueryPart
.In general,
QueryPart
hash codes are the same as the hash codes generated fromQueryPart.toString()
. This guarantees consistent behaviour withQueryPart.equals(Object)
Some
QueryPart
implementations may choose to override this behaviour for improved performance, asQueryPart.toString()
is an expensive operation, if called many times. -
toString
Description copied from interface:QueryPart
Render a SQL string representation of thisQueryPart
.For improved debugging, this renders a SQL string of this
QueryPart
with inlined bind variables. If thisQueryPart
isAttachable
, then the attachedConfiguration
may be used for rendering the SQL string, includingSQLDialect
andSettings
. Do note that mostQueryPart
instances are not attached to aConfiguration
, and thus there is no guarantee that the SQL string will make sense in the context of a specific database. -
create
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.Internal convenience method -
create
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.Internal convenience method -
create
Deprecated.- 3.11.0 - [#6722] - UseAttachable.configuration()
andConfiguration.dsl()
instead.Internal convenience method -
translate
Internal convenience method
-
Attachable.configuration()
andConfiguration.dsl()
instead.