Package energy.eddie.regionconnector.cds.persistence

Interface CdsPermissionRequestRepository

All Superinterfaces:

FullPermissionRequestRepository<CdsPermissionRequest>, PermissionRequestRepository<CdsPermissionRequest>, org.springframework.data.repository.Repository<CdsPermissionRequest,String>, StalePermissionRequestRepository<CdsPermissionRequest>, StatusPermissionRequestRepository<CdsPermissionRequest>

@Repository
public interface CdsPermissionRequestRepository
extends FullPermissionRequestRepository<CdsPermissionRequest>, org.springframework.data.repository.Repository<CdsPermissionRequest,String>

Method Summary

Modifier and Type	Method	Description
Optional<CdsPermissionRequest>	findByState(String state)
Collection<CdsPermissionRequest>	findStalePermissionRequests(int stalenessDuration)	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

Methods inherited from interface energy.eddie.api.agnostic.process.model.persistence.StatusPermissionRequestRepository

findByStatus

Method Details

findByState

Optional<CdsPermissionRequest> findByState(String state)

findStalePermissionRequests

@Query(value="SELECT *\nFROM cds.permission_request WHERE status = \'SENT_TO_PERMISSION_ADMINISTRATOR\' AND (created <= NOW() - :hours * INTERVAL \'1 hour\' OR auth_expires_at <= NOW())\n",
       nativeQuery=true)
Collection<CdsPermissionRequest> findStalePermissionRequests(@Param("hours")
 int stalenessDuration)

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

Parameters:

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