package com.battery.business.runtime;

import static org.junit.jupiter.api.Assertions.assertFalse;
import static org.junit.jupiter.api.Assertions.assertTrue;
import java.io.InputStream;
import java.nio.charset.StandardCharsets;
import org.junit.jupiter.api.Test;

/** Ticket26 迁移只增加行为查询索引，不建立按行或按格修订表。 */
class Ticket26MigrationContractTest
{
    @Test
    void addsActionQueryIndexWithoutReplacingAuditFacts() throws Exception
    {
        try (InputStream stream = getClass().getClassLoader().getResourceAsStream(
                "db/migration/V26__data_revision_action_query_contract.sql"))
        {
            if (stream == null) throw new AssertionError("缺少 Ticket26 迁移");
            String sql = new String(stream.readAllBytes(), StandardCharsets.UTF_8);
            assertTrue(sql.contains("idx_data_revision_query_time"));
            assertTrue(sql.contains("t_test_data_revision_action"));
            assertFalse(sql.matches("(?s).*\\b(DROP|DELETE|UPDATE)\\b.*"));
        }
    }
}