#!/bin/bash

time=`date '+%H:%M:%S'`
date=`date '+%Y-%m-%d'`

humi=$(curl -v --silent 192.168.1.225 2> /dev/null | awk '/Luftfuktighet: /{getline; print}' | sed 's/ //g')
temp=$(curl -v --silent 192.168.1.225 2> /dev/null | awk '/Temperatur: /{getline; print}' | sed 's/ //g')

DB_USER=temp
DB_NAME=temp
DB_PASSWD=kuken2000

if [[ -z "$temp"  || -z "$humi" ]]; then
        exit
fi
        mysql --user=$DB_USER --password=$DB_PASSWD $DB_NAME << EOF
        INSERT INTO  temp.data (id , date , time , humidity , temperature) VALUES (NULL , '$date', '$time', '$humi', '$temp');
        exit
fi
EOF