Package energy.eddie.regionconnector.fi.fingrid.persistence

Interface FiPermissionRequestRepository

All Superinterfaces:

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

@Repository
public interface FiPermissionRequestRepository
extends FullPermissionRequestRepository<FingridPermissionRequest>, org.springframework.data.repository.Repository<FingridPermissionRequest,String>

Method Summary

Modifier and Type	Method	Description
List<FingridPermissionRequest>	findByStatus(PermissionProcessStatus status)
List<FingridPermissionRequest>	findStalePermissionRequests(int duration)	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

findStalePermissionRequests

@Query(value="SELECT permission_id, connection_id, created, data_need_id, granularity, permission_start, permission_end, status, customer_identification FROM fi_fingrid.permission_request WHERE status = \'VALIDATED\' AND created <= NOW() - :hours * INTERVAL \'1 hour\'",
       nativeQuery=true)
List<FingridPermissionRequest> findStalePermissionRequests(@Param("hours")
 int duration)

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

Parameters:

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

findByStatus

List<FingridPermissionRequest> findByStatus(PermissionProcessStatus status)

Specified by:

findByStatus in interface StatusPermissionRequestRepository<FingridPermissionRequest>