Changeset 43a1688 for src/main/java/com

Timestamp:

02/06/23 15:13:02 (23 months ago)

Author:

DenicaKj <dkorvezir@…>

Branches:

master

Children:

f9cc555

Parents:

f8ef9bd

Message:

I CALLED A PROCEDURE FROM SPRING

Location:

src/main/java/com/example/moviezone

Files:

• repository/CustomerRatesFilmRepository.java (modified) (1 diff)
• service/CustomerRatesFilmService.java (added)
• service/Impl/CustomerRatesFilmImpl.java (added)
• web/HomeController.java (modified) (4 diffs)

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

@@ -4 +4 @@
 import com.example.moviezone.model.manytomany.CustomerRatesFilmId;
 import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.query.Procedure;
+import org.springframework.data.repository.query.Param;
 import org.springframework.stereotype.Repository;
 
 @Repository
 public interface CustomerRatesFilmRepository extends JpaRepository<CustomerRatesFilm, CustomerRatesFilmId> {
+@Procedure("project.avg_rating1")
+    double avg_rating(int id);
+
 }

src/main/java/com/example/moviezone/web/HomeController.java

@@ -15 +15 @@
 import java.time.LocalDate;
 import java.util.List;
-import java.util.Optional;
 import java.util.stream.Collectors;
 
@@ -28 +27 @@
 private final TicketService ticketService;
 private final WorkerService workerService;
+private final CustomerRatesFilmService customerRatesFilmService;
 
-    public HomeController(FilmService filmService, UserService userService, ProjectionService projectionService, EventService eventService, TicketService ticketService, WorkerService workerService) {
+    public HomeController(FilmService filmService, UserService userService, ProjectionService projectionService, EventService eventService, TicketService ticketService, WorkerService workerService, CustomerRatesFilmService customerRatesFilmService) {
         this.filmService = filmService;
         this.userService = userService;
@@ -36 +36 @@
         this.ticketService = ticketService;
         this.workerService = workerService;
+        this.customerRatesFilmService = customerRatesFilmService;
     }
 
@@ -49 +50 @@
     @GetMapping("/getFilm/{id}")
     public String getFilm(@PathVariable Long id, Model model) {
-        Optional<Film> film=filmService.getFilmById(id);
+        Film film=filmService.getFilmById(id).get();
         model.addAttribute("film", film);
-        model.addAttribute("bodyContent", "home");
+        List<String> genres= List.of(film.getGenre().split(","));
+        double r=customerRatesFilmService.avg_rating(film.getId_film());
+        model.addAttribute("genres", genres);
+        model.addAttribute("bodyContent", "film");
 
         return "master-template";