Package org.forum.server.jpa

Interface PostRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<Post,Long>, org.springframework.data.repository.Repository<Post,Long>

public interface PostRepository
extends org.springframework.data.repository.CrudRepository<Post,Long>

Author:

etienne-sf

Method Summary

Modifier and Type	Method	Description
List<Post>	findByIds(List<Long> ids)	The query for the BatchLoader
List<Post>	findByTopicId(Long topicId)
List<Post>	findByTopicIdAndMemberIdAndMemberNameAndSince(Long id, Long memberId, String memberName, Date since)
List<Post>	findByTopicIdAndMemberIdAndSince(Long id, Long memberId, Date since)
List<Post>	findByTopicIdAndMemberNameAndSince(Long id, String memberName, Date since)
List<Post>	findByTopicIdAndSince(Long id, Date since)

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findAll, findAllById, findById, save, saveAll

Method Details

findByTopicId

@Query("select p from Post p where p.topicId= ?1")
List<Post> findByTopicId(Long topicId)

findByTopicIdAndSince

@Query("select p from Post p where p.topicId= ?1 and p.date >= ?2")
List<Post> findByTopicIdAndSince(Long id,
 Date since)

findByTopicIdAndMemberIdAndSince

@Query("select p from Post p where p.topicId= ?1 and p.authorId =?2 and p.date >= ?3")
List<Post> findByTopicIdAndMemberIdAndSince(Long id,
 Long memberId,
 Date since)

findByTopicIdAndMemberNameAndSince

@Query(" select p  from Post p  join Member m on m.id=p.authorId where p.topicId= ?1  and m.name =?2  and p.date >= ?3")
List<Post> findByTopicIdAndMemberNameAndSince(Long id,
 String memberName,
 Date since)

findByTopicIdAndMemberIdAndMemberNameAndSince

@Query(" select p  from Post p  join Member m on m.id=p.authorId where p.topicId= ?1  and p.authorId =?2  and m.name = ?3  and p.date >= ?4")
List<Post> findByTopicIdAndMemberIdAndMemberNameAndSince(Long id,
 Long memberId,
 String memberName,
 Date since)

findByIds

@Query("select p from Post p where id in ?1")
List<Post> findByIds(List<Long> ids)

The query for the BatchLoader