io.xiaper.jpa.repository

接口 MessageRepository

所有超级接口:

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

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

作者:

xiaper.io

方法概要

限定符和类型	方法和说明
org.springframework.data.domain.Page<Message>	findByCidAndUserOrCidAndUserAndDeletedSetNotContains(String cid1, User user1, String cid2, User user2, User user3, org.springframework.data.domain.Pageable pageable)
List<Message>	findByCreatedAtBetweenAndSessionType(Date startAt, Date endAt, String sessionType) 某个时间段内的所有消息
List<Message>	findByGidAndDeletedSetNotContains(String gid, User user)
org.springframework.data.domain.Page<Message>	findByGidAndDeletedSetNotContains(String gid, User user, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<Message>	findByIdAndCidAndUserOrCidAndUser(Long id, String cid1, Long user1_id, String cid2, Long user2_id, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<Message>	findByIdAndGid(Long id, String gid, org.springframework.data.domain.Pageable pageable) 加载某条聊天记录之后的数据
org.springframework.data.domain.Page<Message>	findByIdAndThread_Visitor(Long id, Long visitor_id, org.springframework.data.domain.Pageable pageable)
Optional<Message>	findByMid(String mid)
org.springframework.data.domain.Page<Message>	findByThread_VisitorAndDeletedSetNotContains(User visitor, User user, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<Message>	findByThread_WorkGroup_User(User user, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<Message>	findByThread(Thread thread, org.springframework.data.domain.Pageable pageable)
List<Message>	findByThreadAndDeletedSetNotContains(Thread thread, User user)
Optional<Message>	findFirstByThreadAndTypeOrderByIdDesc(Thread thread, String type)

从接口继承的方法 org.springframework.data.jpa.repository.JpaRepository

deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlush

从接口继承的方法 org.springframework.data.repository.PagingAndSortingRepository

findAll

从接口继承的方法 org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteById, existsById, findById, save

从接口继承的方法 org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findOne

从接口继承的方法 org.springframework.data.jpa.repository.JpaSpecificationExecutor

count, findAll, findAll, findAll, findOne

方法详细资料

findByMid

Optional<Message> findByMid(String mid)

findByGidAndDeletedSetNotContains

org.springframework.data.domain.Page<Message> findByGidAndDeletedSetNotContains(String gid,
                                                                                User user,
                                                                                org.springframework.data.domain.Pageable pageable)

findByCidAndUserOrCidAndUserAndDeletedSetNotContains

org.springframework.data.domain.Page<Message> findByCidAndUserOrCidAndUserAndDeletedSetNotContains(String cid1,
                                                                                                   User user1,
                                                                                                   String cid2,
                                                                                                   User user2,
                                                                                                   User user3,
                                                                                                   org.springframework.data.domain.Pageable pageable)

findByThread

org.springframework.data.domain.Page<Message> findByThread(Thread thread,
                                                           org.springframework.data.domain.Pageable pageable)

findByThreadAndDeletedSetNotContains

List<Message> findByThreadAndDeletedSetNotContains(Thread thread,
                                                   User user)

findByGidAndDeletedSetNotContains

List<Message> findByGidAndDeletedSetNotContains(String gid,
                                                User user)

findFirstByThreadAndTypeOrderByIdDesc

Optional<Message> findFirstByThreadAndTypeOrderByIdDesc(Thread thread,
                                                        String type)

findByThread_VisitorAndDeletedSetNotContains

org.springframework.data.domain.Page<Message> findByThread_VisitorAndDeletedSetNotContains(User visitor,
                                                                                           User user,
                                                                                           org.springframework.data.domain.Pageable pageable)

findByThread_WorkGroup_User

org.springframework.data.domain.Page<Message> findByThread_WorkGroup_User(User user,
                                                                          org.springframework.data.domain.Pageable pageable)

findByIdAndThread_Visitor

@Query(value="select * from message m left outer join thread t on m.thread_id=t.id where m.id < :id and t.visitor_id = :visitor_id",
       nativeQuery=true)
org.springframework.data.domain.Page<Message> findByIdAndThread_Visitor(@Param(value="id")
                                                                                                                                                                                                                                      Long id,
                                                                                                                                                                                                                                      @Param(value="visitor_id")
                                                                                                                                                                                                                                      Long visitor_id,
                                                                                                                                                                                                                                      org.springframework.data.domain.Pageable pageable)

findByIdAndCidAndUserOrCidAndUser

@Query(value="select * from message m where m.id < :id and ( ( m.cid = :cid1 and m.users_id = :user1_id ) or ( m.cid = :cid2 and m.users_id = :user2_id ) )",
       nativeQuery=true)
org.springframework.data.domain.Page<Message> findByIdAndCidAndUserOrCidAndUser(@Param(value="id")
                                                                                                                                                                                                                                                                       Long id,
                                                                                                                                                                                                                                                                       @Param(value="cid1")
                                                                                                                                                                                                                                                                       String cid1,
                                                                                                                                                                                                                                                                       @Param(value="user1_id")
                                                                                                                                                                                                                                                                       Long user1_id,
                                                                                                                                                                                                                                                                       @Param(value="cid2")
                                                                                                                                                                                                                                                                       String cid2,
                                                                                                                                                                                                                                                                       @Param(value="user2_id")
                                                                                                                                                                                                                                                                       Long user2_id,
                                                                                                                                                                                                                                                                       org.springframework.data.domain.Pageable pageable)

findByIdAndGid

@Query(value="select * from message m where m.id < :id and m.gid = :gid",
       nativeQuery=true)
org.springframework.data.domain.Page<Message> findByIdAndGid(@Param(value="id")
                                                                                                                                                                Long id,
                                                                                                                                                                @Param(value="gid")
                                                                                                                                                                String gid,
                                                                                                                                                                org.springframework.data.domain.Pageable pageable)

加载某条聊天记录之后的数据

参数:

id - id

gid - gid

pageable - 分页

返回:

聊天记录

findByCreatedAtBetweenAndSessionType

List<Message> findByCreatedAtBetweenAndSessionType(Date startAt,
                                                   Date endAt,
                                                   String sessionType)

某个时间段内的所有消息

参数:

startAt - 起始时间

endAt - 结束时间

sessionType - 会话类型

返回:

聊天记录