/**
* create dependent objects before running each test
**/
public final function setUp()
{
// run the default setUp() method first
parent::setUp();
// Create and insert a sport to own the test team
$this->sport = new Sport(null, "sportLeagues", "sportLeagues2", "SportNames", "SportNames2");
$this->sport->insert($this->getPDO());
// create and insert a Profile to own the test Team
$this->team = new Team(null, $this->sport->getSportId(), $this->VALID_TEAMAPIID, "TeamCities2", "TeamName");
$this->team->insert($this->getPDO());
$this->team2 = new Team(null, $this->sport->getSportId(), $this->VALID_TEAMAPIID2, "TeamCity2", "TeamName2");
$this->team2->insert($this->getPDO());
}
/**
* test grabbing all Teams
**/
public function testGetAllValidTeams()
{
// count the number of rows and save it for later
$numRows = $this->getConnection()->getRowCount("team");
// create a new Team and insert to into mySQL
$team = new Team(null, $this->sport->getSportId(), $this->VALID_TEAMAPIID, $this->VALID_TEAMCITY, $this->VALID_TEAMNAME);
$team->insert($this->getPDO());
// grab the data from mySQL and enforce the fields match our expectations
$results = Team::getAllTeams($this->getPDO());
$this->assertEquals($numRows + 1, $this->getConnection()->getRowCount("team"));
$this->assertCount(1, $results);
$this->assertContainsOnlyInstancesOf("Edu\\Cnm\\Sprots\\Team", $results);
// grab the result from the array and validate it
$pdoTeam = $results[0];
$this->assertEquals($pdoTeam->getTeamSportId(), $this->sport->getSportId());
$this->assertEquals($pdoTeam->getTeamApiId(), $this->VALID_TEAMAPIID);
$this->assertEquals($pdoTeam->getTeamCity(), $this->VALID_TEAMCITY);
$this->assertEquals($pdoTeam->getTeamName(), $this->VALID_TEAMNAME);
//$this->assertEquals($pdoTeam->getTeamSportId(), $this->VALID_TEAMSPORTID);
}
