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 TypeMethodDescriptionfindByStatus(PermissionProcessStatus status) findStalePermissionRequests(int duration) Finds all permission request that are older than thestalenessDurationand have either the statusVALIDATEDorSENT_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:StalePermissionRequestRepositoryFinds all permission request that are older than thestalenessDurationand have either the statusVALIDATEDorSENT_TO_PERMISSION_ADMINISTRATOR.- Specified by:
findStalePermissionRequestsin interfaceStalePermissionRequestRepository<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 -
stalenessDurationhours ago, with above specified status.
-
findByStatus
- Specified by:
findByStatusin interfaceStatusPermissionRequestRepository<FingridPermissionRequest>
-