added gnuplot graph from influxdb

diff --git a/temp2.gnuplot b/temp2.gnuplot
new file mode 100644 (file)
index 0000000..f165051
--- /dev/null
+++ b/temp2.gnuplot
@@ -0,0 +1,21 @@
+set terminal pngcairo mono size 600,800
+
+set xdata time
+set timefmt "%s"
+
+set pointsize 0.2
+
+set output '/dev/shm/temp2.png'
+
+set multiplot
+set size 1, 0.5
+
+set origin 0.0, 0.5
+
+plot "/dev/shm/DS18B20-temperature" using 1:2 with points title "DS18B20 deg. C","/dev/shm/DHT22-temperature" using 1:($2 > 1 && $2 < 45 ? $2 : '') with dots title "DHT22 deg. C"
+
+set origin 0.0, 0.0
+
+plot "/dev/shm/DHT22-humidity" using 1:($2 > 3 ? $2 : '') with dots title "DHT22 % hum"
+
+unset multiplot

diff --git a/temp2.sh b/temp2.sh
new file mode 100755 (executable)
index 0000000..2b1e07b
--- /dev/null
+++ b/temp2.sh
@@ -0,0 +1,28 @@
+#!/bin/sh -x
+
+# install as cgi-script and invoke to get png
+
+#ssh rpi 'cat `ls -t /dev/shm/vaillant.* | head -1` | sed "s/  .*| */ /"' > /dev/shm/temp.tsv
+#tail -4320 `ls -t /dev/shm/vaillant.* | head -1` | sed "s/  .*| */ /" > /dev/shm/temp.tsv
+
+curl -G 'http://10.60.0.89:8086/query' --data-urlencode "db=telegraf" --data-urlencode "epoch=s" --data-urlencode "q=SELECT \"value\" FROM \"mqtt_consumer\" WHERE time > now() - 48h AND \"topic\"='stat/boiler/DS18B20/temperature'" | sed -e 's/^.*"values":\[\[//' -e 's/\],\[/\n/g' -e 's/,/ /g' -e 's/]].*$//' > /dev/shm/DS18B20-temperature
+curl -G 'http://10.60.0.89:8086/query' --data-urlencode "db=telegraf" --data-urlencode "epoch=s" --data-urlencode "q=SELECT \"value\" FROM \"mqtt_consumer\" WHERE time > now() - 48h AND \"topic\"='stat/boiler/DHT22/temperature'" | sed -e 's/^.*"values":\[\[//' -e 's/\],\[/\n/g' -e 's/,/ /g' -e 's/]].*$//' > /dev/shm/DHT22-temperature
+curl -G 'http://10.60.0.89:8086/query' --data-urlencode "db=telegraf" --data-urlencode "epoch=s" --data-urlencode "q=SELECT \"value\" FROM \"mqtt_consumer\" WHERE time > now() - 48h AND \"topic\"='stat/boiler/DHT22/humidity'" | sed -e 's/^.*"values":\[\[//' -e 's/\],\[/\n/g' -e 's/,/ /g' -e 's/]].*$//' > /dev/shm/DHT22-humidity
+
+cd /home/pi/vaillant-thermostat/
+gnuplot temp2.gnuplot
+convert /dev/shm/temp2.png -gravity center -extent 600x800 -colorspace Gray /tmp/temp2.png
+
+echo Location: http://192.168.3.2/temp2.png
+echo
+
+exit 0
+
+montage /dev/shm/[1-3].png -tile 1x3 -geometry +0+0 /tmp/m1.png
+convert /tmp/m1.png -gravity center -extent 600x800 /tmp/m1.pgm
+convert /tmp/m1.png -gravity center -extent 600x800 -colorspace Gray /tmp/m1.gray.png
+display /tmp/m1.pgm
+
+echo Location: http://192.168.3.2/m1.gray.png
+echo
+