001package ca.uhn.fhir.jpa.dao.data;
002
003/*
004 * #%L
005 * HAPI FHIR JPA Server
006 * %%
007 * Copyright (C) 2014 - 2022 Smile CDR, Inc.
008 * %%
009 * Licensed under the Apache License, Version 2.0 (the "License");
010 * you may not use this file except in compliance with the License.
011 * You may obtain a copy of the License at
012 *
013 *      http://www.apache.org/licenses/LICENSE-2.0
014 *
015 * Unless required by applicable law or agreed to in writing, software
016 * distributed under the License is distributed on an "AS IS" BASIS,
017 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
018 * See the License for the specific language governing permissions and
019 * limitations under the License.
020 * #L%
021 */
022
023import ca.uhn.fhir.jpa.entity.TermValueSet;
024import ca.uhn.fhir.jpa.entity.TermValueSetPreExpansionStatusEnum;
025import org.springframework.data.domain.Pageable;
026import org.springframework.data.domain.Slice;
027import org.springframework.data.jpa.repository.JpaRepository;
028import org.springframework.data.jpa.repository.Query;
029import org.springframework.data.repository.query.Param;
030
031import java.util.List;
032import java.util.Optional;
033
034public interface ITermValueSetDao extends JpaRepository<TermValueSet, Long>, IHapiFhirJpaRepository {
035
036        @Query("SELECT vs FROM TermValueSet vs WHERE vs.myResourcePid = :resource_pid")
037        Optional<TermValueSet> findByResourcePid(@Param("resource_pid") Long theResourcePid);
038
039        // Keeping for backwards compatibility but recommend using findTermValueSetByUrlAndNullVersion instead.
040        @Deprecated
041        @Query("SELECT vs FROM TermValueSet vs WHERE vs.myUrl = :url")
042        Optional<TermValueSet> findByUrl(@Param("url") String theUrl);
043
044        @Query("SELECT vs FROM TermValueSet vs WHERE vs.myExpansionStatus = :expansion_status")
045        Slice<TermValueSet> findByExpansionStatus(Pageable pageable, @Param("expansion_status") TermValueSetPreExpansionStatusEnum theExpansionStatus);
046
047        @Query(value="SELECT vs FROM TermValueSet vs INNER JOIN ResourceTable r ON r.myId = vs.myResourcePid WHERE vs.myUrl = :url ORDER BY r.myUpdated DESC")
048        List<TermValueSet> findTermValueSetByUrl(Pageable thePage, @Param("url") String theUrl);
049
050        /**
051         * The current TermValueSet is not necessarily the last uploaded anymore, but the current VS resource
052         * is pointed by a specific ForcedId, so we locate current ValueSet as the one pointing to current VS resource
053         */
054        @Query(value="SELECT vs FROM ForcedId f, TermValueSet vs where f.myForcedId = :forcedId and vs.myResource = f.myResource")
055        Optional<TermValueSet> findTermValueSetByForcedId(@Param("forcedId") String theForcedId);
056
057        @Query("SELECT vs FROM TermValueSet vs WHERE vs.myUrl = :url AND vs.myVersion IS NULL")
058        Optional<TermValueSet> findTermValueSetByUrlAndNullVersion(@Param("url") String theUrl);
059
060        @Query("SELECT vs FROM TermValueSet vs WHERE vs.myUrl = :url AND vs.myVersion = :version")
061        Optional<TermValueSet> findTermValueSetByUrlAndVersion(@Param("url") String theUrl, @Param("version") String theVersion);
062
063
064}