Package com.eeit87t3.tickiteasy.post.repository

Interface CommentRepo

All Superinterfaces:

org.springframework.data.repository.CrudRepository<CommentEntity,Integer>, JpaRepository<CommentEntity,Integer>, org.springframework.data.repository.ListCrudRepository<CommentEntity,Integer>, org.springframework.data.repository.ListPagingAndSortingRepository<CommentEntity,Integer>, org.springframework.data.repository.PagingAndSortingRepository<CommentEntity,Integer>, org.springframework.data.repository.query.QueryByExampleExecutor<CommentEntity>, org.springframework.data.repository.Repository<CommentEntity,Integer>

public interface CommentRepo
extends JpaRepository<CommentEntity,Integer>

Method Summary

Modifier and Type	Method	Description
List<CommentEntity>	findByPostPostID(int postID)
List<ShowCommentDTO>	findCommentsWithMemberInfoByPostID(Integer postID)

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

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

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

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

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

findAll, findAllById, saveAll

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

findAll

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

findAll

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

count, exists, findAll, findBy, findOne

Method Details

findByPostPostID

List<CommentEntity> findByPostPostID(int postID)

findCommentsWithMemberInfoByPostID

@Query("SELECT new com.eeit87t3.tickiteasy.post.dto.ShowCommentDTO(c.postID, c.postCommentID, c.memberID, c.content, c.commentDate, c.editTime, m.nickname, m.profilePic) FROM CommentEntity c JOIN Member m ON c.memberID = m.memberID WHERE c.postID = :postID")
List<ShowCommentDTO> findCommentsWithMemberInfoByPostID(@Param("postID")
 Integer postID)