Changeset 07fe0be for src/main/java/com/example/skychasemk/repository

Timestamp:

02/24/25 22:49:01 (4 months ago)

Author:

ste08 <sjovanoska@…>

Branches:

master

Children:

c064a42

Parents:

fda671c

Message:

Wishlist fully working, can book and pay for the booking.

Location:

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

Files:

• FlightRepository.java (modified) (1 diff)
• WishlistRepository.java (modified) (2 diffs)

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

@@ -19 +19 @@
 
 
+    @Query(value="SELECT * FROM flight  WHERE flightId=:flightId",nativeQuery = true)
+    List<Flight> getFlightByFlightId(Long flightId);
 }

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

@@ -14 +14 @@
 
 import java.util.List;
+import java.util.Optional;
 
 @Repository
@@ -29 +30 @@
     void deleteByUserIdAndTargetId(@Param("userId") Integer userId, @Param("targetId") Integer targetId);
 
+    @Query("SELECT w.targetId FROM Wishlist w WHERE w.wishlistID = :wishlistId")
+    Optional<Wishlist> getFlightFromWishlist(@Param("wishlistId") Long wishlistId);
 }