From 2b7078fd0978ce4074c88b253a42803631f8bc0d Mon Sep 17 00:00:00 2001
From: yeg <1347747024@qq.com>
Date: 星期日, 30 八月 2026 16:48:27 +0800
Subject: [PATCH] 补充运行中接入字段迁移
---
ruoyi-admin/src/test/java/com/ruoyi/config/FlywayMigrationContractTest.java | 7 +++++++
ruoyi-admin/src/main/resources/db/migration/V16__simplify_test_reception_lifecycle.sql | 12 ++++++++++++
ruoyi-admin/src/main/resources/db/migration/V17__persist_runtime_attach_flag.sql | 4 ++++
3 files changed, 23 insertions(+), 0 deletions(-)
diff --git a/ruoyi-admin/src/main/resources/db/migration/V16__simplify_test_reception_lifecycle.sql b/ruoyi-admin/src/main/resources/db/migration/V16__simplify_test_reception_lifecycle.sql
new file mode 100644
index 0000000..ff81934
--- /dev/null
+++ b/ruoyi-admin/src/main/resources/db/migration/V16__simplify_test_reception_lifecycle.sql
@@ -0,0 +1,12 @@
+-- Ticket10 修订：接收状态改为测试级轮询开关；旧区间表保留为历史数据，不再由业务读写。
+SET @stop_menu_id := (SELECT COALESCE(MAX(menu_id), 0) + 1 FROM sys_menu);
+INSERT INTO sys_menu
+ (menu_id, menu_name, parent_id, order_num, path, component, query, route_name,
+ is_frame, is_cache, menu_type, visible, status, perms, icon,
+ create_by, create_time, update_by, update_time, remark)
+SELECT @stop_menu_id, '停止测试', menu_id, 9, '', NULL, NULL, '', 1, 0, 'F', '0', '0',
+ 'system:test:stop', '#', 'admin', NOW(), '', NULL, '测试停止权限'
+FROM sys_menu
+WHERE perms = 'system:test:list'
+ AND NOT EXISTS (SELECT 1 FROM sys_menu existing WHERE existing.perms = 'system:test:stop')
+LIMIT 1;
diff --git a/ruoyi-admin/src/main/resources/db/migration/V17__persist_runtime_attach_flag.sql b/ruoyi-admin/src/main/resources/db/migration/V17__persist_runtime_attach_flag.sql
new file mode 100644
index 0000000..d8b0b28
--- /dev/null
+++ b/ruoyi-admin/src/main/resources/db/migration/V17__persist_runtime_attach_flag.sql
@@ -0,0 +1,4 @@
+-- 保留开始接收时是否接入运行中设备的事实，供列表和实时控制台展示。
+ALTER TABLE t_test
+ ADD COLUMN runtime_attach TINYINT(1) NOT NULL DEFAULT 0
+ COMMENT '是否从已运行设备接入' AFTER ended_at_utc;
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 7e4e0d0..d3c6e01 100644
--- a/ruoyi-admin/src/test/java/com/ruoyi/config/FlywayMigrationContractTest.java
+++ b/ruoyi-admin/src/test/java/com/ruoyi/config/FlywayMigrationContractTest.java
@@ -121,6 +121,13 @@
assertTrue(v16.contains("旧区间表保留为历史数据"));
assertFalse(v16.matches("(?s).*\\bDROP\\s+TABLE\\b.*"));
+ String v17 = resource("db/migration/V17__persist_runtime_attach_flag.sql");
+ assertTrue(v17.contains("ALTER TABLE t_test"));
+ assertTrue(v17.contains("ADD COLUMN runtime_attach"));
+ assertTrue(v17.contains("TINYINT(1) NOT NULL DEFAULT 0"));
+ assertTrue(v17.contains("AFTER ended_at_utc"));
+ assertFalse(v17.matches("(?s).*\\bDROP\\s+TABLE\\b.*"));
+
String testMapper = resource("mapper/system/TTestMapper.xml");
assertTrue(testMapper.contains("selectReceivingChannelsForAdapter"));
assertTrue(testMapper.contains("RECEPTION_RESUMED"));
--
Gitblit v1.7.1