public void PrimDimensinTest()
{
Dim dim = new DimPrimitive <int>("Test", null, null);
//
// Insert new data
//
dim.ColumnData.Append(10);
dim.ColumnData.Append(30);
dim.ColumnData.Append(20);
Assert.AreEqual(3, dim.ColumnData.Length);
Assert.AreEqual(30, dim.ColumnData.GetValue(1));
dim.ColumnData.SetValue(2, 50);
dim.ColumnData.SetValue(1, 50);
dim.ColumnData.SetValue(0, 50);
Assert.AreEqual(50, dim.ColumnData.GetValue(1));
dim.ColumnData.SetValue(1, 10);
Assert.AreEqual(10, dim.ColumnData.GetValue(1));
Assert.AreEqual(false, dim.ColumnData.IsNull(2));
dim.ColumnData.SetValue(2, null);
Assert.AreEqual(true, dim.ColumnData.IsNull(2));
dim.ColumnData.SetValue(1, null);
dim.ColumnData.SetValue(0, null);
Assert.AreEqual(true, dim.ColumnData.IsNull(0));
dim.ColumnData.SetValue(1, 100);
Assert.AreEqual(100, dim.ColumnData.GetValue(1));
}
public void TableLoadTest()
{
//
// Prepare table schema
//
SetTop top = new SetTop("Top");
Set setInteger = top.GetPrimitive("Integer");
Set setDouble = top.GetPrimitive("Double");
Set setString = top.GetPrimitive("String");
// Insert table
Set t1 = new Set("t1");
top.Root.AddSubset(t1);
Dim orders = new DimPrimitive <int>("orders", t1, setInteger);
orders.Add();
Dim revenue = new DimPrimitive <double>("revenue", t1, setDouble);
revenue.Add();
Dim name = new DimPrimitive <string>("name", t1, setString);
name.Add();
//
// Insert new data
//
t1.Append();
Assert.AreEqual(1, t1.Length);
t1.SetValue("orders", 0, 10);
t1.SetValue("revenue", 0, 12345.67);
t1.SetValue("name", 0, "Smith");
Assert.AreEqual(10, t1.GetValue("orders", 0));
Assert.AreEqual(12345.67, t1.GetValue("revenue", 0));
Assert.AreEqual("Smith", t1.GetValue("name", 0));
}
