Changeset 84d0fbb for trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaPlannerRepository.java

Timestamp:

12/19/21 19:39:00 (3 years ago)

Author:

Ema <ema_spirova@…>

Branches:

master

Children:

bdd6491

Parents:

1ad8e64

Message:

spring security 2.0

File:

• trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaPlannerRepository.java (modified) (2 diffs)

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

@@ -4 +4 @@
 import finki.diplomska.tripplanner.models.Planner;
 import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.query.Param;
 import org.springframework.stereotype.Repository;
 
@@ -11 +13 @@
 public interface JpaPlannerRepository extends JpaRepository<Planner, Long> {
 
-
+        @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 );
 }