Package ca.uhn.fhir.jpa.dao.data

Interface ITermValueSetConceptDao

All Superinterfaces:

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

public interface ITermValueSetConceptDao
extends org.springframework.data.jpa.repository.JpaRepository<TermValueSetConcept,Long>, IHapiFhirJpaRepository

Method Summary

Modifier and Type	Method	Description
Integer	countByTermValueSetId(Long theValueSetId)
void	deleteByTermValueSetId(Long theValueSetId)
Optional<TermValueSetConcept>	findByTermValueSetIdSystemAndCode(Long theValueSetId, String theSystem, String theCode)
Optional<TermValueSetConcept>	findByTermValueSetIdSystemAndCodeWithVersion(Long theValueSetId, String theSystem, String theSystemVersion, String theCode)
List<TermValueSetConcept>	findByTermValueSetIdSystemOnly(org.springframework.data.domain.Pageable thePage, Long theValueSetId, String theSystem)
List<TermValueSetConcept>	findByValueSetResourcePidAndCode(Long theValueSetId, String theCode)
Optional<TermValueSetConcept>	findByValueSetResourcePidSystemAndCode(Long theValueSetId, String theSystem, String theCode)
Optional<TermValueSetConcept>	findByValueSetResourcePidSystemAndCodeWithVersion(Long theValueSetId, String theSystem, String theSystemVersion, String theCode)
List<Long>	findIdsByTermValueSetId(Long theValueSetId)
void	updateOrderById(Long theId, int theOrder)

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

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

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

countByTermValueSetId

@Query("SELECT COUNT(*) FROM TermValueSetConcept vsc WHERE vsc.myValueSetPid = :pid")
Integer countByTermValueSetId(@Param("pid")
 Long theValueSetId)

deleteByTermValueSetId

@Query("DELETE FROM TermValueSetConcept vsc WHERE vsc.myValueSetPid = :pid")
@Modifying
void deleteByTermValueSetId(@Param("pid")
 Long theValueSetId)

findByTermValueSetIdSystemOnly

@Query("SELECT vsc FROM TermValueSetConcept vsc WHERE vsc.myValueSetPid = :pid AND vsc.mySystem = :system_url")
List<TermValueSetConcept> findByTermValueSetIdSystemOnly(org.springframework.data.domain.Pageable thePage,
 @Param("pid")
 Long theValueSetId,
 @Param("system_url")
 String theSystem)

findByTermValueSetIdSystemAndCode

@Query("SELECT vsc FROM TermValueSetConcept vsc WHERE vsc.myValueSetPid = :pid AND vsc.mySystem = :system_url AND vsc.myCode = :codeval")
Optional<TermValueSetConcept> findByTermValueSetIdSystemAndCode(@Param("pid")
 Long theValueSetId,
 @Param("system_url")
 String theSystem,
 @Param("codeval")
 String theCode)

findByTermValueSetIdSystemAndCodeWithVersion

@Query("SELECT vsc FROM TermValueSetConcept vsc WHERE vsc.myValueSetPid = :pid AND vsc.mySystem = :system_url AND vsc.mySystemVer = :system_version AND vsc.myCode = :codeval")
Optional<TermValueSetConcept> findByTermValueSetIdSystemAndCodeWithVersion(@Param("pid")
 Long theValueSetId,
 @Param("system_url")
 String theSystem,
 @Param("system_version")
 String theSystemVersion,
 @Param("codeval")
 String theCode)

findByValueSetResourcePidAndCode

@Query("SELECT vsc FROM TermValueSetConcept vsc WHERE vsc.myValueSet.myResourcePid = :resource_pid AND vsc.myCode = :codeval")
List<TermValueSetConcept> findByValueSetResourcePidAndCode(@Param("resource_pid")
 Long theValueSetId,
 @Param("codeval")
 String theCode)

findByValueSetResourcePidSystemAndCode

@Query("SELECT vsc FROM TermValueSetConcept vsc WHERE vsc.myValueSet.myResourcePid = :resource_pid AND vsc.mySystem = :system_url AND vsc.myCode = :codeval")
Optional<TermValueSetConcept> findByValueSetResourcePidSystemAndCode(@Param("resource_pid")
 Long theValueSetId,
 @Param("system_url")
 String theSystem,
 @Param("codeval")
 String theCode)

findByValueSetResourcePidSystemAndCodeWithVersion

@Query("SELECT vsc FROM TermValueSetConcept vsc WHERE vsc.myValueSet.myResourcePid = :resource_pid AND vsc.mySystem = :system_url AND vsc.mySystemVer = :system_version AND vsc.myCode = :codeval")
Optional<TermValueSetConcept> findByValueSetResourcePidSystemAndCodeWithVersion(@Param("resource_pid")
 Long theValueSetId,
 @Param("system_url")
 String theSystem,
 @Param("system_version")
 String theSystemVersion,
 @Param("codeval")
 String theCode)

findIdsByTermValueSetId

@Query("SELECT vsc.myId FROM TermValueSetConcept vsc WHERE vsc.myValueSetPid = :pid ORDER BY vsc.myId")
List<Long> findIdsByTermValueSetId(@Param("pid")
 Long theValueSetId)

updateOrderById

@Query("UPDATE TermValueSetConcept vsc SET vsc.myOrder = :order WHERE vsc.myId = :pid")
@Modifying
void updateOrderById(@Param("pid")
 Long theId,
 @Param("order")
 int theOrder)