Changeset 0226942 in Git for src/main/java/com/wediscussmovies/project/repository/DiscussionRepository.java

Timestamp:

02/08/22 22:07:07 (2 years ago)

Author:

GitHub <noreply@…>

Branches:

main

Children:

967b414

Parents:

ad4243e (diff), c02189f (diff)
Note: this is a merge changeset, the changes displayed below correspond to the merge itself.
Use the (diff) links above to see all the changes relative to each parent.

git-author:

Mato-77 <56981531+Mato-77@…> (02/08/22 22:07:07)

git-committer:

GitHub <noreply@…> (02/08/22 22:07:07)

Message:

Merge pull request #3 from partaloski/master

Added new core functionalities, fixed bugs and improved visual clarity

File:

• src/main/java/com/wediscussmovies/project/repository/DiscussionRepository.java (modified) (2 diffs)

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

@@ -4 +4 @@
 import com.wediscussmovies.project.model.Movie;
 import com.wediscussmovies.project.model.Person;
+import com.wediscussmovies.project.querymodels.DiscussionLikes;
+import com.wediscussmovies.project.querymodels.GenreLikes;
 import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Query;
 import org.springframework.stereotype.Repository;
 
+import javax.transaction.Transactional;
 import java.util.List;
 
@@ -14 +18 @@
      List<Discussion> findAllByMovie(Movie movie);
      List<Discussion> findAllByPerson (Person person);
+
+     @Query(value = "select new com.wediscussmovies.project.querymodels.DiscussionLikes(d.discussionId, count(dl.id.userId)) from Discussion d" +
+             " left join DiscussionLikes dl on dl.id.discussionId = d.discussionId" +
+             " group by d.discussionId" +
+             " order by count(dl.id.userId) desc")
+     @Transactional
+     List<DiscussionLikes> findAllWithLikes();
 }