1234567891011 |
- #!/bin/sh
- mosquitto_sub -h 172.24.42.2 -R -t 'tele/+/sens/#' -F "%t %p %U" | while read TOPIC VALU EPOCH; do
- SEPOCH=$(echo $EPOCH|sed -e 's/\.//g'|cut -b -13)
- TOPI=$(echo $TOPIC|sed -e 's/tele/sp/g')
- IVAL=$(echo $VALU|cut -d\. -f1)
- echo "call insert_data('$TOPI',$IVAL,$SEPOCH);quit;"|mysql -e -s -t tsensor
- echo "call insert_data('$TOPI',$IVAL,$SEPOCH);"
- done
-
|