main
Last change
on this file since 2efe93e was e0ef1b1, checked in by Test <matonikolov77@…>, 2 years ago |
Added CRUD for movies,persons,discussion,replies,genres
Added ajaxcalls
|
-
Property mode
set to
100644
|
File size:
882 bytes
|
Line | |
---|
1 | package com.wediscussmovies.project.repository;
|
---|
2 |
|
---|
3 | import com.wediscussmovies.project.model.Genre;
|
---|
4 | import com.wediscussmovies.project.querymodels.GenreLikes;
|
---|
5 | import org.springframework.data.jpa.repository.JpaRepository;
|
---|
6 | import org.springframework.data.jpa.repository.Query;
|
---|
7 | import org.springframework.stereotype.Repository;
|
---|
8 |
|
---|
9 | import javax.transaction.Transactional;
|
---|
10 | import java.util.List;
|
---|
11 |
|
---|
12 | @Repository
|
---|
13 | public interface GenreRepository extends JpaRepository<Genre, Integer> {
|
---|
14 | List<Genre> findAllByGenreType(String genre);
|
---|
15 |
|
---|
16 | @Query(value = "select new com.wediscussmovies.project.querymodels.GenreLikes(g.genreType, count(ug.id.userId)) from Genre g" +
|
---|
17 | " left join UserGenres ug on ug.id.genreId = g.genreId" +
|
---|
18 | " group by g.genreType" +
|
---|
19 | " order by count(ug.id.userId) desc")
|
---|
20 | @Transactional
|
---|
21 | List<GenreLikes> findAllWithLikes();
|
---|
22 | }
|
---|
Note:
See
TracBrowser
for help on using the repository browser.