1 package com.onap.sdnc.vnfcomparsion.dao;
3 import java.io.Serializable;
4 import java.util.Collection;
7 import org.springframework.data.jpa.repository.JpaRepository;
8 import org.springframework.data.jpa.repository.Query;
9 import org.springframework.data.repository.query.Param;
10 import org.springframework.stereotype.Repository;
12 import com.onap.sdnc.vnfconfigcomparsion.model.VnfConfigDetailsDB;
16 public interface VnfComparisonRepository extends JpaRepository<VnfConfigDetailsDB, Serializable>{
19 @Query(value = "Select * from vnfconfigdetails where vnfid = :vnfid", nativeQuery = true)
20 List<VnfConfigDetailsDB> getVnfDetailsByVnfID(@Param("vnfid") String vnfid);
22 @Query(value = "Select * from vnfconfigdetails where vnfversion = :vnfversion and vnfid = :vnfid", nativeQuery = true)
23 VnfConfigDetailsDB getVnfDetails(@Param("vnfversion") String vnfversion, @Param("vnfid") String vnfid);
25 public static final String FIND_VNFID = "SELECT * FROM vnfconfigdetails group by vnfid";
27 @Query(value= FIND_VNFID,nativeQuery = true)
28 List<VnfConfigDetailsDB> findvnfidvnfname();