/** * test inserting a Team, editing it, and then updating it **/ public function testUpdateValidTeam() { // count the number of rows and save it for later $numRows = $this->getConnection()->getRowCount("team"); // Create a new team and insert into mySQL $team = new Team(null, $this->sport->getSportId(), $this->VALID_TEAMAPIID, $this->VALID_TEAMCITY, $this->VALID_TEAMNAME); $team->insert($this->getPDO()); // edit the Team and update it in mySQL $team->setTEAMAPIID($this->VALID_TEAMAPIID2); $team->setTEAMCITY($this->VALID_TEAMCITY2); $team->setTEAMNAME($this->VALID_TEAMNAME2); $team->update($this->getPDO()); // grab the data from mySQL and enforce the fields match our expectations $pdoTeam = Team::getTeamByTeamId($this->getPDO(), $team->getTeamId()); $this->assertEquals($numRows + 1, $this->getConnection()->getRowCount("team")); $this->assertEquals($pdoTeam->getTeamSportId(), $this->sport->getSportId()); $this->assertEquals($pdoTeam->getTeamApiId(), $this->VALID_TEAMAPIID2); $this->assertEquals($pdoTeam->getTeamCity(), $this->VALID_TEAMCITY2); $this->assertEquals($pdoTeam->getTeamName(), $this->VALID_TEAMNAME2); //$this->assertEquals($pdoTeam->getTeamSportId(), $this->VALID_TEAMSPORTID); }