/**
* test grabbing a TeamStatistic that does not exist
**/
public function testGetInvalidTeamStatistic()
{
// count the number of rows and save it for later
$numRows = $this->getConnection()->getRowCount("teamStatistic");
// create a new TeamStatistics and insert to into mySQL
$teamStatistic = new TeamStatistic($this->game->getGameId(), $this->team->getTeamId(), $this->statistic->getStatisticId(), $this->VALID_TEAMSTATISTICVALUE);
$teamStatistic->insert($this->getPDO());
// grab the data from mySQL and enforce the fields match our expectations
$results = TeamStatistic::getAllTeamStatistics($this->getPDO());
$this->assertEquals($numRows + 1, $this->getConnection()->getRowCount("teamStatistic"));
$this->assertCount(1, $results);
$this->assertContainsOnlyInstancesOf("Edu\\Cnm\\Sprots\\TeamStatistic", $results);
// grab the result from the array and validate it
$pdoTeamStatistic = $results[0];
$this->assertEquals($pdoTeamStatistic->getTeamStatisticGameId(), $this->game->getGameId());
$this->assertEquals($pdoTeamStatistic->getTeamStatisticTeamId(), $this->team->getTeamId());
$this->assertEquals($pdoTeamStatistic->getTeamStatisticStatisticId(), $this->statistic->getStatisticId());
$this->assertEquals($pdoTeamStatistic->getTeamStatisticValue(), $this->VALID_TEAMSTATISTICVALUE);
}
/**
* test inserting a Statistic and re grabbing it from mySQL
**/
public function testGetValidStatisticByStatisticId()
{
//count the number of rows and save
$numRows = $this->getConnection()->getRowCount("statistic");
//create a new Statistic adn insert into mySQL
$statistic = new Statistic(null, $this->VALID_STATISTICNAME);
$statistic->insert($this->getPDO());
//grab data from mySQL and enforce the fields to expectations
$pdoStatistic = Statistic::getStatisticByStatisticId($this->getPDO(), $statistic->getStatisticId());
$this->assertEquals($numRows + 1, $this->getConnection()->getRowCount("statistic"));
$this->assertEquals($pdoStatistic->getStatisticName(), $this->VALID_STATISTICNAME);
}
