Package energy.eddie.regionconnector.be.fluvius.persistence

Interface BePermissionRequestRepository

All Superinterfaces:

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

@Repository
public interface BePermissionRequestRepository
extends org.springframework.data.repository.Repository<FluviusPermissionRequest,String>, FullPermissionRequestRepository<FluviusPermissionRequest>

Method Summary

Modifier and Type	Method	Description
List<FluviusPermissionRequest>	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

findStalePermissionRequests

@Query(value="SELECT permission_id, connection_id, data_need_id, status, data_start, data_end, granularity, flow, created, short_url_identifier FROM be_fluvius.permission_request WHERE status = \'SENT_TO_PERMISSION_ADMINISTRATOR\' AND created <= NOW() - :hours * INTERVAL \'1 hour\'",
       nativeQuery=true)
List<FluviusPermissionRequest> 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<FluviusPermissionRequest>

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.