public static BlogDbContextProvider Create()
{
var provider = new BlogDbContextProvider();
using (var ctx = provider.CreateContext())
{
ctx.Database.Migrate();
}
return(provider);
}
public async Task ShouldSaveTheTagsOfThePostAsExpected()
{
using (var provider = BlogDbContextProvider.Create())
{
string userId = Guid.NewGuid().ToString();
using (var context = provider.CreateContext())
{
var user = new IdentityUser
{
Id = userId,
UserName = TestUtils.RandomString(),
Email = $"{TestUtils.RandomString()}@{TestUtils.RandomString()}.com"
};
await context.Users.AddAsync(user);
await context.SaveChangesAsync();
}
var postId = Guid.NewGuid();
var tags = new[]
{
TestUtils.RandomString(),
TestUtils.RandomString()
};
using (var context = provider.CreateContext())
{
const string ipAddress = "127.0.0.1";
var user = await context.Users.FirstOrDefaultAsync(x => x.Id == userId);
var post = new PostEntity
{
Id = postId,
Language = "en-US",
Title = TestUtils.RandomString(),
Abstract = TestUtils.RandomString(40),
Content = TestUtils.RandomString(200),
Format = PostFormatEntity.PlainText,
CreatedBy = user,
CreatedOnUtc = DateTime.UtcNow,
CreationIpAddress = ipAddress,
Tags = new Collection <PostTagEntity>(tags.Select(t => new PostTagEntity
{
Tag = new TagEntity
{
Name = t,
Slug = TestUtils.RandomString(),
CreatedBy = user,
CreatedOnUtc = DateTime.UtcNow,
CreationIpAddress = ipAddress
}
}).ToList())
};
await context.Posts.AddAsync(post);
await context.SaveChangesAsync();
}
using (var context = provider.CreateContext())
{
// see https://docs.microsoft.com/en-us/ef/core/querying/related-data
var post = await context.Posts.Include(x => x.Tags)
.ThenInclude((PostTagEntity x) => x.Tag)
.AsNoTracking()
.FirstOrDefaultAsync(x => x.Id == postId);
var tagNames = post.Tags.Select(x => x.Tag.Name);
Assert.Equal(tags, tagNames);
}
}
}
public async Task FindApprovedPostById_ShouldFindThePostWhenItExistsAndApproved()
{
using (var provider = BlogDbContextProvider.Create())
{
var postId = Guid.NewGuid();
var expectedTitle = TestUtils.RandomString();
var expectedAbstract = TestUtils.RandomString(40);
using (var context = provider.CreateContext())
{
const string ipAddress = "127.0.0.1";
string userId = Guid.NewGuid().ToString();
var user = new IdentityUser
{
Id = userId,
UserName = TestUtils.RandomString(),
Email = $"{TestUtils.RandomString()}@{TestUtils.RandomString()}.com"
};
var post = new PostEntity
{
Id = postId,
Language = "en-US",
Title = expectedTitle,
Abstract = expectedAbstract,
Content = TestUtils.RandomString(200),
Format = PostFormatEntity.PlainText,
CreatedBy = user,
CreatedOnUtc = DateTime.UtcNow,
CreationIpAddress = ipAddress,
Tags = new Collection <PostTagEntity>((new[]
{
TestUtils.RandomString(),
TestUtils.RandomString()
}).Select(t => new PostTagEntity
{
Tag = new TagEntity
{
Name = t,
Slug = TestUtils.RandomString(),
CreatedBy = user,
CreatedOnUtc = DateTime.UtcNow,
CreationIpAddress = ipAddress
}
}).ToList())
};
await context.Users.AddAsync(user);
await context.Posts.AddAsync(post);
await context.SaveChangesAsync();
}
using (var context = provider.CreateContext())
{
var store = new PostsSqlServerRepository(context);
var result = await store.FindApprovedPostById(postId.ToString());
result.Match(
some =>
{
some.Switch(
found =>
{
var post = found;
Assert.Equal(postId.ToString(), post.Id);
Assert.Equal(expectedTitle, post.Title);
Assert.Equal(expectedAbstract, post.Abstract);
},
notApproved =>
{
Assert.True(false, $"Result shouldn't be {notApproved.GetType().ToString()}");
});
},
() =>
{
Assert.True(false, $"Result shouldn't be Option.None");
});
}
}
}