import { eq } from "drizzle-orm";

import { db } from "../lib/db";
import { user } from "../lib/db/schema";

async function makeAdmin() {
  const email = process.argv[2];
  if (!email) {
    console.error("Usage: pnpm db:make-admin <email>");
    process.exit(1);
  }

  const result = await db
    .update(user)
    .set({ role: "admin" })
    .where(eq(user.email, email))
    .returning({ id: user.id, email: user.email, role: user.role });

  if (result.length === 0) {
    console.error(`No user found with email: ${email}`);
    process.exit(1);
  }

  console.log("Promoted to admin:", result[0]);
  process.exit(0);
}

makeAdmin().catch((e) => {
  console.error(e);
  process.exit(1);
});