Module org.seasar.doma.core

Package org.seasar.doma.jdbc.criteria.expression

Class Expressions

java.lang.Object

org.seasar.doma.jdbc.criteria.expression.Expressions

public class Expressions
extends Object

Constructor Summary

Constructors

Constructor	Description
Expressions()

Method Summary

Modifier and Type	Method	Description
static <PROPERTY> ArithmeticExpression.Add<PROPERTY>	add(PropertyMetamodel<PROPERTY> left, PropertyMetamodel<PROPERTY> right)
static <PROPERTY> ArithmeticExpression.Add<PROPERTY>	add(PropertyMetamodel<PROPERTY> left, PROPERTY right)
static <PROPERTY> ArithmeticExpression.Add<PROPERTY>	add(PROPERTY left, PropertyMetamodel<PROPERTY> right)
static <PROPERTY> AliasExpression<PROPERTY>	alias(PropertyMetamodel<PROPERTY> propertyMetamodel, String alias)
static <PROPERTY> AggregateFunction.Avg<PROPERTY>	avg(PropertyMetamodel<PROPERTY> propertyMetamodel)
static AggregateFunction.AvgAsDouble	avgAsDouble(PropertyMetamodel<?> propertyMetamodel)
static <PROPERTY> StringExpression.Concat<PROPERTY>	concat(PropertyMetamodel<PROPERTY> left, PropertyMetamodel<PROPERTY> right)
static <PROPERTY> StringExpression.Concat<PROPERTY>	concat(PropertyMetamodel<PROPERTY> left, PROPERTY right)
static <PROPERTY> StringExpression.Concat<PROPERTY>	concat(PROPERTY left, PropertyMetamodel<PROPERTY> right)
static AggregateFunction.Count	count()
static AggregateFunction.Count	count(PropertyMetamodel<?> propertyMetamodel)
static AggregateFunction.Count	countDistinct(PropertyMetamodel<?> propertyMetamodel)
static <PROPERTY> ArithmeticExpression.Div<PROPERTY>	div(PropertyMetamodel<PROPERTY> left, PropertyMetamodel<PROPERTY> right)
static <PROPERTY> ArithmeticExpression.Div<PROPERTY>	div(PropertyMetamodel<PROPERTY> left, PROPERTY right)
static <PROPERTY> ArithmeticExpression.Div<PROPERTY>	div(PROPERTY left, PropertyMetamodel<PROPERTY> right)
static PropertyMetamodel<Boolean>	literal(boolean value)
static PropertyMetamodel<Byte>	literal(byte value)
static PropertyMetamodel<Double>	literal(double value)
static PropertyMetamodel<Float>	literal(float value)
static PropertyMetamodel<Integer>	literal(int value)
static PropertyMetamodel<Long>	literal(long value)
static PropertyMetamodel<Short>	literal(short value)
static PropertyMetamodel<String>	literal(String value)
static PropertyMetamodel<BigDecimal>	literal(BigDecimal value)
static PropertyMetamodel<BigInteger>	literal(BigInteger value)
static PropertyMetamodel<LocalDate>	literal(LocalDate value)
static PropertyMetamodel<LocalDateTime>	literal(LocalDateTime value)
static PropertyMetamodel<LocalTime>	literal(LocalTime value)
static <PROPERTY> StringExpression.Lower<PROPERTY>	lower(PropertyMetamodel<PROPERTY> propertyMetamodel)
static <PROPERTY> StringExpression.Ltrim<PROPERTY>	ltrim(PropertyMetamodel<PROPERTY> propertyMetamodel)
static <PROPERTY> AggregateFunction.Max<PROPERTY>	max(PropertyMetamodel<PROPERTY> propertyMetamodel)
static <PROPERTY> AggregateFunction.Min<PROPERTY>	min(PropertyMetamodel<PROPERTY> propertyMetamodel)
static <PROPERTY> ArithmeticExpression.Mod<PROPERTY>	mod(PropertyMetamodel<PROPERTY> left, PropertyMetamodel<PROPERTY> right)
static <PROPERTY> ArithmeticExpression.Mod<PROPERTY>	mod(PropertyMetamodel<PROPERTY> left, PROPERTY right)
static <PROPERTY> ArithmeticExpression.Mod<PROPERTY>	mod(PROPERTY left, PropertyMetamodel<PROPERTY> right)
static <PROPERTY> ArithmeticExpression.Mul<PROPERTY>	mul(PropertyMetamodel<PROPERTY> left, PropertyMetamodel<PROPERTY> right)
static <PROPERTY> ArithmeticExpression.Mul<PROPERTY>	mul(PropertyMetamodel<PROPERTY> left, PROPERTY right)
static <PROPERTY> ArithmeticExpression.Mul<PROPERTY>	mul(PROPERTY left, PropertyMetamodel<PROPERTY> right)
static <PROPERTY> StringExpression.Rtrim<PROPERTY>	rtrim(PropertyMetamodel<PROPERTY> propertyMetamodel)
static <PROPERTY> SelectExpression<PROPERTY>	select(Function<SelectExpression.Declaration,SubSelectContext.Single<PROPERTY>> block)
static <PROPERTY> ArithmeticExpression.Sub<PROPERTY>	sub(PropertyMetamodel<PROPERTY> left, PropertyMetamodel<PROPERTY> right)
static <PROPERTY> ArithmeticExpression.Sub<PROPERTY>	sub(PropertyMetamodel<PROPERTY> left, PROPERTY right)
static <PROPERTY> ArithmeticExpression.Sub<PROPERTY>	sub(PROPERTY left, PropertyMetamodel<PROPERTY> right)
static <PROPERTY> AggregateFunction.Sum<PROPERTY>	sum(PropertyMetamodel<PROPERTY> propertyMetamodel)
static <PROPERTY> StringExpression.Trim<PROPERTY>	trim(PropertyMetamodel<PROPERTY> propertyMetamodel)
static <PROPERTY> StringExpression.Upper<PROPERTY>	upper(PropertyMetamodel<PROPERTY> propertyMetamodel)
static <PROPERTY> UserDefinedExpression<PROPERTY>	userDefined(Class<PROPERTY> klass, String name, List<? extends PropertyMetamodel<?>> operands, Consumer<UserDefinedExpression.Declaration> block)	Creates a user-defined expression with the specified class and block.
static <PROPERTY> UserDefinedExpression<PROPERTY>	userDefined(Class<PROPERTY> klass, String name, PropertyMetamodel<?>[] operands, Consumer<UserDefinedExpression.Declaration> block)	Creates a user-defined expression with the specified class and block.
static <PROPERTY> UserDefinedExpression<PROPERTY>	userDefined(Class<PROPERTY> klass, String name, PropertyMetamodel<?> operand, Consumer<UserDefinedExpression.Declaration> block)	Creates a user-defined expression with the specified class and block.
static <PROPERTY> UserDefinedExpression<PROPERTY>	userDefined(Class<PROPERTY> klass, String name, PropertyMetamodel<?> operand1, PropertyMetamodel<?> operand2, Consumer<UserDefinedExpression.Declaration> block)	Creates a user-defined expression with the specified class and block.
static <PROPERTY> UserDefinedExpression<PROPERTY>	userDefined(Class<PROPERTY> klass, String name, PropertyMetamodel<?> operand1, PropertyMetamodel<?> operand2, PropertyMetamodel<?> operand3, Consumer<UserDefinedExpression.Declaration> block)	Creates a user-defined expression with the specified class and block.
static <PROPERTY> UserDefinedExpression<PROPERTY>	userDefined(PropertyMetamodel<PROPERTY> resultPropertyMetamodel, String name, List<? extends PropertyMetamodel<?>> operands, Consumer<UserDefinedExpression.Declaration> block)	Creates a user-defined expression with the specified resultPropertyMetamodel and block.
static <PROPERTY> UserDefinedExpression<PROPERTY>	userDefined(PropertyMetamodel<PROPERTY> resultPropertyMetamodel, String name, PropertyMetamodel<?>[] operands, Consumer<UserDefinedExpression.Declaration> block)	Creates a user-defined expression with the specified resultPropertyMetamodel and block.
static <PROPERTY> UserDefinedExpression<PROPERTY>	userDefined(PropertyMetamodel<PROPERTY> resultPropertyMetamodel, String name, PropertyMetamodel<?> operand, Consumer<UserDefinedExpression.Declaration> block)	Creates a user-defined expression with the specified resultPropertyMetamodel and block.
static <PROPERTY> UserDefinedExpression<PROPERTY>	userDefined(PropertyMetamodel<PROPERTY> resultPropertyMetamodel, String name, PropertyMetamodel<?> operand1, PropertyMetamodel<?> operand2, Consumer<UserDefinedExpression.Declaration> block)	Creates a user-defined expression with the specified resultPropertyMetamodel and block.
static <PROPERTY> UserDefinedExpression<PROPERTY>	userDefined(PropertyMetamodel<PROPERTY> resultPropertyMetamodel, String name, PropertyMetamodel<?> operand1, PropertyMetamodel<?> operand2, PropertyMetamodel<?> operand3, Consumer<UserDefinedExpression.Declaration> block)	Creates a user-defined expression with the specified resultPropertyMetamodel and block.
static <PROPERTY> CaseExpression<PROPERTY>	when(Consumer<CaseExpression<PROPERTY>.Declaration> block, PropertyMetamodel<PROPERTY> otherwise)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

