X-Git-Url: http://git.rot13.org/?p=vaillant-thermostat;a=blobdiff_plain;f=temp3.sh;h=f587c46d45a83563b3b17c1a9f19924bd359eb80;hp=93566f910fd6eb7cad27a56005cbdc4eebd9fa4b;hb=HEAD;hpb=be973f0f7eedc76569e9b9bfc4ad407b84c66330 diff --git a/temp3.sh b/temp3.sh index 93566f9..5673c1a 100755 --- a/temp3.sh +++ b/temp3.sh @@ -56,7 +56,7 @@ curl -G 'http://10.60.0.92:8086/query' --data-urlencode "db=rtl_433" --data-urle psql_subvision() { to=$1 - echo "select extract(epoch from time), temperature, humidity from s_1 where time > now() - interval '$INTERVAL'" | \ + 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 } @@ -79,7 +79,7 @@ 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' 154 85 +rename_ids 'kuhinja-t-h' 144 rename_ids 'soba-t-h' 251 rename_ids 'hodnik-t-h' 234