Last change
on this file since fc7ec52 was fc7ec52, checked in by darkopopovski <darkopopovski39@…>, 22 months ago |
all files
|
-
Property mode
set to
100644
|
File size:
971 bytes
|
Rev | Line | |
---|
[fc7ec52] | 1 | package com.example.demo.repository;
|
---|
| 2 |
|
---|
| 3 | import com.example.demo.model.Genre;
|
---|
| 4 | import org.springframework.data.jpa.repository.JpaRepository;
|
---|
| 5 | import org.springframework.data.jpa.repository.Query;
|
---|
| 6 |
|
---|
| 7 | import java.util.List;
|
---|
| 8 | import java.util.Optional;
|
---|
| 9 |
|
---|
| 10 | public interface GenreRepository extends JpaRepository<Genre, Integer> {
|
---|
| 11 |
|
---|
| 12 | @Query(value="select g.genre_id ,g.genre_name, count(r) as rezervacii from genre as g\n" +
|
---|
| 13 | " join is_ as i on i.genre_id = g.genre_id\n" +
|
---|
| 14 | " join movie as m on m.movie_id = i.movie_id\n" +
|
---|
| 15 | " join movieprojection as mp on mp.movie_id = m.movie_id\n" +
|
---|
| 16 | " join reservation as r on r.projection_id = mp.projection_id\n" +
|
---|
| 17 | " and r.reservation_date between now() - interval '2 month' and now()\n" +
|
---|
| 18 | " group by g.genre_id\n" +
|
---|
| 19 | " order by rezervacii desc\n" +
|
---|
| 20 | " limit 3;",nativeQuery = true)
|
---|
| 21 | List<Genre> SelectTopThree();
|
---|
| 22 |
|
---|
| 23 |
|
---|
| 24 | } |
---|
Note:
See
TracBrowser
for help on using the repository browser.