NlPermissionRequestRepository (eddie 0.0.0 API)

All Superinterfaces:: PermissionRequestRepository<MijnAansluitingPermissionRequest>, org.springframework.data.repository.Repository<MijnAansluitingPermissionRequest,String>, StalePermissionRequestRepository<MijnAansluitingPermissionRequest>, StatusPermissionRequestRepository<MijnAansluitingPermissionRequest>

@Repository public interface NlPermissionRequestRepository extends org.springframework.data.repository.Repository<MijnAansluitingPermissionRequest,String>, PermissionRequestRepository<MijnAansluitingPermissionRequest>, StalePermissionRequestRepository<MijnAansluitingPermissionRequest>, StatusPermissionRequestRepository<MijnAansluitingPermissionRequest>

Method Summary

Modifier and Type

Method

Description

boolean

existsByPermissionIdAndStatus(String permissionId, PermissionProcessStatus status)

Optional<MijnAansluitingPermissionRequest>

findByStateAndPermissionId(String state, String permissionId)

List<MijnAansluitingPermissionRequest>

findByStatus(PermissionProcessStatus status)

List<MijnAansluitingPermissionRequest>

findStalePermissionRequests(int timeoutDuration)

Finds all permission request that are older than the stalenessDuration and have either the status VALIDATED or SENT_TO_PERMISSION_ADMINISTRATOR.

Methods inherited from interface energy.eddie.api.agnostic.process.model.persistence.PermissionRequestRepository
findByPermissionId, getByPermissionId, save

Method Details
- findByStateAndPermissionId
  
  Optional<MijnAansluitingPermissionRequest> findByStateAndPermissionId(String state, String permissionId)
- findByStatus
  
  List<MijnAansluitingPermissionRequest> findByStatus(PermissionProcessStatus status)
  
  Specified by:
  
  findByStatus in interface StatusPermissionRequestRepository<MijnAansluitingPermissionRequest>
- existsByPermissionIdAndStatus
  
  boolean existsByPermissionIdAndStatus(String permissionId, PermissionProcessStatus status)
- findStalePermissionRequests
  
  @Query(value="SELECT * FROM nl_mijn_aansluiting.permission_request WHERE status = \'VALIDATED\' AND created <= NOW() - :hours * INTERVAL \'1 hour\'", nativeQuery=true) List<MijnAansluitingPermissionRequest> findStalePermissionRequests(@Param("hours") int timeoutDuration)
  
  Description copied from interface: StalePermissionRequestRepository
  
  Finds all permission request that are older than the stalenessDuration and have either the status VALIDATED or SENT_TO_PERMISSION_ADMINISTRATOR.
  
  Specified by:
  
  findStalePermissionRequests in interface StalePermissionRequestRepository<MijnAansluitingPermissionRequest>
  
  Parameters:
  
  timeoutDuration - the max amount of hours the permission request has to be created ago to not be considered stale.
  
  Returns:
  
  all permission request created now - stalenessDuration hours ago, with above specified status.