Expressions

public Expressions()

Method Details

literal

public static PropertyMetamodel<BigDecimal> literal(BigDecimal value)

literal

public static PropertyMetamodel<BigInteger> literal(BigInteger value)

literal

public static PropertyMetamodel<Boolean> literal(boolean value)

literal

public static PropertyMetamodel<Byte> literal(byte value)

literal

public static PropertyMetamodel<Double> literal(double value)

literal

public static PropertyMetamodel<Float> literal(float value)

literal

public static PropertyMetamodel<Integer> literal(int value)

literal

public static PropertyMetamodel<LocalDate> literal(LocalDate value)

literal

public static PropertyMetamodel<LocalDateTime> literal(LocalDateTime value)

literal

public static PropertyMetamodel<LocalTime> literal(LocalTime value)

literal

public static PropertyMetamodel<Long> literal(long value)

literal

public static PropertyMetamodel<Short> literal(short value)

literal

public static PropertyMetamodel<String> literal(String value)

add

public static <PROPERTY>
ArithmeticExpression.Add<PROPERTY> add(PropertyMetamodel<PROPERTY> left,
 PROPERTY right)

add

public static <PROPERTY>
ArithmeticExpression.Add<PROPERTY> add(PROPERTY left,
 PropertyMetamodel<PROPERTY> right)

