Changeset 76712b2 for trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaRegionRepository.java
- Timestamp:
- 01/28/22 18:45:54 (2 years ago)
- Branches:
- master
- Children:
- 6fe77af
- Parents:
- b738035
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaRegionRepository.java
rb738035 r76712b2 3 3 import finki.diplomska.tripplanner.models.Region; 4 4 import org.springframework.data.jpa.repository.JpaRepository; 5 import org.springframework.data.jpa.repository.Query; 5 6 import org.springframework.stereotype.Repository; 7 8 import java.util.List; 6 9 7 10 @Repository 8 11 public interface JpaRegionRepository extends JpaRepository<Region, Long> { 12 13 @Query(value="SELECT r.region_name " + 14 "FROM regions AS r " + 15 "UNION all " + 16 "SELECT c.city_name FROM cities AS c", nativeQuery = true) 17 List<String> getAllCitiesAndRegions(); 9 18 }
Note:
See TracChangeset
for help on using the changeset viewer.