org.alfresco.repo.domain.node.ibatis

Class NodeDAOImpl

java.lang.Object

org.alfresco.repo.domain.node.AbstractNodeDAOImpl

org.alfresco.repo.domain.node.ibatis.NodeDAOImpl

All Implemented Interfaces:

BatchingDAO, NodeDAO, NodeBulkLoader

Direct Known Subclasses:

NodeDAOImpl.MSSQL, NodeDAOImpl.MySQL

public class NodeDAOImpl
extends AbstractNodeDAOImpl

iBatis-specific extension of the Node abstract DAO

Since:

3.4

Author:

Derek Hulley

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	NodeDAOImpl.MSSQL MSSQL requires some overrides to handle specific behaviour.
static class	NodeDAOImpl.MySQL MySQL (InnoDB) specific DAO overrides
static class	NodeDAOImpl.MySQLClusterNDB MySQL Cluster NDB specific DAO overrides WARNING: Experimental/unsupported - see MySQLClusterNDBDialect !

Nested classes/interfaces inherited from interface org.alfresco.repo.domain.node.NodeDAO

NodeDAO.ChildAssocRefQueryCallback, NodeDAO.NodeRefQueryCallback, NodeDAO.NodeView

Field Summary

Fields

Modifier and Type	Field and Description
protected org.alfresco.service.cmr.dictionary.DictionaryService	dictionaryService
protected QNameDAO	qnameDAO

Fields inherited from class org.alfresco.repo.domain.node.AbstractNodeDAOImpl

isDebugEnabled, logger, LONG_ZERO

Constructor Summary

Constructors

Constructor and Description
NodeDAOImpl()

Method Summary

