#!/bin/bash

cat /dev/ttyACM0 | head -1 > measure.txt

file=measure.txt

while read line ; do


       s01=$( echo "$line" |cut -d\: -f1 )
       s02=$( echo "$line" |cut -d\: -f2 )
       s03=$( echo "$line" |cut -d\: -f3 )
       s04=$( echo "$line" |cut -d\: -f4 )
done < ${file}

#Calculos de conversion

hPa=`echo "0.015*($s01-4000)+850" | bc -l`
T=`echo "0.009375*($s02-4000)+(-50)" | bc -l`
Vocs=`echo "0.00625*($s03-4000)" | bc -l`
PM10=`echo "0.025*($s04-4000)"  | bc -l`

#INSERTA VALOR RAW DESDE SENSORES

mysql -u sensor -p1234 -D mediciones -e "INSERT INTO measures (s01, s02, s03, s04) VALUES ($s01, $s02, $s03, $s04)"




#INSERTA VALOR FISICO

mysql -u sensor -p1234 -D mediciones -e "INSERT INTO conversiones (hpa, temp, vocs, pm10 ) VALUES ($hPa, $T, $Vocs, $PM10)"

#mysql -u sensor -p1234 -D mediciones -e "select * from (SELECT * FROM measures order by id desc limit 10) sub order by id asc"


### Conversion de uA > hPa ó mbar