Changes in src/main/java/com/wediscussmovies/project/repository/DiscussionRepository.java [c02189f:e0ef1b1] in Git
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
src/main/java/com/wediscussmovies/project/repository/DiscussionRepository.java
rc02189f re0ef1b1 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;8 6 import org.springframework.data.jpa.repository.JpaRepository; 9 import org.springframework.data.jpa.repository.Query;10 7 import org.springframework.stereotype.Repository; 11 8 12 import javax.transaction.Transactional;13 9 import java.util.List; 14 10 … … 18 14 List<Discussion> findAllByMovie(Movie movie); 19 15 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 @Transactional26 List<DiscussionLikes> findAllWithLikes();27 16 }
Note:
See TracChangeset
for help on using the changeset viewer.