metaclass: (Default)
metaclass ([personal profile] metaclass) wrote2011-01-16 10:33 am
  • Add Memory
  • Share This Entry

ад интеграции

MPX4115A,DS18B20,ATmega,F#,C#,Firebird,SQL,bat-файлы и rrdtool.

select 'update pressure_zero.rrd '||
        cast((pressure.MC_DTDATA-cast('1970.01.01 00:00:00' as timestamp))*86400 as numeric(18))||':'||
        cast(pressure.MC_CALCVALUE/exp(-0.029*9.81*205/(8.31*(temperature.mc_calcvalue+273.15)))        as varchar(20))||''
from MeteoCurrent pressure
join MeteoCurrent temperature on temperature.mc_sens_id=1
 where pressure.MC_SENS_ID=8;



D:\Programm\Firebird25\bin\isql.exe fb25:meteo -u METEO -p meteopassword -ch WIN1251 -b -i export_rrd.sql | grep update >data.tmp
D:\Programm\rrdtool\rrdtool.exe -<data.tmp

Давление:



Температура:




Пересчет давления с датчика в давление на уровне моря и складирование его в rrdtool.