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

Timestamp:

01/24/22 21:08:32 (2 years ago)

Author:

Ema <ema_spirova@…>

Branches:

master

Children:

76712b2

Parents:

bdd6491

Message:

signup/login server errors on front and remove location from planner

Location:

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

Files:

• JpaLocationRepository.java (modified) (1 diff)
• JpaPlannerRepository.java (modified) (1 diff)
• JpaUserRepository.java (modified) (2 diffs)

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

@@ -109 +109 @@
     List<Location> getVillages();
 
+    @Query(value = "SELECT * FROM locations AS l WHERE l.id_city = :cityId", nativeQuery = true)
+    List<Location> getLocationsForCity(@Param("cityId") Long cityId);
 }

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

@@ -16 +16 @@
         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);
+        @Query(value = "DELETE planners_contain " +
+                "FROM planners_contain " +
+                "JOIN planners ON planners_contain.id_planner = planners.id_planner " +
+                "JOIN locations ON planners_contain.id_location = locations.id_location " +
+                "WHERE planners_contain.id_planner = :plannerId AND planners_contain.id_location = :locationId", nativeQuery = true)
+        void deleteLocationFromPlanner(@Param("plannerId") Long plannerId, @Param("locationId") Long locationId);
 }

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

@@ -2 +2 @@
 
 import finki.diplomska.tripplanner.models.User;
+import org.springframework.data.jpa.repository.Query;
 import org.springframework.data.repository.CrudRepository;
+import org.springframework.data.repository.query.Param;
 import org.springframework.stereotype.Repository;
+
+import java.util.List;
+import java.util.Optional;
 
 @Repository
@@ -9 +14 @@
     User findByUsername(String username);
     User getById(Long id);
+
+    @Query(value = "SELECT u.username FROM users AS u", nativeQuery = true)
+    List<String> getAllUsernames();
+
+    @Query(value = "SELECT u.password FROM users AS u WHERE u.username LIKE :username ", nativeQuery = true)
+    Optional<String> getPassword(@Param("username") String username);
+
 }