Version20240702222600::getDescription() - Code Metrics - Inspection of "Allow multi-format media files" - chamilo/chamilo-lms - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#5625)

by Angel Fernando Quiroz

created 2024-07-02 23:32 UTC

Version20240702222600::getDescription() A

↳ Parent: Version20240702222600

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	1	Features	0

Metric	Value
cc	1
eloc	1
c	1
b	1
f	0
nc	1
nop	0
dl	0
loc	3
rs	10

<?php
/* For licensing terms, see /license.txt */

declare(strict_types=1);

namespace Chamilo\CoreBundle\Migrations\Schema\V200;

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

final class Version20240702222600 extends AbstractMigrationChamilo
{
    public function getDescription(): string
    {
        return 'Migration resource_node --* resource_file (during development)';
    }

    /**
     * @inheritDoc
     */
    public function up(Schema $schema): void
    {
        $tblResourceFile = $schema->getTable('resource_file');
        $tblResourceNode = $schema->getTable('resource_node');

        if (!$tblResourceFile->hasColumn('resource_node_id')) {
            $this->addSql('ALTER TABLE resource_file ADD resource_node_id INT DEFAULT NULL');
        }

        if (!$tblResourceFile->hasForeignKey('FK_83BF96AA1BAD783F')) {
            $this->addSql('ALTER TABLE resource_file ADD CONSTRAINT FK_83BF96AA1BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id)');
        }

        if (!$tblResourceFile->hasIndex('IDX_83BF96AA1BAD783F')) {
            $this->addSql('CREATE INDEX IDX_83BF96AA1BAD783F ON resource_file (resource_node_id)');
        }

        if ($tblResourceNode->hasForeignKey('FK_8A5F48FFCE6B9E84')) {
            $this->addSql('ALTER TABLE resource_node DROP FOREIGN KEY FK_8A5F48FFCE6B9E84');
        }

        if ($tblResourceNode->hasIndex('UNIQ_8A5F48FFCE6B9E84')) {
            $this->addSql('DROP INDEX UNIQ_8A5F48FFCE6B9E84 ON resource_node');
        }

        if ($tblResourceNode->hasColumn('resource_file_id')) {
            $this->addSql('ALTER TABLE resource_node DROP resource_file_id');
        }
    }
}

1			<?php
2			/* For licensing terms, see /license.txt */
3
4			declare(strict_types=1);
5
6			namespace Chamilo\CoreBundle\Migrations\Schema\V200;
7
8			use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
9			use Doctrine\DBAL\Schema\Schema;
10
11			final class Version20240702222600 extends AbstractMigrationChamilo
12			{
13			public function getDescription(): string
14			{
15			return 'Migration resource_node --* resource_file (during development)';
16			}
17
18			/**
19			* @inheritDoc
20			*/
21			public function up(Schema $schema): void
22			{
23			$tblResourceFile = $schema->getTable('resource_file');
24			$tblResourceNode = $schema->getTable('resource_node');
25
26			if (!$tblResourceFile->hasColumn('resource_node_id')) {
27			$this->addSql('ALTER TABLE resource_file ADD resource_node_id INT DEFAULT NULL');
28			}
29
30			if (!$tblResourceFile->hasForeignKey('FK_83BF96AA1BAD783F')) {
31			$this->addSql('ALTER TABLE resource_file ADD CONSTRAINT FK_83BF96AA1BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id)');
32			}
33
34			if (!$tblResourceFile->hasIndex('IDX_83BF96AA1BAD783F')) {
35			$this->addSql('CREATE INDEX IDX_83BF96AA1BAD783F ON resource_file (resource_node_id)');
36			}
37
38			if ($tblResourceNode->hasForeignKey('FK_8A5F48FFCE6B9E84')) {
39			$this->addSql('ALTER TABLE resource_node DROP FOREIGN KEY FK_8A5F48FFCE6B9E84');
40			}
41
42			if ($tblResourceNode->hasIndex('UNIQ_8A5F48FFCE6B9E84')) {
43			$this->addSql('DROP INDEX UNIQ_8A5F48FFCE6B9E84 ON resource_node');
44			}
45
46			if ($tblResourceNode->hasColumn('resource_file_id')) {
47			$this->addSql('ALTER TABLE resource_node DROP resource_file_id');
48			}
49			}
50			}

chamilo / chamilo-lms

Pull Request — master (#5625)

Version20240702222600::getDescription() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like