nz.co.gregs.dbvolution.operators

Class DBPermittedRangeInclusiveOperator

java.lang.Object

nz.co.gregs.dbvolution.operators.DBOperator

nz.co.gregs.dbvolution.operators.DBPermittedRangeInclusiveOperator

All Implemented Interfaces:

Serializable

public class DBPermittedRangeInclusiveOperator
extends DBOperator

Implements a BETWEEN operator that includes 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 1, 2, 3, 4, and 5 will be returned.

Unbounded ranges are created by passing null as the lower- or upper-bound. For example, DBPermittedRangeExclusiveOperator(1,null) will produce an operation such that 1 and every number larger 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
DBPermittedRangeInclusiveOperator(Object lowerBound, Object upperBound) Implements a BETWEEN operator that includes 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

DBPermittedRangeInclusiveOperator

public DBPermittedRangeInclusiveOperator(Object lowerBound,
                                 Object upperBound)

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

Use a null value to create open or unbounded ranges.

Parameters:

lowerBound - the smallest value of the desired range

upperBound - the largest value of 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