doctrine / dbal

    /**

     * @group DBAL-1063

     */

    public function testAddForeignKeyDoesNotCreateDuplicateIndex() : void

    {

        $table = new Table('foo');

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

        $table->addIndex(['bar'], 'bar_idx');

        $foreignTable = new Table('bar');

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

        $table->addForeignKeyConstraint($foreignTable, ['bar'], ['foo']);

        self::assertCount(1, $table->getIndexes());

        self::assertTrue($table->hasIndex('bar_idx'));

        self::assertSame(['bar'], $table->getIndex('bar_idx')->getColumns());

    }

    /**

     * @group DBAL-1063

        self::assertTrue($table->hasIndex('idx_unique'));

    }

    public function testAddingFulfillingRegularIndexOverridesImplicitForeignKeyConstraintIndex() : void

    {

        $foreignTable = new Table('foreign');

        $foreignTable->addColumn('id', 'integer');

        $localTable = new Table('local');

        $localTable->addColumn('id', 'integer');

        $localTable->addForeignKeyConstraint($foreignTable, ['id'], ['id']);

        self::assertCount(1, $localTable->getIndexes());

        $localTable->addIndex(['id'], 'explicit_idx');

        self::assertCount(1, $localTable->getIndexes());

        self::assertTrue($localTable->hasIndex('explicit_idx'));

    }

    public function testAddingFulfillingUniqueIndexOverridesImplicitForeignKeyConstraintIndex() : void

    {

        self::assertTrue($localTable->hasIndex('explicit_idx'));

    }

    public function testAddingFulfillingUniqueIndexOverridesImplicitForeignKeyConstraintIndex() : void

    {

        $foreignTable = new Table('foreign');

        $foreignTable->addColumn('id', 'integer');

        $localTable = new Table('local');

        $localTable->addColumn('id', 'integer');

        $localTable->addForeignKeyConstraint($foreignTable, ['id'], ['id']);

        self::assertCount(1, $localTable->getIndexes());

        $localTable->addUniqueIndex(['id'], 'explicit_idx');

        self::assertCount(1, $localTable->getIndexes());

        self::assertTrue($localTable->hasIndex('explicit_idx'));

    }

    public function testAddingFulfillingPrimaryKeyOverridesImplicitForeignKeyConstraintIndex() : void

    {

        self::assertTrue($localTable->hasIndex('explicit_idx'));

    }

    public function testAddingFulfillingPrimaryKeyOverridesImplicitForeignKeyConstraintIndex() : void

    {

        $foreignTable = new Table('foreign');

        $foreignTable->addColumn('id', 'integer');

        $localTable = new Table('local');

        $localTable->addColumn('id', 'integer');

        $localTable->addForeignKeyConstraint($foreignTable, ['id'], ['id']);

        self::assertCount(1, $localTable->getIndexes());

        $localTable->setPrimaryKey(['id'], 'explicit_idx');

        self::assertCount(1, $localTable->getIndexes());

        self::assertTrue($localTable->hasIndex('explicit_idx'));

    }

    public function testAddingFulfillingExplicitIndexOverridingImplicitForeignKeyConstraintIndexWithSameNameDoesNotThrowException() : void

    {