org.alfresco.repo.domain.patch.ibatis

Class PatchDAOImpl

java.lang.Object

org.alfresco.repo.domain.patch.AbstractPatchDAOImpl

org.alfresco.repo.domain.patch.ibatis.PatchDAOImpl

All Implemented Interfaces:

org.alfresco.ibatis.BatchingDAO, PatchDAO

Direct Known Subclasses:

PatchDAOImpl.Oracle, PatchDAOImpl.PostgreSQL

public class PatchDAOImpl
extends AbstractPatchDAOImpl

iBatis-specific implementation of the AVMPatch DAO.

Since:

3.2

Author:

janv

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	PatchDAOImpl.Oracle Oracle-specific DAO
static class	PatchDAOImpl.PostgreSQL PostgreSQL-specific DAO

Nested classes/interfaces inherited from interface org.alfresco.repo.domain.patch.PatchDAO

PatchDAO.StringHandler

Field Summary

Fields

Modifier and Type	Field and Description
protected org.mybatis.spring.SqlSessionTemplate	template

Constructor Summary

Constructors

Constructor and Description
PatchDAOImpl()

Method Summary

Methods

Modifier and Type	Method and Description
int	addSizeCurrentProp() Add a cm:sizeCurrent property to person nodes that don't have it.
protected int	deleteAclEntities(List<Long> aclIds)
protected int	deleteAclMemberEntitiesForAcls(List<Long> aclIds)
protected int	deleteDanglingAceEntities()
void	executeBatch()
List<Map<String,Object>>	getAclsThatInheritFromNonPrimaryParent() Get acls that do not inherit from the primary parent.
List<Map<String,Object>>	getAclsThatInheritWithInheritanceUnset() Get acls that inherit with inheritance unset
protected List<Map<String,Object>>	getAdmOldContentProperties(Long minNodeId, Long maxNodeId) Results are of the form:
List<String>	getAuthoritiesWithNonUtf8Crcs()
protected long	getAVMNodeEntitiesCountWhereNewInStore()
protected List<AVMNodeEntity>	getAVMNodeEntitiesWithEmptyGUID(int maxResults)
List<Long>	getAvmNodesWithOldContentProperties(Long minNodeId, Long maxNodeId)
int	getChildAssocCount()
List<Map<String,Object>>	getChildAssocsForCrcFix(Long minAssocId, Long stopAtAssocId, long rangeMultiplier, long maxIdRange, int maxResults) The results map contains:
List<org.alfresco.service.cmr.repository.NodeRef>	getChildrenOfTheSharedSurfConfigFolder(Long minNodeId, Long maxNodeId) Finds folders of the shared surf-config (for all tenants): company_home/sites/surf-config/components company_home/sites/surf-config/pages company_home/sites/surf-config/pages/user company_home/sites/surf-config/pages/user{userId}
long	getCountNodesWithAspects(Set<org.alfresco.service.namespace.QName> qnames)
long	getCountNodesWithTypId(org.alfresco.service.namespace.QName typeQName) Gets the total number of nodes which match the given Type QName.
List<Map<String,Object>>	getDefiningAclsThatDoNotInheritCorrectlyFromThePrimaryParent() Get defining acls with inheritance issues
protected long	getDmNodeEntitiesCount()
protected long	getDmNodeEntitiesCountWithNewACLs(Long above)
protected long	getMaxAclEntityId()
long	getMaxAdmNodeID()
long	getMaxAvmNodeID()
Long	getMaxChildAssocId()
List<Long>	getNodesByAspectQNameId(Long aspectQNameId, Long minNodeId, Long maxNodeId) Find all the nodes ids with the given aspect
List<Long>	getNodesByContentPropertyMimetypeId(Long mimetypeId, Long minNodeId, Long maxNodeId) Find all the nodes ids with the given content property set with the given mimetype
List<Long>	getNodesByTypeQNameId(Long typeQNameId, Long minNodeId, Long maxNodeId) Find all the nodes ids with the given type
List<Long>	getNodesByTypeUriId(Long nsId, Long minNodeId, Long maxNodeId) Find all the nodes ids with the given type uri
List<org.alfresco.util.Pair<org.alfresco.service.cmr.repository.NodeRef,String>>	getNodesOfTypeWithNamePattern(org.alfresco.service.namespace.QName typeQName, String namePattern) Query for a list of nodes that have a given type and share the same name pattern (SQL LIKE syntax)
protected List<AVMNodeEntity>	getNullVersionLayeredDirectoryNodeEntities(int maxResults)
protected List<AVMNodeEntity>	getNullVersionLayeredFileNodeEntities(int maxResults)
protected void	getOldAttrAVMLocksImpl(org.apache.ibatis.session.ResultHandler resultHandler)
protected void	getOldAttrChainingURSImpl(org.apache.ibatis.session.ResultHandler resultHandler)
protected List<String>	getOldAttrCustomNamesImpl()
protected void	getOldAttrPropertyBackedBeansImpl(org.apache.ibatis.session.ResultHandler resultHandler)
protected void	getOldAttrTenantsImpl(org.apache.ibatis.session.ResultHandler resultHandler)
List<Map<String,Object>>	getSharedAclsThatDoNotInheritCorrectlyFromTheirDefiningAcl() Get shared acls that do not inherit correctly from the defining acl
List<Map<String,Object>>	getSharedAclsThatDoNotInheritCorrectlyFromThePrimaryParent() Get shared acls with inheritance issues
void	migrateOldAttrDropTables() Drop old attribute alf_*attribute* tables
protected List<Long>	selectAllAclEntityIds()
protected List<Long>	selectNonDanglingAclEntityIds()
void	setLocaleDAO(LocaleDAO localeDAO)
void	setQnameDAO(QNameDAO qnameDAO)
void	setSqlSessionTemplate(org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate)
void	startBatch()
protected void	updateAdmOldContentProperty(Long nodeId, Long qnameId, Integer listIndex, Long localeId, Long longValue)
protected int	updateAVMNodeEntitiesNullifyAcl(List<Long> nodeIds)
protected int	updateAVMNodeEntitiesSetAcl(long aclId, List<Long> nodeIds)
int	updateChildAssocCrc(Long assocId, Long childNodeNameCrc, Long qnameCrc)
int	updateContentMimetypeIds(Long oldMimetypeId, Long newMimetypeId) Update all alf_content_data mimetype references.

