-- =====================================================================
|
-- 机场1（DJI Dock 1 / M30）设备型号字典数据
|
-- 表：manage_device_dictionary（DJI 上云线设备型号字典）
|
--
|
-- 背景：经核实 2026-10-16，2025-11-06 数据备份
|
-- （sql/backup/20251106091248.nb3）中以下数据行已随
|
-- DJI 官方 Demo 种子数据存在（'DJI Dock'=id18 / 'Matrice 30'=id2 /
|
-- 'Matrice 30T'=id3 等），开发库无需执行即可直接联调。
|
-- 本脚本为幂等兜底：跨环境部署（dev / prod / daqing）若缺失则补齐，
|
-- 已存在则跳过，可重复执行。
|
--
|
-- 消费点（皆为共享层，由 dock1/dock2 两条链共用）：
|
-- DeviceServiceImpl#deviceGatewayConvertToDeviceEntity :793 机场上线 domain=3
|
-- DeviceServiceImpl#subDeviceConvertToDeviceEntity :827 飞行器上线 domain=0
|
-- DeviceServiceImpl#bindDevice2Entity :1373 设备绑定
|
-- DevicePayloadServiceImpl :205 负载上线 domain=1
|
-- CapacityCameraServiceImpl :68 相机能力上报 domain=1
|
-- FileServiceImpl :209 媒体上传 domain=1
|
--
|
-- 官方文档：https://developer.dji.com/doc/cloud-api-tutorial/cn/api-reference/
|
-- dock-to-cloud/mqtt/dock/dock1/properties.html
|
-- （device_model_key 三段式 domain-type-sub_type 即下列前 3 列）
|
-- =====================================================================
|
|
-- 机场1（Dock1）：domain=3(机场), device_type=1, sub_type=0
|
INSERT INTO `manage_device_dictionary` (`domain`, `device_type`, `sub_type`, `device_name`, `device_desc`)
|
SELECT 3, 1, 0, 'DJI Dock', 'DJI Airport' FROM DUAL
|
WHERE NOT EXISTS (SELECT 1 FROM `manage_device_dictionary` WHERE `domain` = 3 AND `device_type` = 1 AND `sub_type` = 0);
|
|
-- 飞行器 M30：domain=0(飞行器), device_type=67, sub_type=0
|
INSERT INTO `manage_device_dictionary` (`domain`, `device_type`, `sub_type`, `device_name`, `device_desc`)
|
SELECT 0, 67, 0, 'Matrice 30', NULL FROM DUAL
|
WHERE NOT EXISTS (SELECT 1 FROM `manage_device_dictionary` WHERE `domain` = 0 AND `device_type` = 67 AND `sub_type` = 0);
|
|
-- 飞行器 M30T：domain=0, device_type=67, sub_type=1
|
INSERT INTO `manage_device_dictionary` (`domain`, `device_type`, `sub_type`, `device_name`, `device_desc`)
|
SELECT 0, 67, 1, 'Matrice 30T', NULL FROM DUAL
|
WHERE NOT EXISTS (SELECT 1 FROM `manage_device_dictionary` WHERE `domain` = 0 AND `device_type` = 67 AND `sub_type` = 1);
|
|
-- M30 相机：domain=1(负载), device_type=52, sub_type=0
|
INSERT INTO `manage_device_dictionary` (`domain`, `device_type`, `sub_type`, `device_name`, `device_desc`)
|
SELECT 1, 52, 0, 'M30 Camera', NULL FROM DUAL
|
WHERE NOT EXISTS (SELECT 1 FROM `manage_device_dictionary` WHERE `domain` = 1 AND `device_type` = 52 AND `sub_type` = 0);
|
|
-- M30T 相机：domain=1, device_type=53, sub_type=0
|
INSERT INTO `manage_device_dictionary` (`domain`, `device_type`, `sub_type`, `device_name`, `device_desc`)
|
SELECT 1, 53, 0, 'M30T Camera', NULL FROM DUAL
|
WHERE NOT EXISTS (SELECT 1 FROM `manage_device_dictionary` WHERE `domain` = 1 AND `device_type` = 53 AND `sub_type` = 0);
|
|
-- 机场相机：domain=1, device_type=165, sub_type=0
|
INSERT INTO `manage_device_dictionary` (`domain`, `device_type`, `sub_type`, `device_name`, `device_desc`)
|
SELECT 1, 165, 0, 'DJI Dock Camera', NULL FROM DUAL
|
WHERE NOT EXISTS (SELECT 1 FROM `manage_device_dictionary` WHERE `domain` = 1 AND `device_type` = 165 AND `sub_type` = 0);
|
|
-- M30 遥控器：domain=2(遥控器), device_type=119, sub_type=0
|
INSERT INTO `manage_device_dictionary` (`domain`, `device_type`, `sub_type`, `device_name`, `device_desc`)
|
SELECT 2, 119, 0, 'Matrice 30 Smart Controller', 'Remote control for M30' FROM DUAL
|
WHERE NOT EXISTS (SELECT 1 FROM `manage_device_dictionary` WHERE `domain` = 2 AND `device_type` = 119 AND `sub_type` = 0);
|
