notifkit/scripts/create-admin.mjs

#!/usr/bin/env node
/**
 * Create or update an admin user for the Notifkit Dashboard.
 *
 * Usage:
 *   ADMIN_EMAIL=admin@example.com ADMIN_PASSWORD=secret npx notifkit-create-admin
 *   npx notifkit-create-admin admin@example.com secret [role]
 *   node scripts/create-admin.mjs admin@example.com secret [role]
 */

import { config } from "dotenv";
import { resolve } from "node:path";
import postgres from "postgres";
import { scrypt, randomBytes } from "node:crypto";
import { promisify } from "node:util";

config({ path: resolve(process.cwd(), ".env") });

const scryptAsync = promisify(scrypt);

async function hashPassword(password) {
  const salt = randomBytes(16).toString("hex");
  const derivedKey = await scryptAsync(password, salt, 64);
  return `${salt}:${derivedKey.toString("hex")}`;
}

const email = process.argv[2] || process.env.ADMIN_EMAIL;
const password = process.argv[3] || process.env.ADMIN_PASSWORD;
const role = process.argv[4] || "admin";

if (!email || !password) {
  console.error("Usage: npx notifkit-create-admin <email> <password> [role]");
  console.error("Or set ADMIN_EMAIL and ADMIN_PASSWORD in environment.");
  process.exit(1);
}

const databaseUrl =
  process.env.DATABASE_URL || "postgres://platform:platform@localhost:5432/notifkit";
const schema = (process.env.DB_SCHEMA || "public").trim();
if (!/^[a-z_][a-z0-9_]{0,62}$/.test(schema)) {
  console.error(`Invalid DB_SCHEMA "${schema}": must be a lowercase PostgreSQL identifier.`);
  process.exit(1);
}
const sql = postgres(databaseUrl, {
  connection: schema === "public" ? {} : { search_path: `"${schema}"` },
});

try {
  const passwordHash = await hashPassword(password);
  const normalizedEmail = email.trim().toLowerCase();

  const rows = await sql`
    INSERT INTO admin_users (email, password_hash, role)
    VALUES (${normalizedEmail}, ${passwordHash}, ${role})
    ON CONFLICT (email) DO UPDATE
    SET password_hash = EXCLUDED.password_hash,
        role = EXCLUDED.role,
        updated_at = NOW()
    RETURNING id, email, role, created_at, updated_at
  `;

  console.log("\nAdmin user successfully saved:\n");
  console.log(`  ID:       ${rows[0].id}`);
  console.log(`  Email:    ${rows[0].email}`);
  console.log(`  Role:     ${rows[0].role}\n`);
} catch (err) {
  console.error(`Failed to create admin: ${err.message}`);
  process.exit(1);
} finally {
  await sql.end();
}