ForeignKeyTest::testCreatingATableWithAForeignKey()

Complexity

Conditions	2
Paths	2

Size

Total Lines	23
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function testCreatingATableWithAForeignKey() : void
    {
        $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')
        );