From 94cdf3c7741bfb8be1ac74cf6dd7c821afac197d Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Sun, 2 Apr 2017 14:21:03 +0200 Subject: [PATCH] added gnuplot graph from influxdb --- temp2.gnuplot | 21 +++++++++++++++++++++ temp2.sh | 28 ++++++++++++++++++++++++++++ 2 files changed, 49 insertions(+) create mode 100644 temp2.gnuplot create mode 100755 temp2.sh diff --git a/temp2.gnuplot b/temp2.gnuplot new file mode 100644 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 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 + -- 2.20.1