/** * @depends testCanAddColumnComment */ public function testCanRemoveColumnComment() { $table = new \Phinx\Db\Table('table1', array(), $this->adapter); $table->addColumn('field1', 'string', array('comment' => 'Comments from column "field1"'))->save(); $table->changeColumn('field1', 'string', array('comment' => 'null'))->save(); $row = $this->adapter->fetchRow('SELECT (select pg_catalog.col_description(oid,cols.ordinal_position::int) from pg_catalog.pg_class c where c.relname=cols.table_name ) as column_comment FROM information_schema.columns cols WHERE cols.table_catalog=\'' . TESTS_PHINX_DB_ADAPTER_POSTGRES_DATABASE . '\' AND cols.table_name=\'table1\' AND cols.column_name = \'field1\''); $this->assertEmpty($row['column_comment'], 'Dont remove column comment correctly'); }
/** * @depends testCanAddColumnComment */ public function testColumnsAreResetBetweenTables() { $table = new \Phinx\Db\Table('widgets', array(), $this->adapter); $table->addColumn('transport', 'string', array('comment' => $comment = 'One of: car, boat, truck, plane, train'))->save(); $table = new \Phinx\Db\Table('things', array(), $this->adapter); $table->addColumn('speed', 'integer')->save(); $row = $this->adapter->fetchRow('SELECT (select pg_catalog.col_description(oid,cols.ordinal_position::int) from pg_catalog.pg_class c where c.relname=cols.table_name ) as column_comment FROM information_schema.columns cols WHERE cols.table_catalog=\'' . TESTS_PHINX_DB_ADAPTER_POSTGRES_DATABASE . '\' AND cols.table_name=\'widgets\' AND cols.column_name = \'transport\''); $this->assertEquals($comment, $row['column_comment'], 'Could not create column comment'); }