2 * Copyright © 2018-2019 AT&T Intellectual Property.
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
8 * http://www.apache.org/licenses/LICENSE-2.0
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
17 package org.onap.ccsdk.cds.blueprintsprocessor.functions.message.prioritization.db
19 import org.springframework.data.domain.Pageable
20 import org.springframework.data.jpa.repository.JpaRepository
21 import org.springframework.data.jpa.repository.Modifying
22 import org.springframework.data.jpa.repository.Query
23 import org.springframework.stereotype.Repository
24 import org.springframework.transaction.annotation.Transactional
28 @Transactional(readOnly = true)
29 interface PrioritizationMessageRepository : JpaRepository<MessagePrioritization, String> {
31 @Query("FROM MessagePrioritization pm WHERE pm.group = :group ORDER BY pm.createdDate asc")
32 fun findByGroup(group: String, count: Pageable): List<MessagePrioritization>?
35 "FROM MessagePrioritization pm WHERE pm.group = :group AND pm.state in :states " +
36 "ORDER BY pm.createdDate asc"
38 fun findByGroupAndStateIn(group: String, states: List<String>, count: Pageable): List<MessagePrioritization>?
41 "FROM MessagePrioritization pm WHERE pm.group = :group AND pm.state in :states " +
42 "ORDER BY pm.updatedDate asc"
44 fun findByGroupAndStateInOrderByUpdatedDate(group: String, states: List<String>, count: Pageable):
45 List<MessagePrioritization>?
48 "FROM MessagePrioritization pm WHERE pm.group = :group AND pm.state in :states " +
49 "AND pm.expiryDate > :expiryCheckDate ORDER BY pm.createdDate asc"
51 fun findByGroupAndStateInAndNotExpiredDate(
54 expiryCheckDate: Date,
56 ): List<MessagePrioritization>?
59 "FROM MessagePrioritization pm WHERE pm.state in :states " +
60 "AND pm.expiryDate < :expiryCheckDate ORDER BY pm.createdDate asc"
62 fun findByStateInAndExpiredDate(
64 expiryCheckDate: Date,
66 ): List<MessagePrioritization>?
69 "FROM MessagePrioritization pm WHERE pm.group = :group AND pm.state in :states " +
70 "AND pm.expiryDate < :expiryCheckDate ORDER BY pm.createdDate asc"
72 fun findByGroupAndStateInAndExpiredDate(
75 expiryCheckDate: Date,
77 ): List<MessagePrioritization>?
80 "FROM MessagePrioritization pm WHERE pm.group = :group " +
81 "AND pm.expiryDate < :expiryCheckDate ORDER BY pm.createdDate asc"
83 fun findByByGroupAndExpiredDate(group: String, expiryCheckDate: Date, count: Pageable): List<MessagePrioritization>?
86 "FROM MessagePrioritization pm WHERE pm.group = :group AND pm.state in :states " +
87 "AND pm.correlationId = :correlationId ORDER BY pm.createdDate asc"
89 fun findByGroupAndCorrelationId(group: String, states: List<String>, correlationId: String):
90 List<MessagePrioritization>?
93 "FROM MessagePrioritization pm WHERE pm.group = :group AND pm.state in :states " +
94 "AND pm.type in :types AND pm.correlationId = :correlationId ORDER BY pm.createdDate asc"
96 fun findByGroupAndTypesAndCorrelationId(
100 correlationId: String
101 ): List<MessagePrioritization>?
106 "UPDATE MessagePrioritization SET state = :state, updatedDate = :currentDate " +
109 fun setStateForMessageId(id: String, state: String, currentDate: Date): Int
114 "UPDATE MessagePrioritization SET priority = :priority, updatedDate = :currentDate " +
117 fun setPriorityForMessageId(id: String, priority: String, currentDate: Date): Int
122 "UPDATE MessagePrioritization SET state = :state, updatedDate = :currentDate " +
125 fun setStateForMessageIds(ids: List<String>, state: String, currentDate: Date): Int
130 "UPDATE MessagePrioritization SET priority = :priority, updatedDate = :currentDate " +
133 fun setPriorityForMessageIds(ids: List<String>, priority: String, currentDate: Date): Int
138 "UPDATE MessagePrioritization SET state = :state, error = :error, updatedDate = :currentDate " +
141 fun setStateAndErrorForMessageId(id: String, state: String, error: String, currentDate: Date): Int
146 "UPDATE MessagePrioritization SET state = :state, " +
147 "aggregatedMessageIds = :aggregatedMessageIds, updatedDate = :currentDate WHERE id = :id"
149 fun setStateAndAggregatedMessageIds(id: String, state: String, aggregatedMessageIds: String, currentDate: Date): Int
153 @Query("DELETE FROM MessagePrioritization pm WHERE pm.group = :group")
154 fun deleteGroup(group: String)
158 @Query("DELETE FROM MessagePrioritization pm WHERE pm.group = :group AND pm.state IN :states")
159 fun deleteGroupAndStateIn(group: String, states: List<String>)