kuhinja battery change

[vaillant-thermostat] / temp3.sh

diff --git a/temp3.sh b/temp3.sh
index 440b21e..5673c1a 100755 (executable)
--- a/temp3.sh
+++ b/temp3.sh
@@ -54,25 +54,34 @@ curl -G 'http://10.60.0.92:8086/query' --data-urlencode "db=rtl_433" --data-urle
        | tee /dev/shm/rtl_433.th \
        | awk -F, '{print $3" "$5" "$6 > "/dev/shm/id."$4 }'
 
+psql_subvision() {
+       to=$1
+       echo "select extract(epoch from time), temperature, humidity from s_1 where time > now() - interval '$INTERVAL' order by time" | \
+               ssh subvision psql -t -A eg5120 | sed 's/|/ /g' > /dev/shm/data.$to
+}
+
+
 rename_ids() {
        to=$1
-       rm /dev/shm/data.$to
        shift
        while [ ! -z "$1" ] ; do
                if [ -e /dev/shm/id.$1 ] ; then
                        cat /dev/shm/id.$1 > /dev/shm/data.$to
                        rm  /dev/shm/id.$1
+               else
+                       rm /dev/shm/data.$to
                fi
                shift
        done
 }
 
-rename_ids     'vani-t-h' 126 1 # sunce
-rename_ids     'kutija-t-h' 237 114 # hlad
-rename_ids     'kupaona-t-h' 78 15
-rename_ids     'kuhinja-t-h' 85 33
-rename_ids     'soba-t-h' 105 234
-rename_ids     'hodnik-t-h' 145 181
+rename_ids     'vani-t-h' 156 # sunce
+rename_ids     'kutija-t-h' 138 # hlad
+#rename_ids    'kupaona-t-h' 78 15
+psql_subvision 'kupaona-t-h'
+rename_ids     'kuhinja-t-h' 144
+rename_ids     'soba-t-h' 251
+rename_ids     'hodnik-t-h' 234
 
 
 influx_mqtt    'stat/boiler/DS18B20/temperature'       'DS18B20-t'