Ignore:
File:
1 edited

Legend:

Unmodified
Added
Removed
  • src/main/java/com/wediscussmovies/project/repository/MovieRepository.java

    rc02189f r3c0f9a9  
    33import com.wediscussmovies.project.model.Movie;
    44import com.wediscussmovies.project.model.Person;
    5 import com.wediscussmovies.project.querymodels.GenreLikes;
    6 import com.wediscussmovies.project.querymodels.MovieLikesQM;
    75import org.springframework.data.jpa.repository.JpaRepository;
    86import org.springframework.data.jpa.repository.Query;
    9 import org.springframework.data.repository.query.Param;
    107import org.springframework.stereotype.Repository;
    118
    12 import javax.transaction.Transactional;
    139import java.util.List;
    14 import java.util.Optional;
    1510
    1611@Repository
     
    2116     @Query(value="select m.movieId from Movie m")
    2217     List<Integer> findAllMovieIds();
    23 
    24      @Query(value="select new com.wediscussmovies.project.model.Movie(m.movieId, m.title, m.imdbRating, m.imageUrl) from Movie m" +
    25                " where m.movieId = :index")
    26      Optional<Movie> findBasicById(@Param("index")Integer index);
    27 
    28 
    29      @Query(value = "select new com.wediscussmovies.project.querymodels.MovieLikesQM(m.movieId, count(ml.id.userId)) from Movie m" +
    30              " left join MovieLikes ml on ml.id.movieId = m.movieId" +
    31              " group by m.movieId" +
    32              " order by count(ml.id.userId) desc")
    33      @Transactional
    34      List<MovieLikesQM> findAllWithLikes();
    35 
    36      @Query(value = "select new com.wediscussmovies.project.querymodels.MovieLikesQM(m.movieId, count(ml.id.userId)) from Movie m" +
    37              " left join MovieLikes ml on ml.id.movieId = m.movieId" +
    38              " group by m.movieId" +
    39              " having m.movieId = :id")
    40      @Transactional
    41      List<MovieLikesQM> findLikesForMovie(@Param("id") Integer movie_id);
    42 
    43 
    4418}
Note: See TracChangeset for help on using the changeset viewer.