Methods inherited from class org.alfresco.repo.domain.patch.AbstractPatchDAOImpl

deleteAclMembersForAcls, deleteAcls, deleteDanglingAces, getAVMNodesCountWhereNewInStore, getDmNodeCount, getDmNodeCountWithNewACLs, getEmptyGUIDS, getMaxAclId, getNullVersionLayeredDirectories, getNullVersionLayeredFiles, getOldAttrCustomNames, migrateOldAttrAVMLocks, migrateOldAttrChainingURS, migrateOldAttrPropertyBackedBeans, migrateOldAttrTenants, selectAllAclIds, selectNonDanglingAclIds, setContentDataDAO, updateAdmV31ContentProperties, updateAVMNodesNullifyAcl, updateAVMNodesSetAcl

Methods inherited from class java.lang.Object

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

Field Detail

template

protected org.mybatis.spring.SqlSessionTemplate template

Constructor Detail

PatchDAOImpl

public PatchDAOImpl()

Method Detail

setSqlSessionTemplate

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

setQnameDAO

public void setQnameDAO(QNameDAO qnameDAO)

setLocaleDAO

public void setLocaleDAO(LocaleDAO localeDAO)

startBatch

public void startBatch()

executeBatch

public void executeBatch()

getAVMNodeEntitiesCountWhereNewInStore

protected long getAVMNodeEntitiesCountWhereNewInStore()

Specified by:

getAVMNodeEntitiesCountWhereNewInStore in class AbstractPatchDAOImpl

getAVMNodeEntitiesWithEmptyGUID

