Version20230116184632::up() - Code Metrics - Inspection of "Exercise: Fix add categories to tests and FK on c_..." - chamilo/chamilo-lms - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( c172cb...579e52 )

by Yannick

created 2023-01-17 14:51 UTC

Version20230116184632::up() A

↳ Parent: Version20230116184632

Complexity

Conditions	3
Paths	2

Size

Total Lines	25
Code Lines	17

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

Metric	Value
cc	3
eloc	17
c	1
b	0
f	1
nc	2
nop	1
dl	0
loc	25
rs	9.7

<?php

declare(strict_types = 1);

namespace Chamilo\CoreBundle\Migrations\Schema\V200;

use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
use Doctrine\DBAL\Schema\Schema;

/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20230116184632 extends AbstractMigrationChamilo
{
    /**
     * Return desription of the migration step.
     */
    public function getDescription(): string
    {
        return 'Fix FK on c_quiz_question_rel_category';
    }

    /**
     * Process one step up in the migration
     */
    public function up(Schema $schema): void
    {
        $table = $schema->getTable('c_quiz_question_rel_category');
        $cQuizQuestionTable = $schema->getTable('c_quiz_question');
        $cQuizQuestionCategoryTable = $schema->getTable('c_quiz_question_category');

        $fks = $table->getForeignKeys();

        if (!empty($fks)) {
            foreach ($fks as $fk) {
                $table->removeForeignKey($fk->getName());
            }
        }

        $table->addForeignKeyConstraint(
            $cQuizQuestionTable,
            ['question_id'],
            ['iid'],
            ['onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'],
        );
        $table->addForeignKeyConstraint(
            $cQuizQuestionCategoryTable,
            ['category_id'],
            ['iid'],
            ['onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'],
        );
    }
}


1			<?php
2
3			declare(strict_types = 1);
4
5			namespace Chamilo\CoreBundle\Migrations\Schema\V200;
6
7			use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
8			use Doctrine\DBAL\Schema\Schema;
9
10			/**
11			* Auto-generated Migration: Please modify to your needs!
12			*/
13			final class Version20230116184632 extends AbstractMigrationChamilo
14			{
15			/**
16			* Return desription of the migration step.
17			*/
18			public function getDescription(): string
19			{
20			return 'Fix FK on c_quiz_question_rel_category';
21			}
22
23			/**
24			* Process one step up in the migration
25			*/
26			public function up(Schema $schema): void
27			{
28			$table = $schema->getTable('c_quiz_question_rel_category');
29			$cQuizQuestionTable = $schema->getTable('c_quiz_question');
30			$cQuizQuestionCategoryTable = $schema->getTable('c_quiz_question_category');
31
32			$fks = $table->getForeignKeys();
33
34			if (!empty($fks)) {
35			foreach ($fks as $fk) {
36			$table->removeForeignKey($fk->getName());
37			}
38			}
39
40			$table->addForeignKeyConstraint(
41			$cQuizQuestionTable,
42			['question_id'],
43			['iid'],
44			['onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'],
45			);
46			$table->addForeignKeyConstraint(
47			$cQuizQuestionCategoryTable,
48			['category_id'],
49			['iid'],
50			['onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'],
51			);
52			}
53			}
54

chamilo / chamilo-lms

Push — master ( c172cb...579e52 )

Version20230116184632::up() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like