nz.co.gregs.dbvolution.operators

Class DBPermittedRangeExclusiveOperator

java.lang.Object

nz.co.gregs.dbvolution.operators.DBOperator

nz.co.gregs.dbvolution.operators.DBPermittedRangeExclusiveOperator

All Implemented Interfaces:

Serializable

public class DBPermittedRangeExclusiveOperator
extends DBOperator

Implements a BETWEEN operator that excludes the end points of the range.

Given a set of 1,2,3,4,5, using DBPermittedRangeExclusiveOperator(1,5) will produce an operation such that 2,3, and 4 will be returned but not 1, or 5.

Unbounded ranges are created by passing null as the lower- or upper-bound. For example, DBPermittedRangeExclusiveOperator(1,null) will produce an operation such that every number larger than 1 will be returned.

Support DBvolution at Patreon

Author:

Gregory Graham

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
protected DBOperator	operator

Constructor Summary

Constructors

Constructor and Description
DBPermittedRangeExclusiveOperator(Object lowerBound, Object upperBound) Implements a BETWEEN operator that excludes the end points of the range.

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

DBPermittedRangeExclusiveOperator

public DBPermittedRangeExclusiveOperator(Object lowerBound,
                                 Object upperBound)

Implements a BETWEEN operator that excludes the end points of the range.

Use a null value to create open or unbounded ranges.

Parameters:

lowerBound - the largest value smaller than the desired range

upperBound - the smallest value larger than the desired range

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