Package org.apache.syncope.core.persistence.jpa.dao

Class OracleJPAAnySearchDAO

java.lang.Object

org.apache.syncope.core.persistence.common.dao.AbstractSearchDAO

org.apache.syncope.core.persistence.common.dao.AbstractAnySearchDAO

org.apache.syncope.core.persistence.jpa.dao.OracleJPAAnySearchDAO

All Implemented Interfaces:

AnySearchDAO

public class OracleJPAAnySearchDAO
extends AbstractAnySearchDAO

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.syncope.core.persistence.common.dao.AbstractSearchDAO

AbstractSearchDAO.CheckResult<C extends AttrCond>

Field Summary

Fields

Modifier and Type	Field	Description
protected final EntityManager	entityManager
protected static final String	SELECT_COLS_FROM_VIEW

Fields inherited from class org.apache.syncope.core.persistence.common.dao.AbstractAnySearchDAO

anyObjectDAO, anyUtilsFactory, dynRealmDAO, groupDAO, LOG, realmSearchDAO, RELATIONSHIP_FIELDS, userDAO

Fields inherited from class org.apache.syncope.core.persistence.common.dao.AbstractSearchDAO

ALWAYS_FALSE_CLAUSE, entityFactory, LITERAL_COMPARATOR, plainSchemaDAO, validator

Constructor Summary

Constructors

Constructor	Description
OracleJPAAnySearchDAO(RealmSearchDAO realmSearchDAO, DynRealmDAO dynRealmDAO, UserDAO userDAO, GroupDAO groupDAO, AnyObjectDAO anyObjectDAO, PlainSchemaDAO schemaDAO, EntityFactory entityFactory, AnyUtilsFactory anyUtilsFactory, PlainAttrValidationManager validator, EntityManager entityManager)

Method Summary

Modifier and Type	Method	Description
protected String	anyId(SearchSupport svs)
protected String	anyId(SearchSupport.SearchView sv)
protected AnySearchNode.Leaf	buildAdminRealmsFilter(Set<String> realmKeys, SearchSupport svs, List<Object> parameters)
protected String	buildCountQuery(org.apache.syncope.core.persistence.jpa.dao.AbstractJPAAnySearchDAO.QueryInfo queryInfo, AnySearchNode.Leaf filterNode, List<Object> parameters, SearchSupport svs)
protected String	buildFrom(Set<SearchSupport.SearchView> from, Set<String> plainSchemas, OrderBySupport obs)
protected String	buildSearchQuery(org.apache.syncope.core.persistence.jpa.dao.AbstractJPAAnySearchDAO.QueryInfo queryInfo, AnySearchNode.Leaf filterNode, List<Object> parameters, SearchSupport svs, List<org.springframework.data.domain.Sort.Order> orderBy)
protected String	buildWhere(List<String> where, AnySearchNode root)
protected SearchSupport.SearchView	defaultSV(SearchSupport svs)
protected long	doCount(Realm base, boolean recursive, Set<String> adminRealms, SearchCond cond, AnyTypeKind kind)
protected <T extends Any> List<T>	doSearch(Realm base, boolean recursive, Set<String> adminRealms, SearchCond cond, org.springframework.data.domain.Pageable pageable, AnyTypeKind kind)
protected AnySearchNode.Leaf	filJSONAttrQuery(SearchSupport.SearchView from, PlainAttrValue attrValue, PlainSchema schema, AttrCond cond, boolean not, List<Object> parameters)
protected AnySearchNode.Leaf	fillAttrQuery(String column, SearchSupport.SearchView from, PlainAttrValue attrValue, PlainSchema schema, AttrCond cond, boolean not, List<Object> parameters)
protected static void	fillWithParameters(Query query, List<Object> parameters)
static String	from(PlainSchema schema)
protected org.apache.syncope.core.persistence.jpa.dao.AbstractJPAAnySearchDAO.AdminRealmsFilter	getAdminRealmsFilter(Realm base, boolean recursive, Set<String> adminRealms, List<Object> parameters, SearchSupport svs)
protected AnySearchNode	getQuery(AnyCond cond, boolean not, List<Object> parameters, SearchSupport svs)
protected AnySearchNode	getQuery(AnyTypeCond cond, boolean not, List<Object> parameters, SearchSupport svs)
protected org.apache.syncope.core.persistence.jpa.dao.AbstractJPAAnySearchDAO.AttrCondQuery	getQuery(AttrCond cond, boolean not, AbstractSearchDAO.CheckResult<AttrCond> checked, List<Object> parameters, SearchSupport svs)
protected AnySearchNode	getQuery(AuxClassCond cond, boolean not, List<Object> parameters, SearchSupport svs)
protected AnySearchNode	getQuery(DynRealmCond cond, boolean not, List<Object> parameters, SearchSupport svs)
protected AnySearchNode	getQuery(MemberCond cond, boolean not, List<Object> parameters, SearchSupport svs)
protected AnySearchNode	getQuery(MembershipCond cond, boolean not, List<Object> parameters, SearchSupport svs)
protected AnySearchNode	getQuery(RelationshipCond cond, boolean not, List<Object> parameters, SearchSupport svs)
protected AnySearchNode	getQuery(RelationshipTypeCond cond, boolean not, List<Object> parameters, SearchSupport svs)
protected AnySearchNode	getQuery(ResourceCond cond, boolean not, List<Object> parameters, SearchSupport svs)
protected AnySearchNode	getQuery(RoleCond cond, boolean not, List<Object> parameters, SearchSupport svs)
protected Optional<org.apache.syncope.core.persistence.jpa.dao.AbstractJPAAnySearchDAO.QueryInfo>	getQuery(SearchCond cond, List<Object> parameters, SearchSupport svs)
protected Optional<AnySearchNode>	getQueryForCustomConds(SearchCond cond, List<Object> parameters, SearchSupport svs, boolean not)
protected OrderBySupport	parseOrderBy(SearchSupport svs, List<org.springframework.data.domain.Sort.Order> orderBy)
protected void	parseOrderByForCustom(SearchSupport svs, org.springframework.data.domain.Sort.Order clause, OrderBySupport.Item item, OrderBySupport obs)
protected void	parseOrderByForField(SearchSupport svs, OrderBySupport.Item item, String fieldName, org.springframework.data.domain.Sort.Order clause)
protected void	parseOrderByForPlainSchema(SearchSupport svs, OrderBySupport obs, OrderBySupport.Item item, org.springframework.data.domain.Sort.Order clause, PlainSchema schema, String fieldName)
protected static int	setParameter(List<Object> parameters, Object parameter)
protected void	visitNode(AnySearchNode node, Map<SearchSupport.SearchView,Boolean> counters, Set<SearchSupport.SearchView> from, List<String> where, SearchSupport svs)

