Changeset ad4243e in Git for src/main/java

Timestamp:

02/07/22 21:26:03 (3 years ago)

Author:

GitHub <noreply@…>

Branches:

main

Children:

0226942

Parents:

7f36551 (diff), 3c0f9a9 (diff)
Note: this is a merge changeset, the changes displayed below correspond to the merge itself.
Use the (diff) links above to see all the changes relative to each parent.

git-author:

Mato-77 <56981531+Mato-77@…> (02/07/22 21:26:03)

git-committer:

GitHub <noreply@…> (02/07/22 21:26:03)

Message:

Merge pull request #2 from partaloski/master

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

Location:

src/main/java/com/wediscussmovies/project

Files:

• model/primarykeys/GenreLikesPK.java (added)
• model/primarykeys/UserGenresPK.java (modified) (3 diffs)
• querymodels/GenreLikes.java (modified) (1 diff)
• repository/GenreLikesRepository.java (added)
• repository/GenreRepository.java (modified) (2 diffs)
• repository/MovieRepository.java (modified) (2 diffs)
• service/GenreService.java (modified) (1 diff)
• service/MovieService.java (modified) (2 diffs)
• service/PersonService.java (modified) (2 diffs)
• service/impl/GenreServiceImpl.java (modified) (4 diffs)
• service/impl/MovieServiceImpl.java (modified) (1 diff)
• service/impl/PersonServiceImpl.java (modified) (3 diffs)
• web/PageFrontMovies.java (added)
• web/controller/GenreController.java (modified) (2 diffs)
• web/controller/MovieController.java (modified) (5 diffs)
• web/controller/PersonController.java (modified) (2 diffs)
• web/controller/rest/GenreRestController.java (added)

src/main/java/com/wediscussmovies/project/model/primarykeys/UserGenresPK.java

@@ -1 +1 @@
 package com.wediscussmovies.project.model.primarykeys;
+
+import lombok.Data;
 
 import javax.persistence.Column;
@@ -6 +8 @@
 import java.io.Serializable;
 
+@Data
 @Embeddable
 public class UserGenresPK implements Serializable {
@@ -30 +33 @@
         UserGenresPK that = (UserGenresPK) o;
 
-
-
         return userId == that.userId && genreId == that.genreId;
     }

src/main/java/com/wediscussmovies/project/querymodels/GenreLikes.java

@@ -3 +3 @@
 import lombok.Data;
 
+import javax.persistence.Entity;
+import javax.persistence.Table;
+import java.util.Comparator;
+import java.util.Objects;
+
 @Data
 public class GenreLikes {
-
+    private Integer genreId;
     private String name;
     private Long likes;
 
-    public GenreLikes(String name, Long likes) {
+    public static Comparator<GenreLikes> sorter = Comparator.comparing(GenreLikes::getLikes).thenComparing(GenreLikes::getName).reversed();
+
+    public GenreLikes(Integer genreId, String name, Long likes) {
+        this.genreId = genreId;
         this.name = name;
         this.likes = likes;
+
+    }
+
+    @Override
+    public boolean equals(Object o) {
+        if (this == o) return true;
+        if (o == null || getClass() != o.getClass()) return false;
+        GenreLikes that = (GenreLikes) o;
+        return Objects.equals(genreId, that.genreId);
+    }
+
+    @Override
+    public int hashCode() {
+        return Objects.hash(genreId);
     }
 }

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();
 }

src/main/java/com/wediscussmovies/project/service/GenreService.java

@@ -14 +14 @@
     Genre save(String genreName);
     List<GenreLikes> findAllWithLikes();
+    void likeGenre(Integer genreId,Integer userId);
+    void unlikeGenre(Integer genreId,Integer userId);
 
 }

src/main/java/com/wediscussmovies/project/service/MovieService.java

@@ -6 +6 @@
 import com.wediscussmovies.project.model.Person;
 import com.wediscussmovies.project.model.User;
+import org.springframework.data.jpa.repository.Query;
 
 import java.sql.Date;
@@ -16 +17 @@
      List<Movie> searchByTitle(String title);
      Movie findById(Integer id);
+     List<Integer> listAllIds();
      Movie save(String title, String description, String imageUrl, Date airingDate,Double  rating,
                 Integer directorId,List<Integer> actorIds,List<Integer> genreIds);

src/main/java/com/wediscussmovies/project/service/PersonService.java

@@ -5 +5 @@
 import com.wediscussmovies.project.model.Person;
 import com.wediscussmovies.project.model.User;
+import com.wediscussmovies.project.model.relation.MovieLikes;
 
 import java.sql.Date;
 import java.util.List;
