X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=o2ims%2Fadapter%2Focloud_repository.py;h=a02662928d036886ee63cc33afaa22d059d615b2;hb=183ad4ff2db7ce3546f39d9b3d31d8e693f79b76;hp=dba4c24303d660ebf35c7e5932cb0f5193229887;hpb=7e4dd62aa6df26c97dc2596bacacedebb16f7e13;p=pti%2Fo2.git

diff --git a/o2ims/adapter/ocloud_repository.py b/o2ims/adapter/ocloud_repository.py
index dba4c24..a026629 100644
--- a/o2ims/adapter/ocloud_repository.py
+++ b/o2ims/adapter/ocloud_repository.py
@@ -35,8 +35,9 @@ class OcloudSqlAlchemyRepository(OcloudRepository):
         return self.session.query(ocloud.Ocloud).filter_by(
             oCloudId=ocloud_id).first()
 
-    def _list(self) -> List[ocloud.Ocloud]:
-        return self.session.query(ocloud.Ocloud)
+    def _list(self, *args) -> List[ocloud.Ocloud]:
+        return self.session.query(ocloud.Ocloud).filter(*args).order_by(
+            'oCloudId')
 
     def _update(self, ocloud: ocloud.Ocloud):
         self.session.add(ocloud)
@@ -138,8 +139,9 @@ class ResourceSqlAlchemyRepository(ResourceRepository):
         size = kwargs.pop('limit') if 'limit' in kwargs else None
         offset = kwargs.pop('start') if 'start' in kwargs else 0
 
+        args1 = args + (ocloud.Resource.resourcePoolId == resourcepool_id,)
         result = self.session.query(ocloud.Resource).filter(
-            *args).order_by('resourceId')
+            *args1).order_by('resourceId')
         count = result.count()
         if size is not None and size != -1:
             return (count, result.limit(size).offset(offset))