11 lines
369 B
Bash
Executable File
11 lines
369 B
Bash
Executable File
#!/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
|
|
|