From 210663040bf65ee00b5f86545fdc31bd0356fddf Mon Sep 17 00:00:00 2001
From: yeg <1347747024@qq.com>
Date: 星期四, 27 八月 2026 16:31:53 +0800
Subject: [PATCH] feat(device): persist simulator discovery in redis
---
ruoyi-admin/src/test/java/com/ruoyi/config/FlywayMigrationContractTest.java | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/ruoyi-admin/src/test/java/com/ruoyi/config/FlywayMigrationContractTest.java b/ruoyi-admin/src/test/java/com/ruoyi/config/FlywayMigrationContractTest.java
index 8d11c51..4d7ff68 100644
--- a/ruoyi-admin/src/test/java/com/ruoyi/config/FlywayMigrationContractTest.java
+++ b/ruoyi-admin/src/test/java/com/ruoyi/config/FlywayMigrationContractTest.java
@@ -59,6 +59,30 @@
assertTrue(v7.contains("ELSE 'REGISTERED'"));
assertTrue(v7.contains("uk_cabinet_mac_del"));
assertFalse(v7.matches("(?s).*\\bDELETE\\s+FROM\\b.*"));
+
+ String v8 = resource("db/migration/V8__complete_collector_page_contract.sql");
+ assertTrue(v8.contains("ALTER TABLE t_collector"));
+ assertTrue(v8.contains("test_status"));
+ assertTrue(v8.contains("current_test"));
+ assertTrue(v8.contains("current_sample_name"));
+ assertTrue(v8.contains("chk_collector_test_status"));
+ assertFalse(v8.matches("(?s).*\\bDELETE\\s+FROM\\b.*"));
+
+ String v9 = resource("db/migration/V9__move_discovery_candidates_to_redis.sql");
+ assertTrue(v9.contains("adapter_code VARCHAR(64)"));
+ assertTrue(v9.contains("adapter.adapter_code = 'dev-sim'"));
+ assertTrue(v9.contains("cabinet.registration_status = 'DISCOVERED'"));
+ assertTrue(v9.contains("t_test_channel_binding"));
+ assertTrue(v9.contains("t_test_sample"));
+ assertTrue(v9.contains("t_device_run_event"));
+ assertTrue(v9.contains("SELECT protected_cabinet.cabinet_id"));
+ assertTrue(v9.contains("SELECT DISTINCT sibling.cabinet_id"));
+ assertTrue(v9.contains("uk_channel_stable_identity"));
+ assertTrue(v9.contains("ADD KEY idx_cabinet_adapter (adapter_id)"));
+ assertTrue(v9.contains("SET adapter_id = NULL WHERE adapter_code = 'dev-sim'"));
+ assertFalse(v9.contains("DROP FOREIGN KEY fk_channel_adapter"));
+ assertFalse(v9.contains("DROP FOREIGN KEY fk_cabinet_adapter"));
+ assertFalse(v9.matches("(?s).*t_test_battery\\s+\\w+\\s+WHERE\\s+\\w+\\.cabinet_id.*"));
}
private static String sha256(String path)
--
Gitblit v1.7.1