Interface SpectraRatioPairDetailsRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<SpectraRatioPairDetails,Long>, DetachableJpaRepository<SpectraRatioPairDetails,Long>, org.springframework.data.jpa.repository.JpaRepository<SpectraRatioPairDetails,Long>, org.springframework.data.repository.ListCrudRepository<SpectraRatioPairDetails,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<SpectraRatioPairDetails,Long>, org.springframework.data.repository.PagingAndSortingRepository<SpectraRatioPairDetails,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<SpectraRatioPairDetails>, org.springframework.data.repository.Repository<SpectraRatioPairDetails,Long>

@Transactional public interface SpectraRatioPairDetailsRepository extends DetachableJpaRepository<SpectraRatioPairDetails,Long>
  • Method Summary

    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

    • findByUserEditedTrue

      List<SpectraRatioPairDetails> findByUserEditedTrue()
    • deleteAllNotInIdsList

      @Modifying @Query("delete from SpectraRatioPairDetails ratio where ratio.id NOT IN :ids") void deleteAllNotInIdsList(@Param("ids") List<Long> ids)
    • findAllMetdataOnly

      @Query("select ratio from SpectraRatioPairDetails ratio") List<SpectraRatioPairDetailsMetadata> findAllMetdataOnly()
    • findByWaveformIds

      @Query("select ratio from SpectraRatioPairDetails ratio where ratio.numerWaveform.id = :numerId and ratio.denomWaveform.id = :denomId") SpectraRatioPairDetails findByWaveformIds(@Param("numerId") Long numerId, @Param("denomId") Long denomId)