public void GetKeys_UniqueCellNumericCasting_CorrectCell()
{
var table = BuildDataTable(new[] { "Key0", "Key1", "Key0" }, new[] { "Foo", "Bar", "Foo" }, new object[] { "0", "1.0", "0.00" });
var columns = new List <IColumnDefinition>()
{
new Column()
{
Identifier = new ColumnNameIdentifier("two"), Type = ColumnType.Numeric
}
};
var keyRetriever = new KeysRetrieverByName(columns);
Assert.That(keyRetriever.GetKeys(table.Rows[0]).Members, Is.EqualTo(new[] { 0 }));
Assert.That(keyRetriever.GetKeys(table.Rows[1]).Members, Is.EqualTo(new[] { 1 }));
Assert.That(keyRetriever.GetKeys(table.Rows[2]).Members, Is.EqualTo(new[] { 0 }));
}
public void GetKeys_UniqueCell_CorrectCell()
{
var table = BuildDataTable(new[] { "Key0", "Key1", "Key0" }, new[] { "Foo", "Bar", "Foo" }, new object[] { 0, 1, 0 });
var columns = new List <IColumnDefinition>()
{
new Column()
{
Name = "zero", Type = ColumnType.Text
}
};
var keyRetriever = new KeysRetrieverByName(columns);
Assert.That(keyRetriever.GetKeys(table.Rows[0]).Members, Is.EqualTo(new[] { "Key0" }));
Assert.That(keyRetriever.GetKeys(table.Rows[1]).Members, Is.EqualTo(new[] { "Key1" }));
Assert.That(keyRetriever.GetKeys(table.Rows[2]).Members, Is.EqualTo(new[] { "Key0" }));
}
public void GetKeys_TwoCellsReverseOrder_CorrectCells()
{
var table = BuildDataTable(new[] { "Key0", "Key1", "Key0" }, new[] { "Foo", "Bar", "Foo" }, new object[] { 0, 1, 0 });
var columns = new List <IColumnDefinition>()
{
new Column()
{
Identifier = new ColumnNameIdentifier("one"), Type = ColumnType.Text
},
new Column()
{
Identifier = new ColumnNameIdentifier("zero"), Type = ColumnType.Text
}
};
var keyRetriever = new KeysRetrieverByName(columns);
Assert.That(keyRetriever.GetKeys(table.Rows[0]).Members, Is.EqualTo(new[] { "Foo", "Key0" }));
Assert.That(keyRetriever.GetKeys(table.Rows[1]).Members, Is.EqualTo(new[] { "Bar", "Key1" }));
Assert.That(keyRetriever.GetKeys(table.Rows[2]).Members, Is.EqualTo(new[] { "Foo", "Key0" }));
}
