/**
* Test function getPostsAuthorHasRepliedTo
*/
public function testGetPostsAuthorHasRepliedTo()
{
$dao = new PostMySQLDAO();
$posts_replied_to = $dao->getPostsAuthorHasRepliedTo(18, 10, 'twitter');
$this->assertEqual($posts_replied_to[0]["questioner_username"], "user2");
$this->assertEqual($posts_replied_to[0]["question"], "@shutterbug Nice shot!");
$this->assertEqual($posts_replied_to[0]["answerer_username"], "shutterbug");
$this->assertEqual($posts_replied_to[0]["answer"], "@user2 Thanks!");
$posts_replied_to = $dao->getPostsAuthorHasRepliedTo(13, 10, 'twitter');
$this->assertEqual(sizeof($posts_replied_to), 1);
$this->assertEqual($posts_replied_to[0]["question_post_id"], 139);
$this->assertEqual($posts_replied_to[0]["questioner_username"], "user1");
$this->assertEqual($posts_replied_to[0]["question"], "@ev When will Twitter have a business model?");
$this->assertEqual($posts_replied_to[0]['answer_post_id'], 140);
$this->assertEqual($posts_replied_to[0]["answerer_username"], "ev");
$this->assertEqual($posts_replied_to[0]["answer"], "@user1 Soon...");
}
/**
* Test function getPostsAuthorHasRepliedTo
*/
public function testGetPostsAuthorHasRepliedTo()
{
//Public exchanges only
$dao = new PostMySQLDAO();
$posts_replied_to = $dao->getPostsAuthorHasRepliedTo(18, 10, 'twitter', 1, true);
$this->assertEqual($posts_replied_to[0]["questioner_username"], "user2");
$this->assertEqual($posts_replied_to[0]["question"], "@shutterbug Nice shot!");
$this->assertEqual($posts_replied_to[0]["answerer_username"], "shutterbug");
$this->assertEqual($posts_replied_to[0]["answer"], "@user2 Thanks!");
//set up a private exchange
$builders[] = FixtureBuilder::build('posts', array('post_id' => 1000, 'author_user_id' => 20, 'author_username' => 'user1', 'author_fullname' => 'User 1', 'network' => 'twitter', 'post_text' => '@ev Privately, when will Twitter have a business model?', 'source' => 'web', 'pub_date' => '2010-03-01 00:00:00', 'reply_count_cache' => 0, 'retweet_count_cache' => 0, 'old_retweet_count_cache' => 0, 'in_rt_of_user_id' => null, 'in_reply_to_post_id' => null, 'in_reply_to_user_id' => 13, 'is_protected' => 1));
$builders[] = FixtureBuilder::build('posts', array('post_id' => 1001, 'author_user_id' => 13, 'author_username' => 'ev', 'author_fullname' => 'Ev Williams', 'network' => 'twitter', 'post_text' => '@user1 Privately? Soon...', 'source' => 'web', 'pub_date' => '2010-03-01 01:00:00', 'old_retweet_count_cache' => 0, 'in_rt_of_user_id' => null, 'is_protected' => 1, 'reply_count_cache' => 0, 'retweet_count_cache' => 0, 'in_reply_to_user_id' => 20, 'in_reply_to_post_id' => 1000));
$posts_replied_to = $dao->getPostsAuthorHasRepliedTo(13, 10, 'twitter', 1, true);
$this->assertEqual(sizeof($posts_replied_to), 1);
$this->assertEqual($posts_replied_to[0]["question_post_id"], 139);
$this->assertEqual($posts_replied_to[0]["questioner_username"], "user1");
$this->assertEqual($posts_replied_to[0]["question"], "@ev When will Twitter have a business model?");
$this->assertFalse($posts_replied_to[0]["question_is_protected"]);
$this->assertEqual($posts_replied_to[0]['answer_post_id'], 140);
$this->assertEqual($posts_replied_to[0]["answerer_username"], "ev");
$this->assertEqual($posts_replied_to[0]["answer"], "@user1 Soon...");
$this->assertFalse($posts_replied_to[0]["answer_is_protected"]);
$posts_replied_to = $dao->getPostsAuthorHasRepliedTo(13, 10, 'twitter', 1, false);
$this->assertEqual(sizeof($posts_replied_to), 2);
$this->debug(Utils::varDumpToString($posts_replied_to));
$this->assertEqual($posts_replied_to[0]["question_post_id"], 1000);
$this->assertEqual($posts_replied_to[0]["questioner_username"], "user1");
$this->assertEqual($posts_replied_to[0]["question"], "@ev Privately, when will Twitter have a business model?");
$this->assertTrue($posts_replied_to[0]["question_is_protected"]);
$this->assertEqual($posts_replied_to[0]['answer_post_id'], 1001);
$this->assertEqual($posts_replied_to[0]["answerer_username"], "ev");
$this->assertEqual($posts_replied_to[0]["answer"], "@user1 Privately? Soon...");
$this->assertTrue($posts_replied_to[0]["answer_is_protected"]);
$this->assertEqual($posts_replied_to[1]["question_post_id"], 139);
$this->assertEqual($posts_replied_to[1]["questioner_username"], "user1");
$this->assertEqual($posts_replied_to[1]["question"], "@ev When will Twitter have a business model?");
$this->assertEqual($posts_replied_to[1]['answer_post_id'], 140);
$this->assertEqual($posts_replied_to[1]["answerer_username"], "ev");
$this->assertEqual($posts_replied_to[1]["answer"], "@user1 Soon...");
}
/**
* Test getExchangesBetweenUsers
*/
function testGetExchangesBetweenUsers()
{
$dao = new PostMySQLDAO();
$posts_replied_to = $dao->getExchangesBetweenUsers(18, 21);
$this->assertEqual(sizeof($posts_replied_to), 2);
$this->assertEqual($posts_replied_to[0]["questioner_username"], "shutterbug");
$this->assertEqual($posts_replied_to[0]["question"], "This is image post 1");
$this->assertEqual($posts_replied_to[0]["answerer_username"], "user2");
$this->assertEqual($posts_replied_to[0]["answer"], "@shutterbug Nice shot!");
$this->assertEqual($posts_replied_to[1]["questioner_username"], "user2");
$this->assertEqual($posts_replied_to[1]["question"], "@shutterbug Nice shot!");
$this->assertEqual($posts_replied_to[1]["answerer_username"], "shutterbug");
$this->assertEqual($posts_replied_to[1]["answer"], "@user2 Thanks!");
$posts_replied_to = $dao->getPostsAuthorHasRepliedTo(13, 20);
$this->assertEqual(sizeof($posts_replied_to), 1);
$this->assertEqual($posts_replied_to[0]["questioner_username"], "user1");
$this->assertEqual($posts_replied_to[0]["question"], "@ev When will Twitter have a business model?");
$this->assertEqual($posts_replied_to[0]["answerer_username"], "ev");
$this->assertEqual($posts_replied_to[0]["answer"], "@user1 Soon....");
}
