/**
* test creating a PlayerStatistic then deleting it
**/
public function testDeleteValidPlayerStatistic()
{
// count the number of rows and save it for later
$numRows = $this->getConnection()->getRowCount("playerStatistic");
// create a new PlayerStatistic and insert to into mySQL
$playerStatistic = new PlayerStatistic(null, $this->playerStatistic->getPlayerStatisticId(), $this->VALID_PLAYERSTATISTIC);
$playerStatistic->insert($this->getPDO());
// Delete this PlayerStatistic from mySQL
$playerStatistic->assertEquals($numRows + 1, $this->getConnection()->getRowCount("playerStatistic"));
$playerStatistic->delete($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());
}