Methods inherited from class org.apache.syncope.core.persistence.common.dao.AbstractAnySearchDAO

buildEffectiveCond, buildResult, check, check, check, count, findByDerAttrValue, isPatternMatch, search, search, search

Methods inherited from class org.apache.syncope.core.persistence.common.dao.AbstractSearchDAO

buildDerAttrValueConditions, check, check, key, split, syncopeClientException

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.apache.syncope.core.persistence.api.dao.AnySearchDAO

getAllMatchingCond

Field Details

SELECT_COLS_FROM_VIEW

protected static final String SELECT_COLS_FROM_VIEW

See Also:

• Constant Field Values

entityManager

protected final EntityManager entityManager

Constructor Details

OracleJPAAnySearchDAO

public OracleJPAAnySearchDAO(RealmSearchDAO realmSearchDAO,
 DynRealmDAO dynRealmDAO,
 UserDAO userDAO,
 GroupDAO groupDAO,
 AnyObjectDAO anyObjectDAO,
 PlainSchemaDAO schemaDAO,
 EntityFactory entityFactory,
 AnyUtilsFactory anyUtilsFactory,
 PlainAttrValidationManager validator,
 EntityManager entityManager)

Method Details

from

public static String from(PlainSchema schema)

Parameters:

schema -

Returns:

JSON_TABLE(plainAttrs, '$[*]?(@.schema == "fullname").uniqueValue' \ COLUMNS uniqueValue PATH '$.stringValue') AS fullname or JSON_TABLE(plainAttrs, '$[*]?(@.schema == "loginDate").values[*]' \ COLUMNS valuez PATH '$.dateValue') AS loginDate

defaultSV

protected SearchSupport.SearchView defaultSV(SearchSupport svs)

anyId

protected String anyId(SearchSupport.SearchView sv)

parseOrderByForPlainSchema

protected void parseOrderByForPlainSchema(SearchSupport svs,
 OrderBySupport obs,
 OrderBySupport.Item item,
 org.springframework.data.domain.Sort.Order clause,
 PlainSchema schema,
 String fieldName)

parseOrderByForField

protected void parseOrderByForField(SearchSupport svs,
 OrderBySupport.Item item,
 String fieldName,
 org.springframework.data.domain.Sort.Order clause)

filJSONAttrQuery

protected AnySearchNode.Leaf filJSONAttrQuery(SearchSupport.SearchView from,
 PlainAttrValue attrValue,
 PlainSchema schema,
 AttrCond cond,
 boolean not,
 List<Object> parameters)

getQuery

protected org.apache.syncope.core.persistence.jpa.dao.AbstractJPAAnySearchDAO.AttrCondQuery getQuery(AttrCond cond,
 boolean not,
 AbstractSearchDAO.CheckResult<AttrCond> checked,
 List<Object> parameters,
 SearchSupport svs)

visitNode

