Package com.evolveum.midpoint.repo.sqale.filtering

Class ExtensionItemFilterProcessor

java.lang.Object

com.evolveum.midpoint.repo.sqlbase.filtering.item.ItemValueFilterProcessor<ValueFilter<?,?>>

com.evolveum.midpoint.repo.sqale.filtering.ExtensionItemFilterProcessor

All Implemented Interfaces:

FilterProcessor<ValueFilter<?,?>>, RightHandProcessor

public class ExtensionItemFilterProcessor
extends ItemValueFilterProcessor<ValueFilter<?,?>>

Filter processor for extension items stored in JSONB. This takes care of any supported type, scalar or array, and handles any operation. NOTE about NOT treatment: We use the same not treatment for extensions like for other columns resulting in conditions like: `not (u.ext->>'1510' < ? and u.ext->>'1510' is not null)` One might think that the part after AND can be replaced with u.ext ? '1510' to benefit from the GIN index. But `NOT (u.ext ? '...')` is *not* fully complement to the `u.ext ? '...'` (without NOT). It is only fully complement if additional `AND u.ext is not null` is added in which case the index will not be used either. So instead of adding special treatment code for extensions, we just reuse existing predicateWithNotTreated methods.

Field Summary

Fields

Modifier and Type	Field	Description
static String	BOOLEAN_TYPE
static String	DATETIME_TYPE
static String	DECIMAL_TYPE
static String	DOUBLE_TYPE
static String	FLOAT_TYPE
static String	INT_TYPE
static String	INTEGER_TYPE
static String	LONG_TYPE
static String	POLY_STRING_TYPE
static String	SHORT_TYPE
static String	STRING_TYPE

Fields inherited from class com.evolveum.midpoint.repo.sqlbase.filtering.item.ItemValueFilterProcessor

context

Constructor Summary

Constructors

Constructor	Description
ExtensionItemFilterProcessor(SqlQueryContext<?,?,?> context, Function<FlexibleRelationalPathBase<?>,JsonbPath> rootToExtensionPath, MExtItemHolderType holderType)

Method Summary

Modifier and Type	Method	Description
protected boolean	isIgnoreCaseFilter(ValueFilter<?,?> filter)	Returns true, if the filter implies ignore-case behavior.
com.querydsl.core.types.Predicate	process(ValueFilter<?,?> filter)

Methods inherited from class com.evolveum.midpoint.repo.sqlbase.filtering.item.ItemValueFilterProcessor

createBinaryCondition, fuzzyStringPredicate, getSingleValue, operation, predicateWithNotTreated, rightHand, singleValuePredicate, singleValuePredicateWithNotTreated

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.evolveum.midpoint.repo.sqlbase.filtering.FilterProcessor

process

Field Detail

STRING_TYPE

public static final String STRING_TYPE

INT_TYPE

public static final String INT_TYPE

INTEGER_TYPE

public static final String INTEGER_TYPE

SHORT_TYPE

public static final String SHORT_TYPE

LONG_TYPE

public static final String LONG_TYPE

DECIMAL_TYPE

public static final String DECIMAL_TYPE

DOUBLE_TYPE

public static final String DOUBLE_TYPE

FLOAT_TYPE

public static final String FLOAT_TYPE

BOOLEAN_TYPE

public static final String BOOLEAN_TYPE

DATETIME_TYPE

public static final String DATETIME_TYPE

POLY_STRING_TYPE

public static final String POLY_STRING_TYPE

Constructor Detail

ExtensionItemFilterProcessor

public ExtensionItemFilterProcessor(SqlQueryContext<?,?,?> context,
                                    Function<FlexibleRelationalPathBase<?>,JsonbPath> rootToExtensionPath,
                                    MExtItemHolderType holderType)

Method Detail

process

public com.querydsl.core.types.Predicate process(ValueFilter<?,?> filter)
                                          throws RepositoryException

Throws:

RepositoryException

isIgnoreCaseFilter

protected boolean isIgnoreCaseFilter(ValueFilter<?,?> filter)

Description copied from class: ItemValueFilterProcessor

Returns true, if the filter implies ignore-case behavior. Used when filter is transformed to SQL operation, or to determine whether operands need some treatment (e.g. `lower()` function). Can be overridden to cover other matching rules, e.g. for poly-strings.

Overrides:

isIgnoreCaseFilter in class ItemValueFilterProcessor<ValueFilter<?,?>>