def test_should_get_one_post(self):
        yql_query = 'SELECT * FROM meme.posts WHERE owner_guid = "123guid" and pubid = "123pubid"'
        yql_mock = Mock()
        when(yql_mock).execute(yql_query).thenReturn(self.single_query_result)

        post_repository = PostRepository()
        post_repository.yql = yql_mock
        posts = post_repository.get("123guid", "123pubid")
        assert len(posts) == 1
        assert posts[0].guid == "123"