package com.ruoyi.web.controller.system;

import static org.junit.jupiter.api.Assertions.assertTrue;
import java.nio.charset.StandardCharsets;
import java.nio.file.Files;
import java.nio.file.Path;
import org.junit.jupiter.api.Test;

/** Ticket15：结果查询必须从区间历史表读取，并排除实时和未完成测试。 */
class Ticket15ResultQueryContractTest
{
    @Test
    void historicalResultQueryUsesCompletedIntervalHistory()
    {
        Path mapper = Path.of("../ruoyi-system/src/main/resources/mapper/system/TTestMapper.xml");
        String xml;
        try
        {
            xml = Files.readString(mapper, StandardCharsets.UTF_8);
        }
        catch (Exception exception)
        {
            throw new AssertionError(exception);
        }
        assertTrue(xml.contains("id=\"selectHistoricalResultRecords\""));
        assertTrue(xml.contains("t_test_sample s"));
        assertTrue(xml.contains("t_test_collector_sample cs"));
        assertTrue(xml.contains("t.test_status = 'COMPLETED'"));
        assertTrue(xml.contains("i.interval_status = 'CLOSED'"));
        assertTrue(xml.contains("union all"));
    }
}