butler.sql.filter
Class RangeFilter

java.lang.Object
  butler.sql.filter.Filter
      butler.sql.filter.RangeFilter

public class RangeFilter
extends Filter

Filter that checks if a column value is within a specified interval

Author:

Fredrik Bertilsson

Field Summary

protected java.lang.String	_alias
protected Column	_column
protected Column	_column2
protected int	_noOfInputValues

Constructor Summary

RangeFilter(Column column)

RangeFilter(Column minColumn, Column maxColumn)

RangeFilter(Column minColumn, Column maxColumn, java.lang.Object value)

RangeFilter(Column startCol, Column endCol, java.lang.Object minValue, java.lang.Object maxValue)

RangeFilter(Column column, java.lang.Object minValue, java.lang.Object maxValue)

RangeFilter(java.lang.String alias, Column column)

RangeFilter(java.lang.String alias, Column minColumn, Column maxColumn)

Method Summary

java.lang.String	getCaption()
Column	getColumn()
Column	getColumn2()
protected java.lang.String	getElementName()
java.lang.Object	getMaxValue()
java.lang.Object	getMinValue()
int	getNoOfInputValues()
java.util.List	getParamDatatypes()
java.lang.String	getSQL()
java.util.List	getValues()
boolean	isOverlapping()
Filter	modify(QueryParams params)
java.util.List	params2db(java.util.List params)
static Filter	parse(org.dom4j.Element element, java.util.Map tableDictonary)
void	populate(Populatable qi, java.lang.Object value)
void	populate(Populatable qi, java.lang.Object minValue, java.lang.Object maxValue)
void	setCaption(java.lang.String caption)
void	setMaxInclusive(boolean flag)
void	setMinInclusive(boolean flag)
void	setNoOfInputValues(int noOfInputValues)
void	setOverlapping(boolean overlapping)
void	setValue(java.lang.Object value)
void	setValues(java.lang.Object minValue, java.lang.Object maxValue)
void	toXML(org.xml.sax.ContentHandler handler)

Methods inherited from class butler.sql.filter.Filter

and, copy, createId, equals, filter, getFilter, getId, getLeafFilters, getNestedQuery, getOperator, getValues, hashCode, not, or, parseFilter, registerFilterParser, setId, setOperator, setSize, setSize, toXML

Methods inherited from class java.lang.Object

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

Field Detail

_column

protected Column _column

_column2

protected Column _column2

_alias

protected java.lang.String _alias

_noOfInputValues

protected int _noOfInputValues

Constructor Detail

RangeFilter

public RangeFilter(Column column)
            throws java.lang.Exception

Throws:

java.lang.Exception

RangeFilter

public RangeFilter(java.lang.String alias,
                   Column minColumn,
                   Column maxColumn)
            throws java.lang.Exception

Throws:

java.lang.Exception

RangeFilter

public RangeFilter(Column minColumn,
                   Column maxColumn)
            throws java.lang.Exception

Throws:

java.lang.Exception

RangeFilter

public RangeFilter(Column minColumn,
                   Column maxColumn,
                   java.lang.Object value)
            throws java.lang.Exception

Throws:

java.lang.Exception

RangeFilter

public RangeFilter(Column column,
                   java.lang.Object minValue,
                   java.lang.Object maxValue)
            throws java.lang.Exception

Throws:

java.lang.Exception

RangeFilter

public RangeFilter(java.lang.String alias,
                   Column column)
            throws java.lang.Exception

Throws:

java.lang.Exception

RangeFilter

public RangeFilter(Column startCol,
                   Column endCol,
                   java.lang.Object minValue,
                   java.lang.Object maxValue)

Method Detail

setNoOfInputValues

public void setNoOfInputValues(int noOfInputValues)

getNoOfInputValues

public int getNoOfInputValues()

setMinInclusive

public void setMinInclusive(boolean flag)

setMaxInclusive

public void setMaxInclusive(boolean flag)

getSQL

public java.lang.String getSQL()

Overrides:

getSQL in class Filter

getColumn

public Column getColumn()

getColumn2

public Column getColumn2()

getCaption

public java.lang.String getCaption()

Overrides:

getCaption in class Filter

setCaption

public void setCaption(java.lang.String caption)

Overrides:

setCaption in class Filter

populate

public void populate(Populatable qi,
                     java.lang.Object minValue,
                     java.lang.Object maxValue)
              throws java.lang.Exception

Throws:

java.lang.Exception

params2db

public java.util.List params2db(java.util.List params)
                         throws java.lang.Exception

Overrides:

params2db in class Filter

Throws:

java.lang.Exception

populate

public void populate(Populatable qi,
                     java.lang.Object value)
              throws java.lang.Exception

Throws:

java.lang.Exception

setValue

public void setValue(java.lang.Object value)

setValues

public void setValues(java.lang.Object minValue,
                      java.lang.Object maxValue)

getValues

public java.util.List getValues()

Overrides:

getValues in class Filter

getMinValue

public java.lang.Object getMinValue()

getMaxValue

public java.lang.Object getMaxValue()

getElementName

protected java.lang.String getElementName()

toXML

public void toXML(org.xml.sax.ContentHandler handler)
           throws java.lang.Exception

Overrides:

toXML in class Filter

Throws:

java.lang.Exception

parse

public static Filter parse(org.dom4j.Element element,
                           java.util.Map tableDictonary)
                    throws java.lang.Exception

Throws:

java.lang.Exception

modify

public Filter modify(QueryParams params)
              throws java.lang.Exception

Overrides:

modify in class Filter

Throws:

java.lang.Exception

getParamDatatypes

public java.util.List getParamDatatypes()
                                 throws java.lang.Exception

Overrides:

getParamDatatypes in class Filter

Throws:

java.lang.Exception

isOverlapping

public boolean isOverlapping()

setOverlapping

public void setOverlapping(boolean overlapping)