Changeset 3a74959 for src/main/java/com/example/skychasemk

Timestamp:

03/26/25 00:25:45 (2 months ago)

Author:

ste08 <sjovanoska@…>

Branches:

master

Children:

ff72ad2

Parents:

8a947b9

Message:

Review page added

Location:

src/main/java/com/example/skychasemk

Files:

• controller/ReviewController.java (modified) (2 diffs)
• model/Review.java (modified) (1 diff)
• repository/ReviewRepository.java (modified) (2 diffs)

src/main/java/com/example/skychasemk/controller/ReviewController.java

@@ -2 +2 @@
 
 import com.example.skychasemk.dto.ReviewDTO;
+import com.example.skychasemk.model.Notification;
 import com.example.skychasemk.model.Review;
 import com.example.skychasemk.repository.ReviewRepository;
@@ -27 +28 @@
     }
 
-
-    @GetMapping("/{flightId}")
-    public List<Review> getReviewsByFlightId(@PathVariable("flightId") Integer flightId) {
-        return reviewRepository.findReviews(flightId);
-    }
-
-    // Get review by ID
-    @GetMapping("/{id}")
-    public Optional<Review> getReviewById(@PathVariable("id") Integer reviewID) {
-        return reviewService.getReviewById(reviewID);
+    @GetMapping("/{userId}")
+    public ResponseEntity<List<Review>> getReviewsByFlightId(@PathVariable Integer userId) {
+        List<Review> reviews = reviewRepository.findByUserId(userId);
+        return ResponseEntity.ok(reviews);
     }
 

src/main/java/com/example/skychasemk/model/Review.java

@@ -5 +5 @@
 
 @Entity
-@Table(name="Review")
+@Table(name="review")
 public class Review {
 
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    @Column(name = "reviewId")
+    @Column(name = "reviewid")
 
     private Integer reviewID;
-    @Column(name = "userId")
+    @Column(name = "userid")
 
     private Integer userID;
-    @Column(name = "targetId")
+    @Column(name = "targetid")
 
     private Integer targetID;

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

@@ -1 +1 @@
 package com.example.skychasemk.repository;
 
+import com.example.skychasemk.model.Notification;
 import com.example.skychasemk.model.Review;
 import org.springframework.data.jpa.repository.JpaRepository;
@@ -11 +12 @@
     @Query("SELECT r from Review r where r.targetID = :flightId")
     List<Review> findReviews(@Param("flightId") Integer flightId);
+
+    @Query("SELECT r FROM Review r WHERE r.userID = :userId")
+    List<Review> findByUserId(@Param("userId") Integer userId);
 }