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

Timestamp:

02/04/22 23:22:13 (2 years ago)

Author:

Test <matonikolov77@…>

Branches:

main

Children:

5b447b0

Parents:

3ded84d

Message:

Added CRUD for movies,persons,discussion,replies,genres
Added ajaxcalls

Location:

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

Files:

• DiscussionRepository.java (modified) (1 diff)
• GenreRepository.java (modified) (1 diff)
• MovieRepository.java (modified) (1 diff)
• PersonRepository.java (modified) (1 diff)
• ReplyRepository.java (modified) (1 diff)
• UserRepository.java (modified) (2 diffs)

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

@@ -1 +1 @@
 package com.wediscussmovies.project.repository;
 
+import com.wediscussmovies.project.model.Discussion;
+import com.wediscussmovies.project.model.Movie;
+import com.wediscussmovies.project.model.Person;
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.stereotype.Repository;
 
 import java.util.List;
-import com.wediscussmovies.project.model.*;
 
 @Repository
 public interface DiscussionRepository extends JpaRepository<Discussion, Integer> {
-    public List<Discussion> findAllByTitleLike(String title);
+     List<Discussion> findAllByTitleLike(String title);
+     List<Discussion> findAllByMovie(Movie movie);
+     List<Discussion> findAllByPerson (Person person);
 }

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

@@ -1 +1 @@
 package com.wediscussmovies.project.repository;
 
-import com.wediscussmovies.project.model.*;
+import com.wediscussmovies.project.model.Genre;
+import com.wediscussmovies.project.querymodels.GenreLikes;
 import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Query;
 import org.springframework.stereotype.Repository;
 
+import javax.transaction.Transactional;
 import java.util.List;
 
 @Repository
 public interface GenreRepository extends JpaRepository<Genre, Integer> {
-    public List<Genre> findAllByGenreType(String genre);
+     List<Genre> findAllByGenreType(String genre);
+
+     @Query(value = "select new com.wediscussmovies.project.querymodels.GenreLikes(g.genreType, count(ug.id.userId)) from Genre g" +
+             " left join UserGenres ug on ug.id.genreId = g.genreId" +
+             " group by g.genreType" +
+             " order by count(ug.id.userId) desc")
+     @Transactional
+     List<GenreLikes> findAllWithLikes();
 }

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

@@ -1 +1 @@
 package com.wediscussmovies.project.repository;
 
+import com.wediscussmovies.project.model.Movie;
+import com.wediscussmovies.project.model.Person;
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.stereotype.Repository;
 
 import java.util.List;
-import com.wediscussmovies.project.model.*;
 
 @Repository
 public interface MovieRepository extends JpaRepository<Movie, Integer> {
-    public List<Movie> findAllByTitleLike(String Title);
+     List<Movie> findAllByTitleLike(String Title);
+     List<Movie> findAllByDirector(Person director);
+     List<Movie> findAllByDirectorIsNull();
 }

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

@@ -1 +1 @@
 package com.wediscussmovies.project.repository;
 
-import com.wediscussmovies.project.model.*;
-import com.wediscussmovies.project.model.enumerations.PersonType;
+import com.wediscussmovies.project.model.Person;
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.stereotype.Repository;
 
 import java.util.List;
-import java.util.Optional;
 
 @Repository
 public interface PersonRepository extends JpaRepository<Person, Integer> {
-    public List<Person> findAllByType(Character type);
-    public List<Person> findAllByTypeAndNameLike(Character type, String name);
-    public List<Person> findAllByTypeAndSurnameLike(Character type, String surname);
-    public Optional<Person> findPersonByPersonIdAndType(Integer id, Character type);
+     List<Person> findAllByType(Character type);
+     List<Person> findAllByTypeAndNameLike(Character type, String name);
+     List<Person> findAllByTypeAndSurnameLike(Character type, String surname);
+    // Optional<Person> findPersonByPersonIdAndType(Integer id, Character type);
+     List<Person> findAllByTypeAndNameLikeOrSurnameLike(Character type,String name, String surname);
 }

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

@@ -1 +1 @@
 package com.wediscussmovies.project.repository;
 
+import com.wediscussmovies.project.model.Discussion;
+import com.wediscussmovies.project.model.Reply;
+import com.wediscussmovies.project.model.primarykeys.ReplyPK;
 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 com.wediscussmovies.project.model.*;
+
+import javax.transaction.Transactional;
+import java.sql.Date;
+import java.util.List;
 
 
 @Repository
-public interface ReplyRepository extends JpaRepository<Reply, Integer> {
+public interface ReplyRepository extends JpaRepository<Reply, ReplyPK> {
+    List<Reply> findAllByDiscussion(Discussion discussion);
+
+    @Modifying
+    @Query(value = "insert into project.replies (text,date,user_id,discussion_id) values(:text,:date,:user_id,:discussion_id)",nativeQuery = true)
+    @Transactional
+    void insertInto(@Param("text") String text, @Param("date")Date date,
+                    @Param("user_id")Integer userId,@Param("discussion_id")Integer discussionId);
 }

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

@@ -1 +1 @@
 package com.wediscussmovies.project.repository;
 
-import com.wediscussmovies.project.model.*;
+import com.wediscussmovies.project.model.User;
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.stereotype.Repository;
@@ -9 +9 @@
 @Repository
 public interface UserRepository extends JpaRepository<User, Integer> {
-    public Optional<User> findByEmailAndPassword(String email, String password);
-    public Optional<User> findByUsernameAndPassword(String email, String password);
-    public Optional<User> findByUsername(String username);
-    public Optional<User> findByEmail(String email);
+     Optional<User> findByUsername(String username);
 }