Changeset 00fa72f for src/main/java/com/example/moviezone/repository

Timestamp:

02/09/23 14:06:45 (23 months ago)

Author:

DenicaKj <dkorvezir@…>

Branches:

master

Children:

6a9006d, a9ffccd

Parents:

0ba5d1a

Message:

Reservation Implemented

Location:

src/main/java/com/example/moviezone/repository

Files:

• CategoryRepository.java (modified) (1 diff)
• Projection_RoomRepository.java (modified) (1 diff)
• SeatRepository.java (modified) (2 diffs)
• TicketRepository.java (modified) (2 diffs)

src/main/java/com/example/moviezone/repository/CategoryRepository.java

@@ -5 +5 @@
 import org.springframework.stereotype.Repository;
 
+import java.util.Optional;
+
 @Repository
 public interface CategoryRepository extends JpaRepository<Category,Integer>{
+    Optional<Category> getByIdcategory(int id);
 }

src/main/java/com/example/moviezone/repository/Projection_RoomRepository.java

@@ -4 +4 @@
 import com.example.moviezone.model.Projection_Room;
 import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.query.Procedure;
+
+import java.util.List;
 
 public interface Projection_RoomRepository extends JpaRepository<Projection_Room,Integer> {
+    @Procedure("project.getRoomsForProjection")
+    List<Projection_Room> getRoomsForProjection(int id);
 }

src/main/java/com/example/moviezone/repository/SeatRepository.java

@@ -1 +1 @@
 package com.example.moviezone.repository;
 
+import com.example.moviezone.model.Category;
+import com.example.moviezone.model.Projection;
 import com.example.moviezone.model.Projection_Room;
 import com.example.moviezone.model.Seat;
@@ -11 +13 @@
 public interface SeatRepository extends JpaRepository<Seat,Integer> {
     List<Seat> findAllByProjection(Projection_Room projection);
+    List<Seat> findAllByCategoryAndProjection(Category category, Projection_Room projectionRoom);
 }

src/main/java/com/example/moviezone/repository/TicketRepository.java

@@ -4 +4 @@
 import com.example.moviezone.model.Ticket;
 import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.query.Procedure;
 import org.springframework.stereotype.Repository;
 
@@ -10 +11 @@
 public interface TicketRepository extends JpaRepository<Ticket,Integer> {
     List<Ticket> findAllByCustomer(Customer customer);
+    @Procedure("project.getPriceForTicket")
+    Integer getPriceForTicket(int id);
 }