seecoder-paas/src/main/java/cn/seecoder/paas/data/dao/MetricsDAO.java

package cn.seecoder.paas.data.dao;

import cn.seecoder.paas.data.entity.Metrics;
import cn.seecoder.paas.util.enums.MetricsSource;
import cn.seecoder.paas.util.enums.MetricsType;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import java.time.LocalDateTime;
import java.util.List;

@Repository
public interface MetricsDAO extends JpaRepository<Metrics, Integer> {

    List<Metrics> findByMetricsSourceAndAndMetricsSourceValueAndMetricsTypeAndMetricsTimeBetween(MetricsSource source, String metricsSourceValue, MetricsType metricsType, LocalDateTime startTime, LocalDateTime endTime);

    @Transactional
    void deleteByMetricsTimeBefore(LocalDateTime twoDaysAgo);
}