Interface CertificateRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<Certificate,String>, org.springframework.data.jpa.repository.JpaRepository<Certificate,String>, org.springframework.data.repository.ListCrudRepository<Certificate,String>, org.springframework.data.repository.ListPagingAndSortingRepository<Certificate,String>, org.springframework.data.repository.PagingAndSortingRepository<Certificate,String>, org.springframework.data.repository.query.QueryByExampleExecutor<Certificate>, org.springframework.data.repository.Repository<Certificate,String>

public interface CertificateRepository
extends org.springframework.data.jpa.repository.JpaRepository<Certificate,String>

Method Summary

Modifier and Type	Method	Description
Certificate	findBySerialNumber(String serialNumber)
int	nullifyP12IfExpired()

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

findBySerialNumber

Certificate findBySerialNumber(String serialNumber)

nullifyP12IfExpired

@Modifying
@Query("UPDATE Certificate c SET c.p12 = NULL WHERE c.expire < CURRENT_TIMESTAMP")
int nullifyP12IfExpired()