Package com.bytedesk.kbase.faq

Interface FaqRepository

All Superinterfaces:

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

public interface FaqRepository
extends org.springframework.data.jpa.repository.JpaRepository<FaqEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<FaqEntity>

Method Summary

Modifier and Type	Method	Description
Boolean	existsByQuestionAndAnswerAndKbase_UidAndOrgUidAndDeletedFalse(String question, String answer, String kbUid, String orgUid)
Boolean	existsByUid(String uid)
List<FaqEntity>	findByKbase_UidAndDeletedFalse(String kbUid)
List<FaqEntity>	findByQuestionContains(String question)
Optional<FaqEntity>	findByUid(String uid)
List<FaqEntity>	findRandomFaq(int limit)	获取随机FAQ，用于测试

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

existsByUid

Boolean existsByUid(String uid)

findByKbase_UidAndDeletedFalse

List<FaqEntity> findByKbase_UidAndDeletedFalse(String kbUid)

findByQuestionContains

List<FaqEntity> findByQuestionContains(String question)

existsByQuestionAndAnswerAndKbase_UidAndOrgUidAndDeletedFalse

Boolean existsByQuestionAndAnswerAndKbase_UidAndOrgUidAndDeletedFalse(String question,
 String answer,
 String kbUid,
 String orgUid)

findRandomFaq

@Query(value="SELECT * FROM faq WHERE deleted = false ORDER BY RAND() LIMIT :limit",
       nativeQuery=true)
List<FaqEntity> findRandomFaq(@Param("limit")
 int limit)

获取随机FAQ，用于测试

Parameters:

limit - 限制返回的数量

Returns:

随机FAQ列表