Method awardPoints

server/src/db/community-db.ts:641–649

(userId: string, action: string, points: number, referenceId?: string, referenceType?: string)

  // =====================================================

  async awardPoints(userId: string, action: string, points: number, referenceId?: string, referenceType?: string): Promise<void> {
    await query(
      `INSERT INTO community_points (workos_user_id, action, points, reference_id, reference_type)
       VALUES ($1, $2, $3, $4, $5)
       ON CONFLICT (workos_user_id, action, reference_id) WHERE reference_id IS NOT NULL
       DO NOTHING`,
      [userId, action, points, referenceId || null, referenceType || null]
    );
  }

  async getUserPoints(userId: string): Promise<number> {
    const result = await query<{ total: string }>(