Class PBaseString<R,T>

java.lang.Object

io.ebean.typequery.TQProperty<R,T>

io.ebean.typequery.TQPropertyBase<R,T>

io.ebean.typequery.PBaseValueEqual<R,T>

io.ebean.typequery.PBaseComparable<R,T>

io.ebean.typequery.PBaseString<R,T>

Type Parameters:

R - the root query bean type

All Implemented Interfaces:

io.ebean.Query.Property<T>

Direct Known Subclasses:

PCidr, PClass, PCurrency, PInet, PInetAddress, PLocale, PTimeZone, PUri, PUrl, PZoneId, PZoneOffset

public abstract class PBaseString<R,T>
extends PBaseComparable<R,T>

Base for property types that store as String Varchar types.

Field Summary

Fields inherited from class TQProperty

_name, _root

Method Summary

Modifier and Type	Method	Description
final R	between(String lower, String upper)	Between lower and upper values.
final R	contains(String value)	Contains - uses a like with '%' wildcard added to the beginning and end.
final R	containsIfPresent(@Nullable String value)	Is contains if value is non-null and otherwise no expression is added to the query.
final R	endsWith(String value)	Ends with - uses a like with '%' wildcard added to the beginning.
final R	eq(String value)	Equal to.
final R	equalToType(T value)	Deprecated, for removal: This API element is subject to removal in a future version. migrate to PBaseValueEqual.eq(Object).
final R	ge(String value)	Greater than or Equal to.
final R	geOrNull(String value)	Greater than or Equal to OR Null.
final R	gt(String value)	Greater than.
final R	gtOrNull(String value)	Greater than OR Null.
final R	icontains(String value)	Case-insensitive contains.
final R	icontainsIfPresent(@Nullable String value)	Is case-insensitive contains if value is non-null and otherwise no expression is added to the query.
final R	iendsWith(String value)	Case-insensitive ends with.
final R	ieq(String value)	Case-insensitive is equal to.
final R	iequalTo(String value)	Case-insensitive is equal to.
final R	ilike(String value)	Case-insensitive like.
final R	ilikeIfPresent(@Nullable String value)	Is case-insensitive like if value is non-null and otherwise no expression is added to the query.
final R	inRange(String lower, String upper)	Greater or equal to lower value and strictly less than upper value.
final R	istartsWith(String value)	Case-insensitive starts with.
final R	istartsWithIfPresent(@Nullable String value)	Is case-insensitive starts with if value is non-null and otherwise no expression is added to the query.
final R	le(String value)	Less than or Equal to.
final R	leOrNull(String value)	Less than or Equal to OR null.
final R	like(String value)	Like - include '%' and '_' placeholders as necessary.
final R	likeIfPresent(@Nullable String value)	Is like if value is non-null and otherwise no expression is added to the query.
final R	lt(String value)	Less than.
final R	ltOrNull(String value)	Less than OR Null.
final R	ne(String value)	Not equal to.
final R	notEqualToType(T value)	Deprecated, for removal: This API element is subject to removal in a future version. migrate to PBaseValueEqual.ne(Object).
final R	startsWith(String value)	Starts with - uses a like with '%' wildcard added to the end.
final R	startsWithIfPresent(@Nullable String value)	Is starts with if value is non-null and otherwise no expression is added to the query.

Methods inherited from class PBaseComparable

between, betweenProperties, ge, ge, ge, geIfPresent, geOrNull, geSubQuery, greaterOrEqualTo, greaterThan, greaterThanOrNull, gt, gt, gt, gtIfPresent, gtOrNull, gtSubQuery, inRange, inRangeWith, inRangeWith, le, le, le, leIfPresent, leOrNull, lessOrEqualTo, lessThan, lessThanOrNull, leSubQuery, lt, lt, lt, ltIfPresent, ltOrNull, ltSubQuery

Methods inherited from class PBaseValueEqual

asMapKey, eq, eq, eq, eqIfPresent, eqOrNull, eqSubQuery, equalTo, equalToOrNull, in, in, in, inOrEmpty, inSubQuery, isIn, isIn, isIn, ne, ne, ne, neSubQuery, notEqualTo, notIn, notIn, notIn, notInSubQuery

Methods inherited from class TQPropertyBase

asc, desc

Methods inherited from class TQProperty

expr, isNotNull, isNull, propertyName, toString

Methods inherited from class Object

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

Method Details

equalToType

@Deprecated(forRemoval=true)
public final R equalToType(T value)

Deprecated, for removal: This API element is subject to removal in a future version.

migrate to PBaseValueEqual.eq(Object).

Is equal to. The same as eq but uses the strong type as argument rather than String.

Parameters:

value - the equal to bind value

Returns:

the root query bean instance

notEqualToType

@Deprecated(forRemoval=true)
public final R notEqualToType(T value)

Deprecated, for removal: This API element is subject to removal in a future version.

