Best way to create a generic function that accepts a generic table with explicit fields?

[brielov]

I need to create a generic function called softDelete(id: string) that can be used across multiple tables. The function should perform a transaction and, if the deletion fails, attempt to “soft-delete” the record. The function should take a generic table that must have two columns: id: string and deletedAt: Date.

Here’s an example of how the function could work:

/**
 * Soft-deletes an existing location by id
 */
export async function trashLocation(id: string) {
  await db.transaction(async (tx) => {
    try {
      const deleted = await tx.delete(location).where(eq(location.id, id));
      if (deleted.rowCount === 0) {
        await tx
          .update(location)
          .set({ deletedAt: new Date() })
          .where(eq(location.id, id));
      }
    } catch (err) {
      if (
        err instanceof Error &&
        err.message.includes(“foreign key constraint”)
      ) {
        await tx
          .update(location)
          .set({ deletedAt: new Date() })
          .where(eq(location.id, id));
      } else {
        throw err;
      }
    }
  });
}