Addition to Upgrade path

[sit-fricke]

Im using PostgreSQL and had to adjust the migration for the 8 -> 9 upgrade to work with PostgreSQL. Maybe its worth adding it to the UPGRADING.md file:

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
use Spatie\MediaLibrary\MediaCollections\Models\Media;

/**
 * See https://github.com/spatie/laravel-medialibrary/blob/main/UPGRADING.md
 */
return new class extends Migration
{
    public function up()
    {
        Schema::table('media', function (Blueprint $table) {
            if (!Schema::hasColumn('media', 'generated_conversions')) {
                Schema::table('media', function (Blueprint $table) {
                    $table->json('generated_conversions')->nullable();
                });
            }

            $emptyJsonCondition = <<<TEXT
case json_typeof(custom_properties)
    when 'array' then json_array_length(custom_properties)
    when 'object' then (select count(*) from json_object_keys(custom_properties))
    when 'string' then 1
    else 0
end > 0
TEXT;

            Media::query()
                ->where(function ($query) {
                    $query->whereNull('generated_conversions')
                        ->orWhereRaw("json_typeof(generated_conversions) is NULL");
                })
                ->whereRaw($emptyJsonCondition)
                ->update([
                    'generated_conversions' => DB::raw("custom_properties->'generated_conversions'"),
                    // OPTIONAL: Remove the generated conversions from the custom_properties field as well:
                    'custom_properties' => DB::raw("custom_properties::jsonb - 'generated_conversions'")
                ]);
        });
    }

    public function down()
    {
        Schema::table('media', function (Blueprint $table) {
            // Restore the 'generated_conversions' field in the 'custom_properties' column if you removed them in this migration
            Media::query()
                ->whereRaw("json_typeof(generated_conversions) is not NULL")
                ->update([
                    'custom_properties' =>
                        DB::raw("jsonb_set(custom_properties::jsonb, '{generated_conversions}', generated_conversions::jsonb, true)::json")
                ]);

            Schema::table( 'media', function ( Blueprint $table ) {
                $table->dropColumn( 'generated_conversions' );
            } );
        });
    }
};

[noor-tg]

thank you @sit-fricke . I needed this migration file change to use with postgresql.