Package com.bytedesk.call.conference
Interface CallConferenceRepository
- All Superinterfaces:
org.springframework.data.repository.CrudRepository<CallConferenceEntity,,Long> org.springframework.data.jpa.repository.JpaRepository<CallConferenceEntity,,Long> org.springframework.data.jpa.repository.JpaSpecificationExecutor<CallConferenceEntity>,org.springframework.data.repository.ListCrudRepository<CallConferenceEntity,,Long> org.springframework.data.repository.ListPagingAndSortingRepository<CallConferenceEntity,,Long> org.springframework.data.repository.PagingAndSortingRepository<CallConferenceEntity,,Long> org.springframework.data.repository.query.QueryByExampleExecutor<CallConferenceEntity>,org.springframework.data.repository.Repository<CallConferenceEntity,Long>
public interface CallConferenceRepository
extends org.springframework.data.jpa.repository.JpaRepository<CallConferenceEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<CallConferenceEntity>
Call会议室仓库接口
-
Nested Class Summary
Nested classes/interfaces inherited from interface org.springframework.data.jpa.repository.JpaSpecificationExecutor
org.springframework.data.jpa.repository.JpaSpecificationExecutor.SpecificationFluentQuery<T extends Object> -
Method Summary
Modifier and TypeMethodDescriptionlongcountByCreator(String creator) 根据创建者统计会议室数量long统计启用的会议室数量long统计启用录音的会议室数量booleanexistsByConferenceName(String conferenceName) 检查会议室名称是否存在findByConferenceName(String conferenceName) 根据会议室名称查找会议室org.springframework.data.domain.Page<CallConferenceEntity>findByConferenceNameContainingIgnoreCase(String conferenceName, org.springframework.data.domain.Pageable pageable) 根据会议室名称模糊搜索findByCreator(String creator) 根据创建者查找会议室findByCreatorAndEnabledTrue(String creator) 查找指定创建者的启用会议室org.springframework.data.domain.Page<CallConferenceEntity>findByDescriptionContainingIgnoreCase(String description, org.springframework.data.domain.Pageable pageable) 根据描述模糊搜索查找禁用的会议室查找启用的会议室findByMaxMembersBetween(Integer minMembers, Integer maxMembers) 根据最大成员数量范围查找会议室查找启用录音的会议室根据UID查找会议室查找有最大成员限制的会议室查找无成员限制的会议室查找有密码保护的会议室查找无密码保护的会议室Methods inherited from interface org.springframework.data.repository.CrudRepository
count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, saveMethods inherited from interface org.springframework.data.jpa.repository.JpaRepository
deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlushMethods inherited from interface org.springframework.data.jpa.repository.JpaSpecificationExecutor
count, delete, exists, findAll, findAll, findAll, findAll, findBy, findOneMethods inherited from interface org.springframework.data.repository.ListCrudRepository
findAll, findAllById, saveAllMethods inherited from interface org.springframework.data.repository.ListPagingAndSortingRepository
findAllMethods inherited from interface org.springframework.data.repository.PagingAndSortingRepository
findAllMethods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor
count, exists, findAll, findBy, findOne
-
Method Details
-
findByUid
根据UID查找会议室 -
findByConferenceName
根据会议室名称查找会议室 -
findByEnabledTrue
List<CallConferenceEntity> findByEnabledTrue()查找启用的会议室 -
findByEnabledFalse
List<CallConferenceEntity> findByEnabledFalse()查找禁用的会议室 -
findByCreator
根据创建者查找会议室 -
findByRecordEnabledTrue
List<CallConferenceEntity> findByRecordEnabledTrue()查找启用录音的会议室 -
findByConferenceNameContainingIgnoreCase
org.springframework.data.domain.Page<CallConferenceEntity> findByConferenceNameContainingIgnoreCase(String conferenceName, org.springframework.data.domain.Pageable pageable) 根据会议室名称模糊搜索 -
findByDescriptionContainingIgnoreCase
org.springframework.data.domain.Page<CallConferenceEntity> findByDescriptionContainingIgnoreCase(String description, org.springframework.data.domain.Pageable pageable) 根据描述模糊搜索 -
existsByConferenceName
检查会议室名称是否存在 -
findPasswordProtectedConferences
@Query("SELECT c FROM CallConferenceEntity c WHERE c.password IS NOT NULL AND c.password != \'\'") List<CallConferenceEntity> findPasswordProtectedConferences()查找有密码保护的会议室 -
findPublicConferences
@Query("SELECT c FROM CallConferenceEntity c WHERE c.password IS NULL OR c.password = \'\'") List<CallConferenceEntity> findPublicConferences()查找无密码保护的会议室 -
findByMaxMembersBetween
根据最大成员数量范围查找会议室 -
countByEnabledTrue
long countByEnabledTrue()统计启用的会议室数量 -
countByRecordEnabledTrue
long countByRecordEnabledTrue()统计启用录音的会议室数量 -
countByCreator
根据创建者统计会议室数量 -
findByCreatorAndEnabledTrue
查找指定创建者的启用会议室 -
findConferencesWithMemberLimit
@Query("SELECT c FROM CallConferenceEntity c WHERE c.maxMembers IS NOT NULL AND c.maxMembers > 0") List<CallConferenceEntity> findConferencesWithMemberLimit()查找有最大成员限制的会议室 -
findConferencesWithoutMemberLimit
@Query("SELECT c FROM CallConferenceEntity c WHERE c.maxMembers IS NULL OR c.maxMembers <= 0") List<CallConferenceEntity> findConferencesWithoutMemberLimit()查找无成员限制的会议室
-