protected List<AVMNodeEntity> getAVMNodeEntitiesWithEmptyGUID(int maxResults)

Specified by:

getAVMNodeEntitiesWithEmptyGUID in class AbstractPatchDAOImpl

getNullVersionLayeredDirectoryNodeEntities

protected List<AVMNodeEntity> getNullVersionLayeredDirectoryNodeEntities(int maxResults)

Specified by:

getNullVersionLayeredDirectoryNodeEntities in class AbstractPatchDAOImpl

getNullVersionLayeredFileNodeEntities

protected List<AVMNodeEntity> getNullVersionLayeredFileNodeEntities(int maxResults)

Specified by:

getNullVersionLayeredFileNodeEntities in class AbstractPatchDAOImpl

getMaxAvmNodeID

public long getMaxAvmNodeID()

getAvmNodesWithOldContentProperties

public List<Long> getAvmNodesWithOldContentProperties(Long minNodeId,
                                             Long maxNodeId)

getMaxAdmNodeID

public long getMaxAdmNodeID()

getAdmOldContentProperties

protected List<Map<String,Object>> getAdmOldContentProperties(Long minNodeId,
                                                  Long maxNodeId)

Description copied from class: AbstractPatchDAOImpl

Results are of the form:

      nodeId: java.lang.Long
      qnameId: java.lang.Long
      listIndex: java.lang.Integer
      localeId: java.lang.Long
      stringValue: java.lang.String
 

Specified by:

getAdmOldContentProperties in class AbstractPatchDAOImpl

Parameters:

minNodeId - inclusive lower bound for Node ID

maxNodeId - exclusive upper bound for Node ID

Returns:

Returns a map of query results

updateAdmOldContentProperty

protected void updateAdmOldContentProperty(Long nodeId,
                               Long qnameId,
                               Integer listIndex,
                               Long localeId,
                               Long longValue)

Specified by:

updateAdmOldContentProperty in class AbstractPatchDAOImpl

Parameters:

nodeId - part of the unique key

qnameId - part of the unique key

listIndex - part of the unique key

localeId - part of the unique key

longValue - the new ContentData ID

updateContentMimetypeIds

public int updateContentMimetypeIds(Long oldMimetypeId,
                           Long newMimetypeId)

Description copied from interface: PatchDAO

Update all alf_content_data mimetype references.

Parameters:

oldMimetypeId - the ID to search for

newMimetypeId - the ID to change to

Returns:

the number of rows affected

addSizeCurrentProp

public int addSizeCurrentProp()

Description copied from interface: PatchDAO

Add a cm:sizeCurrent property to person nodes that don't have it.

updateAVMNodeEntitiesNullifyAcl

protected int updateAVMNodeEntitiesNullifyAcl(List<Long> nodeIds)

Specified by:

updateAVMNodeEntitiesNullifyAcl in class AbstractPatchDAOImpl

updateAVMNodeEntitiesSetAcl

protected int updateAVMNodeEntitiesSetAcl(long aclId,
                              List<Long> nodeIds)

Specified by:

updateAVMNodeEntitiesSetAcl in class AbstractPatchDAOImpl

getMaxAclEntityId

protected long getMaxAclEntityId()

Specified by:

getMaxAclEntityId in class AbstractPatchDAOImpl

getDmNodeEntitiesCount

protected long getDmNodeEntitiesCount()

Specified by:

getDmNodeEntitiesCount in class AbstractPatchDAOImpl

getDmNodeEntitiesCountWithNewACLs

protected long getDmNodeEntitiesCountWithNewACLs(Long above)

Specified by:

getDmNodeEntitiesCountWithNewACLs in class AbstractPatchDAOImpl

selectAllAclEntityIds

protected List<Long> selectAllAclEntityIds()

Specified by:

selectAllAclEntityIds in class AbstractPatchDAOImpl

selectNonDanglingAclEntityIds

protected List<Long> selectNonDanglingAclEntityIds()

Specified by:

selectNonDanglingAclEntityIds in class AbstractPatchDAOImpl

