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