package ru.mcs.tracker.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import ru.mcs.tracker.entity.LocationEntity;

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

public interface LocationRepository extends JpaRepository<LocationEntity, Long> {
    @Query("SELECT l FROM LocationEntity l WHERE l.deviceGuid = :deviceGuid AND l.timestamp BETWEEN :start AND :end ORDER BY l.timestamp")
    List<LocationEntity> findByDeviceGuidAndTimestampBetween(
            @Param("deviceGuid") String deviceGuid,
            @Param("start") LocalDateTime start,
            @Param("end") LocalDateTime end
    );
}