Uses of Interface
org.eclipse.net4j.db.dml.SQLExpression
Packages that use SQLExpression
Package
Description
The Net4j DB framework concepts for the abstraction of the SQL data definition language.
Structured SQL data manipulation for the Net4j DB framework.
Staged fluent builders for SQL data manipulation.
Server service provider interfaces for the Net4j DB framework.
-
Uses of SQLExpression in org.eclipse.net4j.db.ddl
Subinterfaces of SQLExpression in org.eclipse.net4j.db.ddl -
Uses of SQLExpression in org.eclipse.net4j.db.dml
Subinterfaces of SQLExpression in org.eclipse.net4j.db.dmlModifier and TypeInterfaceDescriptioninterfaceA column reference that may be qualified by a table occurrence.interfaceA boolean SQL expression that can also be projected or ordered when supported by a dialect.interfaceAn immutable logical parameter identity.Fields in org.eclipse.net4j.db.dml declared as SQLExpressionModifier and TypeFieldDescriptionstatic final SQLExpressionSQL.NULLThe SQL NULL literal.static final SQLExpressionSQL.ONEThe numeric SQL literal 1.static final SQLExpressionSQL.ZEROThe numeric SQL literal 0.Methods in org.eclipse.net4j.db.dml that return SQLExpressionModifier and TypeMethodDescriptionstatic SQLExpressionSQL.abs(SQLExpression expression) Creates a structured absolute-value expression.static SQLExpressionSQL.add(SQLExpression left, SQLExpression right) Creates a binary addition expression.static SQLExpressionSQL.avg(SQLExpression expression) Creates an AVG aggregate over the supplied expression.static SQLExpressionSQL.count()Creates the COUNT(*) aggregate.static SQLExpressionSQL.count(SQLExpression expression) Creates COUNT over the non-NULL values produced by the supplied expression.static SQLExpressionSQL.countDistinct(SQLExpression expression) Creates COUNT(DISTINCT expression).static SQLExpressionSQL.divide(SQLExpression left, SQLExpression right) Creates a binary division expression.static SQLExpressionSQL.expression(SQLFragment fragment) Wraps a structured fragment as an expression using the canonical factory.default SQLExpressionSQLFragment.expression()Wraps this fragment as an expression through the canonical SQL factory.static SQLExpressionCreates an expression from an explicit literal value.static SQLExpressionSQL.max(SQLExpression expression) Creates a MAX aggregate over the supplied expression.static SQLExpressionSQL.min(SQLExpression expression) Creates a MIN aggregate over the supplied expression.static SQLExpressionSQL.multiply(SQLExpression left, SQLExpression right) Creates a binary multiplication expression.static SQLExpressionSQL.scalar(SQLSubSelect query) Uses a complete SELECT definition as a scalar expression.static SQLExpressionSQL.subtract(SQLExpression left, SQLExpression right) Creates a binary subtraction expression.static SQLExpressionSQL.sum(SQLExpression expression) Creates a SUM aggregate over the supplied expression.Methods in org.eclipse.net4j.db.dml with parameters of type SQLExpressionModifier and TypeMethodDescriptionstatic SQLExpressionSQL.abs(SQLExpression expression) Creates a structured absolute-value expression.static SQLExpressionSQL.add(SQLExpression left, SQLExpression right) Creates a binary addition expression.static SQLSelectItemSQL.as(SQLExpression expression, String alias) Associates a result-column label with an expression in a projection.static SQLOrderItemSQL.asc(SQLExpression expression) Wraps an expression as an ascending ORDER BY item.static SQLExpressionSQL.avg(SQLExpression expression) Creates an AVG aggregate over the supplied expression.static SQLConditionSQL.between(SQLExpression expression, SQLExpression lower, SQLExpression upper) Creates a BETWEEN condition with inclusive lower and upper bounds according to SQL semantics.static SQLExpressionSQL.count(SQLExpression expression) Creates COUNT over the non-NULL values produced by the supplied expression.static SQLExpressionSQL.countDistinct(SQLExpression expression) Creates COUNT(DISTINCT expression).static SQLOrderItemSQL.desc(SQLExpression expression) Wraps an expression as a descending ORDER BY item.static SQLExpressionSQL.divide(SQLExpression left, SQLExpression right) Creates a binary division expression.static SQLConditionSQL.eq(SQLExpression left, SQLExpression right) Creates an equality condition using ordinary SQL comparison semantics.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 SQLExpressionSQL.max(SQLExpression expression) Creates a MAX aggregate over the supplied expression.static SQLExpressionSQL.min(SQLExpression expression) Creates a MIN aggregate over the supplied expression.static SQLExpressionSQL.multiply(SQLExpression left, SQLExpression right) Creates a binary multiplication expression.static SQLConditionSQL.ne(SQLExpression left, SQLExpression right) Creates an inequality condition.static SQLExpressionSQL.subtract(SQLExpression left, SQLExpression right) Creates a binary subtraction expression.static SQLExpressionSQL.sum(SQLExpression expression) Creates a SUM aggregate over the supplied expression.Method parameters in org.eclipse.net4j.db.dml with type arguments of type SQLExpressionModifier and TypeMethodDescriptionstatic SQLConditionSQL.in(SQLExpression expression, Iterable<? extends SQLExpression> values) Creates an IN condition from a single traversal of the supplied iterable. -
Uses of SQLExpression in org.eclipse.net4j.db.dml.fluent
Methods in org.eclipse.net4j.db.dml.fluent with parameters of type SQLExpressionModifier and TypeMethodDescriptionSQLInStep.add(SQLExpression value) Appends one expression to the IN value list.SQLConditionStep.and(SQLExpression left) Begins a comparison in this clause joined with AND.SQLComparisonStep.between(SQLExpression lower, SQLExpression upper) Adds a BETWEEN comparison with the supplied lower and upper expressions.SQLComparisonStep.eq(SQLExpression right) Adds an equality comparison between the left expression supplied to this stage and the right expression.SQLFragmentStep.expression(SQLExpression expression) Appends a typed SQL expression as a fragment part.SQLComparisonStep.ge(SQLExpression right) Adds a greater-than-or-equal comparison between the left expression supplied to this stage and the right expression.SQLSelectSourceStep.groupBy(SQLExpression first, SQLExpression... others) Adds the ordered expressions used to group the SELECT result.SQLSelectWhereStep.groupBy(SQLExpression first, SQLExpression... others) Adds the ordered expressions used to group the SELECT result.SQLComparisonStep.gt(SQLExpression right) Adds a greater-than comparison between the left expression supplied to this stage and the right expression.SQLSelectGroupByStep.having(SQLExpression left) Supplies a complete reusable HAVING condition or begins a comparison.SQLComparisonStep.in(SQLExpression first, SQLExpression... others) Adds an IN comparison using the supplied ordered expressions.SQLComparisonStep.le(SQLExpression right) Adds a less-than-or-equal comparison between the left expression supplied to this stage and the right expression.SQLComparisonStep.like(SQLExpression right) Adds a LIKE comparison.SQLComparisonStep.lt(SQLExpression right) Adds a less-than comparison between the left expression supplied to this stage and the right expression.SQLComparisonStep.ne(SQLExpression right) Adds an inequality comparison between the left expression supplied to this stage and the right expression.SQLSelectJoinStep.on(SQLExpression left) Supplies a complete ON condition or begins a comparison whose completion returns to the joined SELECT stage.SQLConditionStep.or(SQLExpression left) Begins a comparison in this clause joined with OR.SQLSelectGroupByStep.orderByDesc(SQLExpression expression) Starts an ORDER BY clause with one descending expression.SQLSelectHavingStep.orderByDesc(SQLExpression expression) Starts an ORDER BY clause with one descending expression.SQLSelectSourceStep.orderByDesc(SQLExpression expression) Starts an ORDER BY clause with one descending expression.SQLSelectWhereStep.orderByDesc(SQLExpression expression) Starts an ORDER BY clause with one descending expression.SQLSelectOrderByStep.thenByDesc(SQLExpression expression) Appends a descending expression after the current ORDER BY items.SQLInsertAssignmentStep.to(SQLExpression value) Completes the pending assignment with an expression value.SQLUpdateAssignmentStep.to(SQLExpression value) Completes the pending assignment with an expression value.SQLInsertColumnsStep.values(SQLExpression first, SQLExpression... others) Supplies values positionally corresponding to the explicit target columns.SQLInsertStartStep.values(SQLExpression first, SQLExpression... others) Supplies values for the INSERT target.SQLDeleteStep.where(SQLExpression left) Supplies a complete WHERE condition or begins a comparison that must be completed before the clause stage is available.SQLSelectSourceStep.where(SQLExpression left) Supplies a complete reusable WHERE condition or begins a comparison.SQLUpdateSetStep.where(SQLExpression left) Supplies a complete WHERE condition or begins a comparison that must be completed before the clause stage is available.Method parameters in org.eclipse.net4j.db.dml.fluent with type arguments of type SQLExpressionModifier and TypeMethodDescriptionSQLInStep.addAll(Iterable<? extends SQLExpression> values) Appends expressions from one traversal of the iterable, preserving its iteration order.SQLComparisonStep.in(Iterable<? extends SQLExpression> values) Adds an IN comparison by consuming the iterable once in iteration order. -
Uses of SQLExpression in org.eclipse.net4j.spi.db.ddl
Subinterfaces of SQLExpression in org.eclipse.net4j.spi.db.ddl