scripts/run-migration.js

Rama main · réplica de lectura del repositorio original.

if (process.env.SECRET_BASE && !process.env.SALTS_DATABASE_URL) {
  // SECRET_BASE without SALTS_DATABASE_URL means an outdated selfhost checkout is driving a newer image
  console.error(
    "Your betterlytics-selfhost checkout is outdated for this image.\n" +
      "Run 'git pull' in your betterlytics-selfhost directory, then 'docker compose up -d' again.\n" +
      "No migrations have been run."
  );
  process.exit(1);
}

if (process.env.NODE_ENV !== "production") {
  require("dotenv").config();
}

const { execSync } = require("child_process");

const url = process.env.CLICKHOUSE_URL;
const db = process.env.CLICKHOUSE_DB;
const user = process.env.CLICKHOUSE_USER;
const password = process.env.CLICKHOUSE_PASSWORD;

if (!url || !db) {
  console.error(
    "Error: CLICKHOUSE_URL and CLICKHOUSE_DB must be set in .env file"
  );
  process.exit(1);
}

const command = `clickhouse-migrations migrate --host=${url} --db=${db} --migrations-home=./migrations --timeout=86400000`;

// Long migrations get a ClickHouse progress header every 30s, which overflows Node's 16 KB default after about 35 minutes
const nodeOptions = [process.env.NODE_OPTIONS, "--max-http-header-size=2097152"]
  .filter(Boolean)
  .join(" ");

try {
  execSync(command, {
    stdio: "inherit",
    env: {
      ...process.env,
      NODE_OPTIONS: nodeOptions,
      CH_MIGRATIONS_USER: user,
      CH_MIGRATIONS_PASSWORD: password,
    },
  });
} catch (error) {
  console.error(`Migration failed (exit status ${error.status ?? "unknown"})`);
  process.exit(1);
}