<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Support\Facades\DB;

return new class extends Migration
{
    /**
     * Run the migrations. This will loop over every egg on the system and update the
     * images array to both exist, and have key => value pairings to support naming the
     * images provided.
     */
    public function up(): void
    {
        DB::table('eggs')->select(['id', 'docker_images'])->cursor()->each(function ($egg) {
            $images = is_null($egg->docker_images) ? [] : json_decode($egg->docker_images, true, 512, JSON_THROW_ON_ERROR);

            $results = [];
            foreach ($images as $key => $value) {
                $results[is_int($key) ? $value : $key] = $value;
            }

            DB::table('eggs')->where('id', $egg->id)->update(['docker_images' => $results]);
        });
    }

    /**
     * Reverse the migrations. This just keeps the values from the docker images array.
     */
    public function down(): void
    {
        DB::table('eggs')->select(['id', 'docker_images'])->cursor()->each(function ($egg) {
            DB::table('eggs')->where('id', $egg->id)->update([
                'docker_images' => array_values(json_decode($egg->docker_images, true, 512, JSON_THROW_ON_ERROR)),
            ]);
        });
    }
};
