Interface ITermCodeSystemVersionDao

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

public interface ITermCodeSystemVersionDao extends org.springframework.data.jpa.repository.JpaRepository<TermCodeSystemVersion,Long>, IHapiFhirJpaRepository
  • Method Details

    • deleteForCodeSystem

      @Modifying @Query("DELETE FROM TermCodeSystemVersion csv WHERE csv.myCodeSystem = :cs") void deleteForCodeSystem(@Param("cs") TermCodeSystem theCodeSystem)
    • findSortedPidsByCodeSystemPid

      @Query("SELECT myId FROM TermCodeSystemVersion WHERE myCodeSystemPid = :codesystem_pid order by myId") List<Long> findSortedPidsByCodeSystemPid(@Param("codesystem_pid") Long theCodeSystemPid)
    • findByCodeSystemPidAndVersion

      @Query("SELECT cs FROM TermCodeSystemVersion cs WHERE cs.myCodeSystemPid = :codesystem_pid AND cs.myCodeSystemVersionId = :codesystem_version_id") TermCodeSystemVersion findByCodeSystemPidAndVersion(@Param("codesystem_pid") Long theCodeSystemPid, @Param("codesystem_version_id") String theCodeSystemVersionId)
    • findByCodeSystemUriAndVersion

      @Query("SELECT tcsv FROM TermCodeSystemVersion tcsv INNER JOIN FETCH TermCodeSystem tcs on tcs.myPid = tcsv.myCodeSystemPid WHERE tcs.myCodeSystemUri = :code_system_uri AND tcsv.myCodeSystemVersionId = :codesystem_version_id") TermCodeSystemVersion findByCodeSystemUriAndVersion(@Param("code_system_uri") String theCodeSystemUri, @Param("codesystem_version_id") String theCodeSystemVersionId)
    • findByCodeSystemPidVersionIsNull

      @Query("SELECT cs FROM TermCodeSystemVersion cs WHERE cs.myCodeSystemPid = :codesystem_pid AND cs.myCodeSystemVersionId IS NULL") TermCodeSystemVersion findByCodeSystemPidVersionIsNull(@Param("codesystem_pid") Long theCodeSystemPid)
    • findByCodeSystemResourcePid

      @Query("SELECT cs FROM TermCodeSystemVersion cs WHERE cs.myResourcePid = :resource_id") List<TermCodeSystemVersion> findByCodeSystemResourcePid(@Param("resource_id") Long theCodeSystemResourcePid)
    • findCurrentVersionForCodeSystemResourcePid

      @Query("SELECT cs FROM TermCodeSystemVersion cs WHERE cs.myCodeSystemHavingThisVersionAsCurrentVersionIfAny.myResource.myId = :resource_id") TermCodeSystemVersion findCurrentVersionForCodeSystemResourcePid(@Param("resource_id") Long theCodeSystemResourcePid)