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 findByGroupAndExpiredDate(group: String, expiryCheckDate: Date, count: Pageable): List<MessagePrioritization>?
86 "FROM MessagePrioritization pm WHERE pm.expiryDate < :expiryCheckDate ORDER BY pm.createdDate asc"
88 fun findByExpiredDate(expiryCheckDate: Date, count: Pageable): List<MessagePrioritization>?
91 "FROM MessagePrioritization pm WHERE pm.group = :group AND pm.state in :states " +
92 "AND pm.correlationId = :correlationId ORDER BY pm.createdDate asc"
94 fun findByGroupAndCorrelationId(group: String, states: List<String>, correlationId: String):
95 List<MessagePrioritization>?
98 "FROM MessagePrioritization pm WHERE pm.group = :group AND pm.state in :states " +
99 "AND pm.type in :types AND pm.correlationId = :correlationId ORDER BY pm.createdDate asc"
101 fun findByGroupAndTypesAndCorrelationId(
103 states: List<String>,
105 correlationId: String
106 ): List<MessagePrioritization>?
111 "UPDATE MessagePrioritization SET state = :state, updatedDate = :currentDate " +
114 fun setStateForMessageId(id: String, state: String, currentDate: Date): Int
119 "UPDATE MessagePrioritization SET priority = :priority, updatedDate = :currentDate " +
122 fun setPriorityForMessageId(id: String, priority: String, currentDate: Date): Int
127 "UPDATE MessagePrioritization SET state = :state, updatedDate = :currentDate " +
130 fun setStateForMessageIds(ids: List<String>, state: String, currentDate: Date): Int
135 "UPDATE MessagePrioritization SET priority = :priority, updatedDate = :currentDate " +
138 fun setPriorityForMessageIds(ids: List<String>, priority: String, currentDate: Date): Int
143 "UPDATE MessagePrioritization SET state = :state, error = :error, updatedDate = :currentDate " +
146 fun setStateAndErrorForMessageId(id: String, state: String, error: String, currentDate: Date): Int
151 "UPDATE MessagePrioritization SET state = :state, " +
152 "aggregatedMessageIds = :aggregatedMessageIds, updatedDate = :currentDate WHERE id = :id"
154 fun setStateAndAggregatedMessageIds(id: String, state: String, aggregatedMessageIds: String, currentDate: Date): Int
158 @Query("DELETE FROM MessagePrioritization WHERE id IN :ids")
159 fun deleteByIds(ids: List<String>)
163 @Query("DELETE FROM MessagePrioritization WHERE expiryDate > :expiryCheckDate ")
164 fun deleteByExpiryDate(expiryCheckDate: Date)
168 @Query("DELETE FROM MessagePrioritization WHERE group = :group")
169 fun deleteGroup(group: String)
173 @Query("DELETE FROM MessagePrioritization WHERE group = :group AND state IN :states")
174 fun deleteGroupAndStateIn(group: String, states: List<String>)