Package hu.rts.mike.example.dev.crm.repository

Interface ContactRepository

All Superinterfaces:

ContactRepositoryCustom, org.springframework.data.repository.CrudRepository<Contact,Integer>, org.springframework.data.jpa.repository.JpaRepository<Contact,Integer>, org.springframework.data.repository.ListCrudRepository<Contact,Integer>, org.springframework.data.repository.ListPagingAndSortingRepository<Contact,Integer>, org.springframework.data.repository.PagingAndSortingRepository<Contact,Integer>, org.springframework.data.repository.query.QueryByExampleExecutor<Contact>, org.springframework.data.repository.Repository<Contact,Integer>

@Repository
public interface ContactRepository
extends org.springframework.data.jpa.repository.JpaRepository<Contact,Integer>, ContactRepositoryCustom

Method Summary

Modifier and Type	Method	Description
int	batchSoftDelete(Set<Integer> ids, Instant inactive)
int	restoreSoftDelete(Set<Integer> ids)

Methods inherited from interface hu.rts.mike.example.dev.crm.repository.ContactRepositoryCustom

findAllForGrid, findById

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.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

batchSoftDelete

@Modifying
@Query("UPDATE Contact SET inactive = :inactive WHERE id IN :ids AND inactive IS NULL")
int batchSoftDelete(@Param("ids")
 Set<Integer> ids,
 @Param("inactive")
 Instant inactive)

restoreSoftDelete

@Modifying
@Query("UPDATE Contact SET inactive = NULL WHERE id IN :ids")
int restoreSoftDelete(@Param("ids")
 Set<Integer> ids)