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

Interface SyntheticRepository

All Superinterfaces:

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

@Transactional
public interface SyntheticRepository
extends DetachableJpaRepository<SyntheticCoda,Long>

Method Summary

Modifier and Type	Method	Description
void	deleteBySharedFrequencyBandParametersId(Long id)
void	deleteInBatchBySharedFrequencyBandParametersIds(Collection<Long> ids)
SyntheticCoda	findByWaveformId(Long id)
Collection<SyntheticCoda>	findByWaveformIds(Collection<Long> ids)
List<SyntheticCoda>	findMatchingSelection(String eventId, String stationName, Double lowFreq, Double highFreq)

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

findByWaveformId

@Query("select synth from SyntheticCoda synth where synth.sourceWaveform.id = :id")
SyntheticCoda findByWaveformId(@Param("id")
 Long id)

findByWaveformIds

@Query("select synth from SyntheticCoda synth where synth.sourceWaveform.id in :ids")
Collection<SyntheticCoda> findByWaveformIds(@Param("ids")
 Collection<Long> ids)

deleteBySharedFrequencyBandParametersId

@Modifying
@Query("delete from SyntheticCoda synth where synth.sourceModel.id = :id")
void deleteBySharedFrequencyBandParametersId(@Param("id")
 Long id)

deleteInBatchBySharedFrequencyBandParametersIds

@Modifying
@Query("delete from SyntheticCoda synth where synth.sourceModel.id in :ids")
void deleteInBatchBySharedFrequencyBandParametersIds(@Param("ids")
 Collection<Long> ids)

findMatchingSelection

@Query("select synth from SyntheticCoda synth where (:eventId is null or synth.sourceWaveform.event.eventId = :eventId) and (:stationName is null or synth.sourceWaveform.stream.station.stationName = :stationName) and (:lowFreq is null or synth.sourceWaveform.lowFrequency = :lowFreq) and (:highFreq is null or synth.sourceWaveform.highFrequency = :highFreq)")
List<SyntheticCoda> findMatchingSelection(@Param("eventId")
 String eventId,
 @Param("stationName")
 String stationName,
 @Param("lowFreq")
 Double lowFreq,
 @Param("highFreq")
 Double highFreq)