$pdo = connectToEncryptedMySQL("/etc/apache2/capstone-mysql/sprots.ini");
//determine which HTTP method was used
$method = array_key_exists("HTTP_X_HTTP_METHOD", $_SERVER) ? $_SERVER["HTTP_X_HTTP_METHOD"] : $_SERVER["REQUEST_METHOD"];
//sanitize inputs
$id = filter_input(INPUT_GET, "id", FILTER_VALIDATE_INT);
//make sure the id is valid for methods that require it
if (($method === "DELETE" || $method === "PUT") && (empty($id) === true || $id < 0)) {
throw new InvalidArgumentException("id can not be empty or negative", 405);
}
//sanitize and trim other fields
$sportId = filter_input(INPUT_GET, "sportId", FILTER_VALIDATE_INT);
$sportLeague = filter_input(INPUT_GET, "sportLeague", FILTER_VALIDATE_INT);
$sportName = filter_input(INPUT_GET, "sportName", FILTER_VALIDATE_INT);
//get the Sport based on the given field
if (empty($id) === false) {
$sport = Sport::getSportBySportId($pdo, $id);
$reply->data = $sport;
} elseif (empty($teamId) === false) {
$sport = Sport::getSportBySportLeague($pdo, $playerTeamId);
$reply->date = $sport;
} elseif (empty($sportId) === false) {
$sport = Sport::getSportBySportName($pdo, $playerSportId);
$reply->date = $sport;
} else {
$reply->data = Sport::getAllSportLeagues($pdo)->toArray();
}
} catch (Exception $exception) {
$reply->status = $exception->getCode();
$reply->message = $exception->getMessage();
} catch (TypeError $typeError) {
$reply->status = $typeError->getCode();
/**
* test grabbing a Sport that does not exist
*/
public function testGetInvalidSportBySportId()
{
//grab a Sport id that exceeds the maximum allowable Sport id
$sport = Sport::getSportBySportId($this->getPDO(), SprotsTest::INVALID_KEY);
$this->assertNull($sport);
}
