public void ShouldCreateAndRetrievePost()
{
var repository = new PostRepository(connection, transaction);
var post = new Post{ Title = "test", Content = "empty", Uri = "archive/2009/01/01/hello" };
repository.InsertPost(post);
var retrievedPost = repository.GetPostByUri(post.Uri);
Assert.AreEqual(retrievedPost.Title, post.Title);
Assert.AreEqual(retrievedPost.Content, post.Content);
Assert.AreEqual(retrievedPost.Uri, post.Uri);
}