Version20250926142500::up() - Code Metrics - Inspection of "Install: Fix language selection flow, i18n sync, a..." - chamilo/chamilo-lms - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 5bda23...cfd449 )

by Yannick

created 2025-09-27 20:32 UTC

Version20250926142500::up() A

↳ Parent: Version20250926142500

Complexity

Conditions	1
Paths	1

Size

Total Lines	25
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	2
c	1
b	0
f	0
nc	1
nop	1
dl	0
loc	25
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 Version20250926142500 extends AbstractMigrationChamilo
{
    public function getDescription(): string
    {
        return "Fix mis-labeled 'Português do Brasil': change isocode from pt_PT to pt_BR only when pt_PT appears twice and pt_BR doesn't exist.";
    }

    public function up(Schema $schema): void
    {
        // Convert the Brazilian row from pt_PT -> pt_BR
        // Only do it when there are at least 2 rows with isocode 'pt_PT' and there's no existing 'pt_BR'
        $this->addSql("
            UPDATE language l
            JOIN (
                SELECT id
                FROM language
                WHERE isocode = 'pt_PT'
                  AND (
                        original_name = 'Português do Brasil'
                        OR english_name LIKE '%Brazil%'
                        OR english_name LIKE '%brazilian%'
                      )
                LIMIT 1
            ) b ON b.id = l.id
            SET l.isocode = 'pt_BR'
            WHERE
                (SELECT COUNT(*) FROM language WHERE isocode = 'pt_PT') > 1
                AND (SELECT COUNT(*) FROM language WHERE isocode = 'pt_BR') = 0
        ");

        // Normalize english_name for Brazilian row (optional, harmless if already set)
        $this->addSql("
            UPDATE language
            SET english_name = 'brazilian portuguese'
            WHERE isocode = 'pt_BR'
              AND (english_name IS NULL OR english_name = '' OR english_name LIKE '%brazil%')
        ");
    }

    public function down(Schema $schema): void
    {
        // Revert only if it looks like we performed the change (avoid clobbering a valid dataset).
        $this->addSql("
            UPDATE language l
            JOIN (
                SELECT id
                FROM language
                WHERE isocode = 'pt_BR'
                  AND (
                        original_name = 'Português do Brasil'
                        OR english_name LIKE '%brazil%'
                      )
                LIMIT 1
            ) b ON b.id = l.id
            SET l.isocode = 'pt_PT'
            WHERE (SELECT COUNT(*) FROM language WHERE isocode = 'pt_PT') = 1
        ");
    }
}


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 Version20250926142500 extends AbstractMigrationChamilo
13			{
14			public function getDescription(): string
15			{
16			return "Fix mis-labeled 'Português do Brasil': change isocode from pt_PT to pt_BR only when pt_PT appears twice and pt_BR doesn't exist.";
17			}
18
19			public function up(Schema $schema): void
20			{
21			// Convert the Brazilian row from pt_PT -> pt_BR
22			// Only do it when there are at least 2 rows with isocode 'pt_PT' and there's no existing 'pt_BR'
23			$this->addSql("
24			UPDATE language l
25			JOIN (
26			SELECT id
27			FROM language
28			WHERE isocode = 'pt_PT'
29			AND (
30			original_name = 'Português do Brasil'
31			OR english_name LIKE '%Brazil%'
32			OR english_name LIKE '%brazilian%'
33			)
34			LIMIT 1
35			) b ON b.id = l.id
36			SET l.isocode = 'pt_BR'
37			WHERE
38			(SELECT COUNT(*) FROM language WHERE isocode = 'pt_PT') > 1
39			AND (SELECT COUNT(*) FROM language WHERE isocode = 'pt_BR') = 0
40			");
41
42			// Normalize english_name for Brazilian row (optional, harmless if already set)
43			$this->addSql("
44			UPDATE language
45			SET english_name = 'brazilian portuguese'
46			WHERE isocode = 'pt_BR'
47			AND (english_name IS NULL OR english_name = '' OR english_name LIKE '%brazil%')
48			");
49			}
50
51			public function down(Schema $schema): void
52			{
53			// Revert only if it looks like we performed the change (avoid clobbering a valid dataset).
54			$this->addSql("
55			UPDATE language l
56			JOIN (
57			SELECT id
58			FROM language
59			WHERE isocode = 'pt_BR'
60			AND (
61			original_name = 'Português do Brasil'
62			OR english_name LIKE '%brazil%'
63			)
64			LIMIT 1
65			) b ON b.id = l.id
66			SET l.isocode = 'pt_PT'
67			WHERE (SELECT COUNT(*) FROM language WHERE isocode = 'pt_PT') = 1
68			");
69			}
70			}
71

chamilo / chamilo-lms

Push — master ( 5bda23...cfd449 )

Version20250926142500::up() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like