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 java.time.LocalDate;

import io.delphiplatform.api.v3.rdb.entity.tiktok.FactTikTokTopTrackEntity;
import io.delphiplatform.api.v3.rdb.entity.tiktok.FactTikTokTopTrackEntityId;

public interface FactTikTokTopTrackRepository extends JpaRepository<FactTikTokTopTrackEntity, FactTikTokTopTrackEntityId>,
    JpaSpecificationExecutor<FactTikTokTopTrackEntity> {

    @Query("select max(e.id.chartDate) from FactTikTokTopTrackEntity e where e.id.chartId = :chartId")
    LocalDate findMaxDateByChartId(String chartId);

}