public void GetById_ShouldReturn_CorrectGroupFromDb()
{
var options = new DbContextOptionsBuilder <TasksDbContext>()
.UseInMemoryDatabase(databaseName: "Get_group_by_id")
.Options;
using (var context = new TasksDbContext(options))
{
context.TaskGroups.AddRange(new TaskGroupEntity
{
Name = "TestGroup1",
UserTasks = new List <UserTaskEntity> {
new UserTaskEntity {
Name = "TestTask"
}
}
}, new TaskGroupEntity
{
Name = "TestGroup2"
});
context.SaveChanges();
}
using (var context = new TasksDbContext(options))
{
var taskGroupManager = new TaskGroupDbManager(context, _mapper);
var result = taskGroupManager.Get(1);
Assert.That(result.Id, Is.EqualTo(1));
Assert.That(result.Name, Is.EqualTo("TestGroup1"));
Assert.That(result.UserTasks.ToList().Exists(t => t.Name == "TestTask"), Is.True);
context.Database.EnsureDeleted();
}
}
public void Get_ShouldReturn_AllGroupsFromDb()
{
var options = new DbContextOptionsBuilder <TasksDbContext>()
.UseInMemoryDatabase(databaseName: "Get_all_groups")
.Options;
using (var context = new TasksDbContext(options))
{
context.TaskGroups.AddRange(new TaskGroupEntity
{
Name = "TestGroup1",
UserTasks = new List <UserTaskEntity> {
new UserTaskEntity {
Name = "TestTask"
}
}
}, new TaskGroupEntity
{
Name = "TestGroup2"
});
context.SaveChanges();
}
using (var context = new TasksDbContext(options))
{
var taskGroupManager = new TaskGroupDbManager(context, _mapper);
var result = taskGroupManager.Get();
Assert.That(result.Count, Is.EqualTo(2));
Assert.That(result.Exists(group => group.Name == "TestGroup1" && group.Id == 1 && group.UserTasks.Count() == 1), Is.True);
Assert.That(result.Exists(group => group.Name == "TestGroup2" && group.Id == 2 && !group.UserTasks.Any()), Is.True);
context.Database.EnsureDeleted();
}
}