Modifier and Type	Method and Description
int	countChildAssocsByParent(Long parentNodeId, boolean isPrimary) Counts the number of child associations directly under parentNodeId.
protected int	deleteChildAssocs(List<Long> ids)
protected int	deleteNodeAspects(Long nodeId, Set<Long> qnameIds)
protected int	deleteNodeAssoc(Long sourceNodeId, Long targetNodeId, Long assocTypeQNameId)
protected int	deleteNodeAssocs(List<Long> ids)
protected int	deleteNodeById(Long nodeId)
protected int	deleteNodeProperties(Long nodeId, List<NodePropertyKey> propKeys)
protected int	deleteNodeProperties(Long nodeId, Set<Long> qnameIds)
protected int	deleteNodesByCommitTime(long fromTxnCommitTimeMs, long toTxnCommitTimeMs)
protected void	deleteSubscriptions(Long nodeId) The default implementation relies on ON DELETE CASCADE and the subscriptions avoiding deleted nodes - NoOp.
protected int	deleteTransaction(Long txnId)
int	deleteTxnsUnused(long fromCommitTime, long toCommitTime) Remove unused transactions from commit time 'fromCommitTime' to commit time 'toCommitTime'
void	executeBatch() Write a batch of insert or update commands
Long	getMaxNodeId()
Long	getMinNodeId()
org.alfresco.util.Pair<Long,Long>	getNodeIdsIntervalForType(org.alfresco.service.namespace.QName type, Long startTxnTime, Long endTxnTime) Returns the [minId, maxId] interval for nodes of a type, with the transaction time in the given window time.
List<Transaction>	getOneTxnsByCommitTimeDescending(Long fromTimeInclusive, Long toTimeExclusive, boolean remoteOnly) Get most recent transaction made in a given commit time range
protected Long	insertChildAssoc(ChildAssocEntity assoc)
protected Long	insertNode(NodeEntity node)
protected void	insertNodeAspect(Long nodeId, Long qnameId)
protected Long	insertNodeAssoc(Long sourceNodeId, Long targetNodeId, Long assocTypeQNameId, int assocIndex)
protected void	insertNodeProperties(Long nodeId, Map<NodePropertyKey,NodePropertyValue> persistableProps)
protected Long	insertServer(String ipAddress)
protected Long	insertStore(StoreEntity store)
protected Long	insertTransaction(Long serverId, String changeTxnId, Long commitTimeMs)
protected void	moveNodeData(Long fromNodeId, Long toNodeId) Moves all node-linked data from one node to another.
protected List<StoreEntity>	selectAllStores()
protected ChildAssocEntity	selectChildAssoc(Long assocId)
protected List<ChildAssocEntity>	selectChildAssoc(Long parentNodeId, Long childNodeId, org.alfresco.service.namespace.QName assocTypeQName, org.alfresco.service.namespace.QName assocQName)
protected ChildAssocEntity	selectChildAssoc(Long parentNodeId, org.alfresco.service.namespace.QName assocTypeQName, String childName)
protected void	selectChildAssocs(Long parentNodeId, Long childNodeId, org.alfresco.service.namespace.QName assocTypeQName, org.alfresco.service.namespace.QName assocQName, Boolean isPrimary, Boolean sameStore, NodeDAO.ChildAssocRefQueryCallback resultsCallback) Parameters are all optional except the parent node ID and the callback
protected void	selectChildAssocs(Long parentNodeId, org.alfresco.service.namespace.QName assocTypeQName, Collection<String> childNames, NodeDAO.ChildAssocRefQueryCallback resultsCallback)
void	selectChildAssocs(Long parentNodeId, org.alfresco.service.namespace.QName assocTypeQName, org.alfresco.service.namespace.QName assocQName, int maxResults, NodeDAO.ChildAssocRefQueryCallback resultsCallback)
protected void	selectChildAssocs(Long parentNodeId, Set<org.alfresco.service.namespace.QName> assocTypeQNames, NodeDAO.ChildAssocRefQueryCallback resultsCallback)
protected void	selectChildAssocsByChildTypes(Long parentNodeId, Set<org.alfresco.service.namespace.QName> childNodeTypeQNames, NodeDAO.ChildAssocRefQueryCallback resultsCallback)
protected void	selectChildAssocsByPropertyValue(Long parentNodeId, org.alfresco.service.namespace.QName propertyQName, NodePropertyValue nodeValue, NodeDAO.ChildAssocRefQueryCallback resultsCallback)
List<Node>	selectChildAssocsWithoutNodeAssocsOfTypes(Long parentNodeId, Long minNodeId, Long maxNodeId, Set<org.alfresco.service.namespace.QName> assocTypeQNames)
protected void	selectChildAssocsWithoutParentAssocsOfType(Long parentNodeId, org.alfresco.service.namespace.QName assocTypeQName, NodeDAO.ChildAssocRefQueryCallback resultsCallback)
protected List<ChildAssocEntity>	selectChildNodeIds(Long nodeId, Boolean isPrimary, Long minChildNodeIdInclusive, int maxResults)
protected Transaction	selectLastTxnBeforeCommitTime(Long maxCommitTime)
protected Long	selectMaxTxnCommitTime()
protected Long	selectMaxTxnId()
protected Long	selectMinTxnCommitTime()
protected Long	selectMinTxnCommitTimeForDeletedNodes()
protected Long	selectMinTxnId()
protected Long	selectMinUnusedTxnCommitTime()
protected Map<NodeVersionKey,Set<org.alfresco.service.namespace.QName>>	selectNodeAspects(Set<Long> nodeIds)
protected NodeAssocEntity	selectNodeAssocById(Long assocId)
protected int	selectNodeAssocMaxIndex(Long sourceNodeId, Long assocTypeQNameId)
protected List<NodeAssocEntity>	selectNodeAssocs(Long nodeId)
protected List<NodeAssocEntity>	selectNodeAssocsBySource(Long sourceNodeId, Long typeQNameId)
protected List<NodeAssocEntity>	selectNodeAssocsBySourceAndPropertyValue(Long sourceNodeId, Long typeQNameId, Long propertyQNameId, NodePropertyValue nodeValue)
protected List<NodeAssocEntity>	selectNodeAssocsByTarget(Long targetNodeId, Long typeQNameId)
protected NodeEntity	selectNodeById(Long id)
protected NodeEntity	selectNodeByNodeRef(org.alfresco.service.cmr.repository.NodeRef nodeRef)
protected Map<NodeVersionKey,Map<NodePropertyKey,NodePropertyValue>>	selectNodeProperties(Long nodeId)
protected Map<NodeVersionKey,Map<NodePropertyKey,NodePropertyValue>>	selectNodeProperties(Long nodeId, Set<Long> qnameIds)
protected Map<NodeVersionKey,Map<NodePropertyKey,NodePropertyValue>>	selectNodeProperties(Set<Long> nodeIds)
List<NodePropertyEntity>	selectNodePropertiesByDataType(org.alfresco.service.namespace.QName dataType, long minNodeId, long maxNodeId) Select all node properties that are between two node IDs and of the given actual type
List<NodePropertyEntity>	selectNodePropertiesByTypes(Set<org.alfresco.service.namespace.QName> qnames) Used by the re-encryptor to re-encrypt encryptable properties with a new encryption key.
protected List<Node>	selectNodesByIds(SortedSet<Long> ids)
protected List<Node>	selectNodesByUuids(Long storeId, SortedSet<String> uuids)
protected void	selectNodesWithAspects(List<Long> qnameIds, Long minNodeId, Long maxNodeId, NodeDAO.NodeRefQueryCallback resultsCallback)
protected List<ChildAssocEntity>	selectParentAssocs(Long childNodeId)
protected void	selectParentAssocs(Long childNodeId, org.alfresco.service.namespace.QName assocTypeQName, org.alfresco.service.namespace.QName assocQName, Boolean isPrimary, NodeDAO.ChildAssocRefQueryCallback resultsCallback) Parameters are all optional except the parent node ID and the callback
List<NodeIdAndAclId>	selectPrimaryChildAcls(Long nodeId)
protected List<ChildAssocEntity>	selectPrimaryParentAssocs(Long childNodeId) No DB constraint, so multiple returned
protected ServerEntity	selectServer(String ipAddress)
protected StoreEntity	selectStore(org.alfresco.service.cmr.repository.StoreRef storeRef)
protected NodeEntity	selectStoreRootNode(org.alfresco.service.cmr.repository.StoreRef storeRef)
protected int	selectTransactionCount()
protected Transaction	selectTxnById(Long txnId)
protected List<NodeEntity>	selectTxnChanges(Long txnId, Long storeId)
protected List<Transaction>	selectTxns(Long fromTimeInclusive, Long toTimeExclusive, Integer count, List<Long> includeTxnIds, List<Long> excludeTxnIds, Long excludeServerId, Boolean ascending)
protected List<Long>	selectTxnsUnused(Long minTxnId, Long maxCommitTime, Integer count)
void	setDictionaryService(org.alfresco.service.cmr.dictionary.DictionaryService dictionaryService)
void	setQnameDAO(QNameDAO qnameDAO)
void	setSqlSessionTemplate(org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate)
void	startBatch() Start a batch of insert or update commands
protected int	updateChildAssocIndex(Long parentNodeId, Long childNodeId, org.alfresco.service.namespace.QName assocTypeQName, org.alfresco.service.namespace.QName assocQName, int index)
protected int	updateChildAssocUniqueName(Long assocId, String name)
protected int	updateNode(NodeUpdateEntity nodeUpdate)
protected int	updateNodeAssoc(Long id, int assocIndex)
protected int	updateNodes(Long txnId, List<Long> nodeIds)
protected int	updateNodesInStore(Long txnId, Long storeId)
protected void	updatePrimaryChildrenSharedAclId(Long txnId, Long primaryParentNodeId, Long optionalOldSharedAlcIdInAdditionToNull, Long newSharedAlcId)
protected int	updatePrimaryParentAssocs(Long childNodeId, Long parentNodeId, org.alfresco.service.namespace.QName assocTypeQName, org.alfresco.service.namespace.QName assocQName, String childNodeName)
protected int	updateStore(StoreEntity store)
protected int	updateStoreRoot(StoreEntity store)
protected int	updateTransaction(Long txnId, Long commitTimeMs)