add

public static <PROPERTY>
ArithmeticExpression.Add<PROPERTY> add(PropertyMetamodel<PROPERTY> left,
 PropertyMetamodel<PROPERTY> right)

sub

public static <PROPERTY>
ArithmeticExpression.Sub<PROPERTY> sub(PropertyMetamodel<PROPERTY> left,
 PROPERTY right)

sub

public static <PROPERTY>
ArithmeticExpression.Sub<PROPERTY> sub(PROPERTY left,
 PropertyMetamodel<PROPERTY> right)

sub

public static <PROPERTY>
ArithmeticExpression.Sub<PROPERTY> sub(PropertyMetamodel<PROPERTY> left,
 PropertyMetamodel<PROPERTY> right)

mul

public static <PROPERTY>
ArithmeticExpression.Mul<PROPERTY> mul(PropertyMetamodel<PROPERTY> left,
 PROPERTY right)

mul

public static <PROPERTY>
ArithmeticExpression.Mul<PROPERTY> mul(PROPERTY left,
 PropertyMetamodel<PROPERTY> right)

mul

public static <PROPERTY>
ArithmeticExpression.Mul<PROPERTY> mul(PropertyMetamodel<PROPERTY> left,
 PropertyMetamodel<PROPERTY> right)

div

public static <PROPERTY>
ArithmeticExpression.Div<PROPERTY> div(PropertyMetamodel<PROPERTY> left,
 PROPERTY right)

div

public static <PROPERTY>
ArithmeticExpression.Div<PROPERTY> div(PROPERTY left,
 PropertyMetamodel<PROPERTY> right)

div

public static <PROPERTY>
ArithmeticExpression.Div<PROPERTY> div(PropertyMetamodel<PROPERTY> left,
 PropertyMetamodel<PROPERTY> right)

mod

public static <PROPERTY>
ArithmeticExpression.Mod<PROPERTY> mod(PropertyMetamodel<PROPERTY> left,
 PROPERTY right)

mod

public static <PROPERTY>
ArithmeticExpression.Mod<PROPERTY> mod(PROPERTY left,
 PropertyMetamodel<PROPERTY> right)

mod

public static <PROPERTY>
ArithmeticExpression.Mod<PROPERTY> mod(PropertyMetamodel<PROPERTY> left,
 PropertyMetamodel<PROPERTY> right)

concat

public static <PROPERTY>
StringExpression.Concat<PROPERTY> concat(PropertyMetamodel<PROPERTY> left,
 PROPERTY right)

concat

public static <PROPERTY>
StringExpression.Concat<PROPERTY> concat(PROPERTY left,
 PropertyMetamodel<PROPERTY> right)

concat

public static <PROPERTY>
StringExpression.Concat<PROPERTY> concat(PropertyMetamodel<PROPERTY> left,
 PropertyMetamodel<PROPERTY> right)

lower

