import { neon } from "@neondatabase/serverless";

if (!process.env.DATABASE_URL) {
  console.error("DATABASE_URL not set.");
  process.exit(1);
}

const dbUrl = new URL(process.env.DATABASE_URL);
if (
  !dbUrl.hostname.includes("localhost") &&
  !dbUrl.hostname.includes("127.0.0.1") &&
  !process.env.ALLOW_RESET
) {
  console.error(
    "Refusing to reset non-local database. Set ALLOW_RESET=1 to override.",
  );
  process.exit(1);
}

const sql = neon(process.env.DATABASE_URL);
await sql`DROP SCHEMA public CASCADE`;
await sql`CREATE SCHEMA public`;
console.log("Reset database.");