Methods inherited from class org.alfresco.repo.domain.node.AbstractNodeDAOImpl

addNodeAspects, addNodeProperties, addNodeProperty, cacheNodes, cacheNodesById, clear, cycleCheck, deleteChildAssoc, deleteNode, exists, exists, exists, getAllRootNodes, getCachedAncestors, getChildAssoc, getChildAssoc, getChildAssoc, getChildAssocs, getChildAssocs, getChildAssocs, getChildAssocs, getChildAssocsByChildTypes, getChildAssocsByPropertyValue, getChildAssocsWithoutParentAssocsOfType, getCurrentTransactionId, getMaxTxnCommitTime, getMaxTxnId, getMaxTxnIdByCommitTime, getMinTxnCommitTime, getMinTxnCommitTimeForDeletedNodes, getMinTxnId, getMinUnusedTxnCommitTime, getNodeAclId, getNodeAspects, getNodeAssoc, getNodeAssocOrNull, getNodeAssocsToAndFrom, getNodeIdStatus, getNodePair, getNodePair, getNodeProperties, getNodeProperty, getNodeRefStatus, getNodesWithAspects, getNodeType, getParentAssocs, getPaths, getPrimaryChildrenAcls, getPrimaryParentAssoc, getRootNode, getServerId, getSourceNodeAssocs, getStore, getStores, getTargetAssocsByPropertyValue, getTargetNodeAssocs, getTransactionCount, getTxnById, getTxnChanges, getTxnChangesForStore, getTxnsByCommitTimeAscending, getTxnsByCommitTimeAscending, getTxnsByCommitTimeDescending, getTxnsUnused, hasNodeAspect, init, isInCurrentTxn, moveNode, moveStore, newChildAssoc, newChildAssocInsert, newChildAssocInsertImpl, newNode, newNodeAssoc, newNodeImplInsert, newStore, purgeNodes, purgeTxn, removeNodeAspects, removeNodeAspects, removeNodeAssoc, removeNodeAssocs, removeNodeProperties, setAccessControlListDAO, setAclDAO, setAllRootNodesCache, setAspectsCache, setCachingThreshold, setCheckNodeConsistency, setChildAssocIndex, setChildAssocsUniqueName, setChildAssocsUniqueNameImpl, setChildByNameCache, setContentDataDAO, setControlDAO, setLocaleDAO, setModifiedDate, setModifiedProperties, setNodeAclId, setNodeAssocIndex, setNodeProperties, setNodesCache, setParentAssocsCacheLimitFactor, setParentAssocsCacheSize, setPolicyBehaviourFilter, setPrimaryChildrenSharedAclId, setPropertiesCache, setRootNodesCache, setTransactionService, setUsageDAO, touchNodes, updateChildAssocUniqueNameImpl, updateNode, updatePrimaryParentAssocs, updatePrimaryParentAssocsImpl

