/**
* 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 grab all games
*/
public function testGetAllValidGames()
{
//count the numbers of rows and save
$numRows = $this->getConnection()->getRowCount("game");
//create a new Game and insert into mySql
$game = new Game(null, $this->team->getTeamId(), $this->team2->getTeamId(), $this->VALID_GAMETIME);
$game->insert($this->getPDO());
//grab the dat from mySQL and enforce the fields match
$results = Game::getAllGame($this->getPDO());
$this->assertEquals($numRows + 1, $this->getConnection()->getRowCount('game'));
$this->assertCount(1, $results);
$this->assertContainsOnlyInstancesOf("Edu\\Cnm\\Sprots\\Game", $results);
//grab the results from the array and validate
$pdoGame = $results[0];
$this->assertEquals($pdoGame->getGameFirstTeamId(), $this->team->getTeamId());
}
