source: src/main/java/com/example/skychasemk/repository/ReviewRepository.java

Last change on this file was 3a74959, checked in by ste08 <sjovanoska@…>, 3 months ago

Review page added

  • Property mode set to 100644
File size: 673 bytes
Line 
1package com.example.skychasemk.repository;
2
3import com.example.skychasemk.model.Notification;
4import com.example.skychasemk.model.Review;
5import org.springframework.data.jpa.repository.JpaRepository;
6import org.springframework.data.jpa.repository.Query;
7import org.springframework.data.repository.query.Param;
8
9import java.util.List;
10
11public interface ReviewRepository extends JpaRepository<Review, Integer> {
12 @Query("SELECT r from Review r where r.targetID = :flightId")
13 List<Review> findReviews(@Param("flightId") Integer flightId);
14
15 @Query("SELECT r FROM Review r WHERE r.userID = :userId")
16 List<Review> findByUserId(@Param("userId") Integer userId);
17}
18
Note: See TracBrowser for help on using the repository browser.