sirius.db.jdbc.constraints

Class Like

java.lang.Object

sirius.db.jdbc.constraints.Like

public class Like
extends Object

Represents a LIKE constraint.

This can be used to generate queries like x LIKE 'a%'. Using the helper methods this can also be used to search for occurrences of serveral words in several fields, this can be used as a general table search.

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	Like(Mapping field)

Method Summary

Modifier and Type	Method and Description
SQLConstraint	build() Generates a constraint for the given settings
Like	contains(String value) Sepcifies a value which needs to occur anywhere in the target field.
Like	ignoreCase() Specifies that upper- and lowercase should not be distinguished.
Like	ignoreEmpty() Permits to skip this constraint if the given filter value is empty.
Like	matches(String value) Specifies a value to match in the given field.
Like	startsWith(String value) Sepcifies a value with which the target field needs to start.

Methods inherited from class java.lang.Object

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

Constructor Detail

Like

protected Like(Mapping field)

Method Detail

matches

public Like matches(String value)

Specifies a value to match in the given field.

Note that "*" will be repalced by "%" as this is the wildcard used by SQL.

Parameters:

value - the text to search for

Returns:

the constraint itself

contains

public Like contains(String value)

Sepcifies a value which needs to occur anywhere in the target field.

This is roughly the same as calling matches("*"+value+"*").

Parameters:

value - the value to search for

Returns:

the constaint itself

startsWith

public Like startsWith(String value)

Sepcifies a value with which the target field needs to start.

This is roughly the same as calling matches(value+"*").

Parameters:

value - the value to search for

Returns:

the constaint itself

ignoreCase

public Like ignoreCase()

Specifies that upper- and lowercase should not be distinguished.

Returns:

the constraint itself

ignoreEmpty

public Like ignoreEmpty()

Permits to skip this constraint if the given filter value is empty.

Returns:

the constraint itself

build

@Nullable
public SQLConstraint build()

Generates a constraint for the given settings

Returns:

a constraint based on the given settings or null if no constraint was generated