public void TestPivotGenerator()
{
var data = ShopRiteSalesData.GenerateFullFlatData();
var typeWrapper = new Pivot.Accessories.Mapping.TypeWrapper <ShopRiteSales, AggregationFunctions>();
var generator = new PivotGenerator <ShopRiteSales, AggregationFunctions>(typeWrapper);
var mtx = generator.GeneratePivot(data).Matrix;
DataOutput.CSVHelper.SaveCSVFile(mtx, "ShopRitesSalesPivot.csv");
}
public void TestYDictionary()
{
var data = ShopRiteSalesData.GenerateYMetricsData();
var typeWrapper = new Pivot.Accessories.Mapping.TypeWrapper <ShopRiteSales, AggregationFunctions>();
var generator = new DictionaryGenerator <ShopRiteSales, AggregationFunctions>(typeWrapper);
var dirY = generator.GenerateYDictionary(data);
Assert.AreEqual(51, dirY.Count); // expecting exact amount for combinations
}
public void TestXYDictionary()
{
var data = ShopRiteSalesData.GenerateFullFlatData();
var typeWrapper = new Pivot.Accessories.Mapping.TypeWrapper <ShopRiteSales, AggregationFunctions>();
var generator = new DictionaryGenerator <ShopRiteSales, AggregationFunctions>(typeWrapper);
// checking X
var dirX = generator.GenerateXDictionary(data);
Assert.AreEqual(82, dirX.Count); // expecting exact amount for combinations
var dirY = generator.GenerateYDictionary(data);
Assert.AreEqual(411, dirY.Count); // expecting exact amount for combinations
}
public void TestBuildOrderBy()
{
var data = ShopRiteSalesData.GenerateXMetricsData();
var typeWrapper = new Pivot.Accessories.Mapping.TypeWrapper <ShopRiteSales, AggregationFunctions>();
var queryBuilderObj = new QueryBuilder <ShopRiteSales, AggregationFunctions>(typeWrapper);
var result0 = queryBuilderObj.XBuildOrderBy(data, 0);
Assert.IsNotNull(result0.ElementAt(14));
var result1 = queryBuilderObj.XBuildOrderBy(data, 1);
Assert.IsNotNull(result0.ElementAt(14));
var result2 = queryBuilderObj.XBuildOrderBy(data, 2);
Assert.IsNotNull(result0.ElementAt(14));
var result3 = queryBuilderObj.XBuildOrderBy(data, 3);
Assert.IsNotNull(result0.ElementAt(14));
}
