main
Last change
on this file since c02189f was c02189f, checked in by Petar Partaloski <ppartaloski@…>, 2 years ago |
Added new core functionalities, fixed bugs and improved visual clarity
|
-
Property mode
set to
100644
|
File size:
1.2 KB
|
Rev | Line | |
---|
[6e7b472] | 1 | package com.wediscussmovies.project.repository;
|
---|
| 2 |
|
---|
[e0ef1b1] | 3 | import com.wediscussmovies.project.model.Discussion;
|
---|
| 4 | import com.wediscussmovies.project.model.Movie;
|
---|
| 5 | import com.wediscussmovies.project.model.Person;
|
---|
[c02189f] | 6 | import com.wediscussmovies.project.querymodels.DiscussionLikes;
|
---|
| 7 | import com.wediscussmovies.project.querymodels.GenreLikes;
|
---|
[6e7b472] | 8 | import org.springframework.data.jpa.repository.JpaRepository;
|
---|
[c02189f] | 9 | import org.springframework.data.jpa.repository.Query;
|
---|
[6e7b472] | 10 | import org.springframework.stereotype.Repository;
|
---|
| 11 |
|
---|
[c02189f] | 12 | import javax.transaction.Transactional;
|
---|
[2a5d6a3] | 13 | import java.util.List;
|
---|
| 14 |
|
---|
[6e7b472] | 15 | @Repository
|
---|
| 16 | public interface DiscussionRepository extends JpaRepository<Discussion, Integer> {
|
---|
[e0ef1b1] | 17 | List<Discussion> findAllByTitleLike(String title);
|
---|
| 18 | List<Discussion> findAllByMovie(Movie movie);
|
---|
| 19 | List<Discussion> findAllByPerson (Person person);
|
---|
[c02189f] | 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();
|
---|
[6e7b472] | 27 | }
|
---|
Note:
See
TracBrowser
for help on using the repository browser.