<?php

declare(strict_types=1);

namespace DoctrineMigrations;

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

final class Version20260627140000 extends AbstractMigration
{
    public function getDescription(): string
    {
        return 'Seed initial game: AI Virus Deflection';
    }

    public function up(Schema $schema): void
    {
        $this->addSql("INSERT INTO game (name, number_of_players, status) VALUES ('AI Virus Deflection', 3, 'inDevelopment')");
        $this->addSql("INSERT INTO game_setting (game_id, name, value) VALUES (LAST_INSERT_ID(), 'totalTime', '1800')");
    }

    public function down(Schema $schema): void
    {
        $this->addSql("DELETE gs FROM game_setting gs INNER JOIN game g ON gs.game_id = g.id WHERE g.name = 'AI Virus Deflection'");
        $this->addSql("DELETE FROM game WHERE name = 'AI Virus Deflection'");
    }
}