Changes in src/main/java/com/wediscussmovies/project/repository/GenreRepository.java [3c0f9a9:e0ef1b1] in Git
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
src/main/java/com/wediscussmovies/project/repository/GenreRepository.java
r3c0f9a9 re0ef1b1 4 4 import com.wediscussmovies.project.querymodels.GenreLikes; 5 5 import org.springframework.data.jpa.repository.JpaRepository; 6 import org.springframework.data.jpa.repository.Modifying;7 6 import org.springframework.data.jpa.repository.Query; 8 import org.springframework.data.repository.query.Param;9 7 import org.springframework.stereotype.Repository; 10 8 11 9 import javax.transaction.Transactional; 12 import java.sql.Date;13 10 import java.util.List; 14 11 … … 17 14 List<Genre> findAllByGenreType(String genre); 18 15 19 @Query(value = "select new com.wediscussmovies.project.querymodels.GenreLikes(g.genre Id, g.genreType, count(ug.id.userId)) from Genre g" +16 @Query(value = "select new com.wediscussmovies.project.querymodels.GenreLikes(g.genreType, count(ug.id.userId)) from Genre g" + 20 17 " left join UserGenres ug on ug.id.genreId = g.genreId" + 21 " group by g.genre Id, g.genreType" +18 " group by g.genreType" + 22 19 " order by count(ug.id.userId) desc") 23 20 @Transactional 24 21 List<GenreLikes> findAllWithLikes(); 25 26 @Modifying27 @Query(value = "insert into project.user_genres (user_id,genre_id) values(:user_id,:genre_id)",nativeQuery = true)28 @Transactional29 void insertInto(@Param("user_id")Integer userId, @Param("genre_id")Integer genreId);30 22 }
Note:
See TracChangeset
for help on using the changeset viewer.