blob: 9e7f9b7f00bce85c25d4abfe736a9dbc4f0db084 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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);
}
|