ch.jalu.datasourcecolumns.predicate

Class EqualsIgnoreCasePredicate<C>

java.lang.Object

ch.jalu.datasourcecolumns.predicate.AbstractPredicate<C>

ch.jalu.datasourcecolumns.predicate.EqualsIgnoreCasePredicate<C>

Type Parameters:

C - the context

All Implemented Interfaces:

Predicate<C>

public class EqualsIgnoreCasePredicate<C>
extends AbstractPredicate<C>

Predicate for a case-insensitive equals check.

WARNING: This functionality depends on your database engine. When using this, check that it behaves correctly and verify that the generated SQL isn't suboptimal in regards to performance. See also the constructors in PredicateSqlGenerator.

In MySQL, columns are case-insensitive by default, so the value in PredicateSqlGenerator.useNoCaseCollationForCaseInsensitiveEquals should be set to false for optimal performance.

In SQLite, columns are by default case-sensitive. Here, the above value should be set to true so that the predicate SQL generator performs case-insensitive checks with COLLATE NOCASE. Note that by default this will only work with ASCII characters, cf. SQLite's FAQ, Case-insensitive matching of Unicode characters does not work.

H2 is by default case-sensitive but does not support the COLLATE NOCASE syntax. When connecting, you can specify ignorecase=true in the connection URL.

Constructor Summary

Constructors

Constructor and Description
EqualsIgnoreCasePredicate(Column<String,C> column, String value, boolean isNegated)

Method Summary

Modifier and Type	Method and Description
Column<String,C>	getColumn()
String	getValue()
boolean	isNegated()

Methods inherited from class ch.jalu.datasourcecolumns.predicate.AbstractPredicate

and, or

Methods inherited from class java.lang.Object

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

Constructor Detail

EqualsIgnoreCasePredicate

public EqualsIgnoreCasePredicate(Column<String,C> column,
                                 String value,
                                 boolean isNegated)

Method Detail

getColumn

public Column<String,C> getColumn()

getValue

public String getValue()

isNegated

public boolean isNegated()