Package com.bytedesk.core.category

Interface CategoryRepository

All Superinterfaces:

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

public interface CategoryRepository
extends org.springframework.data.jpa.repository.JpaRepository<CategoryEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<CategoryEntity>

Method Summary

Modifier and Type	Method	Description
void	decrementPostCount(Long categoryId)
Boolean	existsByNameAndOrgUidAndDeletedFalse(String name, String orgUid)
Boolean	existsByUid(String uid)
List<CategoryEntity>	findByKbUidAndDeletedFalse(String kbUid)
Optional<CategoryEntity>	findByNameAndKbUidAndDeletedFalse(String name, String kbUid)
Optional<CategoryEntity>	findByNameAndTypeAndLevelAndPlatformAndDeletedFalse(String name, String type, String level, String platform)
Optional<CategoryEntity>	findByNameAndTypeAndOrgUidAndLevelAndPlatformAndDeletedFalse(String name, String type, String orgUid, String level, String platform)
List<CategoryEntity>	findByParentAndPlatformAndDeletedOrderByOrderAsc(CategoryEntity parent, String platform, Boolean deleted)
Optional<CategoryEntity>	findByUid(String uid)
void	incrementPostCount(Long categoryId)

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<CategoryEntity> findByUid(String uid)

findByParentAndPlatformAndDeletedOrderByOrderAsc

List<CategoryEntity> findByParentAndPlatformAndDeletedOrderByOrderAsc(CategoryEntity parent,
 String platform,
 Boolean deleted)

findByNameAndTypeAndOrgUidAndLevelAndPlatformAndDeletedFalse

Optional<CategoryEntity> findByNameAndTypeAndOrgUidAndLevelAndPlatformAndDeletedFalse(String name,
 String type,
 String orgUid,
 String level,
 String platform)

findByNameAndTypeAndLevelAndPlatformAndDeletedFalse

Optional<CategoryEntity> findByNameAndTypeAndLevelAndPlatformAndDeletedFalse(String name,
 String type,
 String level,
 String platform)

findByNameAndKbUidAndDeletedFalse

Optional<CategoryEntity> findByNameAndKbUidAndDeletedFalse(String name,
 String kbUid)

findByKbUidAndDeletedFalse

List<CategoryEntity> findByKbUidAndDeletedFalse(String kbUid)

existsByNameAndOrgUidAndDeletedFalse

Boolean existsByNameAndOrgUidAndDeletedFalse(String name,
 String orgUid)

existsByUid

Boolean existsByUid(String uid)

incrementPostCount

@Modifying
@Transactional
@Query("UPDATE CategoryEntity c SET c.postCount = c.postCount + 1 WHERE c.id = ?1")
void incrementPostCount(Long categoryId)

decrementPostCount

@Modifying
@Transactional
@Query("UPDATE CategoryEntity c SET c.postCount = c.postCount - 1 WHERE c.id = ?1")
void decrementPostCount(Long categoryId)