/**
* 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);
}