+import java.util.stream.Collectors;
 
 public interface PersonService {
@@ -27 +29 @@
     void deleteById(Integer id);
     void addGradePerson(Integer personId, User user, Grade grade);
-
 }

src/main/java/com/wediscussmovies/project/service/impl/GenreServiceImpl.java

@@ -1 +1 @@
 package com.wediscussmovies.project.service.impl;
 
+import com.wediscussmovies.project.model.User;
 import com.wediscussmovies.project.model.exception.GenreNotExistException;
+import com.wediscussmovies.project.model.exception.UserNotExistException;
+import com.wediscussmovies.project.model.primarykeys.GenreLikesPK;
+import com.wediscussmovies.project.model.primarykeys.UserGenresPK;
+import com.wediscussmovies.project.model.relation.MovieLikes;
+import com.wediscussmovies.project.model.relation.UserGenres;
 import com.wediscussmovies.project.querymodels.GenreLikes;
+import com.wediscussmovies.project.repository.GenreLikesRepository;
 import com.wediscussmovies.project.repository.GenreRepository;
 import com.wediscussmovies.project.model.Genre;
+import com.wediscussmovies.project.repository.UserRepository;
 import com.wediscussmovies.project.service.GenreService;
 import org.springframework.stereotype.Service;
@@ -13 +21 @@
 public class GenreServiceImpl implements GenreService {
     private final GenreRepository genreRepository;
+    private final UserRepository userRepository;
+    private final GenreLikesRepository genreLikesRepository;
 
-    public GenreServiceImpl(GenreRepository genreRepository) {
+
+    public GenreServiceImpl(GenreRepository genreRepository, UserRepository userRepository, GenreLikesRepository genreLikesRepository) {
         this.genreRepository = genreRepository;
+        this.userRepository = userRepository;
+        this.genreLikesRepository = genreLikesRepository;
     }
 
@@ -36 +49 @@
     @Override
     public List<GenreLikes> findAllWithLikes() {
-        return this.genreRepository.findAllWithLikes();
+        List<GenreLikes> genreLikesList = this.genreRepository.findAllWithLikes();
+        genreLikesList.sort(GenreLikes.sorter);
+        return genreLikesList;
     }
 
@@ -43 +58 @@
         return this.genreRepository.findAll();
     }
+
+    @Override
+    public void likeGenre(Integer genreId, Integer userId) {
+        User user = this.userRepository.findById(userId).orElseThrow(() -> new UserNotExistException(userId.toString()));
+        Genre genre = this.genreRepository.findById(genreId).orElseThrow(() -> new GenreNotExistException(genreId));
+        this.genreLikesRepository.save(new UserGenres(genre, user));
+    }
+
+    @Override
+    public void unlikeGenre(Integer genreId, Integer userId) {
+        UserGenresPK movieLikesPK = new UserGenresPK(userId, genreId);
+        this.genreLikesRepository.deleteById(movieLikesPK);
+    }
 }

src/main/java/com/wediscussmovies/project/service/impl/MovieServiceImpl.java

@@ -76 +76 @@
 
     @Override
