Package com.bytedesk.core.thread

Interface ThreadRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<ThreadEntity,Long>, org.springframework.data.jpa.repository.JpaRepository<ThreadEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<ThreadEntity>, org.springframework.data.repository.ListCrudRepository<ThreadEntity,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<ThreadEntity,Long>, org.springframework.data.repository.PagingAndSortingRepository<ThreadEntity,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<ThreadEntity>, org.springframework.data.repository.Repository<ThreadEntity,Long>

@Repository
public interface ThreadRepository
extends org.springframework.data.jpa.repository.JpaRepository<ThreadEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<ThreadEntity>

Method Summary

Modifier and Type	Method	Description
int	countByTopicAndStateAndDeletedFalse(String topic, String state)
Boolean	existsByUid(String uid)
org.springframework.data.domain.Page<ThreadEntity>	findByOwnerAndHideAndDeleted(UserEntity owner, Boolean hide, Boolean deleted, org.springframework.data.domain.Pageable pageable)
List<ThreadEntity>	findByStateAndDeleted(String state, Boolean deleted)
List<ThreadEntity>	findByStatesAndDeleted(List<String> states, Boolean deleted)
List<ThreadEntity>	findByTopicAndDeleted(String topic, Boolean deleted)
List<ThreadEntity>	findByTypesInAndStateAndDeletedFalse(List<String> types, String state)
List<ThreadEntity>	findByTypesInAndStateNotAndDeletedFalse(List<String> types, String state)
List<ThreadEntity>	findByTypesInAndStatesNotInAndDeleted(List<String> types, List<String> states, Boolean deleted)
Optional<ThreadEntity>	findByUid(String uid)
List<ThreadEntity>	findFirstByTopic(String topic)
Optional<ThreadEntity>	findFirstByTopicAndDeletedOrderByCreatedAtDesc(String topic, Boolean deleted)
Optional<ThreadEntity>	findFirstByTopicAndOwnerAndDeletedOrderByUpdatedAtDesc(String topic, UserEntity owner, Boolean deleted)	used for member thread type
Optional<ThreadEntity>	findFirstByTopicAndStateNotContainingAndDeleted(String topic, String state, Boolean deleted)
Optional<ThreadEntity>	findTopicAndStatesNotInAndDeleted(String topicWithWildcard, List<String> states, Boolean deleted)

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.jpa.repository.JpaSpecificationExecutor

count, delete, exists, findAll, findAll, findAll, findBy, findOne

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

findByUid

Optional<ThreadEntity> findByUid(String uid)

existsByUid

Boolean existsByUid(String uid)

findFirstByTopicAndOwnerAndDeletedOrderByUpdatedAtDesc

Optional<ThreadEntity> findFirstByTopicAndOwnerAndDeletedOrderByUpdatedAtDesc(String topic,
 UserEntity owner,
 Boolean deleted)

used for member thread type

findByTopicAndDeleted

List<ThreadEntity> findByTopicAndDeleted(String topic,
 Boolean deleted)

findFirstByTopicAndDeletedOrderByCreatedAtDesc

Optional<ThreadEntity> findFirstByTopicAndDeletedOrderByCreatedAtDesc(String topic,
 Boolean deleted)

findFirstByTopicAndStateNotContainingAndDeleted

Optional<ThreadEntity> findFirstByTopicAndStateNotContainingAndDeleted(String topic,
 String state,
 Boolean deleted)

findTopicAndStatesNotInAndDeleted

@Query(value="select * from core_thread t where t.topic = ?1 and t.state not in ?2 and t.is_deleted = ?3 LIMIT 1",
       nativeQuery=true)
Optional<ThreadEntity> findTopicAndStatesNotInAndDeleted(String topicWithWildcard,
 List<String> states,
 Boolean deleted)

findByOwnerAndHideAndDeleted

org.springframework.data.domain.Page<ThreadEntity> findByOwnerAndHideAndDeleted(UserEntity owner,
 Boolean hide,
 Boolean deleted,
 org.springframework.data.domain.Pageable pageable)

findFirstByTopic

List<ThreadEntity> findFirstByTopic(String topic)

findByStateAndDeleted

List<ThreadEntity> findByStateAndDeleted(String state,
 Boolean deleted)

findByStatesAndDeleted

@Query("SELECT t FROM ThreadEntity t WHERE t.state IN :states AND t.deleted = :deleted")
List<ThreadEntity> findByStatesAndDeleted(@Param("states")
 List<String> states,
 Boolean deleted)

findByTypesInAndStatesNotInAndDeleted

@Query("SELECT t FROM ThreadEntity t WHERE t.type IN :types AND t.state not IN :states AND t.deleted = :deleted")
List<ThreadEntity> findByTypesInAndStatesNotInAndDeleted(@Param("types")
 List<String> types,
 @Param("states")
 List<String> states,
 Boolean deleted)

findByTypesInAndStateAndDeletedFalse

@Query("SELECT t FROM ThreadEntity t WHERE t.type IN :types AND t.state = :state AND t.deleted = false")
List<ThreadEntity> findByTypesInAndStateAndDeletedFalse(@Param("types")
 List<String> types,
 @Param("state")
 String state)

findByTypesInAndStateNotAndDeletedFalse

@Query("SELECT t FROM ThreadEntity t WHERE t.type IN :types AND t.state != :state AND t.deleted = false")
List<ThreadEntity> findByTypesInAndStateNotAndDeletedFalse(@Param("types")
 List<String> types,
 @Param("state")
 String state)

countByTopicAndStateAndDeletedFalse

@Query("SELECT COUNT(*) FROM ThreadEntity t WHERE t.topic = :topic AND t.state = :state AND t.deleted = false")
int countByTopicAndStateAndDeletedFalse(@Param("topic")
 String topic,
 @Param("state")
 String state)