mapfish.lib.filters.comparison¶

class mapfish.lib.filters.comparison.Comparison(type, column, **kwargs)¶

Comparison filter

type

the type of filter to create. Possible values are:

Comparison.EQUAL_TO

Comparison.NOT_EQUAL_TO

Comparison.LOWER_THAN

Comparison.LOWER_THAN_OR_EQUAL_TO

Comparison.GREATER_THAN

Comparison.GREATER_THAN_OR_EQUAL_TO

Comparison.BETWEEN

Comparison.LIKE

Comparison.ILIKE

column

the column to use for the comparison.

**kwargs

lower_bound

the lower bound value, to be used with the BETWEEN type.

upper_bound

the upper bound value, to be used with the BETWEEN type.

value

the value to use.

to_sql_expr()¶

Return the SQLAlchemy SQL expression corresponding to that filter.