Package com.eeit87t3.tickiteasy.post.repository

Interface LikesPostRepo

All Superinterfaces:

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

public interface LikesPostRepo
extends JpaRepository<LikesEntity,Integer>

Method Summary

Modifier and Type	Method	Description
Integer	countByPostID(Integer postID)
void	deleteByPostId(Integer postID)
boolean	existsByMemberIDAndPostID(Integer memberID, Integer postID)
LikesEntity	findByMemberIDAndPostID(Integer memberID, Integer postID)
List<Map<String,Object>>	findLikesByMember(Integer memberID)

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

findByMemberIDAndPostID

LikesEntity findByMemberIDAndPostID(Integer memberID,
 Integer postID)

findLikesByMember

@Query("SELECT new map(p.postID as postID, p.postTitle as title, p.postContent as content, l.likeCreatedTime as Date) FROM LikesEntity l JOIN PostEntity p ON l.postID = p.postID WHERE l.memberID = :memberID")
List<Map<String,Object>> findLikesByMember(Integer memberID)

deleteByPostId

@Modifying
@Transactional
@Query("DELETE FROM LikesEntity l WHERE l.postID = :postID")
void deleteByPostId(@Param("postID")
 Integer postID)

existsByMemberIDAndPostID

boolean existsByMemberIDAndPostID(Integer memberID,
 Integer postID)

countByPostID

Integer countByPostID(Integer postID)