Package com.epam.ta.reportportal.dao

Interface SenderCaseRepository

  • All Superinterfaces:
    org.springframework.data.repository.CrudRepository<SenderCase,​java.lang.Long>, org.springframework.data.jpa.repository.JpaRepository<SenderCase,​java.lang.Long>, org.springframework.data.repository.PagingAndSortingRepository<SenderCase,​java.lang.Long>, org.springframework.data.repository.query.QueryByExampleExecutor<SenderCase>, ReportPortalRepository<SenderCase,​java.lang.Long>, org.springframework.data.repository.Repository<SenderCase,​java.lang.Long>
    public interface SenderCaseRepository
extends ReportPortalRepository<SenderCase,​java.lang.Long>

    • Method Summary

      All Methods Instance Methods Abstract Methods 
      Modifier and Type Method Description
      int deleteRecipients​(java.lang.Long id, java.util.Collection<java.lang.String> recipients)  
      java.util.List<SenderCase> findAllByProjectId​(java.lang.Long projectId)  

      • Methods inherited from interface org.springframework.data.repository.CrudRepository

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

      • Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

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

      • Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

        findAll

      • Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

        count, exists, findAll, findOne

    • Method Detail

      • findAllByProjectId

        @Query("SELECT sc FROM SenderCase sc WHERE sc.project.id = :projectId")
java.util.List<SenderCase> findAllByProjectId​(@Param("projectId")
                                              java.lang.Long projectId)

      • deleteRecipients

        @Modifying
@Query(value="DELETE FROM recipients WHERE sender_case_id = :id AND recipient IN (:recipients)",
       nativeQuery=true)
int deleteRecipients​(@Param("id")
                     java.lang.Long id,
                     @Param("recipients")
                     java.util.Collection<java.lang.String> recipients)