public void ReadPlayerFile_VerifyCountOfPlayers()
{
var fileName = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Players.csv");
var ops = new ReadMLB_Pleayers();
var players = ops.ReaderPlayersFromFile(fileName);
Assert.IsTrue(players.Count == 1000,
"Explected 1000 players");
}
public void InsertRecords()
{
var bOperations = new BackEndDataOperations();
bOperations.TruncatePlayersTable();
var fileName = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory,
"Players.csv");
var csvOps = new ReadMLB_Pleayers();
var opsData = new DataOperations();
var players = csvOps.ReaderPlayersFromFile(fileName);
// check the insert method was successful
Assert.IsTrue(opsData.InsertRecordsFromTextFileImport(players),
"Insert of records failed");
// validate all players where inserted as their id field (primary key should have a value not 0.
Assert.IsTrue(!players.Any(p => p.id == 0),
"One or more records not inserted");
Assert.IsTrue(bOperations.GetPlayerCount() == 1000,
"Expected 1000 records");
}
