Uses of Interface
org.springframework.data.relational.core.sql.Expression
Packages that use Expression
Package
Description
Core domain types around DatabaseClient.
Query and update support.
Statement Builder implementation.
-
Uses of Expression in org.springframework.data.r2dbc.core
Methods in org.springframework.data.r2dbc.core that return types with arguments of type ExpressionMethods in org.springframework.data.r2dbc.core with parameters of type ExpressionModifier and TypeMethodDescriptionStatementMapper.SelectSpec.withProjection
(Expression... expressions) Associateexpressions
with the select list and create a newStatementMapper.SelectSpec
.Method parameters in org.springframework.data.r2dbc.core with type arguments of type ExpressionModifier and TypeMethodDescriptionStatementMapper.SelectSpec.withProjection
(Collection<Expression> projectedFields) AssociateprojectedFields
with the select and create a newStatementMapper.SelectSpec
. -
Uses of Expression in org.springframework.data.r2dbc.query
Methods in org.springframework.data.r2dbc.query that return ExpressionModifier and TypeMethodDescriptionQueryMapper.getMappedObject
(Expression expression, RelationalPersistentEntity<?> entity) Map theExpression
object to apply field name mapping usingthe type to read
.Methods in org.springframework.data.r2dbc.query with parameters of type ExpressionModifier and TypeMethodDescriptionQueryMapper.getMappedObject
(Expression expression, RelationalPersistentEntity<?> entity) Map theExpression
object to apply field name mapping usingthe type to read
. -
Uses of Expression in org.springframework.data.relational.core.sql
Subinterfaces of Expression in org.springframework.data.relational.core.sqlClasses in org.springframework.data.relational.core.sql that implement ExpressionModifier and TypeClassDescriptionclass
Represents an analytic function, also known as windowing functionclass
class
class
BETWEENCondition
comparing betweenExpression
s.class
Bind marker/parameter placeholder used to construct prepared statements with parameter substitution.class
Represents aBoolean
literal.class
Represents aCAST
expression likeCAST(something AS JSON
.class
Column name within aSELECT … FROM
clause.class
ComparingCondition
comparing twoExpression
s.class
Condition
representing fixed sql predicate.static class
class
Simple condition that evaluates to SQLFALSE
.class
IN
Condition
clause.class
IS NULL
Condition
.class
LIKECondition
comparing twoExpression
s.class
Literal<T>
Represents a literal.class
Wrapper for multipleCondition
s.class
Condition group wrapping a nestedCondition
with parentheses.class
class
Represents aNumber
literal.class
class
Simple function accepting one or moreExpression
s.class
Represents aCharSequence
literal.class
Wrapper for aSelect
query to be used as subselect.class
Simple condition that evaluates to SQLTRUE
.Methods in org.springframework.data.relational.core.sql that return ExpressionModifier and TypeMethodDescriptionstatic Expression
Expressions.asterisk()
static Expression
static Expression
Expressions.cast
(Expression expression, String targetType) static Expression
Cast.create
(Expression expression, String targetType) Creates a newCAST
expression.Between.getBegin()
Between.getColumn()
Between.getEnd()
OrderByField.getExpression()
Comparison.getLeft()
Like.getLeft()
Comparison.getRight()
Like.getRight()
AssignValue.getValue()
static Expression
Creates a plainsql
Expression
.Methods in org.springframework.data.relational.core.sql that return types with arguments of type ExpressionMethods in org.springframework.data.relational.core.sql with parameters of type ExpressionModifier and TypeMethodDescriptionSelectBuilder.SelectOnCondition.and
(Expression column) Declare an additional source column in theJOIN
.Column.between
(Expression begin, Expression end) Creates aBETWEEN
Condition
.static Between
Conditions.between
(Expression columnOrExpression, Expression begin, Expression end) Creates aBETWEEN
Condition
.static Expression
Expressions.cast
(Expression expression, String targetType) static SimpleFunction
Functions.count
(Expression... columns) Creates a newCOUNT
function.static AnalyticFunction
AnalyticFunction.create
(String function, Expression... arguments) static AssignValue
AssignValue.create
(Column target, Expression value) static Between
Between.create
(Expression columnOrExpression, Expression begin, Expression end) static Expression
Cast.create
(Expression expression, String targetType) Creates a newCAST
expression.static Comparison
Comparison.create
(Expression leftColumnOrExpression, String comparator, Expression rightColumnOrExpression) static In
In.create
(Expression columnOrExpression, Collection<? extends Expression> expressions) static In
In.create
(Expression columnOrExpression, Expression arg) static In
In.create
(Expression columnOrExpression, Expression... expressions) static IsNull
IsNull.create
(Expression expression) Creates a newIsNull
expression.static Like
Like.create
(Expression leftColumnOrExpression, Expression rightColumnOrExpression) static In
In.createNotIn
(Expression columnOrExpression, Collection<? extends Expression> expressions) static In
In.createNotIn
(Expression columnOrExpression, Expression arg) static In
In.createNotIn
(Expression columnOrExpression, Expression... expressions) SelectBuilder.SelectOnConditionComparison.equals
(Expression column) static OrderByField
OrderByField.from
(Expression expression) Creates a newOrderByField
from anExpression
applying default ordering.static OrderByField
OrderByField.from
(Expression expression, Sort.Direction direction) Creates a newOrderByField
from anExpression
applying a given ordering.Column.in
(Expression... expression) static Condition
Conditions.in
(Expression columnOrExpression, Collection<? extends Expression> expressions) static In
Conditions.in
(Expression columnOrExpression, Expression arg) Creates aIN
clause
.static In
Conditions.in
(Expression columnOrExpression, Expression... expressions) static Comparison
Conditions.isEqual
(Expression leftColumnOrExpression, Expression rightColumnOrExpression) Creates a=
(equals)Condition
.Column.isEqualTo
(Expression expression) Creates a=
(equals)Condition
.Column.isGreater
(Expression expression) Creates a!=
(not equals)Condition
.static Comparison
Conditions.isGreater
(Expression leftColumnOrExpression, Expression rightColumnOrExpression) Column.isGreaterOrEqualTo
(Expression expression) Creates a<=
(greater or equal to)Condition
.static Comparison
Conditions.isGreaterOrEqualTo
(Expression leftColumnOrExpression, Expression rightColumnOrExpression) Column.isLess
(Expression expression) Creates a<
(less)Condition
.static Comparison
Conditions.isLess
(Expression leftColumnOrExpression, Expression rightColumnOrExpression) Column.isLessOrEqualTo
(Expression expression) CCreates a<=
(greater)Condition
.static Comparison
Conditions.isLessOrEqualTo
(Expression leftColumnOrExpression, Expression rightColumnOrExpression) static Comparison
Conditions.isNotEqual
(Expression leftColumnOrExpression, Expression rightColumnOrExpression) Creates a!=
(not equals)Condition
.Column.isNotEqualTo
(Expression expression) Creates a!=
(not equals)Condition
.static IsNull
Conditions.isNull
(Expression expression) Creates aIS NULL
condition.static SimpleFunction
Functions.least
(Expression... expressions) Column.like
(Expression expression) Creates aLIKE
Condition
.static Like
Conditions.like
(Expression leftColumnOrExpression, Expression rightColumnOrExpression) Creates aLIKE
Condition
.static SimpleFunction
Functions.lower
(Expression expression) Creates a newLOWER
function.Column.notBetween
(Expression begin, Expression end) Creates aNOT BETWEEN
Condition
.static Between
Conditions.notBetween
(Expression columnOrExpression, Expression begin, Expression end) Creates aNOT BETWEEN
Condition
.Column.notIn
(Expression... expression) static Condition
Conditions.notIn
(Expression columnOrExpression, Collection<? extends Expression> expressions) static In
Conditions.notIn
(Expression columnOrExpression, Expression arg) Creates aNOT IN
clause
.static In
Conditions.notIn
(Expression columnOrExpression, Expression... expressions) Column.notLike
(Expression expression) Creates aNOT LIKE
Condition
.static Like
Conditions.notLike
(Expression leftColumnOrExpression, Expression rightColumnOrExpression) Creates aNOT LIKE
Condition
.SelectBuilder.SelectOn.on
(Expression column) Declare the source column in theJOIN
.AnalyticFunction.orderBy
(Expression... orderByExpression) AnalyticFunction.partitionBy
(Expression... partitionBy) SelectBuilder.select
(Expression expression) Include aExpression
in the select list.SelectBuilder.select
(Expression... expressions) Include one or moreExpression
s in the select list.SelectBuilder.SelectAndFrom.select
(Expression expression) Include aExpression
in the select list.SelectBuilder.SelectAndFrom.select
(Expression... expressions) Include one or moreExpression
s in the select list.static SelectBuilder.SelectAndFrom
StatementBuilder.select
(Expression expression) Creates a newSelectBuilder
and includes theSELECT
columns.static SelectBuilder.SelectAndFrom
StatementBuilder.select
(Expression... expressions) Creates a newSelectBuilder
and includes one or moreSELECT
columns.Column.set
(Expression value) Creates a valueassignment
.static SimpleFunction
Functions.upper
(Expression expression) Creates a newUPPER
function.static AssignValue
Assignments.value
(Column target, Expression value) InsertBuilder.InsertIntoColumnsAndValuesWithBuild.value
(Expression value) Add avalue
to theVALUES
list.InsertBuilder.InsertValues.value
(Expression value) Add avalue
to theVALUES
list.InsertBuilder.InsertValuesWithBuild.value
(Expression value) Add avalue
to theVALUES
list.InsertBuilder.InsertIntoColumnsAndValuesWithBuild.values
(Expression... values) Add one or morevalues
to theVALUES
list.InsertBuilder.InsertValues.values
(Expression... values) Add one or morevalues
to theVALUES
list.InsertBuilder.InsertValuesWithBuild.values
(Expression... values) Add one or morevalues
to theVALUES
list.Method parameters in org.springframework.data.relational.core.sql with type arguments of type ExpressionModifier and TypeMethodDescriptionstatic SimpleFunction
Functions.count
(Collection<? extends Expression> columns) Creates a newCOUNT
function.static In
In.create
(Expression columnOrExpression, Collection<? extends Expression> expressions) static SimpleFunction
SimpleFunction.create
(String functionName, List<Expression> expressions) static In
In.createNotIn
(Expression columnOrExpression, Collection<? extends Expression> expressions) static Condition
Conditions.in
(Expression columnOrExpression, Collection<? extends Expression> expressions) static Condition
Conditions.notIn
(Expression columnOrExpression, Collection<? extends Expression> expressions) SelectBuilder.select
(Collection<? extends Expression> expressions) Include one or moreExpression
s in the select list.SelectBuilder.SelectAndFrom.select
(Collection<? extends Expression> expressions) Include one or moreExpression
s in the select list.static SelectBuilder.SelectAndFrom
StatementBuilder.select
(Collection<? extends Expression> expressions) Creates a newSelectBuilder
and includes one or moreExpression
s in the select list.InsertBuilder.InsertIntoColumnsAndValuesWithBuild.values
(Collection<? extends Expression> values) Add one or morevalues
to theVALUES
list.InsertBuilder.InsertValues.values
(Collection<? extends Expression> values) Add one or morevalues
to theVALUES
list.InsertBuilder.InsertValuesWithBuild.values
(Collection<? extends Expression> values) Add one or morevalues
to theVALUES
list.