public void DewPointTest() { var db = new DbManagement().GetDb("f*x"); var queryTable = db.GetTable<float>("Aussen.Wetterstation.(?<k>.*?)$", "time > now() - 1y"); var result = queryTable .Transform(i => i.GroupByHours(1, o => o.Mean())) .DewPoint("Temperatur", "Feuchtigkeit", "Taupunkt"); }
public void AllCalcTempValuesTest() { var db = new DbManagement().GetDb("f*x"); var queryTable = db.GetTable<float>("Aussen.Wetterstation.(?<k>.*?)$", "time > now() - 1M"); var result = queryTable .Transform(i => i.GroupByHours(1, o => o.Mean())) .AddDewPoint("Temperatur", "Feuchtigkeit") .AddAbsoluteHumidity("Temperatur", "Feuchtigkeit") .AddHumidex("Temperatur", "Feuchtigkeit") .AddHeatIndex("Temperatur", "Feuchtigkeit") .AddSleetLine("Temperatur", "Feuchtigkeit", 440) .AddSnowLine("Temperatur", "Feuchtigkeit", 440) .RemoveSerie("Feuchtigkeit"); }
public void DynamicWithRealDb() { var db = new DbManagement().GetDb("f*x"); var queryTable = db.GetTable<float>("Aussen.Wetterstation.(?<k>[TF]).*?$", "time > now() - 1M"); var result = queryTable .Group(g => g.ByTime.Hours(1).Aggregate(o => o.Mean())) .Calc(t => t.Sum = t.T + t.F); result.Series.Count().Should().Be(3); result = result.RemoveDbSeries(); result.Series.Count().Should().Be(1); }
public void MultipleTableGroups() { var db = new DbManagement().GetDb("f*x"); var queryTable = db.GetTable<float>("Innen.(?<g>.*).(?<k>Temperatur|Feuchtigkeit)$", "time > now() - 1M"); var result = queryTable .Transform(i => i.GroupByHours(1, o => o.Mean())) .ZipToNew("Sum", t => t.Temperatur + t.Feuchtigkeit); }
public void MultipleAbsoluteHumidityTableGroups() { var db = new DbManagement().GetDb("f*x"); var result = db.GetTable<float>("Innen.(?<g>.*).(?<k>Temperatur|Feuchtigkeit)$", "time > now() - 1M") .Transform(g => g.Group(i => i.ByTime.Hours(1).ExpandTimeRangeByFactor(7).Aggregate(o => o.Mean()))) .GroupSeries().Transform(t => t.AbsoluteHumidity("Temperatur", "Feuchtigkeit")).MergeTables(); }