Methods inherited from class java.lang.Object

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

Field Detail

qnameDAO

protected QNameDAO qnameDAO

dictionaryService

protected org.alfresco.service.cmr.dictionary.DictionaryService dictionaryService

Constructor Detail

NodeDAOImpl

public NodeDAOImpl()

Method Detail

setSqlSessionTemplate

public void setSqlSessionTemplate(org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate)

setQnameDAO

public void setQnameDAO(QNameDAO qnameDAO)

Overrides:

setQnameDAO in class AbstractNodeDAOImpl

Parameters:

qnameDAO - translates QName IDs into QName instances and vice-versa

setDictionaryService

public void setDictionaryService(org.alfresco.service.cmr.dictionary.DictionaryService dictionaryService)

Overrides:

setDictionaryService in class AbstractNodeDAOImpl

Parameters:

dictionaryService - the service help determine cm:auditable characteristics

startBatch

public void startBatch()

Description copied from interface: BatchingDAO

Start a batch of insert or update commands

executeBatch

public void executeBatch()

Description copied from interface: BatchingDAO

Write a batch of insert or update commands

selectServer

protected ServerEntity selectServer(String ipAddress)

Specified by:

selectServer in class AbstractNodeDAOImpl

insertServer

protected Long insertServer(String ipAddress)

Specified by:

insertServer in class AbstractNodeDAOImpl

insertTransaction

protected Long insertTransaction(Long serverId,
                                 String changeTxnId,
                                 Long commitTimeMs)

Specified by:

insertTransaction in class AbstractNodeDAOImpl

updateTransaction

protected int updateTransaction(Long txnId,
                                Long commitTimeMs)

Specified by:

updateTransaction in class AbstractNodeDAOImpl

deleteTransaction

protected int deleteTransaction(Long txnId)

Specified by:

deleteTransaction in class AbstractNodeDAOImpl

selectAllStores

protected List<StoreEntity> selectAllStores()

Specified by:

selectAllStores in class AbstractNodeDAOImpl

selectStore

protected StoreEntity selectStore(org.alfresco.service.cmr.repository.StoreRef storeRef)

Specified by:

selectStore in class AbstractNodeDAOImpl

selectStoreRootNode

protected NodeEntity selectStoreRootNode(org.alfresco.service.cmr.repository.StoreRef storeRef)

Specified by:

selectStoreRootNode in class AbstractNodeDAOImpl

insertStore

protected Long insertStore(StoreEntity store)

Specified by:

insertStore in class AbstractNodeDAOImpl

updateStoreRoot

protected int updateStoreRoot(StoreEntity store)

Specified by:

updateStoreRoot in class AbstractNodeDAOImpl

updateStore

protected int updateStore(StoreEntity store)

Specified by:

updateStore in class AbstractNodeDAOImpl

updateNodesInStore

protected int updateNodesInStore(Long txnId,
                                 Long storeId)

Specified by:

updateNodesInStore in class AbstractNodeDAOImpl

insertNode

protected Long insertNode(NodeEntity node)

Specified by:

insertNode in class AbstractNodeDAOImpl

updateNode

protected int updateNode(NodeUpdateEntity nodeUpdate)

Specified by:

updateNode in class AbstractNodeDAOImpl

updateNodes

protected int updateNodes(Long txnId,
                          List<Long> nodeIds)

Specified by:

updateNodes in class AbstractNodeDAOImpl

getMinNodeId

public Long getMinNodeId()

Returns:

Returns the minimum node id or 0 if there are no nodes

