dump-db.mjs

#!/usr/bin/env zx

import { spawn } from "child_process";

if (process.env.IN_TESTS === "1") {
  process.exit(0);
}

const connectionString = process.env.GM_DBURL;
if (!connectionString) {
  console.error(
    "This script should only be called from a graphile-migrate action."
  );
  process.exit(1);
}

spawn(
  process.env.PG_DUMP || "pg_dump",
  [
    "--no-sync",
    "--schema-only",
    "--no-owner",
    "--exclude-schema=graphile_migrate",
    "--exclude-schema=graphile_worker",
    "--file=../../data/schema.sql",
    connectionString,
  ],
  {
    stdio: "inherit",
    shell: true,
  }
);