X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=portal-BE%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Fportal%2Fservice%2FsharedContext%2FFnSharedContextDao.java;fp=portal-BE%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Fportal%2Fservice%2FsharedContext%2FFnSharedContextDao.java;h=df251027e21c66c55bba785f5a5b4c644cb04058;hb=f7e300301a4a5f01585677657b96a80338cdf03d;hp=8faac5b61d4f80f6660fc819e67cb55d0857010a;hpb=cbc896f277fcf24dc52fcd591667e4ede1e9a9ab;p=portal.git

diff --git a/portal-BE/src/main/java/org/onap/portal/service/sharedContext/FnSharedContextDao.java b/portal-BE/src/main/java/org/onap/portal/service/sharedContext/FnSharedContextDao.java
index 8faac5b6..df251027 100644
--- a/portal-BE/src/main/java/org/onap/portal/service/sharedContext/FnSharedContextDao.java
+++ b/portal-BE/src/main/java/org/onap/portal/service/sharedContext/FnSharedContextDao.java
@@ -40,8 +40,13 @@
 
 package org.onap.portal.service.sharedContext;
 
+import java.time.LocalDateTime;
+import java.util.List;
+import java.util.Optional;
 import org.onap.portal.domain.db.fn.FnSharedContext;
 import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.query.Param;
 import org.springframework.stereotype.Repository;
 import org.springframework.transaction.annotation.Transactional;
 
@@ -49,4 +54,11 @@ import org.springframework.transaction.annotation.Transactional;
 @Transactional
 interface FnSharedContextDao extends JpaRepository<FnSharedContext, Long> {
 
+    @Query
+    Optional<List<FnSharedContext>> getByContextId(@Param("contextId") final String contextId);
+    @Query
+    Optional<List<FnSharedContext>> getByContextIdAndCkey(@Param("contextId") final String contextId, @Param("ckey") final String ckey);
+    @Query
+    void deleteByCreated(@Param("created") final LocalDateTime created);
+
 }