Ignore:
File:
1 edited

Legend:

Unmodified
Added
Removed
  • src/main/java/com/wediscussmovies/project/repository/DiscussionRepository.java

    rc02189f re0ef1b1  
    44import com.wediscussmovies.project.model.Movie;
    55import com.wediscussmovies.project.model.Person;
    6 import com.wediscussmovies.project.querymodels.DiscussionLikes;
    7 import com.wediscussmovies.project.querymodels.GenreLikes;
    86import org.springframework.data.jpa.repository.JpaRepository;
    9 import org.springframework.data.jpa.repository.Query;
    107import org.springframework.stereotype.Repository;
    118
    12 import javax.transaction.Transactional;
    139import java.util.List;
    1410
     
    1814     List<Discussion> findAllByMovie(Movie movie);
    1915     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();
    2716}
Note: See TracChangeset for help on using the changeset viewer.