Module io.ebean.api

Package io.ebean

Class StdOperators

java.lang.Object

io.ebean.StdOperators

public final class StdOperators
extends Object

Standard Operators for use with strongly typed query construction.

This is currently deemed to be experimental and subject to change.

Constructor Summary

Constructors

Constructor	Description
StdOperators()

Method Summary

Modifier and Type	Method	Description
static <T> Query.Property<T>	avg(Query.Property<T> property)	Average of the given property.
static <T> Query.Property<T>	coalesce(Query.Property<T> property, Object value)	Coalesce of the property and value.
static Query.Property<String>	concat(Query.Property<?> property, Object... values)	Concat of the given property and values or other properties.
static Expression	contains(Query.Property<String> property, String value)	Contains - for a given property and value.
static Query.Property<Number>	count(Query.Property<?> property)	Count of the given property.
static <T> Expression	eq(Query.Property<T> property, Query<?> subQuery)	Equal to - for a property and sub-query.
static <T> Expression	eq(Query.Property<T> property, T value)	Equal to - for a property and value.
static <T> Expression	eqOrNull(Query.Property<T> property, T value)	Equal to or null - for a property and value.
static <T> Expression	ge(Query.Property<T> property, Query<?> subQuery)	Greater than or equal to - for a property and sub-query.
static <T> Expression	ge(Query.Property<T> property, T value)	Greater than or equal to - for a property and value.
static <T> Expression	geOrNull(Query.Property<T> property, T value)	Greater than or null - for a property and value.
static <T> Expression	gt(Query.Property<T> property, Query<?> subQuery)	Greater than - for a property and sub-query.
static <T> Expression	gt(Query.Property<T> property, T value)	Greater than - for a property and value.
static <T> Expression	gtOrNull(Query.Property<T> property, T value)	Greater than or null - for a property and value.
static Expression	icontains(Query.Property<String> property, String value)	Case-insensitive contains - for a given property and value.
static Expression	ilike(Query.Property<String> property, String value)	Case-insensitive Like - for a given property and value.
static <T> Expression	in(Query.Property<T> property, Query<?> subQuery)	In - for a given property and sub-query.
static <T> Expression	in(Query.Property<T> property, Collection<T> value)	In - for a given property and collection of values.
static <T> Expression	inOrEmpty(Query.Property<T> property, Collection<T> value)	In or empty - for a given property and collection of values.
static <T> Expression	inRange(Query.Property<T> lowProperty, Query.Property<T> property, Query.Property<T> highProperty)	In range - for properties.
static <T> Expression	inRange(Query.Property<T> lowProperty, Query.Property<T> highProperty, T value)	In range - for properties and a value.
static <T> Expression	inRange(Query.Property<T> property, T lowValue, T highValue)	In range - for a property and values.
static Expression	istartsWith(Query.Property<String> property, String value)	Case-insensitive starts with - for a given property and value.
static <T> Expression	le(Query.Property<T> property, Query<?> subQuery)	Greater than or equal to - for a property and sub-query.
static <T> Expression	le(Query.Property<T> property, T value)	Greater than or equal to - for a property and value.
static <T> Expression	leOrNull(Query.Property<T> property, T value)	Greater than or equal to or null - for a property and value.
static Expression	like(Query.Property<String> property, String value)	Like - for a given property and value.
static Query.Property<String>	lower(Query.Property<String> property)	Lower of the given property.
static <T> Expression	lt(Query.Property<T> property, Query<?> subQuery)	Less than - for a property and sub-query.
static <T> Expression	lt(Query.Property<T> property, T value)	Less than - for a property and value.
static <T> Expression	ltOrNull(Query.Property<T> property, T value)	Less than or null - for a property and value.
static <T> Query.Property<T>	max(Query.Property<T> property)	Max of the given property.
static <T> Query.Property<T>	min(Query.Property<T> property)	Min of the given property.
static <T> Expression	ne(Query.Property<T> property, Query<?> subQuery)	Not equal to - for a property and sub-query.
static <T> Expression	ne(Query.Property<T> property, T value)	Not equal to - for a property and value.
static <T> Expression	notIn(Query.Property<T> property, Query<?> subQuery)	Not In - for a given property and sub-query.
static <T> Expression	notIn(Query.Property<T> property, Collection<T> value)	Not In - for a given property and collection of values.
static Expression	startsWith(Query.Property<String> property, String value)	Starts with - for a given property and value.
static Query.Property<Number>	sum(Query.Property<? extends Number> property)	Sum of the given property.
static Query.Property<String>	upper(Query.Property<String> property)	Upper of the given property.

Methods inherited from class java.lang.Object

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

Constructor Details

StdOperators

public StdOperators()

Method Details

sum

