Method getUserBadges

server/src/db/community-db.ts:659–669

(userId: string)

  }

  async getUserBadges(userId: string): Promise<Badge[]> {
    const result = await query<Badge & { awarded_at: string }>(
      `SELECT b.id, b.name, b.description, b.icon, b.category, ub.awarded_at
       FROM user_badges ub
       JOIN badges b ON b.id = ub.badge_id
       WHERE ub.workos_user_id = $1
       ORDER BY ub.awarded_at DESC`,
      [userId]
    );
    return result.rows;
  }

  async awardBadge(userId: string, badgeId: string): Promise<boolean> {
    const result = await query(