Changeset 6f91f99 in Git for src/main/java/com/wediscussmovies/project/repository/GenreRepository.java

Timestamp:

02/09/22 15:46:58 (2 years ago)

Author:

Test <matonikolov77@…>

Branches:

main

Children:

8f1b7e9

Parents:

967b414

Message:

Refactored reply repository and discussion repository

File:

• src/main/java/com/wediscussmovies/project/repository/GenreRepository.java (modified) (3 diffs)

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

@@ -2 +2 @@
 
 import com.wediscussmovies.project.model.Genre;
-import com.wediscussmovies.project.querymodels.GenreLikes;
+import com.wediscussmovies.project.querymodels.GenreLikesQM;
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.data.jpa.repository.Modifying;
@@ -10 +10 @@
 
 import javax.transaction.Transactional;
-import java.sql.Date;
 import java.util.List;
 
@@ -17 +16 @@
      List<Genre> findAllByGenreType(String genre);
 
-     @Query(value = "select new com.wediscussmovies.project.querymodels.GenreLikes(g.genreId, g.genreType, count(ug.id.userId)) from Genre g" +
+     @Query(value = "select new com.wediscussmovies.project.querymodels.GenreLikesQM(g.genreId, g.genreType, count(ug.id.userId)) from Genre g" +
              " left join UserGenres ug on ug.id.genreId = g.genreId" +
              " group by g.genreId, g.genreType" +
-             " order by count(ug.id.userId) desc")
+             " order by count(ug.id.userId) desc, g.genreType asc")
      @Transactional
-     List<GenreLikes> findAllWithLikes();
+     List<GenreLikesQM> findAllWithLikes();
 
      @Modifying