Package org.craftercms.studio.api.v2.dal

Interface RetryingDatabaseOperationFacade

    • Method Detail

      • deleteAllSourceDependencies

        void deleteAllSourceDependencies​(Map params)
        Delete all dependencies for source path
        Parameters:
        params - SQL query parameters

      • insertDependenciesList

        void insertDependenciesList​(Map params)
        Insert list of dependencies
        Parameters:
        params - SQL query parameters

      • deleteDependenciesForSite

        void deleteDependenciesForSite​(Map params)
        Delete all dependencies for site (delete site subtask)
        Parameters:
        params - SQL query parameters

      • deleteDependenciesForSiteAndPath

        void deleteDependenciesForSiteAndPath​(Map params)
        Delete dependencies for site and path (delete content subtask)
        Parameters:
        params - SQL query parameters

      • moveDependency

        void moveDependency​(Map params)
        Move dependencies (move content subtask)
        Parameters:
        params - SQL query parameters

      • insertNavigationOrderSequence

        void insertNavigationOrderSequence​(NavigationOrderSequence navigationOrderSequence)
        Insert new navigation order sequence
        Parameters:
        navigationOrderSequence - Navigation order sequence object

      • updateNavigationOrderSequence

        void updateNavigationOrderSequence​(NavigationOrderSequence navigationOrderSequence)
        Update navigation order sequence
        Parameters:
        navigationOrderSequence - Navigation order sequence object

      • deleteNavigationOrderSequencesForSite

        void deleteNavigationOrderSequencesForSite​(Map params)
        Delete navigation order sequences for site (delete site subtasks)
        Parameters:
        params - SQL query parameters

      • insertItemForDeployment

        void insertItemForDeployment​(PublishRequest publishRequest)
        Insert new publish request into publishing queue
        Parameters:
        publishRequest -

      • cancelWorkflow

        void cancelWorkflow​(Map params)
        Cancel workflow for single item (cancel items from publishing queue)
        Parameters:
        params - SQL query parameters

      • cancelWorkflowBulk

        void cancelWorkflowBulk​(Map params)
        Cancel workflow for multiple items (cancel items from publishing queue)
        Parameters:
        params -

      • updateItemDeploymentState

        void updateItemDeploymentState​(PublishRequest item)
        Update publishing queue item state
        Parameters:
        item - Publish request item

      • markPublishRequestItemCompleted

        void markPublishRequestItemCompleted​(PublishRequest item)
        Mark publish request item as completed
        Parameters:
        item - Publish request item

      • deleteDeploymentDataForSite

        void deleteDeploymentDataForSite​(Map params)
        Delete publish request items for site (delete site subtask)
        Parameters:
        params - SQL query parameters

      • resetPublishRequestProcessingQueue

        void resetPublishRequestProcessingQueue​(Map params)
        Reset publishing requests in processing state
        Parameters:
        params - SQL query parameters

      • createSite

        boolean createSite​(SiteFeed siteFeed)
        Create new site
        Parameters:
        siteFeed - Site object
        Returns:
        true if success otherwise false

      • deleteSite

        boolean deleteSite​(String siteId,
                   String state)
        Delete site
        Parameters:
        siteId - site identifier
        state - deleted state value
        Returns:

      • updateSiteLastCommitId

        void updateSiteLastCommitId​(Map params)
        Update last commit id for site
        Parameters:
        params - SQL query parameters

      • enableSitePublishing

        void enableSitePublishing​(Map params)
        Enable/disable publishing site
        Parameters:
        params - SQL query parameters

      • updateSitePublishingStatus

        void updateSitePublishingStatus​(String siteId,
                                String status)
        Update publishing status for site
        Parameters:
        siteId - site identifier
        status - status value

      • updateSiteLastVerifiedGitlogCommitId

        void updateSiteLastVerifiedGitlogCommitId​(Map params)
        Update last verified git log commit id for site
        Parameters:
        params - SQL query parameters

      • updateSiteLastSyncedGitlogCommitId

        void updateSiteLastSyncedGitlogCommitId​(Map params)
        Update last synced git log commit id for site
        Parameters:
        params - SQL query parameters

      • setSitePublishedRepoCreated

        void setSitePublishedRepoCreated​(String siteId)
        Set published repo created flag
        Parameters:
        siteId - site identifier

      • unlockPublishingForSite

        void unlockPublishingForSite​(String siteId,
                             String lockOwnerId)
        unlock publisher task for site
        Parameters:
        siteId - site identifier
        lockOwnerId - lock owner identifier

      • updatePublishingLockHeartbeatForSite

        void updatePublishingLockHeartbeatForSite​(String siteId)
        update publishing lock heartbeat for site
        Parameters:
        siteId - site identifier

      • updateSite

        int updateSite​(String siteId,
               String name,
               String description)
        Updates the name and description for the given site
        Parameters:
        siteId - the id of the site
        name - the name of the site
        description - the description of the site
        Returns:
        the number of changed rows

      • setSiteState

        void setSiteState​(String siteId,
                  String state)

      • clearPublishingLockForSite

        void clearPublishingLockForSite​(String siteId)
        Clear publishing lock for site
        Parameters:
        siteId - site identifier

      • insertAuditLog

        int insertAuditLog​(AuditLog auditLog)
        Insert audit log record
        Parameters:
        auditLog - Audit log
        Returns:
        number of rows affected

      • insertAuditLogParams

        void insertAuditLogParams​(Map params)
        Insert audit log parameters
        Parameters:
        params - SQL query parameters

      • deleteAuditLogForSite

        void deleteAuditLogForSite​(long siteId)
        Delete audit log for site
        Parameters:
        siteId - site id

      • updateClusterMember

        int updateClusterMember​(ClusterMember member)
        Update cluster member in the database
        Parameters:
        member - Cluster member to update
        Returns:
        number of affected rows

      • addClusterMember

        int addClusterMember​(ClusterMember member)
        Add member to cluster in the database
        Parameters:
        member - Member to add
        Returns:
        number of affected rows

      • removeClusterMembers

        int removeClusterMembers​(Map params)
        Remove members from cluster in the database
        Parameters:
        params - Parameters for SQL query
        Returns:
        number of affected rows

      • removeClusterMemberByLocalAddress

        int removeClusterMemberByLocalAddress​(Map params)
        Remove member from cluster in the database by local address
        Parameters:
        params - Parameters for SQL query
        Returns:
        number of affected rows

      • updateClusterNodeHeartbeat

        int updateClusterNodeHeartbeat​(Map params)
        Update heartbeat for cluster node
        Parameters:
        params - Parameters for SQL query
        Returns:
        number of affected rows

      • addClusterRemoteRepository

        void addClusterRemoteRepository​(long clusterId,
                                long remoteRepositoryId)
        Add given remote repository for given cluster node
        Parameters:
        clusterId - cluster node identifier
        remoteRepositoryId - remote repository identifier

      • clearClusterData

        void clearClusterData()
        Clear cluster data

      • insertGitLog

        void insertGitLog​(Map params)
        Insert new gitlog table row
        Parameters:
        params - SQL query parameters

      • insertGitLogList

        void insertGitLogList​(Map params)
        Insert list of new rows to gitlog table
        Parameters:
        params -

      • markGitLogProcessed

        void markGitLogProcessed​(Map params)
        Mark git log row as processed
        Parameters:
        params - SQL query parameters

      • markGitLogProcessedBulk

        void markGitLogProcessedBulk​(String siteId,
                             List<String> commitIds)
        Mark commit id as processed for given site and list of
        Parameters:
        siteId - site identifier
        commitIds - list of commit ids

      • deleteGitLogForSite

        void deleteGitLogForSite​(Map params)
        Delete gitlog rows for site (delete site subtask)
        Parameters:
        params - SQL query parameters

      • markGitLogAudited

        void markGitLogAudited​(String siteId,
                       String commitId,
                       int audited)
        Mark gitlog as audited for site
        Parameters:
        siteId - site identifier
        commitId - commit id
        audited - audited flag value

      • insertIgnoreGitLogList

        void insertIgnoreGitLogList​(String siteId,
                            List<String> commitIds)
        Insert list of gitlog rows with ignore option if it already exists
        Parameters:
        siteId - site identifier
        commitIds - commit id

      • markGitLogProcessedBeforeMarker

        void markGitLogProcessedBeforeMarker​(String siteId,
                                     long marker,
                                     int processed,
                                     int unprocessed)
        Mark all git logs as processed if they are inserted before marker
        Parameters:
        siteId - site identifier
        marker - marker git commit
        processed - value for processed

      • upsertGitLogList

        void upsertGitLogList​(String siteId,
                      List<String> commitIds,
                      int processed,
                      int audited)
        Upsert git logs as processed and audited
        Parameters:
        siteId - site identifier
        commitIds - commit ids

      • createGroup

        Integer createGroup​(long orgId,
                    String groupName,
                    String groupDescription)
        Create group
        Parameters:
        orgId - organization id
        groupName - group name
        groupDescription - group description
        Returns:
        Number of affected rows in DB

      • updateGroup

        Integer updateGroup​(Group group)
        Update group
        Parameters:
        group - group to update
        Returns:
        Number of affected rows in DB

      • deleteGroup

        Integer deleteGroup​(long groupId)
        Delete group
        Parameters:
        groupId - group identifier
        Returns:
        Number of affected rows in DB

      • deleteGroups

        Integer deleteGroups​(List<Long> groupIds)
        Delete groups
        Parameters:
        groupIds - ids of the groups to be deleted
        Returns:
        Number of affected rows in DB

      • addGroupMembers

        Integer addGroupMembers​(long groupId,
                        List<Long> userIds)
        Add users to the group
        Parameters:
        groupId - group identifier
        userIds - list of user identifiers
        Returns:
        Number of rows affected in DB

      • removeGroupMembers

        Integer removeGroupMembers​(long groupId,
                           List<Long> userIds)
        Remove users from the group
        Parameters:
        groupId - group identifier
        userIds - list of user identifiers
        Returns:
        Number of rows affected in DB

      • upsertEntry

        void upsertEntry​(Item item)
        ItemDAO insert or update item
        Parameters:
        item - item to insert/update

      • upsertEntries

        void upsertEntries​(List<Item> entries)
        Insert or update items
        Parameters:
        entries - list of items to insert

      • updateItem

        void updateItem​(Item item)
        Update item
        Parameters:
        item - item to update

      • deleteById

        void deleteById​(long id)
        Delete item
        Parameters:
        id - id of the item to delete

      • deleteBySiteAndPath

        void deleteBySiteAndPath​(long siteId,
                         String path)
        Delete item
        Parameters:
        siteId - site identifier
        path - path of item to delete

      • setStatesBySiteAndPathBulk

        void setStatesBySiteAndPathBulk​(long siteId,
                                List<String> paths,
                                long statesBitMap)
        Set items state
        Parameters:
        siteId - site identifier
        paths - paths of items
        statesBitMap - states bit map to be set

      • setStatesByIdBulk

        void setStatesByIdBulk​(List<Long> itemIds,
                       long statesBitMap)
        Set items state
        Parameters:
        itemIds - ids of items
        statesBitMap - states bit map to be set

      • resetStatesBySiteAndPathBulk

        void resetStatesBySiteAndPathBulk​(long siteId,
                                  List<String> paths,
                                  long statesBitMap)
        Reset items state
        Parameters:
        siteId - site identifier
        paths - paths of items
        statesBitMap - states bit map to be reset

      • resetStatesByIdBulk

        void resetStatesByIdBulk​(List<Long> itemIds,
                         long statesBitMap)
        Reset items state
        Parameters:
        itemIds - ids of items
        statesBitMap - states bit map to be reset

      • updateStatesBySiteAndPathBulk

        void updateStatesBySiteAndPathBulk​(long siteId,
                                   List<String> paths,
                                   long onStatesBitMap,
                                   long offStatesBitMap)
        Update states to flip on list off states and flip off another list of states for items
        Parameters:
        siteId - site identifier
        paths - list of paths to update states for
        onStatesBitMap - state bitmap to flip on
        offStatesBitMap - state bitmap to flip off

      • updateStatesByIdBulk

        void updateStatesByIdBulk​(List<Long> itemIds,
                          long onStatesBitMap,
                          long offStatesBitMap)
        Update states to flip on list off states and flip off another list of states for items
        Parameters:
        itemIds - list of item identifiers
        onStatesBitMap - state bitmap to flip on
        offStatesBitMap - state bitmap to flip off

      • updateStatesForSite

        void updateStatesForSite​(long siteId,
                         long onStatesBitMap,
                         long offStatesBitMap)
        Update states to flip on list off states and flip off another list of states for items
        Parameters:
        siteId - site identifier
        onStatesBitMap - state bitmap to flip on
        offStatesBitMap - state bitmap to flip off

      • deleteItemsForSite

        void deleteItemsForSite​(long siteId)
        Delete all items for site
        Parameters:
        siteId - site id

      • deleteItemsById

        void deleteItemsById​(List<Long> itemIds)
        Delete items by id
        Parameters:
        itemIds - item ids

      • deleteItemsForSiteAndPath

        void deleteItemsForSiteAndPath​(long siteId,
                               List<String> paths)
        Delete items for site and paths
        Parameters:
        siteId - site id
        paths - paths of the items

      • deleteBySiteAndPathForFolder

        void deleteBySiteAndPathForFolder​(long siteId,
                                  String path)
        Delete items for site and folder path
        Parameters:
        siteId - site id
        path - path of the folder

      • moveItem

        void moveItem​(String siteId,
              String oldPath,
              String newPath)
        Move item
        Parameters:
        siteId - site identifier
        oldPath - old path
        newPath - new path

      • moveItems

        void moveItems​(String siteId,
               String oldPath,
               String newPath,
               Long parentId,
               String oldPreviewUrl,
               String newPreviewUrl,
               long onStatesBitMap,
               long offStatesBitMap)
        Move items
        Parameters:
        siteId - site identifier
        oldPath - old path
        newPath - new path
        parentId - new parent id, if null parent will not be changed
        oldPreviewUrl - old preview url
        newPreviewUrl - new preview url
        onStatesBitMap - state bitmap to flip on
        offStatesBitMap - state bitmap to flip off

      • clearPreviousPath

        void clearPreviousPath​(String siteId,
                       String path)
        Clear previous path of the content
        Parameters:
        siteId - site identifier
        path - path of the content

      • updateCommitId

        void updateCommitId​(String siteId,
                    String path,
                    String commitId)
        Update commit id for item
        Parameters:
        siteId - site identifier
        path - path of the item
        commitId - commit id

      • updateLastPublishedOn

        void updateLastPublishedOn​(String siteId,
                           String path,
                           ZonedDateTime lastPublishedOn)
        Update last published date for item
        Parameters:
        siteId - site identifier
        path - path of the item
        lastPublishedOn - published date

      • updateLastPublishedOnBulk

        void updateLastPublishedOnBulk​(String siteId,
                               List<String> paths,
                               ZonedDateTime lastPublishedOn)
        Update last published date for item
        Parameters:
        siteId - site identifier
        paths - list of paths
        lastPublishedOn - published date

      • lockItemByPath

        void lockItemByPath​(String siteId,
                    String path,
                    long lockOwnerId,
                    long lockedBitOn,
                    String systemTypeFolder)
        Lock item
        Parameters:
        siteId - site identifier
        path - path of the item
        lockOwnerId - lock owner
        lockedBitOn - state bit mask with LOCKED bit on
        systemTypeFolder - value for system type folder

      • lockItemsByPath

        void lockItemsByPath​(String siteId,
                     List<String> paths,
                     long lockOwnerId,
                     long lockedBitOn,
                     String systemTypeFolder)
        Lock items
        Parameters:
        siteId - site identifier
        paths - list of item paths
        lockOwnerId - lock owner
        lockedBitOn - state bit mask with LOCKED bit on
        systemTypeFolder - value for system type folder

      • unlockItemByPath

        void unlockItemByPath​(String siteId,
                      String path,
                      long lockedBitOff)
        Lock item
        Parameters:
        siteId - site identifier
        path - path of the item
        lockedBitOff - state bit mask with LOCKED bit off

      • lockItemById

        void lockItemById​(Long itemId,
                  long lockOwnerId,
                  long lockedBitOn,
                  String systemTypeFolder)
        Lock item
        Parameters:
        itemId - item identifier
        lockOwnerId - lock owner
        lockedBitOn - state bit mask with LOCKED bit on
        systemTypeFolder - value for system type folder

      • lockItemsById

        void lockItemsById​(List<Long> itemIds,
                   long lockOwnerId,
                   long lockedBitOn,
                   String systemTypeFolder)
        Lock items
        Parameters:
        itemIds - list of item identifiers
        lockOwnerId - lock owner
        lockedBitOn - state bit mask with LOCKED bit on
        systemTypeFolder - value for system type folder

      • unlockItemById

        void unlockItemById​(Long itemId,
                    long lockedBitOff)
        Unlock item
        Parameters:
        itemId - item identifier
        lockedBitOff - state bit mask with LOCKED bit off

      • updateStatesByQuery

        void updateStatesByQuery​(String siteId,
                         String path,
                         Long states,
                         long setStatesMask,
                         long resetStatesMask)
        Update item state by query
        Parameters:
        siteId - site identifier
        path - path regex to filter items to be updated
        states - states bitmap mask to filter items to be updated
        setStatesMask - states bitmap mask to set states on
        resetStatesMask - states bitmap mask to set states off

      • cancelPackages

        void cancelPackages​(String siteId,
                    List<String> packageIds,
                    String cancelledState)
        Cancel publishing packages
        Parameters:
        siteId - site identifier
        packageIds - list of package identifiers
        cancelledState - cancelled state

      • cancelScheduledQueueItems

        void cancelScheduledQueueItems​(String siteId,
                               List<String> paths,
                               ZonedDateTime now,
                               String cancelledState,
                               String readyState)
        Cancel scheduled items from publishing queue
        Parameters:
        siteId - site identifier
        paths - list of paths of content items to be cancelled
        now - timestamp now
        cancelledState - cancelled state value
        readyState - ready for live state value

      • insertRemoteRepository

        void insertRemoteRepository​(Map params)
        Insert remote repository record
        Parameters:
        params - SQL query parameters

      • deleteRemoteRepositoryForSite

        void deleteRemoteRepositoryForSite​(Map params)
        Delete remote repositories for site (delete site subtask)
        Parameters:
        params - SQL query parameters

      • deleteRemoteRepository

        void deleteRemoteRepository​(Map params)
        Delete remote repository record
        Parameters:
        params - SQL query parameters

      • deleteRemoteRepositoriesForSite

        void deleteRemoteRepositoriesForSite​(Map params)
        Delete remote repositories for site (delete site subtask)
        Parameters:
        params - SQL query parameters

      • upsertRefreshToken

        void upsertRefreshToken​(long userId,
                        String token)
        Insert or update refresh token
        Parameters:
        userId - User identifier
        token - token

      • deleteRefreshToken

        void deleteRefreshToken​(long userId)
        Delete refresh token
        Parameters:
        userId - user identifier

      • createAccessToken

        void createAccessToken​(long userId,
                       PersistentAccessToken token)
        Create access token
        Parameters:
        userId - user identifier
        token - token

      • updateAccessToken

        void updateAccessToken​(long userId,
                       long tokenId,
                       boolean enabled)
        Update access token
        Parameters:
        userId - user identifier
        tokenId - token identifier
        enabled - enabled flag

      • deleteAccessToken

        void deleteAccessToken​(long userId,
                       long tokenId)
        Delete access token
        Parameters:
        userId - user identifier
        tokenId - token identifier

      • deleteExpiredTokens

        int deleteExpiredTokens​(int sessionTimeout,
                        List<Long> inactiveUsers)
        Delete expired tokens
        Parameters:
        sessionTimeout - the timeout in minutes for active users
        inactiveUsers - the list of user ids that are inactive

      • createUser

        int createUser​(Map params)
        Create user
        Parameters:
        params - SQL query parameters
        Returns:
        Number of rows affected in DB

      • updateUser

        int updateUser​(Map params)
        Update user
        Parameters:
        params - SQL query parameters
        Returns:
        Number of rows affected in DB

      • deleteUsers

        int deleteUsers​(Map params)
        Delete users
        Parameters:
        params - SQL query params
        Returns:
        Number of rows affected in DB

      • enableUsers

        int enableUsers​(Map params)
        Enable/disable users
        Parameters:
        params - SQL query parameters
        Returns:
        Number of rows affected in DB

      • setUserPassword

        int setUserPassword​(Map params)
        Set password for user
        Parameters:
        params - SQL query parameters
        Returns:
        Number of rows affected

      • deleteUserProperties

        void deleteUserProperties​(long userId,
                          long siteId,
                          List<String> keys)
        Deletes the given user properties
        Parameters:
        userId - the id of the user
        siteId - the id of the site
        keys - the keys to delete

      • updateUserProperties

        void updateUserProperties​(long userId,
                          long siteId,
                          Map<String,​String> properties)
        Updates the given user properties
        Parameters:
        userId - the id of the user
        siteId - the id of the site
        properties - the properties to update or add

      • deleteUserPropertiesBySiteId

        void deleteUserPropertiesBySiteId​(long siteId)
        Deletes all user properties for a given site
        Parameters:
        siteId - the id of the site

      • deleteUserPropertiesByUserIds

        void deleteUserPropertiesByUserIds​(List<Long> userIds)
        Deletes all user properties for a given user
        Parameters:
        userIds - the id of the user

      • insertWorkflowEntry

        void insertWorkflowEntry​(Workflow workflow)
        Insert workflow entry
        Parameters:
        workflow - workflow entry

      • insertWorkflowEntries

        void insertWorkflowEntries​(List<Workflow> workflowEntries)
        Insert workflow entries
        Parameters:
        workflowEntries - list of workflow entries

      • updateWorkflowEntry

        void updateWorkflowEntry​(Workflow workflow)
        Update workflow entry
        Parameters:
        workflow - workflow entry

      • deleteWorkflowEntries

        void deleteWorkflowEntries​(String siteId,
                           List<String> paths)
        Delete workflow entries
        Parameters:
        siteId - site identifier
        paths - list of paths

      • deleteWorkflowEntry

        void deleteWorkflowEntry​(String siteId,
                         String path)
        Delete workflow entry
        Parameters:
        siteId - site identifier
        path - path

      • deleteWorkflowEntriesForSite

        void deleteWorkflowEntriesForSite​(long siteId)
        Delete workflow entries for site
        Parameters:
        siteId - site id