彻底清理补采完整性遗留依赖

yeg

2026-09-02 4eaa4be4d2cbd2aa49d36a313ce71ad3e743db4a

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
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 TABLE t_data_gap"));
        assertTrue(sql.contains("DROP TABLE t_history_sync_cursor"));
        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);
        }
    }
}