Chamilo\CoreBundle\Migrations\Schema\V200\Version20250706105000::up()

Complexity

Conditions	4
Paths	8

Size

Total Lines	95
Code Lines	36

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function up(Schema $schema): void
    {
        // 1. Create table role
        $this->addSql("
            CREATE TABLE role (
                id INT UNSIGNED AUTO_INCREMENT NOT NULL,
                code VARCHAR(50) NOT NULL,
                constant_value INT NOT NULL,
                title VARCHAR(255) NOT NULL,
                description LONGTEXT DEFAULT NULL,
                system_role TINYINT(1) NOT NULL,
                created_at DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)',
                created_by INT UNSIGNED DEFAULT NULL,
                updated_at DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime)',
                updated_by INT UNSIGNED DEFAULT NULL,
                UNIQUE INDEX UNIQ_57698A6A77153098 (code),
                PRIMARY KEY(id)
            ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
        ");
        $this->write("Created table role.");

        // 2. Populate role table
        $roles = PermissionFixtures::getRoles();
        $values = [];
        $id = 1;

        foreach ($roles as $roleName => $shortCode) {
            $code = substr($roleName, 5);
            $constantValue = $this->getRoleConstantValue($code);
            $title = $this->getRoleTitle($code);
            $description = $this->getRoleDescription($code);

            $values[] = sprintf(
                "(%d, '%s', %d, '%s', '%s', %d, NOW())",
                $id,
                $code,
                $constantValue,
                addslashes($title),
                addslashes($description),
                1
            );

            $id++;
        }

        if (!empty($values)) {
            $this->addSql("
                INSERT INTO role
                    (id, code, constant_value, title, description, system_role, created_at)
                VALUES " . implode(", ", $values)
            );
            $this->write("Inserted role data from fixtures.");
        }

        // 3. Add nullable role_id
        $this->addSql("
            ALTER TABLE permission_rel_role
                ADD role_id INT UNSIGNED DEFAULT NULL
        ");
        $this->write("Added role_id column as nullable.");

        // 4. Migrate existing data
        $this->addSql("
            UPDATE permission_rel_role prr
            JOIN role r ON r.code = SUBSTRING(prr.role_code, 6)
            SET prr.role_id = r.id
        ");
        $this->write("Migrated data from role_code to role_id.");

        // 5. Drop old role_code
        $schemaManager = $this->connection->createSchemaManager();
        $columns = $schemaManager->listTableColumns('permission_rel_role');
        if (isset($columns['role_code'])) {
            $this->addSql("
                ALTER TABLE permission_rel_role DROP COLUMN role_code
            ");
            $this->write("Dropped column role_code.");
        }

        // 6. Set role_id NOT NULL
        $this->addSql("
            ALTER TABLE permission_rel_role
                MODIFY role_id INT UNSIGNED NOT NULL
        ");
        $this->write("Set role_id column to NOT NULL.");

        // 7. Add FK and index
        $this->addSql("
            ALTER TABLE permission_rel_role
                ADD CONSTRAINT FK_14B93D3DD60322AC FOREIGN KEY (role_id) REFERENCES role (id)
        ");
        $this->addSql("
            CREATE INDEX IDX_14B93D3DD60322AC ON permission_rel_role (role_id)
        ");
        $this->write("Added FK constraint and index for role_id.");
    }