Package gov.llnl.gnem.apps.coda.calibration.repository

Interface SiteFrequencyBandParametersRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<SiteFrequencyBandParameters,Long>, DetachableJpaRepository<SiteFrequencyBandParameters,Long>, org.springframework.data.jpa.repository.JpaRepository<SiteFrequencyBandParameters,Long>, org.springframework.data.repository.ListCrudRepository<SiteFrequencyBandParameters,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<SiteFrequencyBandParameters,Long>, org.springframework.data.repository.PagingAndSortingRepository<SiteFrequencyBandParameters,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<SiteFrequencyBandParameters>, org.springframework.data.repository.Repository<SiteFrequencyBandParameters,Long>

@Transactional
public interface SiteFrequencyBandParametersRepository
extends DetachableJpaRepository<SiteFrequencyBandParameters,Long>

Method Summary

Modifier and Type	Method	Description
List<SiteFrequencyBandParameters>	findByUniqueFields(String stationName, double lowFrequency, double highFrequency)
SiteFrequencyBandParameters	findByUniqueFields(String networkName, String stationName, double lowFrequency, double highFrequency)
List<String>	findDistinctStationNames()

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

Methods inherited from interface gov.llnl.gnem.apps.coda.common.repository.DetachableJpaRepository

findOneDetached

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

Methods inherited from interface org.springframework.data.repository.ListCrudRepository

findAll, findAllById, saveAll

Methods inherited from interface org.springframework.data.repository.ListPagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findBy, findOne

Method Details

findDistinctStationNames

@Query("select distinct sfb.station.stationName from SiteFrequencyBandParameters sfb")
List<String> findDistinctStationNames()

findByUniqueFields

@Query("select sfb from SiteFrequencyBandParameters sfb where sfb.station.stationName = :stationName and sfb.lowFrequency = :lowFrequency and sfb.highFrequency = :highFrequency and sfb.station.networkName in (\'UNK\', :networkName)")
SiteFrequencyBandParameters findByUniqueFields(@Param("networkName")
 String networkName,
 @Param("stationName")
 String stationName,
 @Param("lowFrequency")
 double lowFrequency,
 @Param("highFrequency")
 double highFrequency)

findByUniqueFields

@Query("select sfb from SiteFrequencyBandParameters sfb where sfb.station.stationName = :stationName and sfb.lowFrequency = :lowFrequency and sfb.highFrequency = :highFrequency")
List<SiteFrequencyBandParameters> findByUniqueFields(@Param("stationName")
 String stationName,
 @Param("lowFrequency")
 double lowFrequency,
 @Param("highFrequency")
 double highFrequency)