yeg
2026-08-30 20b346ef9d4fcbbbe05abfe08e4f4f0303b0812e
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
42
43
44
45
46
47
48
49
package com.ruoyi.config;
 
import static org.junit.jupiter.api.Assertions.assertTrue;
import static org.junit.jupiter.api.Assertions.assertFalse;
 
import java.io.InputStream;
import java.nio.charset.StandardCharsets;
import org.junit.jupiter.api.Test;
 
/** 测试双设备绑定、字段快照和接收状态的 Mapper 契约。 */
class TestDeviceBindingMapperContractTest
{
    @Test
    void persistsAndReadsCollectorMappingsAndFieldSnapshots()
    {
        String mapper = resource("mapper/system/TTestMapper.xml");
        String snapshotMapper = resource("mapper/system/TSharedFieldSnapshotMapper.xml");
 
        assertTrue(mapper.contains("id=\"insertTestCollectorChannel\""));
        assertTrue(mapper.contains("id=\"selectTestCollectorChannels\""));
        assertTrue(snapshotMapper.contains("id=\"insert\""));
        assertTrue(snapshotMapper.contains("id=\"selectByTestId\""));
        assertTrue(mapper.contains("reception_status = 'NOT_STARTED'"));
        assertTrue(mapper.contains("channel_count channelCount"));
        assertTrue(mapper.contains("id=\"selectBatteryNosByTestIds\""));
        assertTrue(mapper.contains("channel_fact.channel_id channelId"));
        assertTrue(mapper.contains("id=\"selectReceptionChannelForUpdate\""));
        assertTrue(mapper.contains("channel_fact.online_status onlineStatus"));
        assertTrue(mapper.contains("channel_fact.last_seen_at_utc lastSeenAtUtc"));
        assertTrue(mapper.contains("then 'RUNNING_ABNORMAL'"));
        assertTrue(mapper.contains("exception_fact.interval_status = 'OPEN'"));
        assertTrue(mapper.contains("set test_status = 'COMPLETED'"));
        assertTrue(mapper.contains("#{testStatus} = 'COMPLETED' and t.test_status in ('COMPLETED', 'TERMINATED')"));
        assertFalse(mapper.contains("group_concat"));
    }
 
    private static String resource(String path)
    {
        try (InputStream stream = TestDeviceBindingMapperContractTest.class.getClassLoader().getResourceAsStream(path))
        {
            if (stream == null) throw new AssertionError("缺少资源 " + path);
            return new String(stream.readAllBytes(), StandardCharsets.UTF_8);
        }
        catch (Exception exception)
        {
            throw new AssertionError("无法读取资源 " + path, exception);
        }
    }
}