DDWiki/运维/安装/更换模块.md

> 10.6 更换成28658

-局域网找新模块确认指向？已确认。
-新模块是否最新？确实最新。最新。
-确认旧模块是否不再更新？最后一次更新时间在2020-10-06 09:34:19，确实不再更新。
-记录旧模块的开关编号和开关名称？
select * from KaiGuan where Mac='187ed5315034'
in ('260','261','262','263','264','265','266','267','268','269', '270','271','272','273','274','275')
-记录旧模块的场景
-1D区晚上21点关 2，4，6，8，10，14
-1层D区下班关 1，3，5，7，9，11，12，13，16
-1层收银下班 14，15
-1层D区上班开 2，4，5，6，8，10，11，12，13，14，15，16
-1层E区上班早开 1，3，7，9
粮油调味区盘点关 1-10
粮油调味区盘点开 1-10

-删除旧模块SceneDetails
select * from sceneDetails where mac='187ed5315034'
delete from sceneDetails where mac='187ed5315034'

-删除旧模块SceneItem
select * from SceneItem where KaiGuanId in ('260','261','262','263','264','265','266','267','268','269', '270','271','272','273','274','275')
delete from SceneItem where KaiGuanId in ('260','261','262','263','264','265','266','267','268','269', '270','271','272','273','274','275')


-删除旧模块warninghistories
select * from warningHistories where KaiGuanId in ('260','261','262','263','264','265','266','267','268','269', '270','271','272','273','274','275')
delete from warningHistories where KaiGuanId in ('260','261','262','263','264','265','266','267','268','269', '270','271','272','273','274','275')

-删除旧模块kaiguanwarning
select * from kaiguanwarning where KaiGuanId in ('260','261','262','263','264','265','266','267','268','269', '270','271','272','273','274','275')
delete from KaiGuanWarning where KaiGuanId in ('260','261','262','263','264','265','266','267','268','269', '270','271','272','273','274','275')

-删除旧模块开关
select * from KaiGuan where Mac='187ed5315034'
delete from KaiGuan where Mac='187ed5315034'

-删除缓存
AllMac
其它相关缓存


-添加新模块开关
select Mac, LineAddress, Name from KaiGuan where Mac='187ed5328658'

update KaiGuan Set Name='射灯2' where Mac='187ed5328658' and LineAddress='1';
update KaiGuan Set Name='灯带9' where Mac='187ed5328658' and LineAddress='2';
update KaiGuan Set Name='灯带10' where Mac='187ed5328658' and LineAddress='3';
update KaiGuan Set Name='灯带10' where Mac='187ed5328658' and LineAddress='4';
update KaiGuan Set Name='灯带11' where Mac='187ed5328658' and LineAddress='5';
update KaiGuan Set Name='灯带11' where Mac='187ed5328658' and LineAddress='6';
update KaiGuan Set Name='灯带12' where Mac='187ed5328658' and LineAddress='7';
update KaiGuan Set Name='灯带12' where Mac='187ed5328658' and LineAddress='8';
update KaiGuan Set Name='灯带14' where Mac='187ed5328658' and LineAddress='9';
-设置新模块相关场景
S3上班
S3下班


> 更新某个模块的所有开关