public static <PROPERTY>
StringExpression.Lower<PROPERTY> lower(PropertyMetamodel<PROPERTY> propertyMetamodel)

ltrim

public static <PROPERTY>
StringExpression.Ltrim<PROPERTY> ltrim(PropertyMetamodel<PROPERTY> propertyMetamodel)

rtrim

public static <PROPERTY>
StringExpression.Rtrim<PROPERTY> rtrim(PropertyMetamodel<PROPERTY> propertyMetamodel)

trim

public static <PROPERTY>
StringExpression.Trim<PROPERTY> trim(PropertyMetamodel<PROPERTY> propertyMetamodel)

upper

public static <PROPERTY>
StringExpression.Upper<PROPERTY> upper(PropertyMetamodel<PROPERTY> propertyMetamodel)

avg

public static <PROPERTY>
AggregateFunction.Avg<PROPERTY> avg(PropertyMetamodel<PROPERTY> propertyMetamodel)

avgAsDouble

public static AggregateFunction.AvgAsDouble avgAsDouble(PropertyMetamodel<?> propertyMetamodel)

count

public static AggregateFunction.Count count()

count

public static AggregateFunction.Count count(PropertyMetamodel<?> propertyMetamodel)

countDistinct

public static AggregateFunction.Count countDistinct(PropertyMetamodel<?> propertyMetamodel)

max

public static <PROPERTY>
AggregateFunction.Max<PROPERTY> max(PropertyMetamodel<PROPERTY> propertyMetamodel)

min

public static <PROPERTY>
AggregateFunction.Min<PROPERTY> min(PropertyMetamodel<PROPERTY> propertyMetamodel)

sum

public static <PROPERTY>
AggregateFunction.Sum<PROPERTY> sum(PropertyMetamodel<PROPERTY> propertyMetamodel)

when

public static <PROPERTY> CaseExpression<PROPERTY> when(Consumer<CaseExpression<PROPERTY>.Declaration> block,
 PropertyMetamodel<PROPERTY> otherwise)

select

public static <PROPERTY> SelectExpression<PROPERTY> select(Function<SelectExpression.Declaration,SubSelectContext.Single<PROPERTY>> block)

alias

public static <PROPERTY> AliasExpression<PROPERTY> alias(PropertyMetamodel<PROPERTY> propertyMetamodel,
 String alias)

userDefined

public static <PROPERTY>
UserDefinedExpression<PROPERTY> userDefined(Class<PROPERTY> klass,
 String name,
 PropertyMetamodel<?>[] operands,
 Consumer<UserDefinedExpression.Declaration> block)

Creates a user-defined expression with the specified class and block.

The klass and name operands are used to determine identity of the expression.

Type Parameters:

PROPERTY - type of expression result

Parameters:

klass - the class of PROPERTY

name - the name that must be unique among user-defined column expressions

operands - the operand list used in the expression

block - the SQL builder

Returns:

user defined expression

userDefined

public static <PROPERTY>
UserDefinedExpression<PROPERTY> userDefined(Class<PROPERTY> klass,
 String name,
 PropertyMetamodel<?> operand,
 Consumer<UserDefinedExpression.Declaration> block)

Creates a user-defined expression with the specified class and block.

The klass and name operands are used to determine identity of the expression.

Type Parameters:

PROPERTY - type of expression result

Parameters:

klass - the class of PROPERTY

name - the name that must be unique among user-defined column expressions

operand - the operand used in the expression

block - the SQL builder

Returns:

user defined expression

userDefined

public static <PROPERTY>
UserDefinedExpression<PROPERTY> userDefined(Class<PROPERTY> klass,
 String name,
 PropertyMetamodel<?> operand1,
 PropertyMetamodel<?> operand2,
 Consumer<UserDefinedExpression.Declaration> block)

Creates a user-defined expression with the specified class and block.

The klass and name operands are used to determine identity of the expression.

Type Parameters:

PROPERTY - type of expression result

Parameters:

klass - the class of PROPERTY

name - the name that must be unique among user-defined column expressions

operand1 - the operand used in the expression

operand2 - the operand used in the expression

block - the SQL builder

Returns:

user defined expression

userDefined

public static <PROPERTY>
UserDefinedExpression<PROPERTY> userDefined(Class<PROPERTY> klass,
 String name,
 PropertyMetamodel<?> operand1,
 PropertyMetamodel<?> operand2,
 PropertyMetamodel<?> operand3,
 Consumer<UserDefinedExpression.Declaration> block)

Creates a user-defined expression with the specified class and block.

