Package com.bytedesk.service.agent

Interface AgentRepository

All Superinterfaces:

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

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

Method Summary

Modifier and Type	Method	Description
boolean	existsByUid(String uid)
Boolean	existsByUserUidAndOrgUidAndDeletedFalse(String userUid, String orgUid)
List<AgentEntity>	findByConnectedAndDeletedFalse(boolean connected)
List<String>	findByConnectedAndEnabled(boolean connected)
Optional<AgentEntity>	findByEmailAndOrgUidAndDeletedFalse(String email, String orgUid)
Optional<AgentEntity>	findByMobileAndOrgUidAndDeletedFalse(String mobile, String orgUid)
List<AgentEntity>	findByOrgUid(String orgUid)
List<String>	findByStatusAndEnabled(String status)
Optional<AgentEntity>	findByUid(String uid)
Optional<AgentEntity>	findByUserUid(String userUid)
Optional<AgentEntity>	findByUserUidAndOrgUidAndDeletedFalse(String userUid, String orgUid)
String	getAgentStatus(String agentUid)
void	updateConnectedByUserUid(Boolean connected, String userUid)
void	updateDeletedByUid(Boolean deleted, String uid)
void	updateStatus(String agentUid, String status)
void	updateStatusByUid(String status, String uid)

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

findByUserUid

Optional<AgentEntity> findByUserUid(String userUid)

findByOrgUid

List<AgentEntity> findByOrgUid(String orgUid)

findByEmailAndOrgUidAndDeletedFalse

Optional<AgentEntity> findByEmailAndOrgUidAndDeletedFalse(String email,
 String orgUid)

findByMobileAndOrgUidAndDeletedFalse

Optional<AgentEntity> findByMobileAndOrgUidAndDeletedFalse(String mobile,
 String orgUid)

findByUserUidAndOrgUidAndDeletedFalse

Optional<AgentEntity> findByUserUidAndOrgUidAndDeletedFalse(String userUid,
 String orgUid)

findByConnectedAndDeletedFalse

List<AgentEntity> findByConnectedAndDeletedFalse(boolean connected)

existsByUserUidAndOrgUidAndDeletedFalse

Boolean existsByUserUidAndOrgUidAndDeletedFalse(String userUid,
 String orgUid)

updateConnectedByUserUid

@Transactional
@Modifying
@Query(value="update bytedesk_service_agent set is_connected = :connected where user_uid = :userUid",
       nativeQuery=true)
void updateConnectedByUserUid(@Param("connected")
 Boolean connected,
 @Param("userUid")
 String userUid)

updateDeletedByUid

@Transactional
@Modifying
@Query("update AgentEntity set deleted = :deleted where uid = :uid")
void updateDeletedByUid(@Param("deleted")
 Boolean deleted,
 @Param("uid")
 String uid)

updateStatusByUid

@Transactional
@Modifying
@Query(value="update bytedesk_service_agent set status = :status where uuid = :uid",
       nativeQuery=true)
void updateStatusByUid(@Param("status")
 String status,
 @Param("uid")
 String uid)

findByStatusAndEnabled

@Query("SELECT a.uid FROM AgentEntity a WHERE a.status = :status AND a.enabled = true")
List<String> findByStatusAndEnabled(@Param("status")
 String status)

findByConnectedAndEnabled

@Query("SELECT a.uid FROM AgentEntity a WHERE a.connected = :connected AND a.enabled = true")
List<String> findByConnectedAndEnabled(@Param("connected")
 boolean connected)

getAgentStatus

@Query("SELECT a.status FROM AgentEntity a WHERE a.uid = :agentUid")
String getAgentStatus(@Param("agentUid")
 String agentUid)

updateStatus

@Modifying
@Query("UPDATE AgentEntity a SET a.status = :status WHERE a.uid = :agentUid")
void updateStatus(@Param("agentUid")
 String agentUid,
 @Param("status")
 String status)

existsByUid

boolean existsByUid(String uid)