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

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

Location:

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

Files:

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

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 );
 }

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

@@ -7 +7 @@
 @Repository
 public interface JpaUserRepository extends CrudRepository<User, Long> {
+    User findByUsername(String username);
+    User getById(Long id);
 }