scripts/supabase-test.mjs

// 验证 supabase-js + secret key 能读写（RLS 绕过）+ REST(443) 连通。
import "dotenv/config";
import { createClient } from "@supabase/supabase-js";

const url = process.env.SUPABASE_URL;
const key = process.env.SUPABASE_SERVICE_KEY;
if (!url || !key) {
  console.error("SUPABASE_URL / SUPABASE_SERVICE_KEY required");
  process.exit(1);
}

const c = createClient(url, key, { auth: { persistSession: false, autoRefreshToken: false } });
const stamp = `selftest-${Date.now()}`;

const up = await c.from("app_settings").upsert({ key: "selftest.sync", value: stamp, updated_at: new Date().toISOString() }, { onConflict: "key" });
console.log("upsert error:", up.error?.message ?? "none");

const rd = await c.from("app_settings").select("*").eq("key", "selftest.sync");
console.log("read back:", rd.data?.[0]?.value === stamp ? "OK match" : `MISMATCH (${JSON.stringify(rd.data)})`, rd.error?.message ?? "");

const del = await c.from("app_settings").delete().eq("key", "selftest.sync");
console.log("cleanup error:", del.error?.message ?? "none");

console.log("supabase round-trip done");