migrate to PBaseValueEqual.ne(Object).

Is not equal to. The same as ne but uses the strong type as argument rather than String.

Parameters:

value - the equal to bind value

Returns:

the root query bean instance

eq

public final R eq(String value)

Equal to.

Parameters:

value - the bind value

Returns:

the root query bean instance

ne

public final R ne(String value)

Not equal to.

Parameters:

value - the bind value

Returns:

the root query bean instance

gt

public final R gt(String value)

Greater than.

Parameters:

value - the bind value

Returns:

the root query bean instance

gtOrNull

public final R gtOrNull(String value)

Greater than OR Null.

Parameters:

value - the bind value

Returns:

the root query bean instance

ge

public final R ge(String value)

Greater than or Equal to.

Parameters:

value - the bind value

Returns:

the root query bean instance

geOrNull

public final R geOrNull(String value)

Greater than or Equal to OR Null.

Parameters:

value - the bind value

Returns:

the root query bean instance

lt

public final R lt(String value)

Less than.

Parameters:

value - the bind value

Returns:

the root query bean instance

ltOrNull

public final R ltOrNull(String value)

Less than OR Null.

Parameters:

value - the bind value

Returns:

the root query bean instance

le

public final R le(String value)

Less than or Equal to.

Parameters:

value - the bind value

Returns:

the root query bean instance

leOrNull

public final R leOrNull(String value)

Less than or Equal to OR null.

Parameters:

value - the bind value

Returns:

the root query bean instance

inRange

public final R inRange(String lower,
 String upper)

Greater or equal to lower value and strictly less than upper value.

This is generally preferable over Between for date and datetime types as SQL Between is inclusive on the upper bound (<= ) and generally we need the upper bound to be exclusive (< ).

Parameters:

lower - the lower bind value (>= )

upper - the upper bind value (< )

Returns:

the root query bean instance

between

public final R between(String lower,
 String upper)

Between lower and upper values.

Parameters:

lower - the lower bind value

upper - the upper bind value

Returns:

the root query bean instance

ieq

public final R ieq(String value)

Case-insensitive is equal to.

Parameters:

value - the equal to bind value

Returns:

the root query bean instance

iequalTo

public final R iequalTo(String value)

Case-insensitive is equal to.

Parameters:

value - the equal to bind value

Returns:

the root query bean instance

like

public final R like(String value)

Like - include '%' and '_' placeholders as necessary.

Parameters:

value - the equal to bind value

Returns:

the root query bean instance

startsWith

public final R startsWith(String value)

Starts with - uses a like with '%' wildcard added to the end.

Parameters:

value - the equal to bind value

Returns:

the root query bean instance

startsWithIfPresent

public final R startsWithIfPresent(@Nullable String value)

Is starts with if value is non-null and otherwise no expression is added to the query.

Parameters:

value - the value which can be null

Returns:

the root query bean instance

endsWith

public final R endsWith(String value)

Ends with - uses a like with '%' wildcard added to the beginning.

Parameters:

value - the equal to bind value

Returns:

the root query bean instance

contains

public final R contains(String value)

Contains - uses a like with '%' wildcard added to the beginning and end.

Parameters:

value - the equal to bind value

Returns:

the root query bean instance

containsIfPresent

public final R containsIfPresent(@Nullable String value)

Is contains if value is non-null and otherwise no expression is added to the query.

Parameters:

value - the value which can be null

Returns:

the root query bean instance

ilike

public final R ilike(String value)

Case-insensitive like.

Parameters:

value - the equal to bind value

Returns:

the root query bean instance

ilikeIfPresent

public final R ilikeIfPresent(@Nullable String value)

Is case-insensitive like if value is non-null and otherwise no expression is added to the query.

Parameters:

value - the value which can be null

Returns:

the root query bean instance

istartsWith

public final R istartsWith(String value)

Case-insensitive starts with.

Parameters:

value - the equal to bind value

Returns:

the root query bean instance

istartsWithIfPresent

public final R istartsWithIfPresent(@Nullable String value)

Is case-insensitive starts with if value is non-null and otherwise no expression is added to the query.

Parameters:

value - the value which can be null

Returns:

the root query bean instance

iendsWith

public final R iendsWith(String value)

Case-insensitive ends with.

Parameters:

value - the equal to bind value

Returns:

the root query bean instance

icontains

public final R icontains(String value)

Case-insensitive contains.

Parameters:

value - the equal to bind value

Returns:

the root query bean instance

icontainsIfPresent

public final R icontainsIfPresent(@Nullable String value)

Is case-insensitive contains if value is non-null and otherwise no expression is added to the query.

Parameters:

value - the value which can be null

Returns:

the root query bean instance

likeIfPresent

public final R likeIfPresent(@Nullable String value)

Is like if value is non-null and otherwise no expression is added to the query.

Parameters:

value - the value which can be null

Returns:

the root query bean instance