X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=o2ims%2Fadapter%2Focloud_repository.py;h=b26e98a069633c3d70207a7dea7b9214d4bdb325;hb=bd72340e71574c7095e94aa2719df66c3f711545;hp=ca902099c5ab68d29520c426022459d8b818b121;hpb=f1946a1e90036bb8a758b49f94ac4d3b40bae66e;p=pti%2Fo2.git

diff --git a/o2ims/adapter/ocloud_repository.py b/o2ims/adapter/ocloud_repository.py
index ca90209..b26e98a 100644
--- a/o2ims/adapter/ocloud_repository.py
+++ b/o2ims/adapter/ocloud_repository.py
@@ -12,63 +12,197 @@
 #  See the License for the specific language governing permissions and
 #  limitations under the License.
 
-import abc
-from typing import List, Set
-# from o2ims.adapter import orm
-from o2ims.domain import ocloud
+from typing import List, Tuple
 
+from o2ims.domain import ocloud, subscription_obj
+from o2ims.domain.ocloud_repo import OcloudRepository, ResourceTypeRepository,\
+    ResourcePoolRepository, ResourceRepository, DeploymentManagerRepository
+from o2ims.domain.subscription_repo import SubscriptionRepository
+from o2common.helper import o2logging
+logger = o2logging.get_logger(__name__)
 
-class OcloudRepository(abc.ABC):
-    def __init__(self):
-        self.seen = set()  # type: Set[ocloud.Ocloud]
 
-    def add(self, ocloud: ocloud.Ocloud):
-        self._add(ocloud)
-        self.seen.add(ocloud)
+class OcloudSqlAlchemyRepository(OcloudRepository):
+    def __init__(self, session):
+        super().__init__()
+        self.session = session
+
+    def _add(self, ocloud: ocloud.Ocloud):
+        self.session.add(ocloud)
+        # self.session.add_all(ocloud.deploymentManagers)
 
-    def get(self, ocloudid) -> ocloud.Ocloud:
-        ocloud = self._get(ocloudid)
-        if ocloud:
-            self.seen.add(ocloud)
-        return ocloud
+    def _get(self, ocloud_id) -> ocloud.Ocloud:
+        return self.session.query(ocloud.Ocloud).filter_by(
+            oCloudId=ocloud_id).first()
 
-    def list(self) -> List[ocloud.Ocloud]:
-        return self._list()
+    def _list(self) -> List[ocloud.Ocloud]:
+        return self.session.query(ocloud.Ocloud)
 
-    def update(self, ocloud: ocloud.Ocloud):
-        self._update(ocloud)
+    def _update(self, ocloud: ocloud.Ocloud):
+        self.session.add(ocloud)
 
-    # def update_fields(self, ocloudid: str, updatefields: dict):
-    #     self._update(ocloudid, updatefields)
 
-    @abc.abstractmethod
-    def _add(self, ocloud: ocloud.Ocloud):
-        raise NotImplementedError
+class ResouceTypeSqlAlchemyRepository(ResourceTypeRepository):
+    def __init__(self, session):
+        super().__init__()
+        self.session = session
 
-    @abc.abstractmethod
-    def _get(self, ocloudid) -> ocloud.Ocloud:
-        raise NotImplementedError
+    def _add(self, resourceType: ocloud.ResourceType):
+        self.session.add(resourceType)
 
-    @abc.abstractmethod
-    def _update(self, ocloud: ocloud.Ocloud):
-        raise NotImplementedError
+    def _get(self, resource_type_id) -> ocloud.ResourceType:
+        return self.session.query(ocloud.ResourceType).filter_by(
+            resourceTypeId=resource_type_id).first()
 
+    def _get_by_name(self, resource_type_name) -> ocloud.ResourceType:
+        return self.session.query(ocloud.ResourceType).filter_by(
+            name=resource_type_name).first()
 
-class OcloudSqlAlchemyRepository(OcloudRepository):
+    def _list(self, **kwargs) -> Tuple[int, List[ocloud.ResourceType]]:
+        size = kwargs.pop('limit') if 'limit' in kwargs else None
+        offset = kwargs.pop('start') if 'start' in kwargs else 0
+
+        result = self.session.query(ocloud.ResourceType).filter_by(
+            **kwargs).order_by('resourceTypeId')
+        count = result.count()
+        if size is not None and size != -1:
+            return (count, result.limit(size).offset(offset))
+        return (count, result)
+
+    def _update(self, resourceType: ocloud.ResourceType):
+        self.session.add(resourceType)
+
+
+class ResourcePoolSqlAlchemyRepository(ResourcePoolRepository):
     def __init__(self, session):
         super().__init__()
         self.session = session
 
-    def _add(self, ocloud: ocloud.Ocloud):
-        self.session.add(ocloud)
-        # self.session.add_all(ocloud.deploymentManagers)
+    def _add(self, resourcePool: ocloud.ResourcePool):
+        self.session.add(resourcePool)
 
-    def _get(self, ocloudid) -> ocloud.Ocloud:
-        return self.session.query(ocloud.Ocloud).filter_by(
-            oCloudId=ocloudid).first()
+    def _get(self, resource_pool_id) -> ocloud.ResourcePool:
+        return self.session.query(ocloud.ResourcePool).filter_by(
+            resourcePoolId=resource_pool_id).first()
 
