Interface PatchDAO

    • Method Detail

      • updateContentMimetypeIds

        int updateContentMimetypeIds​(Long oldMimetypeId,
                                     Long newMimetypeId)
        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
      • updatePersonSizeCurrentType

        int updatePersonSizeCurrentType()
        Update all alf_node_properties of 'sizeCurrent' name to have correct persisted type of Long.
        Returns:
        the number of rows affected
      • getNodesOfTypeWithNamePattern

        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)
        Parameters:
        typeQName - the node type
        namePattern - the SQL LIKE pattern
        Returns:
        Returns the node ID and node name
      • getCountNodesWithAspects

        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

        List<Long> getNodesByTypeQNameId​(Long typeQNameId,
                                         Long minNodeId,
                                         Long maxNodeId)
        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:
        IDs of the nodes
      • getNodesByTypeUriId

        List<Long> getNodesByTypeUriId​(Long uriId,
                                       Long minNodeId,
                                       Long maxNodeId)
        Find all the nodes ids with the given type uri
        Parameters:
        uriId - - 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:
        IDs of the nodes
      • getNodesByAspectQNameId

        List<Long> getNodesByAspectQNameId​(Long aspectQNameId,
                                           Long minNodeId,
                                           Long maxNodeId)
        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:
        IDs of the nodes
      • getNodesByContentPropertyMimetypeId

        List<Long> getNodesByContentPropertyMimetypeId​(Long mimetypeId,
                                                       Long minNodeId,
                                                       Long maxNodeId)
        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:
        IDs of the nodes
      • getNodesByTypeQNameAndAspectQNameId

        List<Long> getNodesByTypeQNameAndAspectQNameId​(long typeQNameId,
                                                       long aspectQNameId,
                                                       long minNodeId,
                                                       long maxNodeId)
        Find all the nodes ids with the given aspect and type
        Parameters:
        typeQNameId - - the id of the type qname
        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:
        List
      • getCountNodesWithTypId

        long getCountNodesWithTypId​(org.alfresco.service.namespace.QName typeQName)
        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

        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}
        Parameters:
        minNodeId - - min node id in the result set - inclusive
        maxNodeId - - max node id in the result set - exclusive
        Returns:
        list of children nodeRefs