doctrine / dbal

    /**

     * @group DBAL-1063

     */

    public function testAddForeignKeyDoesNotCreateDuplicateIndex()

    {

        $table = new Table('foo');

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

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

        $foreignTable = new Table('bar');

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

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

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

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

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

    }

    /**

     * @group DBAL-1063

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

    }

    public function testAddingFulfillingRegularIndexOverridesImplicitForeignKeyConstraintIndex()

    {

        $foreignTable = new Table('foreign');

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

        $localTable = new Table('local');

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

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

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

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

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

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

    }

    public function testAddingFulfillingUniqueIndexOverridesImplicitForeignKeyConstraintIndex()

    {

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

    }

    public function testAddingFulfillingUniqueIndexOverridesImplicitForeignKeyConstraintIndex()

    {

        $foreignTable = new Table('foreign');

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

        $localTable = new Table('local');

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

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

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

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

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

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

    }

    public function testAddingFulfillingPrimaryKeyOverridesImplicitForeignKeyConstraintIndex()

    {

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

    }

    public function testAddingFulfillingPrimaryKeyOverridesImplicitForeignKeyConstraintIndex()

    {

        $foreignTable = new Table('foreign');

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

        $localTable = new Table('local');

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

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

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

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

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

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

    }

    public function testAddingFulfillingExplicitIndexOverridingImplicitForeignKeyConstraintIndexWithSameNameDoesNotThrowException()

    {