Package com.flowable.serviceregistry.engine.impl.invoker.db

Class DatabaseGenericInstanceQuery

java.lang.Object

org.flowable.common.engine.impl.db.ListQueryParameterObject

com.flowable.serviceregistry.engine.impl.invoker.db.DatabaseGenericInstanceQuery

public class DatabaseGenericInstanceQuery
extends ListQueryParameterObject

Author:

Filip Hrisafov

Nested Class Summary

Nested classes/interfaces inherited from class org.flowable.common.engine.impl.db.ListQueryParameterObject

ListQueryParameterObject.OrderBy, ListQueryParameterObject.ResultType

Field Summary

Fields

Modifier and Type	Field	Description
protected Collection<String>	accessibleByGroups
protected String	accessibleByUser
protected String	identityLinkType
protected Collection<JoinTableConfig>	joinTables
protected String	lookupIdColumnName
protected Collection<? extends Collection<String>>	safeAccessibleByGroups
protected String	scopeType
protected Collection<String>	selectColumnNames
protected String	tableName
protected Collection<com.flowable.serviceregistry.engine.impl.invoker.db.WhereClauseComponent>	whereClauseComponents

Fields inherited from class org.flowable.common.engine.impl.db.ListQueryParameterObject

databaseType, DEFAULT_ORDER_BY, defaultOrderBy, firstResult, maxResults, nullHandlingColumn, nullHandlingOnOrder, orderByCollection, orderProperty, parameter, resultType, SORTORDER_ASC, SORTORDER_DESC

Constructor Summary

Constructors

Constructor	Description
DatabaseGenericInstanceQuery()

Method Summary

Modifier and Type	Method	Description
void	addOrder(OrderParameter orderParameter)
protected String	buildOrderBy()
static Collection<com.flowable.serviceregistry.engine.impl.invoker.db.WhereClauseComponent>	createWhereClause(FilterDefinitionMember filterDefinitionMember, Function<QueryColumnMapping,QueryParameter> queryParameterProducer)	Recursively flattens the tree of FilterDefinitionMembers into a flat list of 'components' which can be set to a DatabaseGenericInstanceQuery to be used in the sqlmap to dynamically generate the where clause.
Collection<String>	getAccessibleByGroups()
String	getAccessibleByUser()
String	getIdentityLinkType()
Collection<JoinTableConfig>	getJoinTables()
String	getLookupIdColumnName()
DatabaseGenericInstanceQuery	getQuery()
Collection<? extends Collection<String>>	getSafeAccessibleByGroups()
String	getScopeType()
Collection<String>	getSelectColumnNames()
String	getTableName()
Collection<com.flowable.serviceregistry.engine.impl.invoker.db.WhereClauseComponent>	getWhereClauseComponents()
void	setAccessibleByGroups(Collection<String> accessibleByGroups)
void	setAccessibleByUser(String accessibleByUser)
void	setIdentityLinkType(String identityLinkType)
void	setJoinTables(Collection<JoinTableConfig> joinTables)
void	setLookupIdColumnName(String lookupIdColumnName)
void	setSafeAccessibleByGroups(Collection<? extends Collection<String>> safeAccessibleByGroups)
void	setScopeType(String scopeType)
void	setSelectColumnNames(Collection<String> selectColumnNames)
void	setTableName(String tableName)
void	setWhereClauseComponents(Collection<com.flowable.serviceregistry.engine.impl.invoker.db.WhereClauseComponent> whereClauseComponents)

Methods inherited from class org.flowable.common.engine.impl.db.ListQueryParameterObject

addOrder, getDatabaseType, getFirstResult, getFirstRow, getLastRow, getMaxResults, getNullHandlingColumn, getOrderBy, getOrderByCollectionSafe, getOrderByForWindow, getOuterJoinOrderBy, getParameter, hasOrderBy, hasOrderByForColumn, isNeedsPaging, mapOrderByToSql, setDatabaseType, setFirstResult, setMaxResults, setNullHandlingColumn, setParameter

Methods inherited from class java.lang.Object

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

Field Detail

tableName

protected String tableName

lookupIdColumnName

protected String lookupIdColumnName

scopeType

protected String scopeType

whereClauseComponents

protected Collection<com.flowable.serviceregistry.engine.impl.invoker.db.WhereClauseComponent> whereClauseComponents

accessibleByUser

protected String accessibleByUser

accessibleByGroups

protected Collection<String> accessibleByGroups

safeAccessibleByGroups

protected Collection<? extends Collection<String>> safeAccessibleByGroups

identityLinkType

protected String identityLinkType

joinTables

protected Collection<JoinTableConfig> joinTables

selectColumnNames

protected Collection<String> selectColumnNames

Constructor Detail

DatabaseGenericInstanceQuery

public DatabaseGenericInstanceQuery()

Method Detail

addOrder

public void addOrder(OrderParameter orderParameter)

getTableName

public String getTableName()

setTableName

public void setTableName(String tableName)

getLookupIdColumnName

public String getLookupIdColumnName()

setLookupIdColumnName

public void setLookupIdColumnName(String lookupIdColumnName)

getScopeType

public String getScopeType()

setScopeType

public void setScopeType(String scopeType)

getWhereClauseComponents

public Collection<com.flowable.serviceregistry.engine.impl.invoker.db.WhereClauseComponent> getWhereClauseComponents()

setWhereClauseComponents

public void setWhereClauseComponents(Collection<com.flowable.serviceregistry.engine.impl.invoker.db.WhereClauseComponent> whereClauseComponents)

getAccessibleByUser

public String getAccessibleByUser()

setAccessibleByUser

public void setAccessibleByUser(String accessibleByUser)

getAccessibleByGroups

public Collection<String> getAccessibleByGroups()

setAccessibleByGroups

public void setAccessibleByGroups(Collection<String> accessibleByGroups)

getSafeAccessibleByGroups

public Collection<? extends Collection<String>> getSafeAccessibleByGroups()

setSafeAccessibleByGroups

public void setSafeAccessibleByGroups(Collection<? extends Collection<String>> safeAccessibleByGroups)

getIdentityLinkType

public String getIdentityLinkType()

setIdentityLinkType

public void setIdentityLinkType(String identityLinkType)

getJoinTables

public Collection<JoinTableConfig> getJoinTables()

setJoinTables

public void setJoinTables(Collection<JoinTableConfig> joinTables)

getSelectColumnNames

public Collection<String> getSelectColumnNames()

setSelectColumnNames

public void setSelectColumnNames(Collection<String> selectColumnNames)

buildOrderBy

protected String buildOrderBy()

Overrides:

buildOrderBy in class ListQueryParameterObject

getQuery

public DatabaseGenericInstanceQuery getQuery()

createWhereClause

public static Collection<com.flowable.serviceregistry.engine.impl.invoker.db.WhereClauseComponent> createWhereClause(FilterDefinitionMember filterDefinitionMember,
                                                                                                                     Function<QueryColumnMapping,QueryParameter> queryParameterProducer)

Recursively flattens the tree of FilterDefinitionMembers into a flat list of 'components' which can be set to a DatabaseGenericInstanceQuery to be used in the sqlmap to dynamically generate the where clause. Generates bracket literals for nested parameters and takes care of producing the correct sequence of brackets and logical operators and clauses.

This approach is used, because mybatis does not allow to recursively create sql snippets in the sqlmap. Therefor we do the recursion here to create a sequence of components which can be iterated0 in the sqlmap.