/**
* Test getMostRepliedToPostsByPublicInstancesInLastWeek
*/
function testGetMostRepliedToPostsByPublicInstancesInLastWeek()
{
//Add posts with retweets by user3, who is on the public timeline with retweet counts in the last 9 days
$counter = 0;
$id = 200;
while ($counter < 40) {
$id += $counter;
$q = "INSERT INTO tt_posts (post_id, author_user_id, author_username, author_fullname, author_avatar, post_text, source, pub_date, mention_count_cache, retweet_count_cache) VALUES ({$id}, 23, 'user3', 'User 3', 'avatar.jpg', 'This is post with {$counter} replies', 'web', DATE_SUB(NOW(), INTERVAL " . $counter . " DAY), " . $counter . ", 0 );";
//echo $q;
PDODAO::$PDO->exec($q);
$counter++;
}
$pdao = new PostMySQLDAO();
$page1ofposts = $pdao->getMostRepliedToPostsByPublicInstancesInLastWeek(1, 5);
$this->assertEqual(sizeof($page1ofposts), 5);
$this->assertEqual($page1ofposts[0]->mention_count_cache, 7);
$this->assertEqual($page1ofposts[1]->mention_count_cache, 6);
$page2ofposts = $pdao->getMostRepliedToPostsByPublicInstancesInLastWeek(2, 5);
$this->assertEqual(sizeof($page2ofposts), 2);
$this->assertEqual($page2ofposts[0]->mention_count_cache, 2);
$this->assertEqual($page2ofposts[1]->mention_count_cache, 1);
$totals = $pdao->getTotalPagesAndPostsByPublicInstances(5, 7);
$this->assertEqual($totals["total_posts"], 7);
$this->assertEqual($totals["total_pages"], 2);
}