Add hide_files parameter to CapabilityRequest.__json__

This greatly improves the performance of the active requests page, since it doesn't need to actually fetch all the files under each version to render.

shared/workspaces/workspaces/capability/services/capability_info.py

@@ -28,7 +28,7 @@ from typing import Dict, List, Optional
 import transaction
 from sqlalchemy import desc, text
 from sqlalchemy.ext.declarative import declarative_base
-from sqlalchemy.orm import Session
+from sqlalchemy.orm import Session, selectinload, defer
 
 from workspaces.capability.enums import CapabilityRequestState, QueueState
 from workspaces.capability.helpers_interfaces import ParameterIF
@@ -378,6 +378,7 @@ class CapabilityInfo:
         """
         default_query = (
             self.session.query(CapabilityRequest)
+            .options(selectinload(CapabilityRequest.versions))
             .filter_by(capability_name=capability_name)
             .filter(CapabilityRequest.state != "Complete")
             .filter(CapabilityRequest.sealed == False)
@@ -400,7 +401,7 @@ class CapabilityInfo:
 
         json_list = []
         for request in active_list:
-            json_list.append(request.__json__())
+            json_list.append(request.__json__(hide_files=True))
 
         return {"active_requests": json_list}