<?php

namespace Database\Seeders\Migrators;

use Illuminate\Support\Facades\DB;
use JsonMachine\Items;

class CurrencyRatesMigrator
{
    public function migrate(): void
    {
        DB::table('currency_rates')->truncate();

        $path = database_path('data/tested/currency_rates.json');

        $items = Items::fromFile($path);

        foreach ($items as $id => $item) {
            if (! $item) {
                continue;
            }

            DB::table('currency_rates')->insert((array) $item);
        }

        DB::statement("SELECT setval('currency_rates_id_seq', (SELECT MAX(id) from currency_rates));");
        DB::statement("SELECT nextval('currency_rates_id_seq');");
    }
}