![](/hapi-fhir/images/logos/raccoon-forwards.png)
001/* 002 * #%L 003 * HAPI FHIR JPA Server 004 * %% 005 * Copyright (C) 2014 - 2024 Smile CDR, Inc. 006 * %% 007 * Licensed under the Apache License, Version 2.0 (the "License"); 008 * you may not use this file except in compliance with the License. 009 * You may obtain a copy of the License at 010 * 011 * http://www.apache.org/licenses/LICENSE-2.0 012 * 013 * Unless required by applicable law or agreed to in writing, software 014 * distributed under the License is distributed on an "AS IS" BASIS, 015 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 016 * See the License for the specific language governing permissions and 017 * limitations under the License. 018 * #L% 019 */ 020package ca.uhn.fhir.jpa.dao.data; 021 022import ca.uhn.fhir.jpa.entity.SearchResult; 023import com.google.errorprone.annotations.CanIgnoreReturnValue; 024import org.springframework.data.domain.Pageable; 025import org.springframework.data.domain.Slice; 026import org.springframework.data.jpa.repository.JpaRepository; 027import org.springframework.data.jpa.repository.Modifying; 028import org.springframework.data.jpa.repository.Query; 029import org.springframework.data.repository.query.Param; 030 031import java.util.Collection; 032import java.util.List; 033 034public interface ISearchResultDao extends JpaRepository<SearchResult, Long>, IHapiFhirJpaRepository { 035 036 @Query(value = "SELECT r.myResourcePid FROM SearchResult r WHERE r.mySearchPid = :search ORDER BY r.myOrder ASC") 037 Slice<Long> findWithSearchPid(@Param("search") Long theSearchPid, Pageable thePage); 038 039 @Query(value = "SELECT r.myResourcePid FROM SearchResult r WHERE r.mySearchPid = :search") 040 List<Long> findWithSearchPidOrderIndependent(@Param("search") Long theSearchPid); 041 042 @Modifying 043 @Query("DELETE FROM SearchResult s WHERE s.mySearchPid IN :searchIds") 044 @CanIgnoreReturnValue 045 int deleteBySearchIds(@Param("searchIds") Collection<Long> theSearchIds); 046 047 @Modifying 048 @Query( 049 "DELETE FROM SearchResult s WHERE s.mySearchPid = :searchId and s.myOrder >= :rangeStart and s.myOrder <= :rangeEnd") 050 @CanIgnoreReturnValue 051 int deleteBySearchIdInRange( 052 @Param("searchId") Long theSearchId, 053 @Param("rangeStart") int theRangeStart, 054 @Param("rangeEnd") int theRangeEnd); 055 056 @Query("SELECT count(r) FROM SearchResult r WHERE r.mySearchPid = :search") 057 int countForSearch(@Param("search") Long theSearchPid); 058}