+    public List<Integer> listAllIds() {
+        return this.movieRepository.findAllMovieIds();
+    }
+
+    @Override
     @Transactional
     public Movie save(String title, String description, String imageUrl,

src/main/java/com/wediscussmovies/project/service/impl/PersonServiceImpl.java

@@ -9 +9 @@
 import com.wediscussmovies.project.model.primarykeys.PersonRatesPK;
 import com.wediscussmovies.project.model.relation.MovieActors;
-import com.wediscussmovies.project.model.relation.MovieRates;
 import com.wediscussmovies.project.model.relation.PersonRates;
-import com.wediscussmovies.project.repository.MovieActorsRepository;
-import com.wediscussmovies.project.repository.MovieRepository;
-import com.wediscussmovies.project.repository.PersonRatesRepository;
-import com.wediscussmovies.project.repository.PersonRepository;
+import com.wediscussmovies.project.repository.*;
 import com.wediscussmovies.project.model.Person;
 import com.wediscussmovies.project.service.PersonService;
@@ -32 +28 @@
     private final MovieActorsRepository movieActorsRepository;
     private final PersonRatesRepository personRatesRepository;
-
 
     public PersonServiceImpl(PersonRepository personRepository,
@@ -156 +151 @@
 
 
+
+
     private void addActorForMovies(Person person, List<Integer> movieIds){
 

src/main/java/com/wediscussmovies/project/web/controller/GenreController.java

@@ -1 +1 @@
 package com.wediscussmovies.project.web.controller;
 
+import com.wediscussmovies.project.LoggedUser;
+import com.wediscussmovies.project.model.Genre;
+import com.wediscussmovies.project.model.User;
+import com.wediscussmovies.project.model.relation.UserGenres;
+import com.wediscussmovies.project.querymodels.GenreLikes;
+import com.wediscussmovies.project.repository.GenreLikesRepository;
 import com.wediscussmovies.project.service.GenreService;
 import org.springframework.stereotype.Controller;
@@ -7 +13 @@
 import org.springframework.web.bind.annotation.RequestMapping;
 
+import java.util.ArrayList;
+import java.util.List;
+
 @Controller
 @RequestMapping("/genres")
 public class GenreController {
     private final GenreService genreService;
+    private final GenreLikesRepository genreLikesRepository;
 
-    public GenreController(GenreService genreService) {
+    public GenreController(GenreService genreService, GenreLikesRepository genreLikesRepository) {
         this.genreService = genreService;
+        this.genreLikesRepository = genreLikesRepository;
     }
     @GetMapping
     public String getGenres(Model model){
         model.addAttribute("genres",genreService.findAllWithLikes());
+        model.addAttribute("allGenres", genreService.findAll());
         model.addAttribute("contentTemplate","genres");
+        addModelPropertiesForUser(model);
         return "template";
     }
+
+    private void addModelPropertiesForUser(Model model){
+        User user = LoggedUser.getLoggedUser();
+        List<UserGenres> genreLikesList = this.genreLikesRepository.findAllByUser(user);
+        List<Genre> genres = new ArrayList<>();
+        for(UserGenres g: genreLikesList){
+            genres.add(genreService.findById(g.getId().getGenreId()));
+        }
+        model.addAttribute("likedGenres",genres);
+        model.addAttribute("user",user);
+    }
 }

src/main/java/com/wediscussmovies/project/web/controller/MovieController.java

@@ -9 +9 @@
 import com.wediscussmovies.project.service.PersonService;
 import com.wediscussmovies.project.web.DesignFrontMovies;
+import com.wediscussmovies.project.web.PageFrontMovies;
 import lombok.Data;
 import org.springframework.format.annotation.DateTimeFormat;
@@ -37 +38 @@
     }
 
-    @GetMapping
+    @GetMapping("/old")
     public String getMovies(@RequestParam(required = false) String titleQuery, Model model,
                             @RequestParam(required = false) String error){
@@ -55 +56 @@
         model.addAttribute("movie_rows", movie_rows);
         model.addAttribute("contentTemplate", "moviesList");
+        if (error != null && !error.equals(" "))
+            model.addAttribute("error",error);
+        return "template";
+    }
+
+
+    @GetMapping
+    public String getMoviesAlternative(@RequestParam(required = false) String titleQuery, Model model,
+                            @RequestParam(required = false) String error, @RequestParam(required = false) String page){
+        if (page==null){
+            return "redirect:/movies?page=1";
+        }
+        addModelPropertiesForUser(model);
+        List<Movie> movies = PageFrontMovies.getPagedMovies(page, movieService, model);
+        List<List<Movie>> movie_rows = new ArrayList<>();
+        DesignFrontMovies.designMovieList(movies,movie_rows);
+        model.addAttribute("movies", movies);
+        model.addAttribute("movie_rows", movie_rows);
+        model.addAttribute("contentTemplate", "moviesListPaged");
         if (error != null && !error.equals(" "))
             model.addAttribute("error",error);
@@ -160 +180 @@
     }
     private void addModelProperties(Model model){
-
-        model.addAttribute("directors",  personService.findAllDirectors());
+        model.addAttribute("directors", personService.findAllDirectors());
         model.addAttribute("actors", personService.findAllActors());
         model.addAttribute("genres", genreService.findAll());
@@ -169 +188 @@
         model.addAttribute("likedMovies",this.movieService.findLikedMoviesByUser(user));
         model.addAttribute("user",user);
-        }
+    }
 
 }

src/main/java/com/wediscussmovies/project/web/controller/PersonController.java

@@ -1 +1 @@
 package com.wediscussmovies.project.web.controller;
 
+import com.wediscussmovies.project.LoggedUser;
 import com.wediscussmovies.project.model.Person;
+import com.wediscussmovies.project.model.User;
 import com.wediscussmovies.project.service.MovieService;
 import com.wediscussmovies.project.service.PersonService;
@@ -135 +137 @@
     }
 
+    private void addModelPropertiesForUser(Model model){
+        User user = LoggedUser.getLoggedUser();
+        model.addAttribute("user",user);
+    }
+
 
 }