Method getConnectionCount

server/src/db/community-db.ts:618–626

(userId: string)

  }

  async getConnectionCount(userId: string): Promise<number> {
    const result = await query<{ count: string }>(
      `SELECT COUNT(*) as count FROM connections
       WHERE (requester_user_id = $1 OR recipient_user_id = $1)
         AND status = 'accepted'`,
      [userId]
    );
    return parseInt(result.rows[0]?.count || '0', 10);
  }

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