getMaxNodeId

public Long getMaxNodeId()

Returns:

Returns the maximum node id or 0 if there are no nodes

getNodeIdsIntervalForType

public org.alfresco.util.Pair<Long,Long> getNodeIdsIntervalForType(org.alfresco.service.namespace.QName type,
                                                                   Long startTxnTime,
                                                                   Long endTxnTime)

Description copied from interface: NodeDAO

Returns the [minId, maxId] interval for nodes of a type, with the transaction time in the given window time.

Parameters:

type - the node type

startTxnTime - the starting transaction time, null is allowed, case in which no minimum transaction time is considered

endTxnTime - the end transaction time, null is allowed, case in which no maximum transaction time is considered

Returns:

the interval, as a pair

updatePrimaryChildrenSharedAclId

protected void updatePrimaryChildrenSharedAclId(Long txnId,
                                                Long primaryParentNodeId,
                                                Long optionalOldSharedAlcIdInAdditionToNull,
                                                Long newSharedAlcId)

Specified by:

updatePrimaryChildrenSharedAclId in class AbstractNodeDAOImpl

deleteNodeById

protected int deleteNodeById(Long nodeId)

Specified by:

deleteNodeById in class AbstractNodeDAOImpl

deleteNodesByCommitTime

protected int deleteNodesByCommitTime(long fromTxnCommitTimeMs,
                                      long toTxnCommitTimeMs)

Specified by:

deleteNodesByCommitTime in class AbstractNodeDAOImpl

selectNodeById

protected NodeEntity selectNodeById(Long id)

Specified by:

selectNodeById in class AbstractNodeDAOImpl

selectNodeByNodeRef

protected NodeEntity selectNodeByNodeRef(org.alfresco.service.cmr.repository.NodeRef nodeRef)

Specified by:

selectNodeByNodeRef in class AbstractNodeDAOImpl

selectNodesByUuids

protected List<Node> selectNodesByUuids(Long storeId,
                                        SortedSet<String> uuids)

Specified by:

selectNodesByUuids in class AbstractNodeDAOImpl

selectNodesByIds

protected List<Node> selectNodesByIds(SortedSet<Long> ids)

Specified by:

selectNodesByIds in class AbstractNodeDAOImpl

selectNodeProperties

protected Map<NodeVersionKey,Map<NodePropertyKey,NodePropertyValue>> selectNodeProperties(Set<Long> nodeIds)

Specified by:

selectNodeProperties in class AbstractNodeDAOImpl

selectNodeProperties

protected Map<NodeVersionKey,Map<NodePropertyKey,NodePropertyValue>> selectNodeProperties(Long nodeId)

Specified by:

selectNodeProperties in class AbstractNodeDAOImpl

selectNodeProperties

protected Map<NodeVersionKey,Map<NodePropertyKey,NodePropertyValue>> selectNodeProperties(Long nodeId,
                                                                                          Set<Long> qnameIds)

Specified by:

selectNodeProperties in class AbstractNodeDAOImpl

selectNodePropertiesByTypes

public List<NodePropertyEntity> selectNodePropertiesByTypes(Set<org.alfresco.service.namespace.QName> qnames)

Description copied from interface: NodeDAO

Used by the re-encryptor to re-encrypt encryptable properties with a new encryption key.

selectNodePropertiesByDataType

public List<NodePropertyEntity> selectNodePropertiesByDataType(org.alfresco.service.namespace.QName dataType,
                                                               long minNodeId,
                                                               long maxNodeId)

Description copied from interface: NodeDAO

Select all node properties that are between two node IDs and of the given actual type

Parameters:

dataType - the actual, original type of the property, as given by one of the constants on DataTypeDefinition

minNodeId - the minimum node ID (inclusive)

maxNodeId - the maximum node ID (exclusive)

deleteNodeProperties

protected int deleteNodeProperties(Long nodeId,
                                   Set<Long> qnameIds)

Specified by:

deleteNodeProperties in class AbstractNodeDAOImpl

deleteNodeProperties

protected int deleteNodeProperties(Long nodeId,
                                   List<NodePropertyKey> propKeys)

Specified by:

deleteNodeProperties in class AbstractNodeDAOImpl

insertNodeProperties

protected void insertNodeProperties(Long nodeId,
                                    Map<NodePropertyKey,NodePropertyValue> persistableProps)

Specified by:

insertNodeProperties in class AbstractNodeDAOImpl

selectNodeAspects

protected Map<NodeVersionKey,Set<org.alfresco.service.namespace.QName>> selectNodeAspects(Set<Long> nodeIds)

Specified by:

selectNodeAspects in class AbstractNodeDAOImpl

