Function getDigestByReviewMessage

server/src/db/digest-db.ts:381–391

(
  channelId: string,
  messageTs: string,
)

 * Find a digest by its Slack review message
 */
export async function getDigestByReviewMessage(
  channelId: string,
  messageTs: string,
): Promise<DigestRecord | null> {
  const result = await query<DigestRecord>(
    `SELECT ${DIGEST_COLUMNS} FROM weekly_digests
     WHERE review_channel_id = $1 AND review_message_ts = $2`,
    [channelId, messageTs],
  );
  return result.rows[0] || null;
}

/**
 * Link a sent digest to its published perspective article.