public function setUp() { $this->pdo = new \PDO("mysql:host=127.0.0.1;dbname=tests", 'root', ''); $this->pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION); $this->pdo->exec('SET NAMES utf8'); /** * Table cars; SQLCommand */ $table = new CarTable($this->pdo); $this->carsSqlCommand = new SQLCommand($table->getTableName(), CarEntity::getColumns()); }
/** * @covers ::update */ public function testUpdate() { $carTable = new CarTable($this->pdo); $cars = $carTable->findAll(); $this->assertCount(2, $cars); /** * Alter first car */ $firstCar = $cars[0]; $this->assertFalse($firstCar->isAltered()); $firstCar->set('horsepower', 21); $this->assertTrue($firstCar->isAltered()); $carTable->update($firstCar); /** * Alter second car */ $secondCar = $cars[1]; $this->assertFalse($secondCar->isAltered()); $secondCar->set('horsepower', 41); $this->assertTrue($secondCar->isAltered()); $carTable->update($secondCar); /** * Assert data set */ $expectedCsvDataSet = new \PHPUnit_Extensions_Database_DataSet_CsvDataSet(); $expectedCsvDataSet->addTable('cars', dirname(__FILE__) . '/../Fixture/cars_after-update.csv'); $expectedDataSet = new \PHPUnit_Extensions_Database_DataSet_DataSetFilter($expectedCsvDataSet); $expectedDataSet->setExcludeColumnsForTable('cars', ['modified', 'created']); $dataSet = new \PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection()); $dataSet->addTable('cars', 'SELECT * FROM `cars`'); $dataSet = new \PHPUnit_Extensions_Database_DataSet_DataSetFilter($dataSet); $dataSet->setExcludeColumnsForTable('cars', ['modified', 'created']); $this->assertDataSetsEqual($expectedDataSet, $dataSet); }
protected function index() { $this->view = '../tests/View/Cars/Fixture/index'; $carTable = new CarTable($this->pdo); $this->set('cars', $carTable->findAll()); }