Changeset 0226942 in Git for src/main/java/com/wediscussmovies/project/repository/MovieRepository.java
- Timestamp:
- 02/08/22 22:07:07 (2 years ago)
- Branches:
- main
- Children:
- 967b414
- Parents:
- ad4243e (diff), c02189f (diff)
Note: this is a merge changeset, the changes displayed below correspond to the merge itself.
Use the(diff)
links above to see all the changes relative to each parent. - git-author:
- Mato-77 <56981531+Mato-77@…> (02/08/22 22:07:07)
- git-committer:
- GitHub <noreply@…> (02/08/22 22:07:07)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
src/main/java/com/wediscussmovies/project/repository/MovieRepository.java
rad4243e r0226942 3 3 import com.wediscussmovies.project.model.Movie; 4 4 import com.wediscussmovies.project.model.Person; 5 import com.wediscussmovies.project.querymodels.GenreLikes; 6 import com.wediscussmovies.project.querymodels.MovieLikesQM; 5 7 import org.springframework.data.jpa.repository.JpaRepository; 6 8 import org.springframework.data.jpa.repository.Query; 9 import org.springframework.data.repository.query.Param; 7 10 import org.springframework.stereotype.Repository; 8 11 12 import javax.transaction.Transactional; 9 13 import java.util.List; 14 import java.util.Optional; 10 15 11 16 @Repository … … 16 21 @Query(value="select m.movieId from Movie m") 17 22 List<Integer> findAllMovieIds(); 23 24 @Query(value="select new com.wediscussmovies.project.model.Movie(m.movieId, m.title, m.imdbRating, m.imageUrl) from Movie m" + 25 " where m.movieId = :index") 26 Optional<Movie> findBasicById(@Param("index")Integer index); 27 28 29 @Query(value = "select new com.wediscussmovies.project.querymodels.MovieLikesQM(m.movieId, count(ml.id.userId)) from Movie m" + 30 " left join MovieLikes ml on ml.id.movieId = m.movieId" + 31 " group by m.movieId" + 32 " order by count(ml.id.userId) desc") 33 @Transactional 34 List<MovieLikesQM> findAllWithLikes(); 35 36 @Query(value = "select new com.wediscussmovies.project.querymodels.MovieLikesQM(m.movieId, count(ml.id.userId)) from Movie m" + 37 " left join MovieLikes ml on ml.id.movieId = m.movieId" + 38 " group by m.movieId" + 39 " having m.movieId = :id") 40 @Transactional 41 List<MovieLikesQM> findLikesForMovie(@Param("id") Integer movie_id); 42 43 18 44 }
Note:
See TracChangeset
for help on using the changeset viewer.