insertNodeAspect

protected void insertNodeAspect(Long nodeId,
                                Long qnameId)

Specified by:

insertNodeAspect in class AbstractNodeDAOImpl

deleteNodeAspects

protected int deleteNodeAspects(Long nodeId,
                                Set<Long> qnameIds)

Specified by:

deleteNodeAspects in class AbstractNodeDAOImpl

selectNodesWithAspects

protected void selectNodesWithAspects(List<Long> qnameIds,
                                      Long minNodeId,
                                      Long maxNodeId,
                                      NodeDAO.NodeRefQueryCallback resultsCallback)

Specified by:

selectNodesWithAspects in class AbstractNodeDAOImpl

insertNodeAssoc

protected Long insertNodeAssoc(Long sourceNodeId,
                               Long targetNodeId,
                               Long assocTypeQNameId,
                               int assocIndex)

Specified by:

insertNodeAssoc in class AbstractNodeDAOImpl

updateNodeAssoc

protected int updateNodeAssoc(Long id,
                              int assocIndex)

Specified by:

updateNodeAssoc in class AbstractNodeDAOImpl

deleteNodeAssoc

protected int deleteNodeAssoc(Long sourceNodeId,
                              Long targetNodeId,
                              Long assocTypeQNameId)

Specified by:

deleteNodeAssoc in class AbstractNodeDAOImpl

deleteNodeAssocs

protected int deleteNodeAssocs(List<Long> ids)

Specified by:

deleteNodeAssocs in class AbstractNodeDAOImpl

selectNodeAssocs

protected List<NodeAssocEntity> selectNodeAssocs(Long nodeId)

Specified by:

selectNodeAssocs in class AbstractNodeDAOImpl

selectNodeAssocsBySource

protected List<NodeAssocEntity> selectNodeAssocsBySource(Long sourceNodeId,
                                                         Long typeQNameId)

Specified by:

selectNodeAssocsBySource in class AbstractNodeDAOImpl

selectNodeAssocsBySourceAndPropertyValue

protected List<NodeAssocEntity> selectNodeAssocsBySourceAndPropertyValue(Long sourceNodeId,
                                                                         Long typeQNameId,
                                                                         Long propertyQNameId,
                                                                         NodePropertyValue nodeValue)

Specified by:

selectNodeAssocsBySourceAndPropertyValue in class AbstractNodeDAOImpl

selectNodeAssocsByTarget

protected List<NodeAssocEntity> selectNodeAssocsByTarget(Long targetNodeId,
                                                         Long typeQNameId)

Specified by:

selectNodeAssocsByTarget in class AbstractNodeDAOImpl

selectNodeAssocById

protected NodeAssocEntity selectNodeAssocById(Long assocId)

Specified by:

selectNodeAssocById in class AbstractNodeDAOImpl

selectNodeAssocMaxIndex

protected int selectNodeAssocMaxIndex(Long sourceNodeId,
                                      Long assocTypeQNameId)

Specified by:

selectNodeAssocMaxIndex in class AbstractNodeDAOImpl

insertChildAssoc

protected Long insertChildAssoc(ChildAssocEntity assoc)

Specified by:

insertChildAssoc in class AbstractNodeDAOImpl

deleteChildAssocs

protected int deleteChildAssocs(List<Long> ids)

Specified by:

deleteChildAssocs in class AbstractNodeDAOImpl

updateChildAssocIndex

protected int updateChildAssocIndex(Long parentNodeId,
                                    Long childNodeId,
                                    org.alfresco.service.namespace.QName assocTypeQName,
                                    org.alfresco.service.namespace.QName assocQName,
                                    int index)

Specified by:

updateChildAssocIndex in class AbstractNodeDAOImpl

updateChildAssocUniqueName

protected int updateChildAssocUniqueName(Long assocId,
                                         String name)

Specified by:

updateChildAssocUniqueName in class AbstractNodeDAOImpl

selectChildAssoc

protected ChildAssocEntity selectChildAssoc(Long assocId)

Specified by:

selectChildAssoc in class AbstractNodeDAOImpl

selectChildNodeIds

protected List<ChildAssocEntity> selectChildNodeIds(Long nodeId,
                                                    Boolean isPrimary,
                                                    Long minChildNodeIdInclusive,
                                                    int maxResults)

Specified by:

selectChildNodeIds in class AbstractNodeDAOImpl

selectPrimaryChildAcls

public List<NodeIdAndAclId> selectPrimaryChildAcls(Long nodeId)

Specified by:

selectPrimaryChildAcls in class AbstractNodeDAOImpl

selectChildAssoc

