Method awardBadge

server/src/db/community-db.ts:671–679

(userId: string, badgeId: string)

  }

  async awardBadge(userId: string, badgeId: string): Promise<boolean> {
    const result = await query(
      `INSERT INTO user_badges (workos_user_id, badge_id)
       VALUES ($1, $2)
       ON CONFLICT (workos_user_id, badge_id) DO NOTHING`,
      [userId, badgeId]
    );
    return (result.rowCount ?? 0) > 0;
  }

  /**
   * Check badge thresholds and award any that have been earned.