Changeset 3c0f9a9 in Git for src/main/java/com/wediscussmovies/project/repository

Timestamp:

02/07/22 19:57:58 (3 years ago)

Author:

Petar Partaloski <ppartaloski@…>

Branches:

main

Children:

ad4243e, c02189f

Parents:

7f36551

Message:

Added genre liking, fixed counter, improved paging, improved searches

Location:

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

Files:

• GenreLikesRepository.java (added)
• GenreRepository.java (modified) (2 diffs)
• MovieRepository.java (modified) (2 diffs)

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

@@ -4 +4 @@
 import com.wediscussmovies.project.querymodels.GenreLikes;
 import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Modifying;
 import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.query.Param;
 import org.springframework.stereotype.Repository;
 
 import javax.transaction.Transactional;
+import java.sql.Date;
 import java.util.List;
 
@@ -14 +17 @@
      List<Genre> findAllByGenreType(String genre);
 
-     @Query(value = "select new com.wediscussmovies.project.querymodels.GenreLikes(g.genreType, count(ug.id.userId)) from Genre g" +
+     @Query(value = "select new com.wediscussmovies.project.querymodels.GenreLikes(g.genreId, g.genreType, count(ug.id.userId)) from Genre g" +
              " left join UserGenres ug on ug.id.genreId = g.genreId" +
-             " group by g.genreType" +
+             " group by g.genreId, g.genreType" +
              " order by count(ug.id.userId) desc")
      @Transactional
      List<GenreLikes> findAllWithLikes();
+
+     @Modifying
+     @Query(value = "insert into project.user_genres (user_id,genre_id) values(:user_id,:genre_id)",nativeQuery = true)
+     @Transactional
+     void insertInto(@Param("user_id")Integer userId, @Param("genre_id")Integer genreId);
 }

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

@@ -4 +4 @@
 import com.wediscussmovies.project.model.Person;
 import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Query;
 import org.springframework.stereotype.Repository;
 
@@ -13 +14 @@
      List<Movie> findAllByDirector(Person director);
      List<Movie> findAllByDirectorIsNull();
+     @Query(value="select m.movieId from Movie m")
+     List<Integer> findAllMovieIds();
 }