Package overit.geocallapp.utilities.core.data.criteria

Class CriterionUpper

java.lang.Object

overit.geocall.sql.code.criterion.Criterion

overit.geocallapp.utilities.core.data.criteria.CriterionUpper

All Implemented Interfaces:

Cloneable

public class CriterionUpper
extends Criterion

Custom Criterion for case-insensitive string comparison using UPPER() SQL function. This criterion wraps both the field and the parameter value with UPPER() to enable case-insensitive searches. The use of this operator on a specific field of a table probably requires the creation of a function-based index on UPPER(field).

Only works with String values and Collection<String> values.

For collections, extends OperationIn to wrap values with UPPER().

Example SQL output for String: UPPER(FIELD_NAME) = UPPER(?paramName)

Example SQL output for Collection<String>: UPPER(FIELD_NAME) IN (UPPER(?paramName%0), UPPER(?paramName%1), ...)

Field Summary

Fields inherited from class overit.geocall.sql.code.criterion.Criterion

ASSIGN_NULL, DIFFERENT, DISCARD, DISCARD_CONTROLS, DISCARD_NULLS, DISCARD_USELESS_COLLECTION, DISCARD_USELESS_LIKE, DISCARD_USELESS_SET, DISCARD_USELESS_STRING, EMPTY_SET, EQUAL, GREATER, GREATEREQUAL, IN, IS, ISNOT, ISNOTNULL, ISNULL, LESS, LESSEQUAL, LIKE, NOT_EQUAL, NOTIN, NULL_SET, REQUIRE_IS_DIFFERENT, REQUIRE_IS_EQUAL_TO, REQUIRE_IS_GREATER_THAN, REQUIRE_IS_GREATER_THAN_OR_EQUAL_TO, REQUIRE_IS_IN, REQUIRE_IS_LESS_THAN, REQUIRE_IS_LESS_THAN_OR_EQUAL_TO, REQUIRE_IS_LIKE, REQUIRE_IS_NOT_IN, REQUIRE_IS_NOT_NULL, REQUIRE_IS_NULL, RESET_EMPTY_SET, TAKE_EMPTY_COLLECTION, TAKE_EMPTY_SET, TAKE_IN, TAKE_IS_NULL, TAKE_LIKE, USELESS_COLLECTION, USELESS_LIKE, USELESS_SET, USELESS_STRING

Constructor Summary

Constructors

Constructor	Description
CriterionUpper()

Method Summary

Modifier and Type	Method	Description
Parts	define(String name, Object value)	defines the Parts of the operation with all the information to become a fragment.

Methods inherited from class overit.geocall.sql.code.criterion.Criterion

fieldDepiction

Methods inherited from class java.lang.Object

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

Constructor Details

CriterionUpper

public CriterionUpper()

Method Details

define

public Parts define(String name,
 Object value)

Description copied from class: Criterion

defines the Parts of the operation with all the information to become a fragment.

Specified by:

define in class Criterion

Parameters:

name - the nome of the context field

value - the current value of the context field

Returns:

return null if the Criterion don't find an information, a Parts otherwise. Then Parts con also contain empty strings if the decision is to discard the name and the value