Files

46 lines
2.4 KiB
JavaScript

// End-to-end smoke test against the running dev server: throwaway user -> sandbox bank -> pages -> delete user.
// Usage: node --env-file=.env scripts/e2e-sandbox.mjs [http://localhost:3000]
import { createClient } from "@supabase/supabase-js";
import { randomBytes } from "node:crypto";
const BASE = process.argv[2] ?? "http://localhost:3000";
const url = process.env.NEXT_PUBLIC_SUPABASE_URL;
const ref = new URL(url).hostname.split(".")[0];
const admin = createClient(url, process.env.SUPABASE_SERVICE_ROLE_KEY, { auth: { persistSession: false } });
const email = `e2e-${Date.now()}@broke.test`;
const password = randomBytes(18).toString("base64url");
const { data: created, error: ce } = await admin.auth.admin.createUser({ email, password, email_confirm: true });
if (ce) throw ce;
const uid = created.user.id;
try {
const anon = createClient(url, process.env.NEXT_PUBLIC_SUPABASE_PUBLISHABLE_KEY, { auth: { persistSession: false } });
const { data: s, error: se } = await anon.auth.signInWithPassword({ email, password });
if (se) throw se;
const cookie = `sb-${ref}-auth-token=base64-${Buffer.from(JSON.stringify(s.session)).toString("base64url")}`;
const get = (p, init = {}) => fetch(BASE + p, { ...init, redirect: "manual", headers: { cookie, ...(init.headers ?? {}) } });
const link = await get("/api/plaid/sandbox", { method: "POST" });
console.log("sandbox link:", link.status, await link.text());
// RLS check: this user must not be able to read the Plaid access token column.
const authed = createClient(url, process.env.NEXT_PUBLIC_SUPABASE_PUBLISHABLE_KEY, {
global: { headers: { Authorization: `Bearer ${s.session.access_token}` } },
auth: { persistSession: false },
});
const tok = await authed.from("plaid_items").select("access_token");
console.log("user can read access_token:", tok.error ? `no (${tok.error.code})` : "YES - LEAK");
const own = await authed.from("transactions").select("id", { count: "exact", head: true });
console.log("user sees own transactions:", own.count);
for (const p of ["/", "/transactions", "/spending", "/recurring", "/accounts"]) {
const r = await get(p);
const html = await r.text();
console.log(p, r.status, /Application error|Unhandled Runtime Error|Internal Server Error/.test(html) ? "ERROR IN PAGE" : "ok");
}
} finally {
await admin.auth.admin.deleteUser(uid); // cascades to the user's rows
console.log("test user deleted");
}