Function updateDigestContent

server/src/db/digest-db.ts:364–376

(
  id: number,
  content: DigestContent,
)

 * Update the content of a draft digest. Only works on drafts.
 */
export async function updateDigestContent(
  id: number,
  content: DigestContent,
): Promise<DigestRecord | null> {
  const result = await query<DigestRecord>(
    `UPDATE weekly_digests
     SET content = $2
     WHERE id = $1 AND status = 'draft'
     RETURNING ${DIGEST_COLUMNS}`,
    [id, JSON.stringify(content)],
  );
  return result.rows[0] || null;
}

/**
 * Find a digest by its Slack review message