/**
  * test inserting a PlayerStatistic, editing it, and updating it
  */
 public function testUpdateValidPlayerStatistic()
 {
     // count the number of rows and save it for later
     $numRows = $this->getConnection()->getRowCount("playerStatistic");
     // create a new PlayerStatistics and insert to into mySQL
     $playerStatistic = new PlayerStatistic(null, $this->plsayerStatistic->getPlayerStatisticId(), $this->VALID_PLAYERSTATISTIC);
     $playerStatistic->insert($this->getPDO());
     // edit the PlayerStatistic and update it in mySQL
     $playerStatistic->setPlayerStatistic($this->VALID_PLAYERSTATISTIC);
     $playerStatistic->update($this->getPDO());
     // grab the data from mySQL and enforce the fields match our expectations
     $pdoPlayerStatistic = PlayerStatistic::getPlayerStatisticByPlayerStatisticId($this->getPDO(), $playerStatistic->getPlayerStatisticId());
     $this->assertEquals($numRows + 1, $this->getConnection()->getRowCount("playerStatistic"));
     $this->assertEquals($pdoPlayerStatistic->getPlayerStatisticId(), $this->playerStatistic->getPlayerStatisticId());
 }