Uses of Interface
org.springframework.data.relational.core.sql.Expression
Package
Description
Core domain types around DatabaseClient.
Query and update support.
Statement Builder implementation.
-
Uses of Expression in org.springframework.data.r2dbc.core
Modifier and TypeMethodDescriptionStatementMapper.SelectSpec.withProjection
(Expression... expressions) Associateexpressions
with the select list and create a newStatementMapper.SelectSpec
.Modifier 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
Modifier and TypeMethodDescriptionQueryMapper.getMappedObject
(Expression expression, RelationalPersistentEntity<?> entity) Map theExpression
object to apply field name mapping usingthe type to read
.Modifier 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
Modifier 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
.Modifier 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
.Modifier 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.Modifier 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.