Beispiel #1
0
    $teamStatisticGameId = filter_input(INPUT_GET, "gameId", FILTER_SANITIZE_NUMBER_INT);
    $teamStatisticTeamId = filter_input(INPUT_GET, "teamId", FILTER_SANITIZE_NUMBER_INT);
    $teamStatisticStatisticId = filter_input(INPUT_GET, "statisticId", FILTER_SANITIZE_NUMBER_INT);
    $teamStatisticValue = filter_input(INPUT_GET, "statisticValue", FILTER_SANITIZE_NUMBER_INT);
    //handle REST calls, while only allowing administrators to access database-modifying methods
    if ($method === "GET") {
        //set XSRF cookie
        setXsrfCookie("/");
        //get the teamStatistic based on the given field
    }
    if (empty($teamStatisticGameId) === false) {
        $teamStatistic = TeamStatistic::getTeamStatisticByTeamStatisticGameId($pdo, $teamStatisticGameId);
        $reply->data = $teamStatistic;
    } else {
        if (empty($teamStatisticTeamId) === false) {
            $teamStatistics = TeamStatistic::getTeamStatisticByTeamStatisticTeamId($pdo, $teamStatisticTeamId)->toArray();
            $reply->data = $teamStatistics;
            //	if($teamStatistic !== null && $teamStatistic->getPlayerId() === $_SESSION["teamStatistic"]->getTeamId()) {
            //		$reply->data = $teamStatistic;
            //	}
        } else {
            if (empty($teamStatisticStatisticId) === false) {
                $teamStatistic = TeamStatistic::getTeamStatisticByTeamStatisticStatisticId($pdo, $teamStatisticStatisticId);
                $reply->data = $teamStatistic;
                //	if($teamStatistic !== null && $teamStatistic->getStatisticId() === $_SESSION["teamStatistic"]->getStatisticId()) {
                //		$reply->data = $teamStatistic;
                //		}
            }
        }
    }
} catch (Exception $exception) {
 /**
  * test inserting a valid TeamStatistic and verify that the actual mySQL data matches
  **/
 public function testInsertValidTeamStatisticByTeamStatisticTeamId()
 {
     // 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
     $pdoTeamStatistic = TeamStatistic::getTeamStatisticByTeamStatisticTeamId($this->getPDO(), $this->game->getGameId(), $this->team->getTeamId(), $this->statistic->getStatisticId());
     $this->assertEquals($numRows + 1, $this->getConnection()->getRowCount("teamStatistic"));
     $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);
 }