Changeset 8d391a1 for trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaLocationRepository.java

Timestamp:

11/26/21 20:07:18 (3 years ago)

Author:

Ema <ema_spirova@…>

Branches:

master

Children:

1ad8e64

Parents:

e29cc2e

Message:

disabling to add location if it already exists in the planner

File:

• trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaLocationRepository.java (modified) (1 diff)

trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaLocationRepository.java

@@ -84 +84 @@
     List<Location> getAllLocationsForPlanner(@Param("plannerId") Long plannerId);
 
+
+    @Query(value = "SELECT l.id_location " +
+            "FROM locations AS l " +
+            "WHERE l.id_location IN " +
+            "(SELECT pl.id_location FROM planners_contain AS pl WHERE pl.id_planner = :plannerId)", nativeQuery = true)
+    List<Long> getAllLocationIdsForPlanner(@Param("plannerId") Long plannerId);
+
     @Query(value = "SELECT *, if(l.id_city is NOT NULL, c.city_name, l.location_name) as result " +
             "FROM locations AS l " +