-    def _list(self) -> List[ocloud.Ocloud]:
-        return self.session.query()
+    def _list(self, **kwargs) -> Tuple[int, List[ocloud.ResourcePool]]:
+        size = kwargs.pop('limit') if 'limit' in kwargs else None
+        offset = kwargs.pop('start') if 'start' in kwargs else 0
 
-    def _update(self, ocloud: ocloud.Ocloud):
-        self.session.add(ocloud)
+        result = self.session.query(ocloud.ResourcePool).filter_by(
+            **kwargs).order_by('resourcePoolId')
+        count = result.count()
+        if size is not None and size != -1:
+            return (count, result.limit(size).offset(offset))
+        return (count, result)
+
+    def _update(self, resourcePool: ocloud.ResourcePool):
+        self.session.add(resourcePool)
+
+
+class ResourceSqlAlchemyRepository(ResourceRepository):
+    def __init__(self, session):
+        super().__init__()
+        self.session = session
+
+    def _add(self, resource: ocloud.Resource):
+        self.session.add(resource)
+
+    def _get(self, resource_id) -> ocloud.Resource:
+        # return self.session.query(ocloud.Resource).filter_by(
+        #     resourceId=resource_id).first()
+        # topq = uow.session.query(orm.resource).filter(
+        #     orm.resource.c.resourceId == resourceId).\
+        #     cte('cte', recursive=True)
+        # bootomq = uow.session.query(orm.resource).join(
+        #     topq, orm.resource.c.parentId == topq.c.resourceId)
+        # res = uow.session.query(topq.union(bootomq))
+        def recursive(id):
+            res = self.session.query(ocloud.Resource).filter_by(
+                resourceId=id).first()
+            if res is not None:
+                query = self.session.query(ocloud.Resource).filter_by(
+                    parentId=res.resourceId)
+                children = []
+                for r in query:
+                    child = recursive(r.resourceId)
+                    children.append(child)
+                res.set_children(children)
+            return res
+        return recursive(resource_id)
+
+    def _list(self, resourcepool_id, **kwargs) -> \
+            Tuple[int, List[ocloud.Resource]]:
+        if 'sort' in kwargs:
+            kwargs.pop('sort')
+        size = kwargs.pop('limit') if 'limit' in kwargs else None
+        offset = kwargs.pop('start') if 'start' in kwargs else 0
+
+        result = self.session.query(ocloud.Resource).filter_by(
+            resourcePoolId=resourcepool_id, **kwargs).order_by('resourceId')
+        count = result.count()
+        if size is not None and size != -1:
+            return (count, result.limit(size).offset(offset))
+        return (count, result)
+
+    def _update(self, resource: ocloud.Resource):
+        self.session.add(resource)
+
+
+class DeploymentManagerSqlAlchemyRepository(DeploymentManagerRepository):
+    def __init__(self, session):
+        super().__init__()
+        self.session = session
+
+    def _add(self, deployment_manager: ocloud.DeploymentManager):
+        self.session.add(deployment_manager)
+
+    def _get(self, deployment_manager_id) -> ocloud.DeploymentManager:
+        return self.session.query(ocloud.DeploymentManager).filter_by(
+            deploymentManagerId=deployment_manager_id).first()
+
+    def _list(self, **kwargs) -> Tuple[int, List[ocloud.DeploymentManager]]:
+        size = kwargs.pop('limit') if 'limit' in kwargs else None
+        offset = kwargs.pop('start') if 'start' in kwargs else 0
+
+        result = self.session.query(ocloud.DeploymentManager).filter_by(
+            **kwargs).order_by('deploymentManagerId')
+        count = result.count()
+        if size is not None and size != -1:
+            return (count, result.limit(size).offset(offset))
+        return (count, result)
+
+    def _update(self, deployment_manager: ocloud.DeploymentManager):
+        self.session.add(deployment_manager)
+
+
+class SubscriptionSqlAlchemyRepository(SubscriptionRepository):
+    def __init__(self, session):
+        super().__init__()
+        self.session = session
+
+    def _add(self, subscription: subscription_obj.Subscription):
+        self.session.add(subscription)
+
+    def _get(self, subscription_id) -> subscription_obj.Subscription:
+        return self.session.query(subscription_obj.Subscription).filter_by(
+            subscriptionId=subscription_id).first()
+
+    def _list(self, **kwargs) -> \
+            Tuple[int, List[subscription_obj.Subscription]]:
+        size = kwargs.pop('limit') if 'limit' in kwargs else None
+        offset = kwargs.pop('start') if 'start' in kwargs else 0
+
+        result = self.session.query(subscription_obj.Subscription).filter_by(
+            **kwargs).order_by('subscriptionId')
+        count = result.count()
+        if size is not None and size != -1:
+            return (count, result.limit(size).offset(offset))
+        return (count, result)
+
+    def _update(self, subscription: subscription_obj.Subscription):
+        self.session.add(subscription)
+
+    def _delete(self, subscription_id):
+        self.session.query(subscription_obj.Subscription).filter_by(
+            subscriptionId=subscription_id).delete()