Function restore

db/cli.ts:383–428

* Restores database data from a backup.

(options?: {
  env?: string;
  schema?: string;
  fromEnv?: string;
  args?: string[];
})

 * Restores database data from a backup.
 */
async function restore(options?: {
  env?: string;
  schema?: string;
  fromEnv?: string;
  args?: string[];
}) {
  // Find the latest backup file for the selected environment
  const files = await readdir(backupsDir);
  let file = files
    .sort()
    .reverse()
    .filter((x) => x.endsWith(".sql"))
    .find((file) => {
      return options?.fromEnv
        ? file.endsWith(`_${options.fromEnv}.sql`)
        : !file.includes("_");
    });

  if (!file) {
    throw new Error("Backup file not found.");
  }

  file = relative(process.cwd(), resolve(backupsDir, file));

  const db = getDatabase(options);
  const { current_database } = await db
    .select(db.raw("current_database()"))
    .first()
    .finally(() => db.destroy());

  const fileName = chalk.greenBright(file);
  const dbName = chalk.greenBright(current_database);
  console.log(`Restoring ${fileName} to ${dbName}...`);

  await execa(
    "psql",
    [
      "--file",
      file,
      "--echo-errors",
      "--no-readline",
      ...(options?.args ?? []),
    ],
    { stdio: "inherit" },
  );
}

/**
 * Generates TypeScript types from a live PostgreSQL database.