import { PoolConnection, ResultSetHeader, RowDataPacket } from "mysql2/promise";

type ProjectExists = {
  con: PoolConnection;
  data: {
    email?: string;
    url?: string;
  };
};
export async function projectExists({ con, data }: ProjectExists) {
  const query = `
    SELECT COUNT(*) "COUNT" FROM DOMAINS WHERE (EMAIL IS NOT NULL AND EMAIL = ?) OR NAME = ?
  `;
  const params = [data.email, data.url];

  const [result] = await con.query<RowDataPacket[]>(query, params);

  return result[0].COUNT > 0;
}