protected List<ChildAssocEntity> selectChildAssoc(Long parentNodeId,
                                                  Long childNodeId,
                                                  org.alfresco.service.namespace.QName assocTypeQName,
                                                  org.alfresco.service.namespace.QName assocQName)

Specified by:

selectChildAssoc in class AbstractNodeDAOImpl

selectChildAssocs

protected void selectChildAssocs(Long parentNodeId,
                                 Long childNodeId,
                                 org.alfresco.service.namespace.QName assocTypeQName,
                                 org.alfresco.service.namespace.QName assocQName,
                                 Boolean isPrimary,
                                 Boolean sameStore,
                                 NodeDAO.ChildAssocRefQueryCallback resultsCallback)

Description copied from class: AbstractNodeDAOImpl

Parameters are all optional except the parent node ID and the callback

Specified by:

selectChildAssocs in class AbstractNodeDAOImpl

selectChildAssocs

public void selectChildAssocs(Long parentNodeId,
                              org.alfresco.service.namespace.QName assocTypeQName,
                              org.alfresco.service.namespace.QName assocQName,
                              int maxResults,
                              NodeDAO.ChildAssocRefQueryCallback resultsCallback)

Specified by:

selectChildAssocs in class AbstractNodeDAOImpl

selectChildAssocs

protected void selectChildAssocs(Long parentNodeId,
                                 Set<org.alfresco.service.namespace.QName> assocTypeQNames,
                                 NodeDAO.ChildAssocRefQueryCallback resultsCallback)

Specified by:

selectChildAssocs in class AbstractNodeDAOImpl

selectChildAssoc

protected ChildAssocEntity selectChildAssoc(Long parentNodeId,
                                            org.alfresco.service.namespace.QName assocTypeQName,
                                            String childName)

Specified by:

selectChildAssoc in class AbstractNodeDAOImpl

selectChildAssocs

protected void selectChildAssocs(Long parentNodeId,
                                 org.alfresco.service.namespace.QName assocTypeQName,
                                 Collection<String> childNames,
                                 NodeDAO.ChildAssocRefQueryCallback resultsCallback)

Specified by:

selectChildAssocs in class AbstractNodeDAOImpl

selectChildAssocsByPropertyValue

protected void selectChildAssocsByPropertyValue(Long parentNodeId,
                                                org.alfresco.service.namespace.QName propertyQName,
                                                NodePropertyValue nodeValue,
                                                NodeDAO.ChildAssocRefQueryCallback resultsCallback)

Specified by:

selectChildAssocsByPropertyValue in class AbstractNodeDAOImpl

selectChildAssocsByChildTypes

protected void selectChildAssocsByChildTypes(Long parentNodeId,
                                             Set<org.alfresco.service.namespace.QName> childNodeTypeQNames,
                                             NodeDAO.ChildAssocRefQueryCallback resultsCallback)

Specified by:

selectChildAssocsByChildTypes in class AbstractNodeDAOImpl

selectChildAssocsWithoutParentAssocsOfType

protected void selectChildAssocsWithoutParentAssocsOfType(Long parentNodeId,
                                                          org.alfresco.service.namespace.QName assocTypeQName,
                                                          NodeDAO.ChildAssocRefQueryCallback resultsCallback)

Specified by:

selectChildAssocsWithoutParentAssocsOfType in class AbstractNodeDAOImpl

selectChildAssocsWithoutNodeAssocsOfTypes

public List<Node> selectChildAssocsWithoutNodeAssocsOfTypes(Long parentNodeId,
                                                            Long minNodeId,
                                                            Long maxNodeId,
                                                            Set<org.alfresco.service.namespace.QName> assocTypeQNames)

Parameters:

parentNodeId - the parent node id

minNodeId - the minimum node ID (inclusive), null for no limitation on the minimum value of the node id

maxNodeId - the maximum node ID (exclusive), null for no limitation on the maximum value of the node id

assocTypeQNames - the node associations to exclude, null for no filtering of the associations types

Returns:

list of child nodes

selectPrimaryParentAssocs

protected List<ChildAssocEntity> selectPrimaryParentAssocs(Long childNodeId)

Description copied from class: AbstractNodeDAOImpl

No DB constraint, so multiple returned

Specified by:

selectPrimaryParentAssocs in class AbstractNodeDAOImpl

selectParentAssocs

protected void selectParentAssocs(Long childNodeId,
                                  org.alfresco.service.namespace.QName assocTypeQName,
                                  org.alfresco.service.namespace.QName assocQName,
                                  Boolean isPrimary,
                                  NodeDAO.ChildAssocRefQueryCallback resultsCallback)

