Changeset 5867520 for src/main/java/com/example/moviezone/repository

Timestamp:

02/08/23 15:48:51 (22 months ago)

Author:

DenicaKj <dkorvezir@…>

Branches:

master

Children:

2c7a732

Parents:

90317ea

Message:

Projections

Location:

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

Files:

• ProjectionIsPlayedInRoomRepository.java (modified) (1 diff)
• ProjectionRepository.java (modified) (1 diff)

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

@@ -10 +10 @@
 
 public interface ProjectionIsPlayedInRoomRepository extends JpaRepository<ProjectionIsPlayedInRoom, ProjectionIsPlayedInRoomId> {
-    @Query("SELECT pir FROM ProjectionIsPlayedInRoom pir WHERE pir.id_projection = :id_projection")
+    @Query("SELECT pir FROM ProjectionIsPlayedInRoom pir WHERE pir.idprojection = :id_projection")
     List<ProjectionIsPlayedInRoom> findAllByProjectionId(@Param("id_projection") Integer id_projection);
 }

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

@@ -3 +3 @@
 import com.example.moviezone.model.Projection;
 import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.query.Procedure;
 
+import javax.transaction.Transactional;
 import java.time.LocalDate;
 import java.util.List;
-
+@Transactional
 public interface ProjectionRepository extends JpaRepository<Projection,Integer> {
-    //    NOTE: CHANGE THIS WITH MATERIALIZED VIEW
-    //List<Projection> findAllBydate_time_startBefore(LocalDate datum);
+    @Procedure("project.getProjectionsForFilms")
+    List<Projection> getProjectionsForFilms(int id);
 }