check-db.js

const { createClient } = require('@supabase/supabase-js')

const supabaseUrl = process.env.NEXT_PUBLIC_SUPABASE_URL
const supabaseKey = process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY

if (!supabaseUrl || !supabaseKey) {
    console.error('Missing env vars')
    process.exit(1)
}

const supabase = createClient(supabaseUrl, supabaseKey)

async function check() {
    console.log('Checking wishlists table...')
    const { data, error } = await supabase.from('wishlists').select('count', { count: 'exact', head: true })
    if (error) {
        console.error('Error accessing wishlists table:', error.message) // Log just message
        if (error.message && error.message.includes('relation "public.wishlists" does not exist')) {
            console.log('CONFIRMED: Table missing.')
        } else {
            console.log('Error is NOT missing table:', error)
        }
    } else {
        console.log('Wishlists table exists.')
    }
}

check()