public void TestDateMode()
{
var aggregator = new OracleValueAggregator();
var date = new OracleDateTime(new OracleDate(2016, 6, 22));
aggregator.AddValue(date);
aggregator.AddValue(date);
aggregator.Mode.Value.ShouldBe(date);
aggregator.Mode.Count.ShouldBe(2);
}
public void TestIntervalDayToSecondMode()
{
var aggregator = new OracleValueAggregator();
var oneDay = new OracleIntervalDayToSecond(new OracleIntervalDS(1d));
aggregator.AddValue(oneDay);
aggregator.AddValue(oneDay);
var twoDays = new OracleIntervalDayToSecond(new OracleIntervalDS(2d));
aggregator.AddValue(twoDays);
aggregator.Mode.Value.ShouldBe(oneDay);
aggregator.Mode.Count.ShouldBe(2);
}
public void TestDateAggregation()
{
var aggregator = new OracleValueAggregator();
aggregator.AddValue(new DateTime(2016, 6, 11));
aggregator.AddValue(new DateTime(2016, 6, 12));
aggregator.AggregatedValuesAvailable.ShouldBeFalse();
aggregator.LimitValuesAvailable.ShouldBeTrue();
aggregator.Average.ShouldBeNull();
aggregator.Sum.ShouldBeNull();
aggregator.Minimum.ShouldBe(new OracleDateTime(2016, 6, 11, 0, 0, 0));
aggregator.Maximum.ShouldBe(new OracleDateTime(2016, 6, 12, 0, 0, 0));
aggregator.Mode.Value.ShouldBeNull();
aggregator.Mode.Count.ShouldBeNull();
aggregator.Median.ShouldBeNull();
aggregator.Count.ShouldBe(2);
aggregator.DistinctCount.ShouldBe(2);
}
public void TestNumberAggregation()
{
var aggregator = new OracleValueAggregator();
aggregator.AddValue(1);
aggregator.AddValue(2);
aggregator.AggregatedValuesAvailable.ShouldBeTrue();
aggregator.LimitValuesAvailable.ShouldBeTrue();
aggregator.Average.ShouldBe(new OracleNumber(new OracleDecimal(1.5m)));
aggregator.Sum.ShouldBe(new OracleNumber(new OracleDecimal(3m)));
aggregator.Minimum.ShouldBe(new OracleNumber(new OracleDecimal(1m)));
aggregator.Maximum.ShouldBe(new OracleNumber(new OracleDecimal(2m)));
aggregator.Mode.Value.ShouldBeNull();
aggregator.Mode.Count.ShouldBeNull();
aggregator.Median.ShouldBe(new OracleNumber(new OracleDecimal(1.5m)));
aggregator.Count.ShouldBe(2);
aggregator.DistinctCount.ShouldBe(2);
}
public void TestDistinctStrings()
{
var aggregator = new OracleValueAggregator();
aggregator.AddValue("value1");
aggregator.AddValue("value2");
aggregator.AddValue("value1");
aggregator.AggregatedValuesAvailable.ShouldBeFalse();
aggregator.LimitValuesAvailable.ShouldBeFalse();
aggregator.Average.ShouldBeNull();
aggregator.Sum.ShouldBeNull();
aggregator.Minimum.ShouldBeNull();
aggregator.Maximum.ShouldBeNull();
aggregator.Mode.Value.ShouldBeNull();
aggregator.Mode.Count.ShouldBeNull();
aggregator.Median.ShouldBeNull();
aggregator.Count.ShouldBe(3);
aggregator.DistinctCount.ShouldBe(2);
}
public void TestMultipleTypes()
{
var aggregator = new OracleValueAggregator();
aggregator.AddValue(1);
aggregator.AddValue(1);
aggregator.AddValue("string");
aggregator.AddValue("string");
aggregator.AddValue(null);
aggregator.AggregatedValuesAvailable.ShouldBeFalse();
aggregator.LimitValuesAvailable.ShouldBeFalse();
aggregator.Average.ShouldBeNull();
aggregator.Sum.ShouldBeNull();
aggregator.Minimum.ShouldBeNull();
aggregator.Maximum.ShouldBeNull();
aggregator.Mode.Value.ShouldBeNull();
aggregator.Mode.Count.ShouldBeNull();
aggregator.Median.ShouldBeNull();
aggregator.Count.ShouldBe(4);
aggregator.DistinctCount.ShouldBeNull();
}
public void TestIntervalAggregation()
{
var aggregator = new OracleValueAggregator();
var oneYear = new OracleIntervalYearToMonth(new OracleIntervalYM(1, 0));
aggregator.AddValue(oneYear);
aggregator.AddValue(oneYear);
var twoYear = new OracleIntervalYearToMonth(new OracleIntervalYM(2, 0));
aggregator.AddValue(twoYear);
aggregator.AddValue(twoYear);
aggregator.AggregatedValuesAvailable.ShouldBeTrue();
aggregator.LimitValuesAvailable.ShouldBeTrue();
aggregator.Average.ShouldBe(new OracleIntervalYearToMonth(new OracleIntervalYM(1, 6)));
aggregator.Sum.ShouldBe(new OracleIntervalYearToMonth(new OracleIntervalYM(6, 0)));
aggregator.Minimum.ShouldBe(oneYear);
aggregator.Maximum.ShouldBe(twoYear);
aggregator.Mode.Value.ShouldBeNull();
aggregator.Mode.Count.ShouldBeNull();
aggregator.Median.ShouldBe(new OracleIntervalYearToMonth(new OracleIntervalYM(1, 6)));
aggregator.Count.ShouldBe(4);
aggregator.DistinctCount.ShouldBe(2);
}