protected void visitNode(AnySearchNode node,
 Map<SearchSupport.SearchView,Boolean> counters,
 Set<SearchSupport.SearchView> from,
 List<String> where,
 SearchSupport svs)

buildFrom

protected String buildFrom(Set<SearchSupport.SearchView> from,
 Set<String> plainSchemas,
 OrderBySupport obs)

setParameter

protected static int setParameter(List<Object> parameters,
 Object parameter)

fillWithParameters

protected static void fillWithParameters(Query query,
 List<Object> parameters)

anyId

protected String anyId(SearchSupport svs)

getQueryForCustomConds

protected Optional<AnySearchNode> getQueryForCustomConds(SearchCond cond,
 List<Object> parameters,
 SearchSupport svs,
 boolean not)

getQuery

protected Optional<org.apache.syncope.core.persistence.jpa.dao.AbstractJPAAnySearchDAO.QueryInfo> getQuery(SearchCond cond,
 List<Object> parameters,
 SearchSupport svs)

getQuery

protected AnySearchNode getQuery(AnyTypeCond cond,
 boolean not,
 List<Object> parameters,
 SearchSupport svs)

getQuery

protected AnySearchNode getQuery(AuxClassCond cond,
 boolean not,
 List<Object> parameters,
 SearchSupport svs)

getQuery

protected AnySearchNode getQuery(RelationshipTypeCond cond,
 boolean not,
 List<Object> parameters,
 SearchSupport svs)

getQuery

protected AnySearchNode getQuery(RelationshipCond cond,
 boolean not,
 List<Object> parameters,
 SearchSupport svs)

getQuery

protected AnySearchNode getQuery(MembershipCond cond,
 boolean not,
 List<Object> parameters,
 SearchSupport svs)

getQuery

protected AnySearchNode getQuery(RoleCond cond,
 boolean not,
 List<Object> parameters,
 SearchSupport svs)

getQuery

protected AnySearchNode getQuery(DynRealmCond cond,
 boolean not,
 List<Object> parameters,
 SearchSupport svs)

getQuery

protected AnySearchNode getQuery(ResourceCond cond,
 boolean not,
 List<Object> parameters,
 SearchSupport svs)

getQuery

protected AnySearchNode getQuery(MemberCond cond,
 boolean not,
 List<Object> parameters,
 SearchSupport svs)

fillAttrQuery

protected AnySearchNode.Leaf fillAttrQuery(String column,
 SearchSupport.SearchView from,
 PlainAttrValue attrValue,
 PlainSchema schema,
 AttrCond cond,
 boolean not,
 List<Object> parameters)

getQuery

protected AnySearchNode getQuery(AnyCond cond,
 boolean not,
 List<Object> parameters,
 SearchSupport svs)

buildAdminRealmsFilter

protected AnySearchNode.Leaf buildAdminRealmsFilter(Set<String> realmKeys,
 SearchSupport svs,
 List<Object> parameters)

getAdminRealmsFilter

protected org.apache.syncope.core.persistence.jpa.dao.AbstractJPAAnySearchDAO.AdminRealmsFilter getAdminRealmsFilter(Realm base,
 boolean recursive,
 Set<String> adminRealms,
 List<Object> parameters,
 SearchSupport svs)

buildWhere

protected String buildWhere(List<String> where,
 AnySearchNode root)

buildCountQuery

protected String buildCountQuery(org.apache.syncope.core.persistence.jpa.dao.AbstractJPAAnySearchDAO.QueryInfo queryInfo,
 AnySearchNode.Leaf filterNode,
 List<Object> parameters,
 SearchSupport svs)

doCount

protected long doCount(Realm base,
 boolean recursive,
 Set<String> adminRealms,
 SearchCond cond,
 AnyTypeKind kind)

Specified by:

doCount in class AbstractAnySearchDAO

parseOrderByForCustom

protected void parseOrderByForCustom(SearchSupport svs,
 org.springframework.data.domain.Sort.Order clause,
 OrderBySupport.Item item,
 OrderBySupport obs)

parseOrderBy

protected OrderBySupport parseOrderBy(SearchSupport svs,
 List<org.springframework.data.domain.Sort.Order> orderBy)

buildSearchQuery

protected String buildSearchQuery(org.apache.syncope.core.persistence.jpa.dao.AbstractJPAAnySearchDAO.QueryInfo queryInfo,
 AnySearchNode.Leaf filterNode,
 List<Object> parameters,
 SearchSupport svs,
 List<org.springframework.data.domain.Sort.Order> orderBy)

doSearch

protected <T extends Any> List<T> doSearch(Realm base,
 boolean recursive,
 Set<String> adminRealms,
 SearchCond cond,
 org.springframework.data.domain.Pageable pageable,
 AnyTypeKind kind)

Specified by:

doSearch in class AbstractAnySearchDAO