doctrine / dbal

    /**

     * @group DBAL-2302

     */

    public function testDropNonAutoincrementColumnFromCompositePrimaryKeyWithAutoincrementColumn()

    {

        $table = new Table("tbl");

        $table->addColumn('id', 'integer', array('autoincrement' => true));

        $table->addColumn('foo', 'integer');

        $table->addColumn('bar', 'integer');

        $table->setPrimaryKey(array('id', 'foo'));

        $comparator = new Comparator();

        $diffTable = clone $table;

        $diffTable->dropPrimaryKey();

        $diffTable->setPrimaryKey(array('id'));

        self::assertSame(

            array(

                'ALTER TABLE tbl MODIFY id INT NOT NULL',

                'ALTER TABLE tbl DROP PRIMARY KEY',

                'ALTER TABLE tbl ADD PRIMARY KEY (id)',

            ),

            $this->_platform->getAlterTableSQL($comparator->diffTable($table, $diffTable))

        );

    }

    /**

     * @group DBAL-2302

    /**

     * @group DBAL-2302

     */

    public function testAddNonAutoincrementColumnToPrimaryKeyWithAutoincrementColumn()

    {

        $table = new Table("tbl");

        $table->addColumn('id', 'integer', array('autoincrement' => true));

        $table->addColumn('foo', 'integer');

        $table->addColumn('bar', 'integer');

        $table->setPrimaryKey(array('id'));

        $comparator = new Comparator();

        $diffTable = clone $table;

        $diffTable->dropPrimaryKey();

        $diffTable->setPrimaryKey(array('id', 'foo'));

        self::assertSame(

            array(

                'ALTER TABLE tbl MODIFY id INT NOT NULL',

                'ALTER TABLE tbl DROP PRIMARY KEY',

                'ALTER TABLE tbl ADD PRIMARY KEY (id, foo)',

            ),

            $this->_platform->getAlterTableSQL($comparator->diffTable($table, $diffTable))

        );

    }

    /**

     * @group DBAL-586

        ), $sql);

    }

    public function testAlterPrimaryKeyWithNewColumn()

    {

        $table = new Table("yolo");

        $table->addColumn('pkc1', 'integer');

        $table->addColumn('col_a', 'integer');

        $table->setPrimaryKey(array('pkc1'));

        $comparator = new Comparator();

        $diffTable = clone $table;

        $diffTable->addColumn('pkc2', 'integer');

        $diffTable->dropPrimaryKey();

        $diffTable->setPrimaryKey(array('pkc1', 'pkc2'));

        self::assertSame(

            array(

                'ALTER TABLE yolo DROP PRIMARY KEY',

                'ALTER TABLE yolo ADD pkc2 INT NOT NULL',

                'ALTER TABLE yolo ADD PRIMARY KEY (pkc1, pkc2)',

            ),

            $this->_platform->getAlterTableSQL($comparator->diffTable($table, $diffTable))

        );

    }

    public function testInitializesDoctrineTypeMappings()

    {