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

Class MySQLJPAAnySearchDAO

java.lang.Object

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

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

All Implemented Interfaces:

AnySearchDAO

Direct Known Subclasses:

MariaDBJPAAnySearchDAO

public class MySQLJPAAnySearchDAO
extends AbstractAnySearchDAO

Nested Class Summary

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

AbstractAnySearchDAO.CheckResult<C extends AttrCond>

Field Summary

Fields

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

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

ALWAYS_FALSE_CLAUSE, anyObjectDAO, anyUtilsFactory, dynRealmDAO, entityFactory, groupDAO, LOG, plainSchemaDAO, realmSearchDAO, RELATIONSHIP_FIELDS, userDAO, validator

Constructor Summary

Constructors

Constructor	Description
MySQLJPAAnySearchDAO(RealmSearchDAO realmSearchDAO, DynRealmDAO dynRealmDAO, UserDAO userDAO, GroupDAO groupDAO, AnyObjectDAO anyObjectDAO, PlainSchemaDAO schemaDAO, EntityFactory entityFactory, AnyUtilsFactory anyUtilsFactory, PlainAttrValidationManager validator, EntityManagerFactory entityManagerFactory, 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)
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, AbstractAnySearchDAO.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 boolean	isOracle()
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 static Supplier<SyncopeClientException>	syncopeClientException(String message)
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, check, check, count, isPatternMatch, key, search, search, search

Methods inherited from class java.lang.Object

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

Field Details

SELECT_COLS_FROM_VIEW

protected static final String SELECT_COLS_FROM_VIEW

See Also:

• Constant Field Values

entityManagerFactory

protected final EntityManagerFactory entityManagerFactory

entityManager

protected final EntityManager entityManager

Constructor Details

MySQLJPAAnySearchDAO

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

Method Details

parseOrderByForPlainSchema

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

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,
 AbstractAnySearchDAO.CheckResult<AttrCond> checked,
 List<Object> parameters,
 SearchSupport svs)

setParameter

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

fillWithParameters

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

syncopeClientException

protected static Supplier<SyncopeClientException> syncopeClientException(String message)

isOracle

protected boolean isOracle()

defaultSV

protected SearchSupport.SearchView defaultSV(SearchSupport svs)

anyId

protected String anyId(SearchSupport.SearchView sv)

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)

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)

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

parseOrderByForField

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

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