```
update KaiGuan Set Name='插座', Code='1' where Mac='187ed532d2cc' and LineAddress='1';
update KaiGuan Set Name='插座', Code='2' where Mac='187ed532d2cc' and LineAddress='2';
update KaiGuan Set Name='插座', Code='3' where Mac='187ed532d2cc' and LineAddress='3';
update KaiGuan Set Name='插座', Code='4' where Mac='187ed532d2cc' and LineAddress='4';
update KaiGuan Set Name='插座', Code='5' where Mac='187ed532d2cc' and LineAddress='5';
update KaiGuan Set Name='插座', Code='6' where Mac='187ed532d2cc' and LineAddress='6';
update KaiGuan Set Name='插座', Code='7' where Mac='187ed532d2cc' and LineAddress='7';
update KaiGuan Set Name='插座', Code='8' where Mac='187ed532d2cc' and LineAddress='8';
update KaiGuan Set Name='插座', Code='9' where Mac='187ed532d2cc' and LineAddress='9';
update KaiGuan Set Name='插座', Code='10' where Mac='187ed532d2cc' and LineAddress='10';
update KaiGuan Set Name='插座', Code='11' where Mac='187ed532d2cc' and LineAddress='11';
update KaiGuan Set Name='插座', Code='12' where Mac='187ed532d2cc' and LineAddress='12';
update KaiGuan Set Name='插座', Code='13' where Mac='187ed532d2cc' and LineAddress='13';
update KaiGuan Set Name='插座', Code='14' where Mac='187ed532d2cc' and LineAddress='14';
update KaiGuan Set Name='插座', Code='15' where Mac='187ed532d2cc' and LineAddress='15';
update KaiGuan Set Name='插座', Code='16' where Mac='187ed532d2cc' and LineAddress='16';
update KaiGuan Set Name='插座', Code='17' where Mac='187ed532d2cc' and LineAddress='17';
update KaiGuan Set Name='插座', Code='18' where Mac='187ed532d2cc' and LineAddress='18';
update KaiGuan Set Name='插座', Code='19' where Mac='187ed532d2cc' and LineAddress='19';
update KaiGuan Set Name='插座', Code='20' where Mac='187ed532d2cc' and LineAddress='20';

update KaiGuan Set Name='插座', Code='1' where Mac='187ed532d2cc' and LineAddress='1';
update KaiGuan Set Name='筒灯', Code='2' where Mac='187ed532d2cc' and LineAddress='2';
update KaiGuan Set Name='筒灯', Code='3' where Mac='187ed532d2cc' and LineAddress='3';
update KaiGuan Set Name='筒灯', Code='4' where Mac='187ed532d2cc' and LineAddress='4';
update KaiGuan Set Name='筒灯', Code='5' where Mac='187ed532d2cc' and LineAddress='5';
update KaiGuan Set Name='筒灯', Code='6' where Mac='187ed532d2cc' and LineAddress='6';
update KaiGuan Set Name='筒灯', Code='7' where Mac='187ed532d2cc' and LineAddress='7';
update KaiGuan Set Name='筒灯', Code='8' where Mac='187ed532d2cc' and LineAddress='8';
update KaiGuan Set Name='筒灯', Code='9' where Mac='187ed532d2cc' and LineAddress='9';
update KaiGuan Set Name='筒灯', Code='10' where Mac='187ed532d2cc' and LineAddress='10';
update KaiGuan Set Name='筒灯', Code='11' where Mac='187ed532d2cc' and LineAddress='11';
update KaiGuan Set Name='筒灯', Code='12' where Mac='187ed532d2cc' and LineAddress='12';
update KaiGuan Set Name='筒灯', Code='13' where Mac='187ed532d2cc' and LineAddress='13';
update KaiGuan Set Name='筒灯', Code='14' where Mac='187ed532d2cc' and LineAddress='14';
update KaiGuan Set Name='筒灯', Code='15' where Mac='187ed532d2cc' and LineAddress='15';
update KaiGuan Set Name='筒灯', Code='16' where Mac='187ed532d2cc' and LineAddress='16';
update KaiGuan Set Name='筒灯', Code='17' where Mac='187ed532d2cc' and LineAddress='17';
update KaiGuan Set Name='插座', Code='18' where Mac='187ed532d2cc' and LineAddress='18';
update KaiGuan Set Name='插座', Code='19' where Mac='187ed532d2cc' and LineAddress='19';
update KaiGuan Set Name='筒灯', Code='20' where Mac='187ed532d2cc' and LineAddress='20';
```

> 14E38更换成14784

- 确认缓存中是否有14784的数据
- 记录当前的开关编号，1015-1024
- 删除相关
```
-- KaiGuan
编号：1015-1024
Mac:187ed5314e38
地址：1-10

-- SceneItem
select * from sceneitem where KaiGuanId in ('1015','1016','1017','1018','1019','1020','1021','1022','1023','1024')

-- SceneDetails
select * from scenedetails limit 1
select * from scenedetails where mac='187ed5314e38'

-- warninghistories
select * from warninghistories where KaiGuanId in ('1015','1016','1017','1018','1019','1020','1021','1022','1023','1024')

-- kaiguanwarning
select * from kaiguanwarning where KaiGuanId in ('1015','1016','1017','1018','1019','1020','1021','1022','1023','1024')

-- 删除
delete from scenedetails where mac='187ed5314e38'

delete from sceneitem where KaiGuanId in ('1015','1016','1017','1018','1019','1020','1021','1022','1023','1024')

delete from warninghistories where KaiGuanId in ('1015','1016','1017','1018','1019','1020','1021','1022','1023','1024')

delete from kaiguanwarning where KaiGuanId in ('1015','1016','1017','1018','1019','1020','1021','1022','1023','1024')

delete from kaiguan where Mac='187ed5314e38'
```
- 添加新开关

```
select * from kaiguan where Mac='187ed5314c38' sort=3
select * from kaiguan where Mac='187ed5314d98' sort=1
187ed5314784 sort=2
select * from kaiguan where Mac='187ed5314784'
```
- 可视化界面-1层F区，尝试是否可以分断合闸
- 添加到场景中
```