public async Task Create_Success()
{
var repository = new Core.Repositories.Sql.PostRepository(ConnectionString);
var post = new Post
{
Title = "Test title",
UserId = "1",
Content = "Test content.",
CreationDateTime = DateTime.UtcNow,
RevisionDateTime = DateTime.UtcNow
};
await repository.CreateAsync(post);
Assert.NotNull(post.Id);
using(var connection = new SqlConnection(ConnectionString))
{
var testPost = (await connection.QueryAsync<Post>($"SELECT * FROM [Post] WHERE [Id] = '{post.Id}';")).FirstOrDefault();
Assert.NotNull(testPost);
Assert.Equal(post.Id, testPost.Id);
}
}
public async Task Create_Success()
{
var repository = new Core.Repositories.Sql.PostRepository(ConnectionString);
var post = new Post
{
Title = "Test title",
UserId = "1",
Content = "Test content.",
CreationDateTime = DateTime.UtcNow,
RevisionDateTime = DateTime.UtcNow
};
await repository.CreateAsync(post);
Assert.NotNull(post.Id);
using (var connection = new SqlConnection(ConnectionString))
{
var testPost = (await connection.QueryAsync <Post>($"SELECT * FROM [Post] WHERE [Id] = '{post.Id}';")).FirstOrDefault();
Assert.NotNull(testPost);
Assert.Equal(post.Id, testPost.Id);
}
}
public async Task Page_CorrectOrder()
{
var repository = new Core.Repositories.Sql.PostRepository(ConnectionString);
var posts = await repository.PageAsync(null, 1, 2, true);
}
public async Task Page_CorrectOrder()
{
var repository = new Core.Repositories.Sql.PostRepository(ConnectionString);
var posts = await repository.PageAsync(null, 1, 2, true);
}
