Changeset 6f91f99 in Git for src/main/java/com/wediscussmovies/project/repository/DiscussionRepository.java
- Timestamp:
- 02/09/22 15:46:58 (2 years ago)
- Branches:
- main
- Children:
- 8f1b7e9
- Parents:
- 967b414
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
src/main/java/com/wediscussmovies/project/repository/DiscussionRepository.java
r967b414 r6f91f99 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 import com.wediscussmovies.project.querymodels.DiscussionLikesQM; 8 7 import org.springframework.data.jpa.repository.JpaRepository; 9 8 import org.springframework.data.jpa.repository.Query; 9 import org.springframework.data.repository.query.Param; 10 10 import org.springframework.stereotype.Repository; 11 11 … … 19 19 List<Discussion> findAllByPerson (Person person); 20 20 21 @Query(value = "select new com.wediscussmovies.project.querymodels.DiscussionLikes (d.discussionId, count(dl.id.userId)) from Discussion d" +21 @Query(value = "select new com.wediscussmovies.project.querymodels.DiscussionLikesQM(d.discussionId, count(dl.id.userId)) from Discussion d" + 22 22 " left join DiscussionLikes dl on dl.id.discussionId = d.discussionId" + 23 " group by d.discussionId" + 23 " where :discussionId = d.discussionId" + 24 " group by d.discussionId"+ 24 25 " order by count(dl.id.userId) desc") 25 26 @Transactional 26 List<DiscussionLikes> findAllWithLikes(); 27 DiscussionLikesQM findDiscussionWithLikes(@Param("discussionId") Integer discussionId); 28 29 @Query(value = "select new com.wediscussmovies.project.querymodels.DiscussionLikesQM(d.discussionId, count(dl.id.userId)) from Discussion d" + 30 " left join DiscussionLikes dl on dl.id.discussionId = d.discussionId" + 31 " group by d.discussionId"+ 32 " order by count(dl.id.userId) desc") 33 @Transactional 34 List<DiscussionLikesQM> findAllDiscussionsWithLikes(); 27 35 }
Note:
See TracChangeset
for help on using the changeset viewer.