<?php

namespace Database\Seeders;

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

class RelationshipsSeeder extends Seeder
{
    public function run()
    {
        $relationships = [
            ['id' => 1, 'relationship' => 'MADRE', 'status' => 1],
            ['id' => 2, 'relationship' => 'PADRE', 'status' => 1],
            ['id' => 3, 'relationship' => 'ABUELO/A',  'status' => 1],
            ['id' => 4, 'relationship' => 'TÍO/A',  'status' => 1],
            ['id' => 5, 'relationship' => 'HERMANO/A',  'status' => 1],
            ['id' => 6, 'relationship' => 'OTRO FAMILIAR',  'status' => 1],
        ];


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

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