Uses of Interface
org.eclipse.net4j.db.dml.SQLCondition
Packages that use SQLCondition
Package
Description
Structured SQL data manipulation for the Net4j DB framework.
Staged fluent builders for SQL data manipulation.
-
Uses of SQLCondition in org.eclipse.net4j.db.dml
Methods in org.eclipse.net4j.db.dml that return SQLConditionModifier and TypeMethodDescriptionstatic SQLConditionSQL.and(SQLCondition left, SQLCondition right) Creates a condition that combines both supplied conditions with AND.default SQLConditionSQLCondition.and(SQLCondition other) Combines this condition with another condition using AND.static SQLConditionSQL.between(SQLExpression expression, SQLExpression lower, SQLExpression upper) Creates a BETWEEN condition with inclusive lower and upper bounds according to SQL semantics.static SQLConditionSQL.condition(SQLFragment fragment) Wraps a structured fragment as a condition using the canonical factory.default SQLConditionSQLFragment.condition()Wraps this fragment as a condition through the canonical SQL factory.static SQLConditionSQL.eq(SQLExpression left, SQLExpression right) Creates an equality condition using ordinary SQL comparison semantics.static SQLConditionSQL.exists(SQLSubSelect query) Creates an EXISTS condition over a complete SELECT definition.static SQLConditionSQL.ge(SQLExpression left, SQLExpression right) Creates a greater-than-or-equal condition.static SQLConditionSQL.gt(SQLExpression left, SQLExpression right) Creates a greater-than condition.static SQLConditionSQL.in(SQLExpression expression, Iterable<? extends SQLExpression> values) Creates an IN condition from a single traversal of the supplied iterable.static SQLConditionSQL.in(SQLExpression expression, SQLExpression... values) Creates an IN condition over a snapshotted, non-empty ordered list of expressions.static SQLConditionSQL.in(SQLExpression expression, SQLSubSelect subSelect) Creates an IN condition whose values come from a complete SELECT definition.static SQLConditionSQL.isNotNull(SQLExpression expression) Creates an IS NOT NULL condition.static SQLConditionSQL.isNull(SQLExpression expression) Creates an IS NULL condition.static SQLConditionSQL.le(SQLExpression left, SQLExpression right) Creates a less-than-or-equal condition.static SQLConditionSQL.like(SQLExpression left, SQLExpression right) Creates a LIKE condition.static SQLConditionSQL.lt(SQLExpression left, SQLExpression right) Creates a less-than condition.static SQLConditionSQL.ne(SQLExpression left, SQLExpression right) Creates an inequality condition.static SQLConditionSQL.not(SQLCondition condition) Creates a negated condition.default SQLConditionSQLCondition.not()Negates this condition.static SQLConditionSQL.notExists(SQLSubSelect query) Creates a NOT EXISTS condition over a complete SELECT definition.static SQLConditionSQL.or(SQLCondition left, SQLCondition right) Creates a condition that combines both supplied conditions with OR.default SQLConditionSQLCondition.or(SQLCondition other) Combines this condition with another condition using OR.Methods in org.eclipse.net4j.db.dml with parameters of type SQLConditionModifier and TypeMethodDescriptionstatic SQLConditionSQL.and(SQLCondition left, SQLCondition right) Creates a condition that combines both supplied conditions with AND.default SQLConditionSQLCondition.and(SQLCondition other) Combines this condition with another condition using AND.static SQLConditionSQL.not(SQLCondition condition) Creates a negated condition.static SQLConditionSQL.or(SQLCondition left, SQLCondition right) Creates a condition that combines both supplied conditions with OR.default SQLConditionSQLCondition.or(SQLCondition other) Combines this condition with another condition using OR. -
Uses of SQLCondition in org.eclipse.net4j.db.dml.fluent
Methods in org.eclipse.net4j.db.dml.fluent with parameters of type SQLConditionModifier and TypeMethodDescriptionSQLConditionStep.and(SQLCondition condition) Adds a complete structured condition joined with AND.SQLFragmentStep.condition(SQLCondition condition) Appends a typed SQL condition as a fragment part.SQLSelectGroupByStep.having(SQLCondition condition) Supplies a complete reusable HAVING condition or begins a comparison.SQLSelectJoinStep.on(SQLCondition condition) Supplies a complete ON condition or begins a comparison whose completion returns to the joined SELECT stage.SQLConditionStep.or(SQLCondition condition) Adds a complete structured condition joined with OR.SQLDeleteStep.where(SQLCondition condition) Supplies a complete WHERE condition or begins a comparison that must be completed before the clause stage is available.SQLSelectSourceStep.where(SQLCondition condition) Supplies a complete reusable WHERE condition or begins a comparison.SQLUpdateSetStep.where(SQLCondition condition) Supplies a complete WHERE condition or begins a comparison that must be completed before the clause stage is available.