The klass and name operands are used to determine identity of the expression.

Type Parameters:

PROPERTY - type of expression result

Parameters:

klass - the class of PROPERTY

name - the name that must be unique among user-defined column expressions

operand1 - the operand used in the expression

operand2 - the operand used in the expression

operand3 - the operand used in the expression

block - the SQL builder

Returns:

user defined expression

userDefined

public static <PROPERTY>
UserDefinedExpression<PROPERTY> userDefined(Class<PROPERTY> klass,
 String name,
 List<? extends PropertyMetamodel<?>> operands,
 Consumer<UserDefinedExpression.Declaration> block)

Creates a user-defined expression with the specified class and block.

The klass and name operands are used to determine identity of the expression.

Type Parameters:

PROPERTY - type of expression result

Parameters:

klass - the class of PROPERTY

name - the name that must be unique among user-defined column expressions

operands - the operand list used in the expression

block - the SQL builder

Returns:

user defined expression

userDefined

public static <PROPERTY>
UserDefinedExpression<PROPERTY> userDefined(PropertyMetamodel<PROPERTY> resultPropertyMetamodel,
 String name,
 PropertyMetamodel<?>[] operands,
 Consumer<UserDefinedExpression.Declaration> block)

Creates a user-defined expression with the specified resultPropertyMetamodel and block.

The klass and name operands are used to determine identity of the expression.

Type Parameters:

PROPERTY - type of expression result

Parameters:

resultPropertyMetamodel - the property metamodel of PROPERTY

name - the name that must be unique among user-defined column expressions

operands - the operand list used in the expression

block - the SQL builder

Returns:

user defined expression

userDefined

public static <PROPERTY>
UserDefinedExpression<PROPERTY> userDefined(PropertyMetamodel<PROPERTY> resultPropertyMetamodel,
 String name,
 PropertyMetamodel<?> operand,
 Consumer<UserDefinedExpression.Declaration> block)

Creates a user-defined expression with the specified resultPropertyMetamodel and block.

The klass and name operands are used to determine identity of the expression.

Type Parameters:

PROPERTY - type of expression result

Parameters:

resultPropertyMetamodel - the property metamodel of PROPERTY

name - the name that must be unique among user-defined column expressions

operand - the operand used in the expression

block - the SQL builder

Returns:

user defined expression

userDefined

public static <PROPERTY>
UserDefinedExpression<PROPERTY> userDefined(PropertyMetamodel<PROPERTY> resultPropertyMetamodel,
 String name,
 PropertyMetamodel<?> operand1,
 PropertyMetamodel<?> operand2,
 Consumer<UserDefinedExpression.Declaration> block)

Creates a user-defined expression with the specified resultPropertyMetamodel and block.

The klass and name operands are used to determine identity of the expression.

Type Parameters:

PROPERTY - type of expression result

Parameters:

resultPropertyMetamodel - the property metamodel of PROPERTY

name - the name that must be unique among user-defined column expressions

operand1 - the operand used in the expression

operand2 - the operand used in the expression

block - the SQL builder

Returns:

user defined expression

userDefined

public static <PROPERTY>
UserDefinedExpression<PROPERTY> userDefined(PropertyMetamodel<PROPERTY> resultPropertyMetamodel,
 String name,
 PropertyMetamodel<?> operand1,
 PropertyMetamodel<?> operand2,
 PropertyMetamodel<?> operand3,
 Consumer<UserDefinedExpression.Declaration> block)

Creates a user-defined expression with the specified resultPropertyMetamodel and block.

The klass and name operands are used to determine identity of the expression.

Type Parameters:

PROPERTY - type of expression result

Parameters:

resultPropertyMetamodel - the property metamodel of PROPERTY

name - the name that must be unique among user-defined column expressions

operand1 - the operand used in the expression

operand2 - the operand used in the expression

operand3 - the operand used in the expression

block - the SQL builder

Returns:

user defined expression

userDefined

public static <PROPERTY>
UserDefinedExpression<PROPERTY> userDefined(PropertyMetamodel<PROPERTY> resultPropertyMetamodel,
 String name,
 List<? extends PropertyMetamodel<?>> operands,
 Consumer<UserDefinedExpression.Declaration> block)

Creates a user-defined expression with the specified resultPropertyMetamodel and block.

The klass and name operands are used to determine identity of the expression.

Type Parameters:

PROPERTY - type of expression result

Parameters:

resultPropertyMetamodel - the property metamodel of PROPERTY

name - the name that must be unique among user-defined column expressions

operands - the operand list used in the expression

block - the SQL builder

Returns:

user defined expression