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

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

File:

• src/main/java/com/wediscussmovies/project/repository/ReplyRepository.java (modified) (1 diff)

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