// Cities exist thus list of cities
public void TestGetCities()
{
var cities = new List <City>
{
new City {
Id = 1, Name = "Richmond", Description = "Small"
},
new City {
Id = 2, Name = "Vancouver", Description = "Big"
}
}.AsQueryable();
var mockSet = new Mock <DbSet <City> >();
mockSet.As <IQueryable <City> >().Setup(m => m.Provider).Returns(cities.Provider);
mockSet.As <IQueryable <City> >().Setup(m => m.Expression).Returns(cities.Expression);
mockSet.As <IQueryable <City> >().Setup(m => m.ElementType).Returns(cities.ElementType);
var mockContext = new Mock <CityInfoContext>();
mockContext.Setup(m => m.Cities).Returns(mockSet.Object);
var repo = new CityInfoRepository(mockContext.Object);
var cities2 = repo.GetCities();
Assert.Equal(2, cities2.Count());
Assert.Equal(1, cities2.First().Id);
Assert.Equal("Richmond", cities2.First().Name);
Assert.Equal("Small", cities2.First().Description);
Assert.Equal(2, cities2.Last().Id);
Assert.Equal("Vancouver", cities2.Last().Name);
Assert.Equal("Big", cities2.Last().Description);
}
// Cities with correct id thus does exist
public void TestCityExists()
{
var cities = new List <City>
{
new City {
Id = 1, Name = "Richmond", Description = "Small"
},
new City {
Id = 2, Name = "Vancouver", Description = "Big"
}
}.AsQueryable();
var mockSet = new Mock <DbSet <City> >();
mockSet.As <IQueryable <City> >().Setup(m => m.Provider).Returns(cities.Provider);
mockSet.As <IQueryable <City> >().Setup(m => m.Expression).Returns(cities.Expression);
mockSet.As <IQueryable <City> >().Setup(m => m.ElementType).Returns(cities.ElementType);
var mockContext = new Mock <CityInfoContext>();
mockContext.Setup(m => m.Cities).Returns(mockSet.Object);
var repo = new CityInfoRepository(mockContext.Object);
Assert.True(repo.CityExists(1));
}
// No cities, thus no point of interest
public void TestGetPointNoCities()
{
var cities = new List <City> {
}.AsQueryable();
var points = new List <PointOfInterest> {
}.AsQueryable();
var mockSet = new Mock <DbSet <City> >();
mockSet.As <IQueryable <City> >().Setup(m => m.Provider).Returns(cities.Provider);
mockSet.As <IQueryable <City> >().Setup(m => m.Expression).Returns(cities.Expression);
mockSet.As <IQueryable <City> >().Setup(m => m.ElementType).Returns(cities.ElementType);
var mockSetP = new Mock <DbSet <PointOfInterest> >();
mockSetP.As <IQueryable <City> >().Setup(m => m.Provider).Returns(points.Provider);
mockSetP.As <IQueryable <City> >().Setup(m => m.Expression).Returns(points.Expression);
mockSetP.As <IQueryable <City> >().Setup(m => m.ElementType).Returns(points.ElementType);
var mockContext = new Mock <CityInfoContext>();
mockContext.Setup(m => m.Cities).Returns(mockSet.Object);
mockContext.Setup(m => m.PointsOfInterest).Returns(mockSetP.Object);
var repo = new CityInfoRepository(mockContext.Object);
Assert.Null(repo.GetPointOfInterestForCity(1, 1));
}
// Data with POI(include = false)
public void TestGetCityIncludeFalse()
{
PointOfInterest poi1 = new PointOfInterest
{
Id = 1,
Name = "Downtown",
Description = "Lots of food"
};
PointOfInterest poi2 = new PointOfInterest
{
Id = 2,
Name = "Stanley Park",
Description = "Lots to do"
};
PointOfInterest poi3 = new PointOfInterest
{
Id = 3,
Name = "Science World",
Description = "Lots of science"
};
PointOfInterest poi4 = new PointOfInterest
{
Id = 3,
Name = "UBC",
Description = "School"
};
var cities = new List <City>
{
new City {
Id = 1, Name = "Richmond", Description = "Small", PointsOfInterest = { poi1, poi2 }
},
new City {
Id = 2, Name = "Vancouver", Description = "Big", PointsOfInterest = { poi3, poi4 }
},
}.AsQueryable();
var mockSet = new Mock <DbSet <City> >();
mockSet.As <IQueryable <City> >().Setup(m => m.Provider).Returns(cities.Provider);
mockSet.As <IQueryable <City> >().Setup(m => m.Expression).Returns(cities.Expression);
mockSet.As <IQueryable <City> >().Setup(m => m.ElementType).Returns(cities.ElementType);
var mockContext = new Mock <CityInfoContext>();
mockContext.Setup(m => m.Cities).Returns(mockSet.Object);
var repo = new CityInfoRepository(mockContext.Object);
Assert.Equal(1, repo.GetCity(1, false).Id);
Assert.Equal("Richmond", repo.GetCity(1, false).Name);
Assert.Equal("Small", repo.GetCity(1, false).Description);
Assert.Equal(2, repo.GetCity(1, false).PointsOfInterest.Count);
Assert.True(repo.GetCity(1, false).PointsOfInterest.Contains(poi1));
Assert.True(repo.GetCity(1, false).PointsOfInterest.Contains(poi2));
}
private CityInfoRepository CreateSutWithDependencies()
{
var fakeCityInfoData = new CityInfoFakeData();
var context = fakeCityInfoData.CreateAndSeedContext();
var repository = new CityInfoRepository(context);
return(repository);
}
private CitiesController CreateSutWithDependencies()
{
var fakeCityInfoData = new CityInfoFakeData();
var context = fakeCityInfoData.CreateAndSeedContext();
var repository = new CityInfoRepository(context);
var mapper = InitializeAutomapper();
var controller = new CitiesController(mapper, null, null, repository);
return(controller);
}
// No cities thus empty list
public void TestGetCitiesNoCities()
{
var cities = new List <City> {
}.AsQueryable();
var mockSet = new Mock <DbSet <City> >();
mockSet.As <IQueryable <City> >().Setup(m => m.Provider).Returns(cities.Provider);
mockSet.As <IQueryable <City> >().Setup(m => m.Expression).Returns(cities.Expression);
mockSet.As <IQueryable <City> >().Setup(m => m.ElementType).Returns(cities.ElementType);
var mockContext = new Mock <CityInfoContext>();
mockContext.Setup(m => m.Cities).Returns(mockSet.Object);
var repo = new CityInfoRepository(mockContext.Object);
Assert.Empty(repo.GetCities());
}
// Cities with existing city id, no points of interest
public void TestGetPointNoPoints()
{
var cities = new List <City>
{
new City {
Id = 1, Name = "Richmond", Description = "Small"
},
new City {
Id = 2, Name = "Vancouver", Description = "Big"
}
}.AsQueryable();
var points = new List <PointOfInterest> {
}.AsQueryable();
var mockSet = new Mock <DbSet <City> >();
mockSet.As <IQueryable <City> >().Setup(m => m.Provider).Returns(cities.Provider);
mockSet.As <IQueryable <City> >().Setup(m => m.Expression).Returns(cities.Expression);
mockSet.As <IQueryable <City> >().Setup(m => m.ElementType).Returns(cities.ElementType);
var mockSetP = new Mock <DbSet <PointOfInterest> >();
mockSetP.As <IQueryable <City> >().Setup(m => m.Provider).Returns(points.Provider);
mockSetP.As <IQueryable <City> >().Setup(m => m.Expression).Returns(points.Expression);
mockSetP.As <IQueryable <City> >().Setup(m => m.ElementType).Returns(points.ElementType);
var mockContext = new Mock <CityInfoContext>();
mockContext.Setup(m => m.Cities).Returns(mockSet.Object);
mockContext.Setup(m => m.PointsOfInterest).Returns(mockSetP.Object);
var repo = new CityInfoRepository(mockContext.Object);
Assert.Null(repo.GetPointOfInterestForCity(1, 1));
}
// Cities with existing city id, correct poi id
public void TestGetPoint()
{
PointOfInterest poi1 = new PointOfInterest
{
Id = 1,
Name = "Downtown",
Description = "Lots of food",
CityId = 1
};
PointOfInterest poi2 = new PointOfInterest
{
Id = 2,
Name = "Stanley Park",
Description = "Lots to do",
CityId = 1
};
PointOfInterest poi3 = new PointOfInterest
{
Id = 3,
Name = "Science World",
Description = "Lots of science",
CityId = 2
};
PointOfInterest poi4 = new PointOfInterest
{
Id = 4,
Name = "UBC",
Description = "School",
CityId = 2
};
var cities = new List <City>
{
new City {
Id = 1, Name = "Richmond", Description = "Small"
},
new City {
Id = 2, Name = "Vancouver", Description = "Big"
}
}.AsQueryable();
var points = new List <PointOfInterest> {
poi1, poi2, poi3, poi4
}.AsQueryable();
var mockSet = new Mock <DbSet <City> >();
mockSet.As <IQueryable <City> >().Setup(m => m.Provider).Returns(cities.Provider);
mockSet.As <IQueryable <City> >().Setup(m => m.Expression).Returns(cities.Expression);
mockSet.As <IQueryable <City> >().Setup(m => m.ElementType).Returns(cities.ElementType);
var mockSetP = new Mock <DbSet <PointOfInterest> >();
mockSetP.As <IQueryable <City> >().Setup(m => m.Provider).Returns(points.Provider);
mockSetP.As <IQueryable <City> >().Setup(m => m.Expression).Returns(points.Expression);
mockSetP.As <IQueryable <City> >().Setup(m => m.ElementType).Returns(points.ElementType);
var mockContext = new Mock <CityInfoContext>();
mockContext.Setup(m => m.Cities).Returns(mockSet.Object);
mockContext.Setup(m => m.PointsOfInterest).Returns(mockSetP.Object);
var repo = new CityInfoRepository(mockContext.Object);
Assert.Equal(2, repo.GetPointOfInterestForCity(1, 2).Id);
Assert.Equal("Stanley Park", repo.GetPointOfInterestForCity(1, 2).Name);
Assert.Equal("Lots to do", repo.GetPointOfInterestForCity(1, 2).Description);
Assert.Equal(1, repo.GetPointOfInterestForCity(1, 2).CityId);
}
public CityController(CityInfoRepository cityInfoRepository)
{
_cityInfoRepository = cityInfoRepository;
}
public PointsOfInteresController(ILogger <PointsOfInteresController> logger, IMailService localMailService, CityInfoRepository cityInfoRepository)
{
_logger = logger;
_localMailService = localMailService;
_cityInfoRepository = cityInfoRepository;
}
