1   
2   
3   
4   
5   
6   package org.tailormap.api.repository;
7   
8   import java.util.List;
9   import java.util.Optional;
10  import org.springframework.data.jpa.repository.JpaRepository;
11  import org.springframework.data.jpa.repository.Query;
12  import org.springframework.data.repository.history.RevisionRepository;
13  import org.springframework.data.repository.query.Param;
14  import org.springframework.data.rest.core.annotation.RepositoryRestResource;
15  import org.springframework.lang.NonNull;
16  import org.springframework.security.access.prepost.PreAuthorize;
17  import org.tailormap.api.persistence.GeoService;
18  import org.tailormap.api.security.annotation.PreAuthorizeAdmin;
19  
20  @PreAuthorizeAdmin
21  @RepositoryRestResource(path = "geo-services", collectionResourceRel = "geo-services", itemResourceRel = "geo-service")
22  public interface GeoServiceRepository
23      extends JpaRepository<GeoService, String>, RevisionRepository<GeoService, String, Long> {
24    @Override
25    @NonNull @PreAuthorize("permitAll()")
26    Optional<GeoService> findById(@NonNull String id);
27  
28    
29  
30  
31  
32  
33  
34  
35    @NonNull @PreAuthorize("permitAll()")
36    @Query("from GeoService s where id in :ids")
37    List<GeoService> findByIds(@Param("ids") List<String> ids);
38  
39    
40  
41  
42  
43  
44  
45  
46  
47  
48    @NonNull @PreAuthorize("permitAll()")
49    @Query("from GeoService s where id not in :ids")
50    List<GeoService> getAllExcludingIds(@Param("ids") List<String> ids);
51  }