Description copied from class: AbstractNodeDAOImpl

Parameters are all optional except the parent node ID and the callback

Specified by:

selectParentAssocs in class AbstractNodeDAOImpl

selectParentAssocs

protected List<ChildAssocEntity> selectParentAssocs(Long childNodeId)

Specified by:

selectParentAssocs in class AbstractNodeDAOImpl

updatePrimaryParentAssocs

protected int updatePrimaryParentAssocs(Long childNodeId,
                                        Long parentNodeId,
                                        org.alfresco.service.namespace.QName assocTypeQName,
                                        org.alfresco.service.namespace.QName assocQName,
                                        String childNodeName)

Specified by:

updatePrimaryParentAssocs in class AbstractNodeDAOImpl

moveNodeData

protected void moveNodeData(Long fromNodeId,
                            Long toNodeId)

Description copied from class: AbstractNodeDAOImpl

Moves all node-linked data from one node to another. The source node will be left in an orphaned state and without any attached data other than the current transaction.

Specified by:

moveNodeData in class AbstractNodeDAOImpl

Parameters:

fromNodeId - the source node

toNodeId - the target node

deleteSubscriptions

protected void deleteSubscriptions(Long nodeId)

The default implementation relies on ON DELETE CASCADE and the subscriptions avoiding deleted nodes - NoOp.

Specified by:

deleteSubscriptions in class AbstractNodeDAOImpl

selectLastTxnBeforeCommitTime

protected Transaction selectLastTxnBeforeCommitTime(Long maxCommitTime)

Specified by:

selectLastTxnBeforeCommitTime in class AbstractNodeDAOImpl

selectTransactionCount

protected int selectTransactionCount()

Specified by:

selectTransactionCount in class AbstractNodeDAOImpl

selectTxnById

protected Transaction selectTxnById(Long txnId)

Specified by:

selectTxnById in class AbstractNodeDAOImpl

selectTxnChanges

protected List<NodeEntity> selectTxnChanges(Long txnId,
                                            Long storeId)

Specified by:

selectTxnChanges in class AbstractNodeDAOImpl

selectTxns

protected List<Transaction> selectTxns(Long fromTimeInclusive,
                                       Long toTimeExclusive,
                                       Integer count,
                                       List<Long> includeTxnIds,
                                       List<Long> excludeTxnIds,
                                       Long excludeServerId,
                                       Boolean ascending)

Specified by:

selectTxns in class AbstractNodeDAOImpl

selectTxnsUnused

protected List<Long> selectTxnsUnused(Long minTxnId,
                                      Long maxCommitTime,
                                      Integer count)

Specified by:

selectTxnsUnused in class AbstractNodeDAOImpl

deleteTxnsUnused

public int deleteTxnsUnused(long fromCommitTime,
                            long toCommitTime)

Description copied from interface: NodeDAO

Remove unused transactions from commit time 'fromCommitTime' to commit time 'toCommitTime'

Parameters:

fromCommitTime - delete unused transactions from commit time

toCommitTime - delete unused transactions to commit time

Returns:

int

selectMinTxnCommitTime

protected Long selectMinTxnCommitTime()

Specified by:

selectMinTxnCommitTime in class AbstractNodeDAOImpl

selectMaxTxnCommitTime

protected Long selectMaxTxnCommitTime()

Specified by:

selectMaxTxnCommitTime in class AbstractNodeDAOImpl

selectMinTxnCommitTimeForDeletedNodes

protected Long selectMinTxnCommitTimeForDeletedNodes()

Specified by:

selectMinTxnCommitTimeForDeletedNodes in class AbstractNodeDAOImpl

selectMinTxnId

protected Long selectMinTxnId()

Specified by:

selectMinTxnId in class AbstractNodeDAOImpl

selectMinUnusedTxnCommitTime

protected Long selectMinUnusedTxnCommitTime()

Specified by:

selectMinUnusedTxnCommitTime in class AbstractNodeDAOImpl

selectMaxTxnId

protected Long selectMaxTxnId()

Specified by:

selectMaxTxnId in class AbstractNodeDAOImpl

countChildAssocsByParent

public int countChildAssocsByParent(Long parentNodeId,
                                    boolean isPrimary)

Description copied from interface: NodeDAO

Counts the number of child associations directly under parentNodeId.

Parameters:

parentNodeId - the parent node id

isPrimary - count just primary associations?

getOneTxnsByCommitTimeDescending

public List<Transaction> getOneTxnsByCommitTimeDescending(Long fromTimeInclusive,
                                                          Long toTimeExclusive,
                                                          boolean remoteOnly)

Get most recent transaction made in a given commit time range