deleteDanglingAceEntities

protected int deleteDanglingAceEntities()

Specified by:

deleteDanglingAceEntities in class AbstractPatchDAOImpl

deleteAclEntities

protected int deleteAclEntities(List<Long> aclIds)

Specified by:

deleteAclEntities in class AbstractPatchDAOImpl

deleteAclMemberEntitiesForAcls

protected int deleteAclMemberEntitiesForAcls(List<Long> aclIds)

Specified by:

deleteAclMemberEntitiesForAcls in class AbstractPatchDAOImpl

getAuthoritiesWithNonUtf8Crcs

public List<String> getAuthoritiesWithNonUtf8Crcs()

Returns:

Returns the names of authorities with incorrect CRC values

getChildAssocCount

public int getChildAssocCount()

Returns:

Returns the number child association rows

getMaxChildAssocId

public Long getMaxChildAssocId()

Returns:

Returns the maximum child assoc ID or 0 if there are none

getChildAssocsForCrcFix

public List<Map<String,Object>> getChildAssocsForCrcFix(Long minAssocId,
                                               Long stopAtAssocId,
                                               long rangeMultiplier,
                                               long maxIdRange,
                                               int maxResults)

Description copied from interface: PatchDAO

The results map contains:

 
        
        
        
        
        
        
        
       ]]>
 

Parameters:

minAssocId - the minimum child assoc ID

stopAtAssocId - the child assoc ID to stop at i.e. once this ID has been reached, pull back no results

rangeMultiplier - the ration of IDs to actual rows (how many IDs to select to get a row)

maxIdRange - the largest ID range to use for selects. Normally, the ID range should be allowed to grow in accordance with the general distribution of rows, but if memory problems are encountered, then the range will need to be set down.

maxResults - the number of child associations to fetch

Returns:

Returns child associations that need fixing

updateChildAssocCrc

public int updateChildAssocCrc(Long assocId,
                      Long childNodeNameCrc,
                      Long qnameCrc)

getNodesOfTypeWithNamePattern

public List<org.alfresco.util.Pair<org.alfresco.service.cmr.repository.NodeRef,String>> getNodesOfTypeWithNamePattern(org.alfresco.service.namespace.QName typeQName,
                                                                                                             String namePattern)

Description copied from interface: PatchDAO

Query for a list of nodes that have a given type and share the same name pattern (SQL LIKE syntax)

Parameters:

typeQName - the node type

namePattern - the SQL LIKE pattern

Returns:

Returns the node ID and node name

getOldAttrTenantsImpl

protected void getOldAttrTenantsImpl(org.apache.ibatis.session.ResultHandler resultHandler)

Specified by:

getOldAttrTenantsImpl in class AbstractPatchDAOImpl

getOldAttrAVMLocksImpl

protected void getOldAttrAVMLocksImpl(org.apache.ibatis.session.ResultHandler resultHandler)

Specified by:

getOldAttrAVMLocksImpl in class AbstractPatchDAOImpl

getOldAttrPropertyBackedBeansImpl

protected void getOldAttrPropertyBackedBeansImpl(org.apache.ibatis.session.ResultHandler resultHandler)

Specified by:

getOldAttrPropertyBackedBeansImpl in class AbstractPatchDAOImpl

getOldAttrChainingURSImpl

protected void getOldAttrChainingURSImpl(org.apache.ibatis.session.ResultHandler resultHandler)

Specified by:

getOldAttrChainingURSImpl in class AbstractPatchDAOImpl

getOldAttrCustomNamesImpl

protected List<String> getOldAttrCustomNamesImpl()

Specified by:

getOldAttrCustomNamesImpl in class AbstractPatchDAOImpl

migrateOldAttrDropTables

public void migrateOldAttrDropTables()

Description copied from interface: PatchDAO

Drop old attribute alf_*attribute* tables

getAclsThatInheritFromNonPrimaryParent

public List<Map<String,Object>> getAclsThatInheritFromNonPrimaryParent()

Description copied from interface: PatchDAO

