X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=sdnc-a1-controller%2Foam%2Fconfigbackuprestore%2Fvnfconfigbackupservice%2Fsrc%2Fmain%2Fjava%2Fcom%2Fonap%2Fsdnc%2Fvnfbackupservice%2Fdao%2FVnfBackupServiceRepo.java;fp=sdnc-a1-controller%2Foam%2Fconfigbackuprestore%2Fvnfconfigbackupservice%2Fsrc%2Fmain%2Fjava%2Fcom%2Fonap%2Fsdnc%2Fvnfbackupservice%2Fdao%2FVnfBackupServiceRepo.java;h=0000000000000000000000000000000000000000;hb=6a24cde9bbcc101fca02204ca6f1c69ada049790;hp=7a1323381ed873839ebf148bd5dc1e1e2e53266d;hpb=22ca33237c833c90e3626bf1132e72282e207ea5;p=nonrtric.git

diff --git a/sdnc-a1-controller/oam/configbackuprestore/vnfconfigbackupservice/src/main/java/com/onap/sdnc/vnfbackupservice/dao/VnfBackupServiceRepo.java b/sdnc-a1-controller/oam/configbackuprestore/vnfconfigbackupservice/src/main/java/com/onap/sdnc/vnfbackupservice/dao/VnfBackupServiceRepo.java
deleted file mode 100644
index 7a132338..00000000
--- a/sdnc-a1-controller/oam/configbackuprestore/vnfconfigbackupservice/src/main/java/com/onap/sdnc/vnfbackupservice/dao/VnfBackupServiceRepo.java
+++ /dev/null
@@ -1,68 +0,0 @@
-/*
-* ============LICENSE_START=======================================================
-* ONAP : SDNC-FEATURES
-* ================================================================================
-* Copyright 2018 TechMahindra
-*=================================================================================
-* 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.onap.sdnc.vnfbackupservice.dao;
-
-import java.sql.Timestamp;
-import java.util.List;
-
-import javax.transaction.Transactional;
-
-import org.springframework.data.jpa.repository.JpaRepository;
-import org.springframework.data.jpa.repository.Modifying;
-import org.springframework.data.jpa.repository.Query;
-import org.springframework.data.repository.query.Param;
-import org.springframework.stereotype.Repository;
-
-
-import com.onap.sdnc.vnfbackupservice.model.VnfConfigDetailsDB;
-
-@Repository
-public interface VnfBackupServiceRepo extends JpaRepository<VnfConfigDetailsDB, Long> {
-
-	@Query(value = "Select * from vnfconfigdetails where vnfid = :vnfid", nativeQuery = true)
-	List<VnfConfigDetailsDB> getVnfDetails(@Param("vnfid") String vnfid);
-	
-	@Query(value = "Select * from vnfconfigdetails where vnfid = :vnfid ORDER BY vnfversion DESC LIMIT 1", nativeQuery = true)
-	VnfConfigDetailsDB getVnfDetail(@Param("vnfid") String vnfid);
-
-	@Modifying
-	@Query(value = "insert into vnfconfigdetails (configinfo,creationdate,lastupdated,status,vnfid,vnfname,vnfversion) VALUES (:configinfo,:creationdate,:lastupdated,:status,:vnfid,:vnfname,:vnfversion)", nativeQuery = true)
-	@Transactional
-	void saveVnfDetails(@Param("configinfo") String configinfo, @Param("creationdate") Timestamp creationDate,
-			@Param("lastupdated") Timestamp lastupdated, @Param("status") int status, @Param("vnfid") String vnfid,
-			@Param("vnfname") String vnfname,@Param("vnfversion") String vnfversion);
-
-	@Query(value = "Select configinfo && vnfversion from vnfconfigdetails where vnfid = :vnfid", nativeQuery = true)
-	List<VnfConfigDetailsDB> getVnfDetailhavingAllVersion(@Param("vnfid") String vnfid);
-
-	@Query(value = "Select backuptime from vnfschedulertime where id=1", nativeQuery = true)
-	String getvnfschedulertime();
-
-	@Modifying
-	@Query(value = "insert into vnfschedulertime(id, backuptime) VALUES (:id, :backuptime)", nativeQuery = true)
-	@Transactional
-	void insertSchedulerTime(@Param("id") int id, @Param("backuptime") String backuptime);
-
-	@Modifying
-	@Query(value = "UPDATE vnfschedulertime SET backuptime =:formatDateTime WHERE id = 1", nativeQuery = true)
-	@Transactional
-	void updateSchedulerTime(@Param("formatDateTime") String formatDateTime);
-	
-}