Method indexSlackMessage

server/src/db/addie-db.ts:416–447

* Store a Slack message for local search * Uses upsert to avoid duplicates based on channel_id + ts

(input: SlackMessageInput)

   * Uses upsert to avoid duplicates based on channel_id + ts
   */
  async indexSlackMessage(input: SlackMessageInput): Promise<void> {
    // Create a title from the first 100 chars of the message
    const title = input.text.substring(0, 100) + (input.text.length > 100 ? '...' : '');

    await query(
      `INSERT INTO addie_knowledge (
        title, category, content, source_url, source_type,
        slack_channel_id, slack_channel_name, slack_user_id, slack_username, slack_ts, slack_permalink,
        created_by
      ) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12)
      ON CONFLICT (slack_channel_id, slack_ts) WHERE source_type = 'slack'
      DO UPDATE SET
        content = EXCLUDED.content,
        title = EXCLUDED.title,
        slack_username = EXCLUDED.slack_username,
        updated_at = NOW()`,
      [
        title,
        'slack',
        input.text,
        input.permalink,
        'slack',
        input.channel_id,
        input.channel_name,
        input.user_id,
        input.username,
        input.ts,
        input.permalink,
        'system',
      ]
    );
  }

  /**
   * Search Slack messages stored locally using PostgreSQL full-text search