Method getUserPoints

server/src/db/community-db.ts:651–657

(userId: string)

  }

  async getUserPoints(userId: string): Promise<number> {
    const result = await query<{ total: string }>(
      `SELECT COALESCE(SUM(points), 0) as total FROM community_points WHERE workos_user_id = $1`,
      [userId]
    );
    return parseInt(result.rows[0]?.total || '0', 10);
  }

  async getUserBadges(userId: string): Promise<Badge[]> {
    const result = await query<Badge & { awarded_at: string }>(