ForeignKeyTest.php 1.04 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11
<?php

declare(strict_types=1);

namespace Doctrine\Tests\DBAL\Functional\Schema;

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

class ForeignKeyTest extends DbalFunctionalTestCase
{
12
    public function testCreatingATableWithAForeignKey(): void
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
    {
        $schema = new Schema();

        $referencedTable = $schema->createTable('referenced_table');
        $referencedTable->addColumn('id', 'integer');
        $referencedTable->setPrimaryKey(['id']);

        $referencingTable = $schema->createTable('referencing_table');
        $referencingTable->addColumn('referenced_id', 'integer');
        $referencingTable->addForeignKeyConstraint(
            $referencedTable,
            ['referenced_id'],
            ['id']
        );

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

        self::assertCount(
            1,
            $this->connection->getSchemaManager()->listTableForeignKeys('referencing_table')
        );
    }
}