public void AdjustColumnsTrivialRowSmallBatch()
{
var input = WideStruct1.GetTestData()
.ToStreamable()
.Select(() => new WideStruct1())
.ToAtemporalObservable()
.ToEnumerable()
.ToList();
Assert.IsTrue(input.SequenceEqual(WideStruct1.GetTestData()));
}
public void AdjustColumnsAddViaDictionaryRow()
{
var input = WideStruct1.GetTestData()
.ToStreamable()
.Select(() => new WideStruct2(), new Dictionary <string, Expression <Func <WideStruct1, object> > >
{
{ "Key2", o => (o.Key1 == "c" ? "e" : "d") }
})
.ToAtemporalObservable()
.ToEnumerable()
.ToList();
Assert.IsTrue(input.SequenceEqual(WideStruct2.GetTestData()));
}
public void AdjustColumnsAddViaFormulaRow()
{
var input = WideStruct1.GetTestData()
.ToStreamable()
.Select(
() => new WideStruct2(),
o => o.Key2,
o => o.Key1 == "c" ? "e" : "d")
.ToAtemporalObservable()
.ToEnumerable()
.ToList();
Assert.IsTrue(input.SequenceEqual(WideStruct2.GetTestData()));
}
public void Pivot1AllColumnarSmallBatch()
{
var input = new List <UnpivotStruct1N>
{
new UnpivotStruct1N {
Key1 = "a", Attribute = "i5", Value = 5
},
new UnpivotStruct1N {
Key1 = "a", Attribute = "i9", Value = 9
},
new UnpivotStruct1N {
Key1 = "b", Attribute = "i1", Value = 11
},
new UnpivotStruct1N {
Key1 = "b", Attribute = "i2", Value = 9
},
new UnpivotStruct1N {
Key1 = "b", Attribute = "i14", Value = 100
},
new UnpivotStruct1N {
Key1 = "c", Attribute = "i15", Value = 0
},
new UnpivotStruct1N {
Key1 = "c", Attribute = "o", Value = 9
},
}.ToStreamable()
.Pivot(
() => new WideStruct1(),
o => o.Key1,
o => o.Attribute,
o => o.Value,
o => o.SingleOrDefault())
.ToAtemporalObservable()
.ToEnumerable()
.ToList();
var expected = WideStruct1.GetTestData();
Assert.IsTrue(input.OrderBy(o => o.Key1).SequenceEqual(expected));
}
public void Unpivot1AllColumnarSmallBatch()
{
var input = WideStruct1.GetTestData()
.ToStreamable()
.Unpivot(
() => new UnpivotStruct1(),
e => e.Key1,
e => e.Attribute,
e => e.Value)
.ToAtemporalObservable()
.ToEnumerable()
.ToList();
var expected = new List <UnpivotStruct1>
{
new UnpivotStruct1 {
Key1 = "a", Attribute = "i5", Value = 5
},
new UnpivotStruct1 {
Key1 = "a", Attribute = "i9", Value = 9
},
new UnpivotStruct1 {
Key1 = "b", Attribute = "i1", Value = 11
},
new UnpivotStruct1 {
Key1 = "b", Attribute = "i14", Value = 100
},
new UnpivotStruct1 {
Key1 = "b", Attribute = "i2", Value = 9
},
new UnpivotStruct1 {
Key1 = "c", Attribute = "i15", Value = 0
},
new UnpivotStruct1 {
Key1 = "c", Attribute = "o", Value = 9
},
};
Assert.IsTrue(input.SequenceEqual(expected));
}
