public void GroupByExpressionMinutes() { var sw = Stopwatch.StartNew(); var result = _unitUnderTest40s.Group(g => g.ByTime.Expression("6m").TimeStampIsMiddle().Aggregate(a => a.First())) .Rows; result[0].TimeUtc.Should().Be(new DateTime(2010, 1, 1, 13, 27, 0, DateTimeKind.Utc)); result[1].TimeUtc.Should().Be(new DateTime(2010, 1, 1, 13, 33, 0, DateTimeKind.Utc)); sw.Stop(); }
public void GroupByMinutesTestStartDateAndNullNotTrimmed() { var sw = Stopwatch.StartNew(); var result = _unitUnderTest9mNotTrimmed.GroupByMinutes(6, a => a.First()).Rows; var result2 = _unitUnderTest9mNotTrimmed.Group(c => c.ByTime.Minutes(6).Aggregate(a => a.First())).Rows; result.First().TimeUtc.Should().Be(new DateTime(2010, 1, 1, 13, 0, 0, DateTimeKind.Utc)); result.Last().TimeUtc.Should().Be(new DateTime(2010, 1, 1, 14, 54, 0, DateTimeKind.Utc)); result[1].Value.Should().Be(null); result.Last().Value.Should().Be(null); result.SequenceEqual(result2).Should().BeTrue(); sw.Stop(); }
public void GroupByDaysAnd9() { var sw = Stopwatch.StartNew(); var result = _unitUnderTest5h.Group(g => g.ByTime.Days(3, 9).Aggregate(a => a.First())).Rows; var result2 = _unitUnderTest5h.Group(c => c.ByTime.Days(3, 9).Aggregate(a => a.First())).Rows; result[0].TimeUtc.Should().Be(new DateTime(2010, 5, 19, 9, 0, 0, DateTimeKind.Local).ToUniversalTime()); result[1].TimeUtc.Should().Be(new DateTime(2010, 5, 22, 9, 0, 0, DateTimeKind.Local).ToUniversalTime()); result.SequenceEqual(result2).Should().BeTrue(); var last = result.Last(); sw.Stop(); }
public void ExpMeanTest() { var sw = Stopwatch.StartNew(); //var result = _unitUnderTest50.GroupBySeconds(5, a => a.MeanByTime()).Rows; //var result2 = _unitUnderTest50.GroupBySeconds(5, a => a.MeanByTimeIncludePrevious()).RemoveNulls().Rows; var result3 = _unitUnderTest50.Group( g => g.ByTime.Seconds(5) .TimeStampIsMiddle() .ExpandTimeRangeByFactor(50) .Aggregate(a => a.MeanExpWeighted())).Rows; sw.Stop(); }
public void GroupByHours() { var sw = Stopwatch.StartNew(); var result = _unitUnderTest9m.GroupByHours(3, a => a.First()).Rows; var result2 = _unitUnderTest9m.Group(c => c.ByTime.Hours(3).Aggregate(a => a.First())).Rows; result.SequenceEqual(result2).Should().BeTrue(); result.First().TimeUtc.Should().Be(new DateTime(2010, 1, 1, 12, 0, 0, DateTimeKind.Utc)); sw.Stop(); }