doctrine / dbal

        );

    }

    public function testGeneratesTableAlterationWithRemovedColumnCommentSql()

    {

        $table = new Table('mytable');

        $table->addColumn('foo', 'string', array('comment' => 'foo comment'));

        $tableDiff = new TableDiff('mytable');

        $tableDiff->fromTable = $table;

        $tableDiff->changedColumns['foo'] = new ColumnDiff(

            'foo',

            new Column('foo', Type::getType('string')),

            array('comment')

        );

        self::assertEquals(

            array(

                "COMMENT ON COLUMN mytable.foo IS NULL"

            ),

            $this->_platform->getAlterTableSQL($tableDiff)

        );

    }

    /**

     * @dataProvider getLockHints

        );

    }

    public function testAlterTableAddColumns()

    {

        $diff = new TableDiff('user');

        $diff->addedColumns['foo'] = new Column('foo', Type::getType('string'));

        $diff->addedColumns['count'] = new Column('count', Type::getType('integer'), array('notnull' => false, 'default' => 1));

        $expected = array(

            'ALTER TABLE user ADD COLUMN foo VARCHAR(255) NOT NULL',

            'ALTER TABLE user ADD COLUMN count INTEGER DEFAULT 1',

        );

        self::assertEquals($expected, $this->_platform->getAlterTableSQL($diff));

    }

    /**

     * @dataProvider complexDiffProvider