/// <summary>
/// Creates DB context for testing.
/// </summary>
/// <returns>The DB context with data for testing</returns>
public static MoviesApiContext CreateContextWithDataForTesting()
{
var options = new DbContextOptionsBuilder <MoviesApiContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
MoviesApiContext context = new MoviesApiContext(options);
return(context);
}
/// <summary>
/// Add seed data to the DB
/// </summary>
/// <param name="context">the DB to be updated</param>
private static void AddTestData(MoviesApiContext context)
{
context.Movies.Add(new MovieItem
{
Id = 1,
Title = "The Shawshank Redemption",
YearOfRelease = 1994,
RunningTime = 142,
Genres = "Crime,Drama"
});
context.Movies.Add(new MovieItem
{
Id = 2,
Title = "American Beauty",
YearOfRelease = 1999,
RunningTime = 122,
Genres = "Drama"
});
context.Movies.Add(new MovieItem
{
Id = 3,
Title = "Moana",
YearOfRelease = 2016,
RunningTime = 107,
Genres = "Animation, Adventure, Comedy"
});
context.Movies.Add(new MovieItem
{
Id = 4,
Title = "X-Men",
YearOfRelease = 2000,
RunningTime = 104,
Genres = "Action,Adventure,Sci-fi"
});
context.Movies.Add(new MovieItem
{
Id = 5,
Title = "Pan's Labyrinth",
YearOfRelease = 2006,
RunningTime = 118,
Genres = "Drama, Fantasy"
});
context.Movies.Add(new MovieItem
{
Id = 6,
Title = "Zoolander",
YearOfRelease = 2001,
RunningTime = 90,
Genres = "Comedy"
});
context.UserRatings.Add(new UserRating
{
UserId = "Stuart",
MovieId = 1,
Rating = 5
});
context.UserRatings.Add(new UserRating
{
UserId = "Stuart",
MovieId = 2,
Rating = 3
});
context.UserRatings.Add(new UserRating
{
UserId = "Stuart",
MovieId = 3,
Rating = 2
});
context.UserRatings.Add(new UserRating
{
UserId = "Stuart",
MovieId = 4,
Rating = 3
});
context.UserRatings.Add(new UserRating
{
UserId = "Stuart",
MovieId = 5,
Rating = 5
});
context.UserRatings.Add(new UserRating
{
UserId = "Stuart",
MovieId = 6,
Rating = 2
});
context.UserRatings.Add(new UserRating
{
UserId = "Mary",
MovieId = 1,
Rating = 3
});
context.UserRatings.Add(new UserRating
{
UserId = "Mary",
MovieId = 2,
Rating = 2
});
context.UserRatings.Add(new UserRating
{
UserId = "Mary",
MovieId = 3,
Rating = 3
});
context.UserRatings.Add(new UserRating
{
UserId = "Mary",
MovieId = 4,
Rating = 4
});
context.UserRatings.Add(new UserRating
{
UserId = "Mary",
MovieId = 5,
Rating = 5
});
context.UserRatings.Add(new UserRating
{
UserId = "Wendy",
MovieId = 2,
Rating = 3
});
context.UserRatings.Add(new UserRating
{
UserId = "Wendy",
MovieId = 3,
Rating = 3
});
context.UserRatings.Add(new UserRating
{
UserId = "Wendy",
MovieId = 4,
Rating = 3
});
context.UserRatings.Add(new UserRating
{
UserId = "Wendy",
MovieId = 5,
Rating = 3
});
context.UserRatings.Add(new UserRating
{
UserId = "Wendy",
MovieId = 6,
Rating = 3
});
context.SaveChanges();
}