public void UpdateCityTests() { //Arrange CitySqlDAO dao = new CitySqlDAO(ConnectionString); IList <City> cities = dao.GetCitiesByCountryCode("USA"); City cityToUpdate = cities[0]; //Act cityToUpdate.Population = 5; dao.UpdateCity(cityToUpdate); //Assert Assert.AreEqual(5, cityToUpdate.Population); //THIS TEST IS ONLY TESTING MEMORY NOT THE DB IList <City> updatedCities = dao.GetCitiesByCountryCode("USA"); City fromDB = null; foreach (City c in updatedCities) { if (c.CityId == cityToUpdate.CityId) { fromDB = c; break; } } Assert.AreEqual(5, fromDB.Population); }
public void GetCitiesByCountryCode_Should_ReturnRightNumberOfCities(string countryCode, int expectedCityCount) { CitySqlDAO dao = new CitySqlDAO(ConnectionString); IList <City> cities = dao.GetCitiesByCountryCode(countryCode); Assert.AreEqual(expectedCityCount, cities.Count); }
public void GetCitiesByCountryCodeTest() { // Arrange CitySqlDAO citySqlDAO = new CitySqlDAO(connectionString); // Act IList <City> cities = citySqlDAO.GetCitiesByCountryCode("USA"); // Assert Assert.IsTrue(cities.Count > 0); }
public void GetCitiesByCountryCode_Should_ReturnRightNumberOfCities(string countryCode, int expectedCityCount) { // Arrange CitySqlDAO dao = new CitySqlDAO(connectionString); // Act IList <City> cities = dao.GetCitiesByCountryCode(countryCode); // Assert Assert.IsTrue(cities.Count >= expectedCityCount); }
public void GetCitiesByCountryCodeTest(string code, int expectedCount) { // Perform our test // Arrange CitySqlDAO dao = new CitySqlDAO(connectionString); // Act IList <City> cities = dao.GetCitiesByCountryCode(code); // Assert Assert.AreEqual(expectedCount, cities.Count); }
public void AddCity_Should_Fail_IfCountryDoesNotExist() { // Arrange CitySqlDAO dao = new CitySqlDAO(connectionString); IList <City> list = dao.GetCitiesByCountryCode("USA"); int cityCountBefore = list.Count; // Act City city = new City(); city.CountryCode = "YYZ"; city.Name = "East Cleveland"; city.District = "Ohio"; city.Population = 75000; dao.AddCity(city); // Assert - City count goes up by 1 list = dao.GetCitiesByCountryCode("USA"); int cityCountAfter = list.Count; }
public void GetCitiesByCountryCode_Should_ReturnRightNumberOfCities(string countryCode, int expectedValue) { // Arrange CitySqlDAO dao = new CitySqlDAO(ConnectionString); // Act IList <City> cities = dao.GetCitiesByCountryCode(countryCode); // Assert Assert.AreEqual(expectedValue, cities.Count); }
public void AddCity_Should_IncreaseCountBy1() { // Arrange CitySqlDAO dao = new CitySqlDAO(connectionString); IList <City> list = dao.GetCitiesByCountryCode("USA"); int cityCountBefore = list.Count; // Act City city = new City(); city.CountryCode = "USA"; city.Name = "East Cleveland"; city.District = "Ohio"; city.Population = 75000; dao.AddCity(city); // Assert - City count goes up by 1 list = dao.GetCitiesByCountryCode("USA"); int cityCountAfter = list.Count; Assert.AreEqual(cityCountBefore + 1, cityCountAfter); }
private void GetCitiesByCountryCode() { string countryCode = CLIHelper.GetString("Enter the country code that you want to retrieve:"); IList <City> cities = cityDAO.GetCitiesByCountryCode(countryCode); Console.WriteLine(); Console.WriteLine($"Printing {cities.Count} cities for {countryCode}"); foreach (var city in cities) { Console.WriteLine(city); } }
public void GetCitiesByCountryCodeTest() { // Initialize data in the DB // SetupDatabase(); // Perform our test // ------ Arrange CitySqlDAO dao = new CitySqlDAO(connectionString); // ------ Act IList <City> cities = dao.GetCitiesByCountryCode("USA"); // ------ Assert Assert.AreEqual(2, cities.Count); // Go back to the original DB values // CleanupDatabase(); }