'use server' import type { MessageMutationResult } from './types' import type { MessageRef } from '@admin/types/messages' import db from '@admin/db' import { and, eq, isNotNull, isNull, sql } from 'drizzle-orm' import { mutateMessage } from './internal-mutate-message' export async function setMessageArchived( ref: MessageRef, archived: boolean ): Promise { return mutateMessage(ref, { action: archived ? 'archive' : 'unarchive', changedFields: ['archivedAt'], failureMessage: archived ? 'Failed to archive message' : 'Failed to unarchive message', apply: async (source, id) => { const updated = await db .update(source.table) .set({ archivedAt: archived ? sql`CURRENT_TIMESTAMP` : null }) .where( and( eq(source.table.id, id), archived ? isNull(source.table.archivedAt) : isNotNull(source.table.archivedAt) ) ) .returning({ id: source.table.id }) return updated.length } }) }