import { ProjectStatusMap } from "@/models/projects/statusMap";
import { PoolConnection, ResultSetHeader } from "mysql2/promise";

type insertProjectProps = {
  name: string;
  email: string;
  ready: boolean;
};
export default async function insertProject(
  con: PoolConnection,
  { name, email, ready }: insertProjectProps,
) {
  const [insertDomainResult] = await con.query<ResultSetHeader>(
    "INSERT INTO DOMAINS (NAME, EMAIL, STATUS) VALUES (?, ?, ?)",
    [name, email, ready ? ProjectStatusMap.SENDED : ProjectStatusMap.PENDING],
  );

  return {
    operation: insertDomainResult.affectedRows > 0,
    data: {
      id: insertDomainResult.insertId,
    },
  };
}