public static Query.Property<Number> sum(Query.Property<? extends Number> property)

Sum of the given property.

count

public static Query.Property<Number> count(Query.Property<?> property)

Count of the given property.

avg

public static <T> Query.Property<T> avg(Query.Property<T> property)

Average of the given property.

max

public static <T> Query.Property<T> max(Query.Property<T> property)

Max of the given property.

min

public static <T> Query.Property<T> min(Query.Property<T> property)

Min of the given property.

coalesce

public static <T> Query.Property<T> coalesce(Query.Property<T> property,
 Object value)

Coalesce of the property and value.

lower

public static Query.Property<String> lower(Query.Property<String> property)

Lower of the given property.

upper

public static Query.Property<String> upper(Query.Property<String> property)

Upper of the given property.

concat

public static Query.Property<String> concat(Query.Property<?> property,
 Object... values)

Concat of the given property and values or other properties.

eq

public static <T> Expression eq(Query.Property<T> property,
 T value)

Equal to - for a property and value.

eq

public static <T> Expression eq(Query.Property<T> property,
 Query<?> subQuery)

Equal to - for a property and sub-query.

eqOrNull

public static <T> Expression eqOrNull(Query.Property<T> property,
 T value)

Equal to or null - for a property and value.

ne

public static <T> Expression ne(Query.Property<T> property,
 T value)

Not equal to - for a property and value.

ne

public static <T> Expression ne(Query.Property<T> property,
 Query<?> subQuery)

Not equal to - for a property and sub-query.

gt

public static <T> Expression gt(Query.Property<T> property,
 T value)

Greater than - for a property and value.

gt

public static <T> Expression gt(Query.Property<T> property,
 Query<?> subQuery)

Greater than - for a property and sub-query.

gtOrNull

public static <T> Expression gtOrNull(Query.Property<T> property,
 T value)

Greater than or null - for a property and value.

ge

public static <T> Expression ge(Query.Property<T> property,
 T value)

Greater than or equal to - for a property and value.

ge

public static <T> Expression ge(Query.Property<T> property,
 Query<?> subQuery)

Greater than or equal to - for a property and sub-query.

geOrNull

public static <T> Expression geOrNull(Query.Property<T> property,
 T value)

Greater than or null - for a property and value.

lt

public static <T> Expression lt(Query.Property<T> property,
 T value)

Less than - for a property and value.

lt

public static <T> Expression lt(Query.Property<T> property,
 Query<?> subQuery)

Less than - for a property and sub-query.

ltOrNull

public static <T> Expression ltOrNull(Query.Property<T> property,
 T value)

Less than or null - for a property and value.

le

public static <T> Expression le(Query.Property<T> property,
 T value)

Greater than or equal to - for a property and value.

le

public static <T> Expression le(Query.Property<T> property,
 Query<?> subQuery)

Greater than or equal to - for a property and sub-query.

leOrNull

public static <T> Expression leOrNull(Query.Property<T> property,
 T value)

Greater than or equal to or null - for a property and value.

inRange

public static <T> Expression inRange(Query.Property<T> property,
 T lowValue,
 T highValue)

In range - for a property and values.

inRange

public static <T> Expression inRange(Query.Property<T> lowProperty,
 Query.Property<T> highProperty,
 T value)

In range - for properties and a value.

inRange

public static <T> Expression inRange(Query.Property<T> lowProperty,
 Query.Property<T> property,
 Query.Property<T> highProperty)

In range - for properties.

in

public static <T> Expression in(Query.Property<T> property,
 Collection<T> value)

In - for a given property and collection of values.

in

public static <T> Expression in(Query.Property<T> property,
 Query<?> subQuery)

In - for a given property and sub-query.

inOrEmpty

public static <T> Expression inOrEmpty(Query.Property<T> property,
 Collection<T> value)

In or empty - for a given property and collection of values.

notIn

public static <T> Expression notIn(Query.Property<T> property,
 Collection<T> value)

Not In - for a given property and collection of values.

notIn

public static <T> Expression notIn(Query.Property<T> property,
 Query<?> subQuery)

Not In - for a given property and sub-query.

like

public static Expression like(Query.Property<String> property,
 String value)

Like - for a given property and value.

ilike

public static Expression ilike(Query.Property<String> property,
 String value)

Case-insensitive Like - for a given property and value.

startsWith

public static Expression startsWith(Query.Property<String> property,
 String value)

Starts with - for a given property and value.

istartsWith

public static Expression istartsWith(Query.Property<String> property,
 String value)

Case-insensitive starts with - for a given property and value.

contains

public static Expression contains(Query.Property<String> property,
 String value)

Contains - for a given property and value.

icontains

public static Expression icontains(Query.Property<String> property,
 String value)

Case-insensitive contains - for a given property and value.