From 45c4742c0cf31b0217874944127491990bf1a097 Mon Sep 17 00:00:00 2001 From: lgq <1015864684@qq.com> Date: 星期六, 19 七月 2025 11:05:17 +0800 Subject: [PATCH] Merge branch 'master' of http://124.71.187.17:8299/r/~lgq/IGD5300-package --- local/bin/.export.sh.un~ | 0 local/bin/export.sh | 1 + 2 files changed, 1 insertions(+), 0 deletions(-) diff --git a/local/bin/.export.sh.un~ b/local/bin/.export.sh.un~ new file mode 100755 index 0000000..ca69813 --- /dev/null +++ b/local/bin/.export.sh.un~ Binary files differ diff --git a/local/bin/export.sh b/local/bin/export.sh index a8e414e..8a10b90 100755 --- a/local/bin/export.sh +++ b/local/bin/export.sh @@ -1,6 +1,7 @@ #!/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 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 -- Gitblit v1.9.3