-# Copyright (C) 2021 Wind River Systems, Inc.\r
-#\r
-# Licensed under the Apache License, Version 2.0 (the "License");\r
-# you may not use this file except in compliance with the License.\r
-# You may obtain a copy of the License at\r
-#\r
-# http://www.apache.org/licenses/LICENSE-2.0\r
-#\r
-# Unless required by applicable law or agreed to in writing, software\r
-# distributed under the License is distributed on an "AS IS" BASIS,\r
-# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\r
-# See the License for the specific language governing permissions and\r
-# limitations under the License.\r
-\r
-from sqlalchemy import select\r
-\r
-from o2ims.adapter.orm import ocloud, resource, resourcetype, \\r
- resourcepool, deploymentmanager, subscription\r
-from o2ims.adapter import unit_of_work\r
-from o2ims.domain.ocloud import Subscription\r
-\r
-\r
-def oclouds(uow: unit_of_work.SqlAlchemyUnitOfWork):\r
- with uow:\r
- res = uow.session.execute(select(ocloud))\r
- return [dict(r) for r in res]\r
-\r
-\r
-def ocloud_one(ocloudid: str, uow: unit_of_work.AbstractUnitOfWork):\r
- with uow:\r
- res = uow.session.execute(\r
- select(ocloud).where(ocloud.c.oCloudId == ocloudid))\r
- first = res.first()\r
- return None if first is None else dict(first)\r
-\r
-\r
-def resource_types(uow: unit_of_work.SqlAlchemyUnitOfWork):\r
- with uow:\r
- res = uow.session.execute(select(resourcetype))\r
- return [dict(r) for r in res]\r
-\r
-\r
-def resource_type_one(resourceTypeId: str,\r
- uow: unit_of_work.SqlAlchemyUnitOfWork):\r
- with uow:\r
- res = uow.session.execute(select(resourcetype).where(\r
- resourcetype.c.resourceTypeId == resourceTypeId))\r
- first = res.first()\r
- return None if first is None else dict(first)\r
-\r
-\r
-def resource_pools(uow: unit_of_work.SqlAlchemyUnitOfWork):\r
- with uow:\r
- res = uow.session.execute(select(resourcepool))\r
- return [dict(r) for r in res]\r
-\r
-\r
-def resource_pool_one(resourcePoolId: str,\r
- uow: unit_of_work.SqlAlchemyUnitOfWork):\r
- with uow:\r
- res = uow.session.execute(select(resourcepool).where(\r
- resourcepool.c.resourcePoolId == resourcePoolId))\r
- first = res.first()\r
- return None if first is None else dict(first)\r
-\r
-\r
-def resources(resourcePoolId: str, uow: unit_of_work.SqlAlchemyUnitOfWork):\r
- with uow:\r
- res = uow.session.execute(select(resource).where(\r
- resource.c.resourcePoolId == resourcePoolId))\r
- return [dict(r) for r in res]\r
-\r
-\r
-def resource_one(resourceId: str, uow: unit_of_work.SqlAlchemyUnitOfWork):\r
- with uow:\r
- # topq = uow.session.query(resource).filter(\r
- # resource.c.resourceId == resourceId).cte('cte', recursive=True)\r
- # bootomq = uow.session.query(resource).join(\r
- # topq, resource.c.parentId == topq.c.resourceId)\r
- # res = uow.session.query(topq.union(bootomq))\r
- # print(res)\r
- res = uow.session.execute(select(resource).where(\r
- resource.c.resourceId == resourceId))\r
- first = res.first()\r
- return None if first is None else dict(first)\r
-\r
-\r
-def deployment_managers(uow: unit_of_work.SqlAlchemyUnitOfWork):\r
- with uow:\r
- res = uow.session.execute(select(deploymentmanager))\r
- return [dict(r) for r in res]\r
-\r
-\r
-def deployment_manager_one(deploymentManagerId: str,\r
- uow: unit_of_work.SqlAlchemyUnitOfWork):\r
- with uow:\r
- res = uow.session.execute(select(deploymentmanager).where(\r
- deploymentmanager.c.deploymentManagerId == deploymentManagerId))\r
- first = res.first()\r
- return None if first is None else dict(first)\r
-\r
-\r
-def subscriptions(uow: unit_of_work.SqlAlchemyUnitOfWork):\r
- with uow:\r
- res = uow.session.execute(select(subscription))\r
- return [dict(r) for r in res]\r
-\r
-\r
-def subscription_one(subscriptionId: str,\r
- uow: unit_of_work.SqlAlchemyUnitOfWork):\r
- with uow:\r
- res = uow.session.execute(select(subscription).where(\r
- subscription.c.subscriptionId == subscriptionId))\r
- first = res.first()\r
- return None if first is None else dict(first)\r
-\r
-\r
-def subscription_create(subscription: Subscription,\r
- uow: unit_of_work.SqlAlchemyUnitOfWork):\r
- with uow:\r
- uow.subscriptions.add(subscription)\r
- uow.commit()\r
-\r
-\r
-def subscription_delete(subscriptionId: str,\r
- uow: unit_of_work.SqlAlchemyUnitOfWork):\r
- with uow:\r
- uow.subscriptions.delete(subscriptionId)\r
- uow.commit()\r
- return True\r
+# Copyright (C) 2021 Wind River Systems, Inc.
+#
+# Licensed under the Apache License, Version 2.0 (the "License");
+# you may not use this file except in compliance with the License.
+# You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+
+import uuid
+
+from o2common.service import unit_of_work
+from o2ims.views.ocloud_dto import SubscriptionDTO
+from o2ims.domain.subscription_obj import Subscription
+
+from o2common.helper import o2logging
+logger = o2logging.get_logger(__name__)
+
+
+def oclouds(uow: unit_of_work.AbstractUnitOfWork):
+ with uow:
+ li = uow.oclouds.list()
+ return [r.serialize() for r in li]
+
+
+def ocloud_one(ocloudid: str, uow: unit_of_work.AbstractUnitOfWork):
+ with uow:
+ first = uow.oclouds.get(ocloudid)
+ return first.serialize() if first is not None else None
+
+
+def resource_types(uow: unit_of_work.AbstractUnitOfWork):
+ with uow:
+ li = uow.resource_types.list()
+ return [r.serialize() for r in li]
+
+
+def resource_type_one(resourceTypeId: str,
+ uow: unit_of_work.AbstractUnitOfWork):
+ with uow:
+ first = uow.resource_types.get(resourceTypeId)
+ return first.serialize() if first is not None else None
+
+
+def resource_pools(uow: unit_of_work.AbstractUnitOfWork):
+ with uow:
+ li = uow.resource_pools.list()
+ return [r.serialize() for r in li]
+
+
+def resource_pool_one(resourcePoolId: str,
+ uow: unit_of_work.AbstractUnitOfWork):
+ with uow:
+ first = uow.resource_pools.get(resourcePoolId)
+ return first.serialize() if first is not None else None
+
+
+def resources(resourcePoolId: str, uow: unit_of_work.AbstractUnitOfWork,
+ **kwargs):
+
+ filter_kwargs = {} # filter key should be the same with database name
+ if 'resourceTypeName' in kwargs:
+ resource_type_name = kwargs['resourceTypeName']
+ with uow:
+ # res_types = uow.resource_types.list()
+ # restype_ids = [
+ # restype.resourceTypeId for restype in res_types
+ # if resourceTypeName == restype.name]
+ # restype_id = '' if len(restype_ids) == 0 else restype_ids[0]
+ res_type = uow.resource_types.get_by_name(resource_type_name)
+ restype_id = '' if res_type is None else res_type.resourceTypeId
+ filter_kwargs['resourceTypeId'] = restype_id
+
+ # li = uow.resources.list(resourcePoolId)
+ # return [r.serialize() for r in li if r.resourceTypeId == restype_id]
+ if 'parentId' in kwargs:
+ filter_kwargs['parentId'] = kwargs['parentId']
+
+ with uow:
+ li = uow.resources.list(resourcePoolId, **filter_kwargs)
+ return [r.serialize() for r in li]
+
+
+def resource_one(resourceId: str, uow: unit_of_work.AbstractUnitOfWork):
+ with uow:
+ first = uow.resources.get(resourceId)
+ return first.serialize() if first is not None else None
+
+
+def deployment_managers(uow: unit_of_work.AbstractUnitOfWork):
+ with uow:
+ li = uow.deployment_managers.list()
+ return [r.serialize() for r in li]
+
+
+def deployment_manager_one(deploymentManagerId: str,
+ uow: unit_of_work.AbstractUnitOfWork):
+ with uow:
+ first = uow.deployment_managers.get(deploymentManagerId)
+ return first.serialize() if first is not None else None
+
+
+def subscriptions(uow: unit_of_work.AbstractUnitOfWork):
+ with uow:
+ li = uow.subscriptions.list()
+ return [r.serialize() for r in li]
+
+
+def subscription_one(subscriptionId: str,
+ uow: unit_of_work.AbstractUnitOfWork):
+ with uow:
+ first = uow.subscriptions.get(subscriptionId)
+ return first.serialize() if first is not None else None
+
+
+def subscription_create(subscriptionDto: SubscriptionDTO.subscription,
+ uow: unit_of_work.AbstractUnitOfWork):
+
+ sub_uuid = str(uuid.uuid4())
+ subscription = Subscription(
+ sub_uuid, subscriptionDto['callback'],
+ subscriptionDto['consumerSubscriptionId'],
+ subscriptionDto['filter'])
+ with uow:
+ uow.subscriptions.add(subscription)
+ uow.commit()
+ return {"subscriptionId": sub_uuid}
+
+
+def subscription_delete(subscriptionId: str,
+ uow: unit_of_work.AbstractUnitOfWork):
+ with uow:
+ uow.subscriptions.delete(subscriptionId)
+ uow.commit()
+ return True