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"); }