Package energy.eddie.outbound.metric.repositories

Interface PermissionRequestMetricsRepository

All Superinterfaces:

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

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

Method Summary

Modifier and Type	Method	Description
Optional<PermissionRequestMetricsModel>	getPermissionRequestMetrics(PermissionProcessStatus status, String dataNeedType, String permissionAdminId, String regionConnectorId, String countryCode)
void	upsertPermissionRequestMetric(double mean, double median, int permissionRequestCount, String permissionRequestStatus, 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

getPermissionRequestMetrics

@Query("SELECT p FROM PermissionRequestMetricsModel p WHERE p.permissionRequestStatus = :status AND p.dataNeedType = :dataNeedType AND p.permissionAdministratorId = :permissionAdminId AND p.regionConnectorId = :regionConnectorId AND p.countryCode = :countryCode")
Optional<PermissionRequestMetricsModel> getPermissionRequestMetrics(@Param("status")
 PermissionProcessStatus status,
 @Param("dataNeedType")
 String dataNeedType,
 @Param("permissionAdminId")
 String permissionAdminId,
 @Param("regionConnectorId")
 String regionConnectorId,
 @Param("countryCode")
 String countryCode)

upsertPermissionRequestMetric

@Modifying
@Transactional
@Query(value="INSERT INTO metric.permission_request_metrics (mean, median, permission_request_count, permission_request_status,\n    data_need_type, permission_administrator_id, region_connector_id, country_code)\nVALUES (:mean, :median, :permissionRequestCount, :permissionRequestStatus, :dataNeedType, :permissionAdministratorId,\n    :regionConnectorId, :countryCode)\nON CONFLICT (permission_request_status, data_need_type, permission_administrator_id, region_connector_id, country_code)\nDO UPDATE SET\n    mean = EXCLUDED.mean,\n    median = EXCLUDED.median,\n    permission_request_count = EXCLUDED.permission_request_count\n",
       nativeQuery=true)
void upsertPermissionRequestMetric(@Param("mean")
 double mean,
 @Param("median")
 double median,
 @Param("permissionRequestCount")
 int permissionRequestCount,
 @Param("permissionRequestStatus")
 String permissionRequestStatus,
 @Param("dataNeedType")
 String dataNeedType,
 @Param("permissionAdministratorId")
 String permissionAdministratorId,
 @Param("regionConnectorId")
 String regionConnectorId,
 @Param("countryCode")
 String countryCode)