From 5f2e61174b5412115ed7ebacbf402dae682014e9 Mon Sep 17 00:00:00 2001 From: wuwei <wuquan-1230@q63.com> Date: 星期三, 16 七月 2025 14:52:06 +0800 Subject: [PATCH] 1.更新snmp导出oid表的脚本export.sh 2.rootfs更新sqlite3命令 --- local/bin/export.sh | 4 ++-- new_board_upgrade/rootfs/home/version | 2 +- new_board_upgrade/upgrade/rootfs.tgz | 0 new_board_upgrade/rootfs/usr/sbin/sqlite3 | 0 4 files changed, 3 insertions(+), 3 deletions(-) diff --git a/local/bin/export.sh b/local/bin/export.sh index 51fe1e6..ce746be 100755 --- a/local/bin/export.sh +++ b/local/bin/export.sh @@ -1,7 +1,7 @@ #!/bin/sh -sqlite3 /work/iot_cfg.db ".headers on " "select d.name as 璁惧鍚嶇О,'1.3.6.1.4.1.27116.'||d.id||'.'||a.passcode as OID, d.id as 璁惧ID, a.passcode as 閫氶亾鍙�, a.name as 鏁版嵁鍚嶇О,a.note as 澶囨敞 from device d left join accuracy a on d.id=a.id where uploadFlag=0" > /tmp/oid_list.csv -sqlite3 /work/iot_cfg.db "SELECT name as 璁惧鍚嶇О, '1.3.6.1.4.1.27116.'||id||'.3' as OID, id as 璁惧ID, 3 as 閫氶亾鍙� , '鐘舵��' as 鏁版嵁鍚嶇О, '0-姝ｅ父;1-鍛婅' as 澶囨敞 FROM ioDevice ;" >> /tmp/oid_list.csv +sqlite3 /work/iot_cfg.db ".headers on " "select d.name as 璁惧鍚嶇О,'1.3.6.1.4.1.27116.'||d.type||'.'||d.id||'.'||a.passcode as OID, d.id as 璁惧ID, d.type as 璁惧绫诲瀷, a.passcode as 閫氶亾鍙�, a.name as 鏁版嵁鍚嶇О,a.note as 澶囨敞 from device d left join accuracy a on d.id=a.id where uploadFlag=0" > /tmp/oid_list.csv +sqlite3 /work/iot_cfg.db "SELECT name as 璁惧鍚嶇О, '1.3.6.1.4.1.27116.'||type||'.'||id||'.3' as OID, id as 璁惧ID, type as 璁惧绫诲瀷, 3 as 閫氶亾鍙� , '鐘舵��' as 鏁版嵁鍚嶇О, '0-姝ｅ父;1-鍛婅' as 澶囨敞 FROM ioDevice ;" >> /tmp/oid_list.csv sed -i 's/|/,/g' /tmp/oid_list.csv diff --git a/new_board_upgrade/rootfs/home/version b/new_board_upgrade/rootfs/home/version index c4e8def..d6d6b90 100644 --- a/new_board_upgrade/rootfs/home/version +++ b/new_board_upgrade/rootfs/home/version @@ -1,3 +1,3 @@ -2025-07-09-v002 +2025-07-16-v001 type=1 RK3568 diff --git a/new_board_upgrade/rootfs/usr/sbin/sqlite3 b/new_board_upgrade/rootfs/usr/sbin/sqlite3 new file mode 100755 index 0000000..f7a64c9 --- /dev/null +++ b/new_board_upgrade/rootfs/usr/sbin/sqlite3 Binary files differ diff --git a/new_board_upgrade/upgrade/rootfs.tgz b/new_board_upgrade/upgrade/rootfs.tgz index 3291d81..2ae1a7c 100644 --- a/new_board_upgrade/upgrade/rootfs.tgz +++ b/new_board_upgrade/upgrade/rootfs.tgz Binary files differ -- Gitblit v1.9.3