Get acls that do not inherit from the primary parent.

getAclsThatInheritWithInheritanceUnset

public List<Map<String,Object>> getAclsThatInheritWithInheritanceUnset()

Description copied from interface: PatchDAO

Get acls that inherit with inheritance unset

getDefiningAclsThatDoNotInheritCorrectlyFromThePrimaryParent

public List<Map<String,Object>> getDefiningAclsThatDoNotInheritCorrectlyFromThePrimaryParent()

Description copied from interface: PatchDAO

Get defining acls with inheritance issues

getSharedAclsThatDoNotInheritCorrectlyFromThePrimaryParent

public List<Map<String,Object>> getSharedAclsThatDoNotInheritCorrectlyFromThePrimaryParent()

Description copied from interface: PatchDAO

Get shared acls with inheritance issues

getSharedAclsThatDoNotInheritCorrectlyFromTheirDefiningAcl

public List<Map<String,Object>> getSharedAclsThatDoNotInheritCorrectlyFromTheirDefiningAcl()

Description copied from interface: PatchDAO

Get shared acls that do not inherit correctly from the defining acl

getCountNodesWithAspects

public long getCountNodesWithAspects(Set<org.alfresco.service.namespace.QName> qnames)

Parameters:

qnames - the qnames to search for

Returns:

Returns a count of the number of nodes that have either of the aspects

getNodesByTypeQNameId

public List<Long> getNodesByTypeQNameId(Long typeQNameId,
                               Long minNodeId,
                               Long maxNodeId)

Description copied from interface: PatchDAO

Find all the nodes ids with the given type

Parameters:

typeQNameId - - the id of the type qname

minNodeId - - min node id in the result set - inclusive

maxNodeId - - max node id in the result set - exclusive

Returns:

getNodesByTypeUriId

public List<Long> getNodesByTypeUriId(Long nsId,
                             Long minNodeId,
                             Long maxNodeId)

Description copied from interface: PatchDAO

Find all the nodes ids with the given type uri

Parameters:

nsId - - the id of the type qname uri

minNodeId - - min node id in the result set - inclusive

maxNodeId - - max node id in the result set - exclusive

Returns:

getNodesByAspectQNameId

public List<Long> getNodesByAspectQNameId(Long aspectQNameId,
                                 Long minNodeId,
                                 Long maxNodeId)

Description copied from interface: PatchDAO

Find all the nodes ids with the given aspect

Parameters:

aspectQNameId - - the id of the aspect qname

minNodeId - - min node id in the result set - inclusive

maxNodeId - - max node id in the result set - exclusive

Returns:

getNodesByContentPropertyMimetypeId

public List<Long> getNodesByContentPropertyMimetypeId(Long mimetypeId,
                                             Long minNodeId,
                                             Long maxNodeId)

Description copied from interface: PatchDAO

Find all the nodes ids with the given content property set with the given mimetype

Parameters:

mimetypeId - - the id of the content data mimetype

minNodeId - - min node id in the result set - inclusive

maxNodeId - - max node id in the result set - exclusive

Returns:

getCountNodesWithTypId

public long getCountNodesWithTypId(org.alfresco.service.namespace.QName typeQName)

Description copied from interface: PatchDAO

Gets the total number of nodes which match the given Type QName.

Parameters:

typeQName - the qname to search for

Returns:

count of nodes that match the typeQName

getChildrenOfTheSharedSurfConfigFolder

public List<org.alfresco.service.cmr.repository.NodeRef> getChildrenOfTheSharedSurfConfigFolder(Long minNodeId,
                                                                                       Long maxNodeId)

Description copied from interface: PatchDAO

Finds folders of the shared surf-config (for all tenants):

• company_home/sites/surf-config/components
• company_home/sites/surf-config/pages
• company_home/sites/surf-config/pages/user
• company_home/sites/surf-config/pages/user{userId}

Parameters:

minNodeId - - min node id in the result set - inclusive

maxNodeId - - max node id in the result set - exclusive

Returns:

list of children nodeRefs