Changeset bdd6491 for trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa

Timestamp:

12/28/21 08:56:55 (3 years ago)

Author:

Ema <ema_spirova@…>

Branches:

master

Children:

b738035

Parents:

84d0fbb

Message:

pre final presentation

Location:

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

Files:

• JpaLocationRepository.java (modified) (1 diff)
• JpaPlannerRepository.java (modified) (1 diff)

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

@@ -108 +108 @@
             "WHERE lb.id_category=4", nativeQuery = true)
     List<Location> getVillages();
+
 }

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

@@ -15 +15 @@
         @Query(value = "SELECT * FROM planners AS p left JOIN users AS u ON p.user_id = u.id WHERE u.username like :username", nativeQuery = true)
         List<Planner> getPlannersByUser(@Param("username") String username );
+
+        @Query(value = "delete from planners_contain WHERE planners_contain.id_location = :locationId", nativeQuery = true)
+        void deleteLocationFromPlanner(@Param("locationId") Long locationId);
 }