Package com.restapi.template.api.community.post.data

Interface PostRepository

  • All Superinterfaces:
    org.springframework.data.repository.CrudRepository<Post,​java.lang.Long>, org.springframework.data.jpa.repository.JpaRepository<Post,​java.lang.Long>, org.springframework.data.repository.PagingAndSortingRepository<Post,​java.lang.Long>, org.springframework.data.repository.query.QueryByExampleExecutor<Post>, org.springframework.data.repository.Repository<Post,​java.lang.Long>
    @Repository
public interface PostRepository
extends org.springframework.data.jpa.repository.JpaRepository<Post,​java.lang.Long>
    게시글 레포지터리.
    Version:
    1.0
    Author:
    always0ne

    • Method Summary

      All Methods Instance Methods Abstract Methods 
      Modifier and Type Method Description
      org.springframework.data.domain.Page<PostsDto> findAllProjectedBy​(org.springframework.data.domain.Pageable pageable)
      모든 게시글 조회(Pagenation).
      java.util.Optional<Post> findByPostId​(java.lang.Long postId)
      게시글 아이디로 조회.
      java.util.Optional<Post> findByPostIdAndAuthor_UserId​(java.lang.Long postId, java.lang.String userId)
      사용자의 게시글인지 확인하며 포스트 조회.

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

        count, delete, deleteAll, deleteAll, deleteById, existsById, findById, save

      • Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

        deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlush

      • Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

        findAll

      • Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

        count, exists, findAll, findOne

    • Method Detail

      • findByPostId

        java.util.Optional<Post> findByPostId​(java.lang.Long postId)
        게시글 아이디로 조회.
        Parameters:
        postId - 게시글 아이디
        Returns:
        게시글(Optional)

      • findByPostIdAndAuthor_UserId

        java.util.Optional<Post> findByPostIdAndAuthor_UserId​(java.lang.Long postId,
                                                      java.lang.String userId)
        사용자의 게시글인지 확인하며 포스트 조회.
        Parameters:
        postId - 게시글 아이디
        userId - 작성자 ID
        Returns:
        게시글(Optional)

      • findAllProjectedBy

        @Query(value="SELECT new com.restapi.template.api.community.post.dto.PostsDto(postId, title, author.userId, views, commentNum, modifiedDate) FROM Post",
       countQuery="SELECT count(postId) FROM Post")
org.springframework.data.domain.Page<PostsDto> findAllProjectedBy​(org.springframework.data.domain.Pageable pageable)
        모든 게시글 조회(Pagenation).
        Parameters:
        pageable - 페이지 정보
        Returns:
        모든 게시글(Page)