sync_supabase_storage.js

// 1. Pastikan local supabase sudah linked dengan supabase online
// 2. `npx supabase storage ls ss:///[bucket-name]/[path-to-folder]/ --experimental`
// 3. Copy semua nama file pada storage di array images_tournaments_logos atau rename sesuai keinginan

import { createClient } from '@supabase/supabase-js'

const supabaseOnline = createClient("[URL-SUPABASE-ONLINE]", "[SUPABASE-ONLINE-ANON-KEY]");
const supabaseSelfHost = createClient("[URL-SUPABASE-SELF-HOST]", "[SUPABASE-SELF-HOST-ANON-KEY]");

const images_tournaments_logos = [
    "1.png",
    "1.webp",
    "2.jpeg",
    "3.jpeg",
    "3.png",
    "4.png",
    "4.webp",
    "5.webp",
]

images_tournaments_logos.forEach(async (val) => {
    const { data, error } = await supabaseOnline.storage.from('images').getPublicUrl("tournaments/logos/" + val)

    if (error) {
        console.error({
            val,
            error
        })
    } else {
        const url = data.publicUrl;
        const blob = await fetch(url).then((r) => r.blob());
        const { data: uploadData, error: uploadError } = await supabaseSelfHost.storage.from('images').upload(`tournaments/logos/${val}`, blob, {
            upsert: true,
        });

        if (uploadError) {
            console.error({
                val, uploadError
            })
        }
    }
})