Deleting records w/ sqlite-core.

Hello all, hoping to find some clarity/direction. So I'm trying to delete a record using;

export async function acceptUserMail(mailItem: string) {
  return db.delete(mailbox).where(eq(mailbox.id, mailItem)).run();
}

export async function acceptUserMail(mailItem: string) {
  return db.delete(mailbox).where(eq(mailbox.id, mailItem)).run();
}

Which leads to record values being set to null as opposed to the record being deleted. Any pointers?

1 Reply

PostgresqlOP•2y ago

Fixed it by using the correct join 😅