Esempio n. 1
0
 public function testAddTimestamps()
 {
     $adapter = new MysqlAdapter(array());
     $table = new \Phinx\Db\Table('ntable', array(), $adapter);
     $table->addTimestamps();
     $columns = $table->getPendingColumns();
     $this->assertEquals('created_at', $columns[0]->getName());
     $this->assertEquals('timestamp', $columns[0]->getType());
     $this->assertEquals('CURRENT_TIMESTAMP', $columns[0]->getDefault());
     $this->assertEquals('', $columns[0]->getUpdate());
     $this->assertEquals('updated_at', $columns[1]->getName());
     $this->assertEquals('timestamp', $columns[1]->getType());
     $this->assertTrue($columns[1]->isNull());
     $this->assertNull($columns[1]->getDefault());
 }
Esempio n. 2
0
 /**
  * @dataProvider provideTimestampColumnNames
  *
  * @param AdapterInterface $adapter
  * @param string|null      $createdAtColumnName
  * @param string|null      $updatedAtColumnName
  * @param string           $expectedCreatedAtColumnName
  * @param string           $expectedUpdatedAtColumnName
  */
 public function testAddTimestamps(AdapterInterface $adapter, $createdAtColumnName, $updatedAtColumnName, $expectedCreatedAtColumnName, $expectedUpdatedAtColumnName)
 {
     $table = new \Phinx\Db\Table('ntable', [], $adapter);
     $table->addTimestamps($createdAtColumnName, $updatedAtColumnName);
     $columns = $table->getPendingColumns();
     $this->assertEquals($expectedCreatedAtColumnName, $columns[0]->getName());
     $this->assertEquals('timestamp', $columns[0]->getType());
     $this->assertEquals('CURRENT_TIMESTAMP', $columns[0]->getDefault());
     $this->assertEquals('', $columns[0]->getUpdate());
     $this->assertEquals($expectedUpdatedAtColumnName, $columns[1]->getName());
     $this->assertEquals('timestamp', $columns[1]->getType());
     $this->assertEquals('', $columns[1]->getUpdate());
     $this->assertTrue($columns[1]->isNull());
     $this->assertNull($columns[1]->getDefault());
 }