diff options
Diffstat (limited to 'src/main/java/com/wipro/www/sonhms/dao/BufferedNotificationsRepository.java')
-rw-r--r-- | src/main/java/com/wipro/www/sonhms/dao/BufferedNotificationsRepository.java | 43 |
1 files changed, 0 insertions, 43 deletions
diff --git a/src/main/java/com/wipro/www/sonhms/dao/BufferedNotificationsRepository.java b/src/main/java/com/wipro/www/sonhms/dao/BufferedNotificationsRepository.java deleted file mode 100644 index bdbdb6e..0000000 --- a/src/main/java/com/wipro/www/sonhms/dao/BufferedNotificationsRepository.java +++ /dev/null @@ -1,43 +0,0 @@ -/******************************************************************************* - * ============LICENSE_START======================================================= - * pcims - * ================================================================================ - * Copyright (C) 2018 Wipro Limited. - * ============================================================================== - * Licensed under the Apache License, Version 2.0 (the "License"); - * you may not use this file except in compliance with the License. - * You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, software - * distributed under the License is distributed on an "AS IS" BASIS, - * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - * See the License for the specific language governing permissions and - * limitations under the License. - * ============LICENSE_END========================================================= - ******************************************************************************/ - -package com.wipro.www.sonhms.dao; - -import com.wipro.www.sonhms.entity.BufferedNotifications; - -import java.util.List; - -import org.springframework.data.jpa.repository.Query; -import org.springframework.data.repository.CrudRepository; -import org.springframework.stereotype.Repository; - - -@Repository -public interface BufferedNotificationsRepository extends CrudRepository<BufferedNotifications, String> { - - @Query(nativeQuery = true, value = "SELECT cluster_id FROM buffered_notifications WHERE notification=?1") - public String getClusterIdForNotification(String notification); - - @Query(nativeQuery = true, - value = "DELETE FROM buffered_notifications " + "WHERE notification = ( SELECT notification " - + "FROM buffered_notifications WHERE cluster_id=?1) RETURNING notification;") - public List<String> getNotificationsFromQueue(String clusterId); - -} |