public void TestSmallPivotGenerator()
{
var data = SmallDatasets.GenerateFullFlatData();
var typeWrapper = new Pivot.Accessories.Mapping.TypeWrapper <TwoByTwo, AggregationFunctions>();
var generator = new PivotGenerator <TwoByTwo, AggregationFunctions>(typeWrapper);
var mtx = generator.GeneratePivot(data).Matrix;
DataOutput.CSVHelper.SaveCSVFile(mtx, "SmallTwoByTwoMatrix.csv");
}
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 TestXYDictionarySmallSet_CheckOrder()
{
var data = SmallDatasets.GenerateFullFlatData();
var typeWrapper = new Pivot.Accessories.Mapping.TypeWrapper <TwoByTwo, AggregationFunctions>();
var generator = new DictionaryGenerator <TwoByTwo, AggregationFunctions>(typeWrapper);
// checking X
var dirX = generator.GenerateXDictionary(data);
Assert.AreEqual(6, dirX.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 TestGenerateXLevelTree()
{
var data = SmallDatasets.GenerateFullFlatData();
var typeWrapper = new Pivot.Accessories.Mapping.TypeWrapper <TwoByTwo, AggregationFunctions>();
var generator = new DictionaryGenerator <TwoByTwo, AggregationFunctions>(typeWrapper);
SortedDictionary <FieldList, int> dirX = generator.GenerateXDictionary(data);
int level = 0;
IEnumerable <AggregationTreeNode> q0 = GenerateAggregationTreeXAnyLevel(dirX, level);
var lst = q0.ToList();
Assert.AreEqual(4, lst.Count);
level = 1;
IEnumerable <AggregationTreeNode> q1 = GenerateAggregationTreeXAnyLevel(dirX, level);
lst = q1.ToList();
Assert.AreEqual(2, lst.Count);
}
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));
}
