Changeset 8f1b7e9 in Git for src/main/java/com/wediscussmovies/project/repository

Timestamp:

02/10/22 13:28:00 (3 years ago)

Author:

Test <matonikolov77@…>

Branches:

main

Children:

980eeda

Parents:

6f91f99

Message:

Changed DiscussionRepository and DiscussionServiceImpl for fetching likes

File:

• src/main/java/com/wediscussmovies/project/repository/DiscussionRepository.java (modified) (1 diff)

src/main/java/com/wediscussmovies/project/repository/DiscussionRepository.java

@@ -19 +19 @@
      List<Discussion> findAllByPerson (Person person);
 
-     @Query(value = "select new com.wediscussmovies.project.querymodels.DiscussionLikesQM(d.discussionId, count(dl.id.userId)) from Discussion d" +
+     @Query(value = "select new com.wediscussmovies.project.querymodels.DiscussionLikesQM(d.discussionId, count (dl.user) ) from Discussion d" +
              " left join DiscussionLikes dl on dl.id.discussionId = d.discussionId" +
-             " where :discussionId = d.discussionId" +
-             " group by d.discussionId"+
-             " order by count(dl.id.userId) desc")
+             " where :id = d.discussionId" +
+             " group by d.discussionId")
      @Transactional
-     DiscussionLikesQM findDiscussionWithLikes(@Param("discussionId") Integer discussionId);
+     DiscussionLikesQM findDiscussionWithLikes(@Param("id") Integer discussionId);
 
-     @Query(value = "select new com.wediscussmovies.project.querymodels.DiscussionLikesQM(d.discussionId, count(dl.id.userId)) from Discussion d" +
+     @Query(value = "select new com.wediscussmovies.project.querymodels.DiscussionLikesQM (d.discussionId, count(dl.user))  from Discussion d" +
              " left join DiscussionLikes dl on dl.id.discussionId = d.discussionId" +
              " group by d.discussionId"+
-             " order by count(dl.id.userId) desc")
+               " order by d.discussionId asc")
      @Transactional
-     List<DiscussionLikesQM> findAllDiscussionsWithLikes();
+     List<DiscussionLikesQM
+             > findAllDiscussionsWithLikes();
 }