package io.delphiplatform.api.v3.rdb.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import io.delphiplatform.api.v3.model.datahealth.DataHealthChartPosition;
import io.delphiplatform.api.v3.rdb.entity.shazam.FactShazamChartEntity;
import io.delphiplatform.api.v3.rdb.entity.shazam.FactShazamChartId;

public interface FactShazamChartRepository extends JpaRepository<FactShazamChartEntity, FactShazamChartId>,
    JpaSpecificationExecutor<FactShazamChartEntity> {

    @Query("SELECT new io.delphiplatform.api.v3.model.datahealth.DataHealthChartPosition("
        + " 'shazam_top', 'shazam', MIN(date),  MAX(date)) FROM FactShazamChartEntity")
    DataHealthChartPosition getMinMaxDates();
}