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();
}
