Package energy.eddie.outbound.metric.repositories

Interface PermissionRequestStatusDurationRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<PermissionRequestStatusDurationModel,Long>, org.springframework.data.jpa.repository.JpaRepository<PermissionRequestStatusDurationModel,Long>, org.springframework.data.repository.ListCrudRepository<PermissionRequestStatusDurationModel,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<PermissionRequestStatusDurationModel,Long>, org.springframework.data.repository.PagingAndSortingRepository<PermissionRequestStatusDurationModel,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<PermissionRequestStatusDurationModel>, org.springframework.data.repository.Repository<PermissionRequestStatusDurationModel,Long>

@Repository
public interface PermissionRequestStatusDurationRepository
extends org.springframework.data.jpa.repository.JpaRepository<PermissionRequestStatusDurationModel,Long>

Method Summary

Modifier and Type	Method	Description
double	getMedianDurationMilliseconds(String status, String dataNeedType, String permissionAdministratorId, String regionConnectorId, String countryCode)

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

Methods inherited from interface org.springframework.data.repository.ListCrudRepository

findAll, findAllById, saveAll

Methods inherited from interface org.springframework.data.repository.ListPagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findBy, findOne

Method Details

getMedianDurationMilliseconds

@Query(value="SELECT percentile_cont(0.5) WITHIN GROUP (ORDER BY duration_milliseconds)\nFROM metric.permission_request_status_duration\nWHERE permission_request_status = :status AND\n      data_need_type = :dataNeedType AND\n      region_connector_id = :regionConnectorId AND\n      permission_administrator_id = :permissionAdministratorId AND\n      country_code = :countryCode\n",
       nativeQuery=true)
double getMedianDurationMilliseconds(@Param("status")
 String status,
 @Param("dataNeedType")
 String dataNeedType,
 @Param("permissionAdministratorId")
 String permissionAdministratorId,
 @Param("regionConnectorId")
 String regionConnectorId,
 @Param("countryCode")
 String countryCode)