/**
* test grabbing all players
**/
public function testGetAllValidPlayers()
{
// count the number of rows and save it for later
$numRows = $this->getConnection()->getRowCount("player");
// create a new player and insert to into mySQL
$player = new Player(null, $this->VALID_PLAYERAPIID, $this->team->getTeamId(), $this->sport->getSportId(), $this->VALID_PLAYERNAME);
$player->insert($this->getPDO());
// grab the data from mySQL and enforce the fields match our expectations
$results = Player::getAllPlayers($this->getPDO());
$this->assertEquals($numRows + 1, $this->getConnection()->getRowCount("player"));
$this->assertCount(1, $results);
$this->assertContainsOnlyInstancesOf("Edu\\Cnm\\Sprots\\Player", $results);
// grab the result from the array and validate it
$pdoPlayer = $results[0];
$this->assertEquals($pdoPlayer->getPlayerId(), $player->getPlayerId());
$this->assertEquals($pdoPlayer->getPlayerApiId(), $this->VALID_PLAYERAPIID);
$this->assertEquals($pdoPlayer->getPlayerTeamId(), $this->team->getTeamId());
$this->assertEquals($pdoPlayer->getPlayerSportId(), $this->sport->getSportId());
$this->assertEquals($pdoPlayer->getPlayerName(), $this->VALID_PLAYERNAME);
}
$teamApiId = filter_input(INPUT_GET, "teamApiId", FILTER_SANITIZE_STRING);
$teamCity = filter_input(INPUT_GET, "teamCity", FILTER_SANITIZE_STRING);
$teamName = filter_input(INPUT_GET, "teamName", FILTER_SANITIZE_STRING);
//get the team based on the given field
if (empty($id) === false) {
$team = Team::getTeamByTeamId($pdo, $id);
$reply->data = $team;
} elseif (empty($teamId) === false) {
$team = Team::getTeamByTeamApiId($pdo, $teamApiId);
$reply->date = $team;
} elseif (empty($teamCity) === false) {
$team = Team::getTeamByTeamCity($pdo, $teamCity);
$reply->date = $team;
} elseif (empty($teamName) === false) {
$team = Team::getTeamByTeamName($pdo, $teamName);
$reply->date = $team;
} else {
$reply->data = Team::getAllTeams($pdo)->toArray();
}
} catch (Exception $exception) {
$reply->status = $exception->getCode();
$reply->message = $exception->getMessage();
} catch (TypeError $typeError) {
$reply->status = $typeError->getCode();
$reply->message = $typeError->getMessage();
}
header("Content-type: application/json");
if ($reply->data === null) {
unset($reply->data);
}
echo json_encode($reply);
/**
* 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);
}
