/** * test grabbing a Favorite by profile id **/ public function testGetValidFavoriteByProfileId() { // count the number of rows and save it for later $numRows = $this->getConnection()->getRowCount("favorite"); // create a new Favorite and insert to into mySQL $favorite = new Favorite($this->tweet->getTweetId(), $this->profile->getProfileId(), $this->VALID_FAVORITEDATE); $favorite->insert($this->getPDO()); // grab the data from mySQL and enforce the fields match our expectations $results = Favorite::getFavoriteByProfileId($this->getPDO(), $this->profile->getProfileId()); $this->assertEquals($numRows + 1, $this->getConnection()->getRowCount("favorite")); $this->assertCount(1, $results); $this->assertContainsOnlyInstancesOf("Favorite", $results); // grab the result from the array and validate it $pdoFavorite = $results[0]; $this->assertEquals($pdoFavorite->getTweetId(), $this->tweet->getTweetId()); $this->assertEquals($pdoFavorite->getProfileId(), $this->profile->getProfileId()); $this->assertEquals($pdoFavorite->getFavoriteDate(), $this->VALID_FAVORITEDATE); }
/** * test inserting a Tweet and regrabbing it from mySQL **/ public function testGetValidTweetByTweetId() { // count the number of rows and save it for later $numRows = $this->getConnection()->getRowCount("tweet"); // create a new Tweet and insert to into mySQL $tweet = new Tweet(null, $this->profile->getProfileId(), $this->VALID_TWEETCONTENT, $this->VALID_TWEETDATE); $tweet->insert($this->getPDO()); // grab the data from mySQL and enforce the fields match our expectations $pdoTweet = Tweet::getTweetByTweetId($this->getPDO(), $tweet->getTweetId()); $this->assertEquals($numRows + 1, $this->getConnection()->getRowCount("tweet")); $this->assertEquals($pdoTweet->getProfileId(), $this->profile->getProfileId()); $this->assertEquals($pdoTweet->getTweetContent(), $this->VALID_TWEETCONTENT); $this->assertEquals($pdoTweet->getTweetDate(), $this->VALID_TWEETDATE); }