Method rateInteraction

server/src/db/addie-db.ts:1207–1233

* Rate an interaction

(
    id: string,
    rating: number,
    ratedBy: string,
    options: {
      notes?: string;
      outcome?: string;
      user_sentiment?: string;
      intent_category?: string;
    } = {}
  )

   * Rate an interaction
   */
  async rateInteraction(
    id: string,
    rating: number,
    ratedBy: string,
    options: {
      notes?: string;
      outcome?: string;
      user_sentiment?: string;
      intent_category?: string;
    } = {}
  ): Promise<void> {
    await query(
      `UPDATE addie_interactions
       SET rating = $1, rating_by = $2, rating_notes = $3, rated_at = NOW(),
           outcome = $4, user_sentiment = $5, intent_category = $6
       WHERE id = $7`,
      [
        rating,
        ratedBy,
        options.notes || null,
        options.outcome || null,
        options.user_sentiment || null,
        options.intent_category || null,
        id,
      ]
    );
  }

  // ============== Web Conversations Methods ==============