From bacc47aa433025823546246637ccaebc690da24c Mon Sep 17 00:00:00 2001
From: lgq <1015864684@qq.com>
Date: 星期五, 01 八月 2025 16:39:07 +0800
Subject: [PATCH] 更新export.sh脚本，snmp_val.sh更换getval

---
 local/bin/export.sh |    4 +++-
 1 files changed, 3 insertions(+), 1 deletions(-)

diff --git a/local/bin/export.sh b/local/bin/export.sh
index 8a10b90..d21d1e0 100755
--- a/local/bin/export.sh
+++ b/local/bin/export.sh
@@ -1,10 +1,12 @@
 #!/bin/sh
 
 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, 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 ".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, a.passcode as 閫氶亾鍙�, a.name as 鏁版嵁鍚嶇О,a.note as 澶囨敞  from netDevice d left join accuracy a on d.id=a.id   where uploadFlag=0" > /tmp/oid_list.csv
+sqlite3 /work/iot_cfg.db "select d.name as 璁惧鍚嶇О,'1.3.6.1.4.1.27116.'||d.type||'.'||d.id||'.'||a.passcode as OID, d.id as 璁惧ID, a.passcode as 閫氶亾鍙�, a.name as 鏁版嵁鍚嶇О,a.note as 澶囨敞  from netDevice 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, 3 as 閫氶亾鍙� , '鐘舵��' as 鏁版嵁鍚嶇О, '0-姝ｅ父;1-鍛婅' as 澶囨敞  FROM ioDevice ;" >> /tmp/oid_list.csv
 
 sed -i 's/|/,/g' /tmp/oid_list.csv
 
 
 /usr/local/bin/snmp_cfg -f /work/snmp.json /tmp/oid_list.csv
+
+jsoner -s /work/snmp.json script_handler \"/usr/local/bin/getval\"
\ No newline at end of file

--
Gitblit v1.9.3