/** * 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("Edu\\Cnm\\Dmcdonald21\\DataDesign\\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 Profile and regrabbing it from mySQL **/ public function testGetValidProfileByProfileId() { // count the number of rows and save it for later $numRows = $this->getConnection()->getRowCount("profile"); // create a new Profile and insert to into mySQL $profile = new Profile(null, $this->VALID_ATHANDLE, $this->VALID_EMAIL, $this->VALID_PHONE); $profile->insert($this->getPDO()); // grab the data from mySQL and enforce the fields match our expectations $pdoProfile = Profile::getProfileByProfileId($this->getPDO(), $profile->getProfileId()); $this->assertSame($numRows + 1, $this->getConnection()->getRowCount("profile")); $this->assertSame($pdoProfile->getAtHandle(), $this->VALID_ATHANDLE); $this->assertSame($pdoProfile->getEmail(), $this->VALID_EMAIL); $this->assertSame($pdoProfile->getPhone(), $this->VALID_PHONE); }