private void InitContext()
{
var rand = new Random();
CocktailsContext = new CocktailsContext(CreateContextOptions());
var flavors = Enumerable.Range(1, 100)
.Select(i => new Flavor
{
Id = Guid.NewGuid(),
Name = $"Flavor{i}",
ModifiedDate = DateTimeOffset.UtcNow.AddTicks(rand.Next())
});
var categories = Enumerable.Range(1, 100)
.Select(i => new Category
{
Id = Guid.NewGuid(),
Name = $"Category{i}",
ModifiedDate = DateTimeOffset.UtcNow.AddTicks(rand.Next())
});
CocktailsContext.Flavors.AddRange(flavors);
CocktailsContext.Categories.AddRange(categories);
CocktailsContext.SaveChanges();
var ingredients = Enumerable.Range(1, 100)
.Select(i => new Ingredient
{
Id = Guid.NewGuid(),
Name = $"Ingredient{i}",
FlavorId = CocktailsContext.Flavors.ToArray()[i - 1].Id,
CategoryId = CocktailsContext.Categories.ToArray()[i - 1].Id,
ModifiedDate = DateTimeOffset.UtcNow.AddTicks(rand.Next())
});
CocktailsContext.Ingredients.AddRange(ingredients);
CocktailsContext.SaveChanges();
var cocktails = Enumerable.Range(1, 100)
.Select(i => new Cocktail
{
Id = Guid.NewGuid(),
Name = $"Cocktail{i}",
ModifiedDate = DateTimeOffset.UtcNow.AddTicks(rand.Next())
});
CocktailsContext.Cocktails.AddRange(cocktails);
CocktailsContext.SaveChanges();
}
public RecipeImporterTests()
{
var builder = new DbContextOptionsBuilder <CocktailsContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString());
_db = new CocktailsContext(builder.Options);
_sut = new RecipeImporter(_db);
_db.Library.Add(new Library
{
Id = LibraryId,
Name = LibraryName
});
_db.SaveChanges();
}
public async Task GetFlavorWithCorrectId()
{
var id = Guid.NewGuid();
var flavor = new Flavor {
Id = id, Name = "flavor"
};
CocktailsContext.Add(flavor);
CocktailsContext.SaveChanges();
var result = await _repository.GetSingleAsync(x => x.Where(y => y.Id == id), _token);
Assert.IsNotNull(result);
Assert.AreEqual(flavor.Id, result.Id);
Assert.AreEqual(flavor.Name, result.Name);
}
public void GetCocktailsByNameTest()
{
const string nameKeyword = "Name ";
var item1 = CocktailsContext.Cocktails.ToArray()[0];
var item2 = CocktailsContext.Cocktails.ToArray()[1];
item1.Name = nameKeyword + 1;
item2.Name = nameKeyword + 2;
CocktailsContext.SaveChanges();
var result = QueryFunctions.CocktailsByNameFunction(CocktailsContext.Cocktails, nameKeyword).ToArray();
Assert.AreEqual(2, result.Length);
Assert.Contains(item1, result);
Assert.Contains(item2, result);
}