nz.co.gregs.dbvolution.operators

Class DBPermittedValuesIgnoreCaseOperator

java.lang.Object

nz.co.gregs.dbvolution.operators.DBOperator

nz.co.gregs.dbvolution.operators.DBPermittedValuesIgnoreCaseOperator

All Implemented Interfaces:

Serializable

public class DBPermittedValuesIgnoreCaseOperator
extends DBOperator

Provides an operator that checks that the column matches the provided values, while remaining case-insensitive. Creates a virtual operator that provides access to the ISNULL, EQUALS, or IN operator as required while ensuring that the actual operation is case-insensitive.

Support DBvolution at Patreon

Author:

gregorygraham

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
protected DBOperator	operator

Constructor Summary

Constructors

Constructor and Description
DBPermittedValuesIgnoreCaseOperator(Collection<String> permitted) Provides an operator that checks that the column matches the provided values, while remaining case-insensitive.
DBPermittedValuesIgnoreCaseOperator(String... permitted) Provides an operator that checks that the column matches the provided values, while remaining case-insensitive.
DBPermittedValuesIgnoreCaseOperator(StringExpression[] permitted) Provides an operator that checks that the column matches the provided values, while remaining case-insensitive.

Method Summary

Methods

Modifier and Type	Method and Description
DBOperator	copyAndAdapt(QueryableDatatypeSyncer.DBSafeInternalQDTAdaptor typeAdaptor) Adds TypeAdaptor support to DBOperator.
BooleanExpression	generateWhereExpression(DBDefinition db, DBExpression column) Create the expression to be used in the query generation.
void	invertOperator(Boolean invertOperator) Make this operator an exclusive rather than inclusive comparison.
void	not() Make this operator an exclusive rather than inclusive comparison.

Methods inherited from class nz.co.gregs.dbvolution.operators.DBOperator

equals, getFirstValue, getSecondValue, getThirdValue, hashCode, includeNulls, setFirstValue, setSecondValue, setThirdValue

Methods inherited from class java.lang.Object

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

Field Detail

operator

protected DBOperator operator

Constructor Detail

DBPermittedValuesIgnoreCaseOperator

public DBPermittedValuesIgnoreCaseOperator(String... permitted)

Provides an operator that checks that the column matches the provided values, while remaining case-insensitive. Creates a virtual operator that provides access to the ISNULL, EQUALS, or IN operator as required while ensuring that the actual operation is case-insensitive.

Parameters:

permitted - a list of strings that are permitted values.

DBPermittedValuesIgnoreCaseOperator

public DBPermittedValuesIgnoreCaseOperator(StringExpression[] permitted)

Provides an operator that checks that the column matches the provided values, while remaining case-insensitive. Creates a virtual operator that provides access to the ISNULL, EQUALS, or IN operator as required while ensuring that the actual operation is case-insensitive.

Parameters:

permitted - a list of string expression that are permitted values.

DBPermittedValuesIgnoreCaseOperator

public DBPermittedValuesIgnoreCaseOperator(Collection<String> permitted)

Provides an operator that checks that the column matches the provided values, while remaining case-insensitive. Creates a virtual operator that provides access to the ISNULL, EQUALS, or IN operator as required while ensuring that the actual operation is case-insensitive.

Parameters:

permitted - a list of strings that are permitted values.

Method Detail

copyAndAdapt

public DBOperator copyAndAdapt(QueryableDatatypeSyncer.DBSafeInternalQDTAdaptor typeAdaptor)

Description copied from class: DBOperator

Adds TypeAdaptor support to DBOperator.

Specified by:

copyAndAdapt in class DBOperator

Parameters:

typeAdaptor -

Support DBvolution at Patreon

Returns:

the type adapted operator

generateWhereExpression

public BooleanExpression generateWhereExpression(DBDefinition db,
                                        DBExpression column)

Description copied from class: DBOperator

Create the expression to be used in the query generation.

Specified by:

generateWhereExpression in class DBOperator

column -

Support DBvolution at Patreon

Returns:

a boolean expression

invertOperator

public void invertOperator(Boolean invertOperator)

Description copied from class: DBOperator

Make this operator an exclusive rather than inclusive comparison.

Basically switches the operator from, for instance, "==" to "!=".

Overrides:

invertOperator in class DBOperator

not

public void not()

Description copied from class: DBOperator

Make this operator an exclusive rather than inclusive comparison.

Basically switches the operator from, for instance, "==" to "!=".

Overrides:

not in class DBOperator