public void FindMissingTiploc()
{
var records = ParserHelper.ParseRecords(Records);
using (var connection = _fixture.CreateConnection())
{
connection.Open();
var loader = new LocationLoader(connection, new Sequence(), Substitute.For <ILogger>());
loader.Initialise();
foreach (var record in records)
{
loader.Add(record);
}
var id = loader.Find("WATRLOO");
Assert.Equal(5L, id);
var row = loader.Table.Rows[4];
Assert.Equal(5L, row["Id"]);
Assert.Equal("I", row["Action"]);
Assert.Equal("WATRLOO", row["Tiploc"]);
Assert.Equal("WATRLOO - MISSING", row["Description"]);
Assert.Equal(DBNull.Value, row["Nlc"]);
Assert.Equal(DBNull.Value, row["NlcCheckCharacter"]);
Assert.Equal(DBNull.Value, row["NlcDescription"]);
Assert.Equal(DBNull.Value, row["Stanox"]);
Assert.Equal(DBNull.Value, row["ThreeLetterCode"]);
}
}
public void FindExistingTiploc()
{
var records = ParserHelper.ParseRecords(Records);
using (var connection = _fixture.CreateConnection())
{
connection.Open();
var loader = new LocationLoader(connection, new Sequence(), Substitute.For <ILogger>());
loader.Initialise();
foreach (var record in records)
{
loader.Add(record);
}
var id = loader.Find("PRNC884");
Assert.Equal(2L, id);
}
}