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

type InsertNoteProps = {
  domain: number;
  note: string;
  status: number;
  title: string;
};
export default async function insertNote(
  con: PoolConnection,
  { domain, title, note, status }: InsertNoteProps,
) {
  const [result] = await con.query<ResultSetHeader>(
    "INSERT INTO DOMAINNOTES (DOMAIN, TITLE, NOTE, STATUS) VALUES (?, ?, ?, ?)",
    [domain, title, note, status],
  );

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