Testing Framework

cd web
pnpm add -D vitest @vitejs/plugin-react jsdom \
  @testing-library/react @testing-library/user-event \
  @testing-library/jest-dom

import { defineConfig } from "vitest/config";
import react from "@vitejs/plugin-react";
import path from "path";

export default defineConfig({
  plugins: [react()],
  test: {
    environment: "jsdom",
    globals: true,
    setupFiles: ["./test/setup.ts"],
  },
  resolve: {
    alias: { "@": path.resolve(__dirname, ".") },
  },
});

import "@testing-library/jest-dom";

"test":          "vitest",
"test:ui":       "vitest --ui",
"test:coverage": "vitest run --coverage"

cd web
pnpm add -D @playwright/test
npx playwright install chromium

import { defineConfig, devices } from "@playwright/test";

export default defineConfig({
  testDir: "./e2e",
  fullyParallel: true,
  reporter: "html",
  use: {
    baseURL: "http://localhost:3000",
    trace: "on-first-retry",
  },
  projects: [
    { name: "chromium", use: { ...devices["Desktop Chrome"] } },
  ],
  webServer: {
    command: "pnpm dev",
    url: "http://localhost:3000",
    reuseExistingServer: !process.env.CI,
  },
});

"test:e2e":    "playwright test",
"test:e2e:ui": "playwright test --ui"

In the Neon dashboard, create a branch named test from main. Add to .env:

TEST_DATABASE_URL="postgresql://..."

// test/db.ts
import { PrismaNeon } from "@prisma/adapter-neon";
import { PrismaClient }  from "@prisma/client";
import { neon }          from "@neondatabase/serverless";

const sql = neon(process.env.TEST_DATABASE_URL!);
export const testDb = new PrismaClient({ adapter: new PrismaNeon(sql) });

export async function resetDb() {
  await testDb.$executeRawUnsafe(`
    TRUNCATE alert_user, alert, narrative, intent_probe_operator,
    intent_probe, comp_snapshot, comp, support, moat_score,
    moat_dimension, category_moat_dimension, category,
    demand_pressure_snapshot, convergence_snapshot,
    guest_profile, study, market_parcel, parcel, property,
    operator, permit_event, cup_event, anchor_visitor_stat,
    isochrone, market_anchor, market_county, anchor, county,
    market, subscription, "user"
    RESTART IDENTITY CASCADE
  `);
}