Doctrine\Tests\DBAL\Functional\Ticket\DBAL2807Test

Complexity

Total Complexity

2

Size/Duplication

Total Lines	40
Duplicated Lines	0 %

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	testAlterPrimaryKeyToAutoIncrementColumn()	0	31	2

<?php

namespace Doctrine\Tests\DBAL\Functional\Ticket;

use Doctrine\DBAL\Schema\Comparator;
use Doctrine\Tests\DbalFunctionalTestCase;

final class DBAL2807Test extends DbalFunctionalTestCase
{
    /**
     * Ensures that the primary key is created within the same "alter table" statement that an auto-increment column
     * is added to the table as part of the new primary key.
     *
     * Before the fix for this problem this resulted in a database error: (at least on mysql)
     * SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key
     */
    public function testAlterPrimaryKeyToAutoIncrementColumn()
    {
        $schemaManager = $this->connection->getSchemaManager();
        $schema = $schemaManager->createSchema();

        $table = $schema->createTable('dbal2807');
        $table->addColumn('initial_id', 'integer');
        $table->setPrimaryKey(['initial_id']);

        $schemaManager->dropAndCreateTable($table);

        $newSchema = clone $schema;
        $newTable = $newSchema->getTable($table->getName());
        $newTable->addColumn('new_id', 'integer', ['autoincrement' => true]);
        $newTable->dropPrimaryKey();
        $newTable->setPrimaryKey(['new_id']);

        $diff = (new Comparator())->compare($schema, $newSchema);

        foreach ($diff->toSql($this->connection->getDatabasePlatform()) as $sql)
        {
            $this->connection->exec($sql);
        }

        $validationSchema = $schemaManager->createSchema();
        $validationTable = $validationSchema->getTable($table->getName());

        $this->assertTrue($validationTable->hasColumn('new_id'));
        $this->assertTrue($validationTable->getColumn('new_id')->getAutoincrement());
        $this->assertTrue($validationTable->hasPrimaryKey());
        $this->assertSame(['new_id'], $validationTable->getPrimaryKeyColumns());
    }
}