migrations/Version20241201000000.php line 1

<?php

declare(strict_types=1);

namespace DoctrineMigrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;

final class Version20241201000000 extends AbstractMigration
{
    public function getDescription(): string
    {
        return 'Ensure evaluation_criterion columns exist with safe defaults for existing data sets';
    }

    public function up(Schema $schema): void
    {
        if ('mysql' !== $this->connection->getDatabasePlatform()->getName()) {
            return;
        }

        $schemaManager = $this->connection->createSchemaManager();

        if (!$schemaManager->tablesExist(['evaluation_criterion'])) {
            return;
        }

        $columns = array_change_key_case($schemaManager->listTableColumns('evaluation_criterion'), CASE_LOWER);

        if (!isset($columns['label'])) {
            $this->addSql("ALTER TABLE evaluation_criterion ADD COLUMN label VARCHAR(255) DEFAULT NULL");
            $this->addSql("UPDATE evaluation_criterion SET label = key_name WHERE label IS NULL");
            $this->addSql("ALTER TABLE evaluation_criterion MODIFY label VARCHAR(255) NOT NULL");
        }

        if (!isset($columns['section'])) {
            $this->addSql("ALTER TABLE evaluation_criterion ADD COLUMN section VARCHAR(100) DEFAULT NULL");
        }
    }

    public function down(Schema $schema): void
    {
        if ('mysql' !== $this->connection->getDatabasePlatform()->getName()) {
            return;
        }

        $schemaManager = $this->connection->createSchemaManager();

        if (!$schemaManager->tablesExist(['evaluation_criterion'])) {
            return;
        }

        $columns = array_change_key_case($schemaManager->listTableColumns('evaluation_criterion'), CASE_LOWER);

        if (isset($columns['label'])) {
            $this->addSql('ALTER TABLE evaluation_criterion DROP COLUMN label');
        }

        if (isset($columns['section'])) {
            $this->addSql('ALTER TABLE evaluation_criterion DROP COLUMN section');
        }
    }
}