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
}
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