doctrine / dbal

    /**

     * @group DBAL-37

     */

    public function testAlterTableAutoIncrementAdd()

    {

        $tableFrom = new \Doctrine\DBAL\Schema\Table('autoinc_table_add');

        $column = $tableFrom->addColumn('id', 'integer');

        $this->_sm->createTable($tableFrom);

        $tableFrom = $this->_sm->listTableDetails('autoinc_table_add');

        self::assertFalse($tableFrom->getColumn('id')->getAutoincrement());

        $tableTo = new \Doctrine\DBAL\Schema\Table('autoinc_table_add');

        $column = $tableTo->addColumn('id', 'integer');

        $column->setAutoincrement(true);

        $c = new \Doctrine\DBAL\Schema\Comparator();

        $diff = $c->diffTable($tableFrom, $tableTo);

        $sql = $this->_conn->getDatabasePlatform()->getAlterTableSQL($diff);

        self::assertEquals(array(

            "CREATE SEQUENCE autoinc_table_add_id_seq",

            "SELECT setval('autoinc_table_add_id_seq', (SELECT MAX(id) FROM autoinc_table_add))",

            "ALTER TABLE autoinc_table_add ALTER id SET DEFAULT nextval('autoinc_table_add_id_seq')",

        ), $sql);

        $this->_sm->alterTable($diff);

        $tableFinal = $this->_sm->listTableDetails('autoinc_table_add');

        self::assertTrue($tableFinal->getColumn('id')->getAutoincrement());

    }

    /**

     * @group DBAL-37

    /**

     * @group DBAL-37

     */

    public function testAlterTableAutoIncrementDrop()

    {

        $tableFrom = new \Doctrine\DBAL\Schema\Table('autoinc_table_drop');

        $column = $tableFrom->addColumn('id', 'integer');

        $column->setAutoincrement(true);

        $this->_sm->createTable($tableFrom);

        $tableFrom = $this->_sm->listTableDetails('autoinc_table_drop');

        self::assertTrue($tableFrom->getColumn('id')->getAutoincrement());

        $tableTo = new \Doctrine\DBAL\Schema\Table('autoinc_table_drop');

        $column = $tableTo->addColumn('id', 'integer');

        $c = new \Doctrine\DBAL\Schema\Comparator();

        $diff = $c->diffTable($tableFrom, $tableTo);

        self::assertInstanceOf('Doctrine\DBAL\Schema\TableDiff', $diff, "There should be a difference and not false being returned from the table comparison");

        self::assertEquals(array("ALTER TABLE autoinc_table_drop ALTER id DROP DEFAULT"), $this->_conn->getDatabasePlatform()->getAlterTableSQL($diff));

        $this->_sm->alterTable($diff);

        $tableFinal = $this->_sm->listTableDetails('autoinc_table_drop');

        self::assertFalse($tableFinal->getColumn('id')->getAutoincrement());

    }

    /**

     * @group DBAL-75

        self::assertEquals('(-1)', $columns['col_string']->getDefault());

    }

    public function testAlterTableAutoIncrementBigInt()

    {

        $tableFrom = new \Doctrine\DBAL\Schema\Table('autoinc_table_bitgint');

        $column = $tableFrom->addColumn('id', 'integer');

        $column->setAutoincrement(true);

        $this->_sm->createTable($tableFrom);

        $tableFrom = $this->_sm->listTableDetails('autoinc_table_bitgint');

        self::assertTrue($tableFrom->getColumn('id')->getAutoincrement());

        $tableTo = new \Doctrine\DBAL\Schema\Table('autoinc_table_bitgint');

        $column = $tableTo->addColumn('id', 'bigint');

        $column->setAutoincrement(true);

        $c = new \Doctrine\DBAL\Schema\Comparator();

        $diff = $c->diffTable($tableFrom, $tableTo);

        self::assertInstanceOf('Doctrine\DBAL\Schema\TableDiff', $diff, "There should be a difference and not false being returned from the table comparison");

        self::assertEquals(array("ALTER TABLE autoinc_table_bitgint ALTER id TYPE BIGINT"), $this->_conn->getDatabasePlatform()->getAlterTableSQL($diff));

        $this->_sm->alterTable($diff);

        $tableFinal = $this->_sm->listTableDetails('autoinc_table_bitgint');

        self::assertTrue($tableFinal->getColumn('id')->getAutoincrement());

    }

}

class MoneyType extends Type