package com.ruoyi.config;

import static org.junit.jupiter.api.Assertions.assertTrue;

import java.io.InputStream;
import java.nio.charset.StandardCharsets;
import org.junit.jupiter.api.Test;

/** Ticket28 迁移必须移除区间、租约、补采和完整性遗留模型。 */
class Ticket28MigrationContractTest
{
    @Test
    void removesLegacyTablesColumnsAndConstraints()
    {
        String sql = resource("db/migration/V28__remove_reception_backfill_integrity_legacy.sql");
        assertTrue(sql.contains("DROP TABLE t_test_reception_interval"));
        assertTrue(sql.contains("DROP TABLE t_collector_channel_lease"));
        assertTrue(sql.contains("DROP TABLE t_channel_lease"));
        assertTrue(sql.contains("DROP FOREIGN KEY fk_sample_reception_interval"));
        assertTrue(sql.contains("DROP FOREIGN KEY fk_collector_sample_reception_interval"));
        assertTrue(sql.contains("DROP COLUMN reception_interval_id"));
        assertTrue(sql.contains("DROP COLUMN backfill_status"));
        assertTrue(sql.contains("DROP COLUMN backfill_started_at_utc"));
        assertTrue(sql.contains("DROP COLUMN backfill_completed_at_utc"));
    }

    private static String resource(String path)
    {
        try (InputStream stream = Ticket28MigrationContractTest.class.getClassLoader().getResourceAsStream(path))
        {
            if (stream == null) throw new AssertionError("Missing migration resource " + path);
            return new String(stream.readAllBytes(), StandardCharsets.UTF_8);
        }
        catch (Exception exception)
        {
            throw new AssertionError("Unable to read migration resource " + path, exception);
        }
    }
}