1 files changed, 31 insertions, 0 deletions
diff --git a/SDNCReports/sdnc_reports_dao/src/main/java/com/onap/sdnc/reports/repository/DeviceRepository.java b/SDNCReports/sdnc_reports_dao/src/main/java/com/onap/sdnc/reports/repository/DeviceRepository.java
new file mode 100644
index 0000000..9e7f9b7
--- /dev/null
+++ b/SDNCReports/sdnc_reports_dao/src/main/java/com/onap/sdnc/reports/repository/DeviceRepository.java
@@ -0,0 +1,31 @@
+
+package com.onap.sdnc.reports.repository;
+
+import java.util.Date;
+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.CrudRepository;
+import org.springframework.data.repository.query.Param;
+import org.springframework.stereotype.Repository;
+
+import com.onap.sdnc.reports.model.DeviceConfig;
+import com.onap.sdnc.reports.model.PreTestConfig;
+import com.onap.sdnc.reports.model.Report;
+
+@Repository
+public interface DeviceRepository extends JpaRepository<DeviceConfig, Long> {
+//public interface DeviceRepository extends CrudRepository<DeviceConfig, Long> {
+	//List<Report> findByLastName(String lastName);
+	@Query(value= "from DeviceConfig where deviceName = :deviceName" )
+	DeviceConfig findDeviceName(@Param("deviceName") String  deviceName);
+	
+	@Modifying
+    @Query(value = "insert into DeviceConfig (deviceName,createdOn) VALUES (:deviceName,:createdOn)", nativeQuery = true)
+    @Transactional
+    void logDeviceName(@Param("deviceName") String deviceName, @Param("createdOn") String  createdOn);
+}