Changes in src/main/java/com/wediscussmovies/project/repository/MovieRepository.java [c02189f:3c0f9a9] in Git
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
src/main/java/com/wediscussmovies/project/repository/MovieRepository.java
rc02189f r3c0f9a9 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;7 5 import org.springframework.data.jpa.repository.JpaRepository; 8 6 import org.springframework.data.jpa.repository.Query; 9 import org.springframework.data.repository.query.Param;10 7 import org.springframework.stereotype.Repository; 11 8 12 import javax.transaction.Transactional;13 9 import java.util.List; 14 import java.util.Optional;15 10 16 11 @Repository … … 21 16 @Query(value="select m.movieId from Movie m") 22 17 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 @Transactional34 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 @Transactional41 List<MovieLikesQM> findLikesForMovie(@Param("id") Integer movie_id);42 43 44 18 }
Note:
See TracChangeset
for help on using the changeset viewer.