main
Last change
on this file since 5b447b0 was e0ef1b1, checked in by Test <matonikolov77@…>, 2 years ago |
Added CRUD for movies,persons,discussion,replies,genres
Added ajaxcalls
|
-
Property mode
set to
100644
|
File size:
1.1 KB
|
Rev | Line | |
---|
[6e7b472] | 1 | package com.wediscussmovies.project.repository;
|
---|
| 2 |
|
---|
[e0ef1b1] | 3 | import com.wediscussmovies.project.model.Discussion;
|
---|
| 4 | import com.wediscussmovies.project.model.Reply;
|
---|
| 5 | import com.wediscussmovies.project.model.primarykeys.ReplyPK;
|
---|
[6e7b472] | 6 | import org.springframework.data.jpa.repository.JpaRepository;
|
---|
[e0ef1b1] | 7 | import org.springframework.data.jpa.repository.Modifying;
|
---|
| 8 | import org.springframework.data.jpa.repository.Query;
|
---|
| 9 | import org.springframework.data.repository.query.Param;
|
---|
[6e7b472] | 10 | import org.springframework.stereotype.Repository;
|
---|
[e0ef1b1] | 11 |
|
---|
| 12 | import javax.transaction.Transactional;
|
---|
| 13 | import java.sql.Date;
|
---|
| 14 | import java.util.List;
|
---|
[3ded84d] | 15 |
|
---|
[6e7b472] | 16 |
|
---|
| 17 | @Repository
|
---|
[e0ef1b1] | 18 | public interface ReplyRepository extends JpaRepository<Reply, ReplyPK> {
|
---|
| 19 | List<Reply> findAllByDiscussion(Discussion discussion);
|
---|
| 20 |
|
---|
| 21 | @Modifying
|
---|
| 22 | @Query(value = "insert into project.replies (text,date,user_id,discussion_id) values(:text,:date,:user_id,:discussion_id)",nativeQuery = true)
|
---|
| 23 | @Transactional
|
---|
| 24 | void insertInto(@Param("text") String text, @Param("date")Date date,
|
---|
| 25 | @Param("user_id")Integer userId,@Param("discussion_id")Integer discussionId);
|
---|
[6e7b472] | 26 | }
|
---|
Note:
See
TracBrowser
for help on using the repository browser.