Version20201212203600::up() - Code Metrics - Inspection of "Migration: Fix orphaned folder deletion in c_docum..." - chamilo/chamilo-lms - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#5558)

unknown

created 2024-05-29 21:27 UTC

Version20201212203600::up() A

↳ Parent: Version20201212203600

Complexity

Conditions	2
Paths	2

Size

Total Lines	18
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	2
eloc	6
c	1
b	0
f	0
nc	2
nop	1
dl	0
loc	18
rs	10

<?php

declare(strict_types=1);

/* For licensing terms, see /license.txt */

namespace Chamilo\CoreBundle\Migrations\Schema\V200;

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

final class Version20201212203600 extends AbstractMigrationChamilo
{
    public function getDescription(): string
    {
        return 'Validate and delete orphaned records from c_document with path starting with /shared_folder_session_';
    }

    public function up(Schema $schema): void
    {
        // Validate orphaned records
        $sql = "SELECT cd1.iid, cd1.path, cd1.c_id
                FROM c_document cd1
                LEFT JOIN c_document cd2 ON cd2.c_id = cd1.c_id AND cd2.path = SUBSTRING_INDEX(cd1.path, '/', 2)
                WHERE cd1.path LIKE '/shared_folder_session_%'
                AND cd2.iid IS NULL";
        $result = $this->connection->executeQuery($sql);
        $orphans = $result->fetchAllAssociative();

        if (!empty($orphans)) {
            // Delete orphaned records
            $deleteSql = "DELETE cd1 FROM c_document cd1
                    LEFT JOIN c_document cd2 ON cd2.c_id = cd1.c_id AND cd2.path = SUBSTRING_INDEX(cd1.path, '/', 2)
                    WHERE cd1.path LIKE '/shared_folder_session_%'
                    AND cd2.iid IS NULL";
            $this->addSql($deleteSql);
        }
    }

    public function down(Schema $schema): void
    {
        // No down migration provided
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			/* For licensing terms, see /license.txt */
6
7			namespace Chamilo\CoreBundle\Migrations\Schema\V200;
8
9			use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
10			use Doctrine\DBAL\Schema\Schema;
11
12			final class Version20201212203600 extends AbstractMigrationChamilo
13			{
14			public function getDescription(): string
15			{
16			return 'Validate and delete orphaned records from c_document with path starting with /shared_folder_session_';
17			}
18
19			public function up(Schema $schema): void
20			{
21			// Validate orphaned records
22			$sql = "SELECT cd1.iid, cd1.path, cd1.c_id
23			FROM c_document cd1
24			LEFT JOIN c_document cd2 ON cd2.c_id = cd1.c_id AND cd2.path = SUBSTRING_INDEX(cd1.path, '/', 2)
25			WHERE cd1.path LIKE '/shared_folder_session_%'
26			AND cd2.iid IS NULL";
27			$result = $this->connection->executeQuery($sql);
28			$orphans = $result->fetchAllAssociative();
29
30			if (!empty($orphans)) {
31			// Delete orphaned records
32			$deleteSql = "DELETE cd1 FROM c_document cd1
33			LEFT JOIN c_document cd2 ON cd2.c_id = cd1.c_id AND cd2.path = SUBSTRING_INDEX(cd1.path, '/', 2)
34			WHERE cd1.path LIKE '/shared_folder_session_%'
35			AND cd2.iid IS NULL";
36			$this->addSql($deleteSql);
37			}
38			}
39
40			public function down(Schema $schema): void
41			{
42			// No down migration provided
43			}
44			}
45

chamilo / chamilo-lms

Pull Request — master (#5558)

Version20201212203600::up() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like