Changeset c02189f in Git for src/main/java/com/wediscussmovies/project/repository
- Timestamp:
- 02/08/22 20:13:23 (3 years ago)
- Branches:
- main
- Children:
- 0226942, 3fe36de
- Parents:
- 3c0f9a9
- Location:
- src/main/java/com/wediscussmovies/project/repository
- Files:
-
- 1 added
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
src/main/java/com/wediscussmovies/project/repository/DiscussionRepository.java
r3c0f9a9 rc02189f 4 4 import com.wediscussmovies.project.model.Movie; 5 5 import com.wediscussmovies.project.model.Person; 6 import com.wediscussmovies.project.querymodels.DiscussionLikes; 7 import com.wediscussmovies.project.querymodels.GenreLikes; 6 8 import org.springframework.data.jpa.repository.JpaRepository; 9 import org.springframework.data.jpa.repository.Query; 7 10 import org.springframework.stereotype.Repository; 8 11 12 import javax.transaction.Transactional; 9 13 import java.util.List; 10 14 … … 14 18 List<Discussion> findAllByMovie(Movie movie); 15 19 List<Discussion> findAllByPerson (Person person); 20 21 @Query(value = "select new com.wediscussmovies.project.querymodels.DiscussionLikes(d.discussionId, count(dl.id.userId)) from Discussion d" + 22 " left join DiscussionLikes dl on dl.id.discussionId = d.discussionId" + 23 " group by d.discussionId" + 24 " order by count(dl.id.userId) desc") 25 @Transactional 26 List<DiscussionLikes> findAllWithLikes(); 16 27 } -
src/main/java/com/wediscussmovies/project/repository/GenreRepository.java
r3c0f9a9 rc02189f 28 28 @Transactional 29 29 void insertInto(@Param("user_id")Integer userId, @Param("genre_id")Integer genreId); 30 31 @Query(value = "select new com.wediscussmovies.project.model.Genre (g.genreId, g.genreType) from Genre g" + 32 " ORDER BY g.genreType DESC") 33 List<Genre> findAllSorted(); 30 34 } -
src/main/java/com/wediscussmovies/project/repository/MovieRepository.java
r3c0f9a9 rc02189f 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.