public function testGetAllQuestionPosts() { //Add a question $builder[] = FixtureBuilder::build('posts', array('author_user_id' => 13, 'author_username' => 'ev', 'post_text' => 'I need a new cell phone. What should I buy?', 'network' => 'twitter', 'in_reply_to_post_id' => 0, 'pub_date' => '-1d')); $dao = new PostMySQLDAO(); $questions = $dao->getAllQuestionPosts(13, 'twitter', 10); $this->debug('Questions: ' . $questions); $this->assertEqual(sizeof($questions), 1); $this->assertEqual($questions[0]->post_text, 'I need a new cell phone. What should I buy?'); //Add another question $builder[] = FixtureBuilder::build('posts', array('author_user_id' => 13, 'author_username' => 'ev', 'post_text' => 'Best sushi in NY? downtown', 'network' => 'twitter', 'in_reply_to_post_id' => 0, 'pub_date' => '-2d')); $questions = $dao->getAllQuestionPosts(13, 'twitter', 10); $this->assertEqual(sizeof($questions), 2); $this->assertEqual($questions[1]->post_text, 'Best sushi in NY? downtown'); $this->assertEqual($questions[0]->post_text, 'I need a new cell phone. What should I buy?'); //Messages with a question mark in between two characters (e.g. URLs) aren't necessarily questions $builder[] = FixtureBuilder::build('posts', array('author_user_id' => 13, 'author_username' => 'ev', 'post_text' => 'Love this video: http://www.youtube.com/watch?v=PQu-zrE-k5s', 'network' => 'twitter', 'in_reply_to_post_id' => 0, 'pub_date' => '-3d')); $questions = $dao->getAllQuestionPosts(13, 'twitter', 10); $this->assertEqual(sizeof($questions), 2); // test paging $questions = $dao->getAllQuestionPosts(13, 'twitter', $count = 1, $page = 1); $this->assertEqual($questions[0]->post_text, 'I need a new cell phone. What should I buy?'); $questions = $dao->getAllQuestionPosts(13, 'twitter', $count = 1, $page = 2); $this->assertEqual($questions[0]->post_text, 'Best sushi in NY? downtown'); // test count $questions = $dao->getAllQuestionPosts(13, 'twitter', $count = 1, $page = 1); $this->assertEqual(sizeof($questions), 1); $questions = $dao->getAllQuestionPosts(13, 'twitter', $count = 2, $page = 1); $this->assertEqual(sizeof($questions), 2); // test default order $questions = $dao->getAllQuestionPosts(13, 'twitter', $count = 1, $page = 1, "';-- SELECT"); $this->assertEqual($questions[0]->post_text, 'I need a new cell phone. What should I buy?'); }
public function testGetAllQuestionPosts() { //Add a question $question_builder = FixtureBuilder::build('posts', array('author_user_id' => 13, 'author_username' => 'ev', 'post_text' => 'I need a new cell phone. What should I buy?', 'network' => 'twitter', 'in_reply_to_post_id' => 0, 'pub_date' => '-1d')); $dao = new PostMySQLDAO(); $questions = $dao->getAllQuestionPosts(13, 'twitter', 10); $this->assertTrue(sizeof($questions), 1); $this->assertEqual($questions[0]->post_text, 'I need a new cell phone. What should I buy?'); //Add another question $question_builder1 = FixtureBuilder::build('posts', array('author_user_id' => 13, 'author_username' => 'ev', 'post_text' => 'Best sushi in NY? downtown', 'network' => 'twitter', 'in_reply_to_post_id' => 0, 'pub_date' => '-2d')); $questions = $dao->getAllQuestionPosts(13, 'twitter', 10); $this->assertTrue(sizeof($questions), 1); $this->assertEqual($questions[1]->post_text, 'Best sushi in NY? downtown'); $this->assertEqual($questions[0]->post_text, 'I need a new cell phone. What should I buy?'); }