Interface FrPermissionRequestRepository
- All Superinterfaces:
org.springframework.data.repository.CrudRepository<EnedisPermissionRequest,,String> PermissionRequestRepository<FrEnedisPermissionRequest>,org.springframework.data.repository.Repository<EnedisPermissionRequest,,String> StalePermissionRequestRepository<EnedisPermissionRequest>,StatusPermissionRequestRepository<FrEnedisPermissionRequest>
@Repository
public interface FrPermissionRequestRepository
extends org.springframework.data.repository.CrudRepository<EnedisPermissionRequest,String>, PermissionRequestRepository<FrEnedisPermissionRequest>, StalePermissionRequestRepository<EnedisPermissionRequest>, StatusPermissionRequestRepository<FrEnedisPermissionRequest>
-
Method Summary
Modifier and TypeMethodDescriptionfindByStatus(PermissionProcessStatus status) findStalePermissionRequests(int timeoutDuration) Finds all permission request that are older than thestalenessDurationand have either the statusVALIDATEDorSENT_TO_PERMISSION_ADMINISTRATOR.Methods inherited from interface org.springframework.data.repository.CrudRepository
count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findAll, findAllById, findById, save, saveAllMethods inherited from interface energy.eddie.api.agnostic.process.model.persistence.PermissionRequestRepository
findByPermissionId, getByPermissionId, save
-
Method Details
-
findByStatus
- Specified by:
findByStatusin interfaceStatusPermissionRequestRepository<FrEnedisPermissionRequest>
-
findStalePermissionRequests
@Query(value="SELECT permission_id, connection_id, permission_start, permission_end, data_need_id, status, granularity, usage_point_id, latest_meter_reading_end_date, created, usage_point_type FROM fr_enedis.enedis_permission_request WHERE status = \'VALIDATED\' AND created <= NOW() - :hours * INTERVAL \'1 hour\'", nativeQuery=true) List<EnedisPermissionRequest> findStalePermissionRequests(@Param("hours") int timeoutDuration) Description copied from interface:StalePermissionRequestRepositoryFinds all permission request that are older than thestalenessDurationand have either the statusVALIDATEDorSENT_TO_PERMISSION_ADMINISTRATOR.- Specified by:
findStalePermissionRequestsin interfaceStalePermissionRequestRepository<EnedisPermissionRequest>- 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 -
stalenessDurationhours ago, with above specified status.
-