<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class CoursesLettersSeeder extends Seeder
{
    public function run()
    {
        $letters = [
            ['id' => 1, 'letter' => 'A', 'status' => 1],
            ['id' => 2, 'letter' => 'B', 'status' => 1],
            ['id' => 3, 'letter' => 'C', 'status' => 1],
            ['id' => 4, 'letter' => 'D', 'status' => 1],
            ['id' => 5, 'letter' => 'E', 'status' => 1],
            ['id' => 6, 'letter' => 'F', 'status' => 1],
            ['id' => 7, 'letter' => 'G', 'status' => 1],
            ['id' => 8, 'letter' => 'H', 'status' => 1],
            ['id' => 9, 'letter' => 'I', 'status' => 1],
        ];

        foreach ($letters as $row) {
            DB::table('courses_letters')->updateOrInsert(
                ['id' => $row['id']],
                $row                  
            );
        }

        $this->command->info('✅ Se han procesado ' . count($letters) . ' courses_letters correctamente.');
    }
}