X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=o2ims%2Fviews%2Focloud_view.py;h=215c9177f5cc2aab59247eb8f400c5b1b5eccc67;hb=8bf75e2f14a0b44fb5d9b771f3976e3ad80d7ae2;hp=9a1a595b8cd1662fe128fda736ac4e74c9ec5237;hpb=84867b76a65efc4e9add52c86eae7e451c4a038d;p=pti%2Fo2.git

diff --git a/o2ims/views/ocloud_view.py b/o2ims/views/ocloud_view.py
index 9a1a595..215c917 100644
--- a/o2ims/views/ocloud_view.py
+++ b/o2ims/views/ocloud_view.py
@@ -1,130 +1,244 @@
-# 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.
-
-from sqlalchemy import select
-
-from o2ims.adapter.orm import ocloud, resource, resourcetype, \
-    resourcepool, deploymentmanager, subscription
-from o2common.service import unit_of_work
-from o2ims.domain.ocloud import Subscription
-
-
-def oclouds(uow: unit_of_work.AbstractUnitOfWork):
-    with uow:
-        res = uow.session.execute(select(ocloud))
-    return [dict(r) for r in res]
-
-
-def ocloud_one(ocloudid: str, uow: unit_of_work.AbstractUnitOfWork):
-    with uow:
-        res = uow.session.execute(
-            select(ocloud).where(ocloud.c.oCloudId == ocloudid))
-        first = res.first()
-    return None if first is None else dict(first)
-
-
-def resource_types(uow: unit_of_work.AbstractUnitOfWork):
-    with uow:
-        res = uow.session.execute(select(resourcetype))
-    return [dict(r) for r in res]
-
-
-def resource_type_one(resourceTypeId: str,
-                      uow: unit_of_work.AbstractUnitOfWork):
-    with uow:
-        res = uow.session.execute(select(resourcetype).where(
-            resourcetype.c.resourceTypeId == resourceTypeId))
-        first = res.first()
-    return None if first is None else dict(first)
-
-
-def resource_pools(uow: unit_of_work.AbstractUnitOfWork):
-    with uow:
-        res = uow.session.execute(select(resourcepool))
-    return [dict(r) for r in res]
-
-
-def resource_pool_one(resourcePoolId: str,
-                      uow: unit_of_work.AbstractUnitOfWork):
-    with uow:
-        res = uow.session.execute(select(resourcepool).where(
-            resourcepool.c.resourcePoolId == resourcePoolId))
-        first = res.first()
-    return None if first is None else dict(first)
-
-
-def resources(resourcePoolId: str, uow: unit_of_work.AbstractUnitOfWork):
-    with uow:
-        res = uow.session.execute(select(resource).where(
-            resource.c.resourcePoolId == resourcePoolId))
-    return [dict(r) for r in res]
-
-
-def resource_one(resourceId: str, uow: unit_of_work.AbstractUnitOfWork):
-    with uow:
-        # topq = uow.session.query(resource).filter(
-        #     resource.c.resourceId == resourceId).cte('cte', recursive=True)
-        # bootomq = uow.session.query(resource).join(
-        #     topq, resource.c.parentId == topq.c.resourceId)
-        # res = uow.session.query(topq.union(bootomq))
-        # print(res)
-        res = uow.session.execute(select(resource).where(
-            resource.c.resourceId == resourceId))
-        first = res.first()
-    return None if first is None else dict(first)
-
-
-def deployment_managers(uow: unit_of_work.AbstractUnitOfWork):
-    with uow:
-        res = uow.session.execute(select(deploymentmanager))
-    return [dict(r) for r in res]
-
-
-def deployment_manager_one(deploymentManagerId: str,
-                           uow: unit_of_work.AbstractUnitOfWork):
-    with uow:
-        res = uow.session.execute(select(deploymentmanager).where(
-            deploymentmanager.c.deploymentManagerId == deploymentManagerId))
-        first = res.first()
-    return None if first is None else dict(first)
-
-
-def subscriptions(uow: unit_of_work.AbstractUnitOfWork):
-    with uow:
-        res = uow.session.execute(select(subscription))
-    return [dict(r) for r in res]
-
-
-def subscription_one(subscriptionId: str,
-                     uow: unit_of_work.AbstractUnitOfWork):
-    with uow:
-        res = uow.session.execute(select(subscription).where(
-            subscription.c.subscriptionId == subscriptionId))
-        first = res.first()
-    return None if first is None else dict(first)
-
-
-def subscription_create(subscription: Subscription,
-                        uow: unit_of_work.AbstractUnitOfWork):
-    with uow:
-        uow.subscriptions.add(subscription)
-        uow.commit()
-
-
-def subscription_delete(subscriptionId: str,
-                        uow: unit_of_work.AbstractUnitOfWork):
-    with uow:
-        uow.subscriptions.delete(subscriptionId)
-        uow.commit()
-    return True
+# 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 filecmp
+import os.path
+import uuid
+import yaml
+from datetime import datetime
+import shutil
+
+from o2common.service import unit_of_work
+from o2common.config import config
+from o2common.views.pagination_view import Pagination
+from o2common.views.view import gen_filter, check_filter
+from o2ims.domain import ocloud
+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, **kwargs):
+    pagination = Pagination(**kwargs)
+    query_kwargs = pagination.get_pagination()
+    args = gen_filter(ocloud.ResourceType,
+                      kwargs['filter']) if 'filter' in kwargs else []
+    with uow:
+        li = uow.resource_types.list_with_count(*args, **query_kwargs)
+    return pagination.get_result(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, **kwargs):
+    pagination = Pagination(**kwargs)
+    query_kwargs = pagination.get_pagination()
+    args = gen_filter(ocloud.ResourcePool,
+                      kwargs['filter']) if 'filter' in kwargs else []
+    with uow:
+        li = uow.resource_pools.list_with_count(*args, **query_kwargs)
+    return pagination.get_result(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):
+    pagination = Pagination(**kwargs)
+    # filter key should be the same with database name
+    query_kwargs = pagination.get_pagination()
+    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
+        query_kwargs['resourceTypeId'] = restype_id
+    args = gen_filter(
+        ocloud.Resource, kwargs['filter']) if 'filter' in kwargs else []
+    args.append(ocloud.Resource.resourcePoolId == resourcePoolId)
+    # args.append(ocloud.Resource.parentId == None)
+
+    if 'parentId' in kwargs:
+        query_kwargs['parentId'] = kwargs['parentId']
+    if 'sort' in kwargs:
+        query_kwargs['sort'] = kwargs['sort']
+
+    with uow:
+        ret = uow.resources.list_with_count(
+            resourcePoolId, *args, **query_kwargs)
+
+    return pagination.get_result(ret)
+
+
+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, **kwargs):
+    pagination = Pagination(**kwargs)
+    query_kwargs = pagination.get_pagination()
+    args = gen_filter(ocloud.DeploymentManager,
+                      kwargs['filter']) if 'filter' in kwargs else []
+    with uow:
+        li = uow.deployment_managers.list_with_count(*args, **query_kwargs)
+    return pagination.get_result(li)
+
+
+def deployment_manager_one(deploymentManagerId: str,
+                           uow: unit_of_work.AbstractUnitOfWork,
+                           profile: str =
+                           ocloud.DeploymentManagerProfileDefault):
+    profile = profile.lower()
+    with uow:
+        first = uow.deployment_managers.get(deploymentManagerId)
+        if first is None:
+            return first
+        result = first.serialize()
+        if result is None:
+            return None
+
+    profile_data = result.pop("profile", None)
+    result['profileName'] = profile
+    profiles = config.get_dms_support_profiles()
+    if profile not in profiles:
+        return ""
+
+    if ocloud.DeploymentManagerProfileDefault == profile \
+            or ocloud.DeploymentManagerProfileSOL018 == profile:
+        result['serviceUri'] = \
+            profile_data['cluster_api_endpoint']
+        result['profileData'] = profile_data
+    elif ocloud.DeploymentManagerProfileSOL018HelmCLI == profile:
+        result['serviceUri'] = \
+            profile_data['cluster_api_endpoint']
+
+        helmcli_profile = dict()
+        helmcli_profile["helmcli_host_with_port"], helmcli_profile[
+            "helmcli_username"], helmcli_profile["helmcli_password"] = \
+            config.get_helmcli_access()
+        helmcli_profile["helmcli_kubeconfig"] = _gen_kube_config(
+            deploymentManagerId, profile_data)
+        result['profileData'] = helmcli_profile
+    else:
+        return ""
+
+    return result
+
+
+def _gen_kube_config(dmId: str, kubeconfig: dict) -> dict:
+
+    data = config.gen_k8s_config_dict(
+        kubeconfig.pop('cluster_api_endpoint', None),
+        kubeconfig.pop('cluster_ca_cert', None),
+        kubeconfig.pop('admin_user', None),
+        kubeconfig.pop('admin_client_cert', None),
+        kubeconfig.pop('admin_client_key', None),
+    )
+
+    # Generate a random key for tmp kube config file
+    # letters = string.ascii_uppercase
+    # random_key = ''.join(random.choice(letters) for i in range(10))
+    name_key = dmId[:8]
+
+    # Get datetime of now as tag of the tmp file
+    current_time = datetime.now().strftime("%Y%m%d%H%M%S")
+    tmp_file_name = 'kubeconfig_' + name_key + "_" + current_time
+    kube_config_name = 'kubeconfig_' + name_key + '.config'
+
+    # write down the yaml file of kubectl into tmp folder
+    with open('/tmp/' + tmp_file_name, 'w') as file:
+        yaml.dump(data, file)
+
+    # generate the kube config file if not exist or update the file if it
+    # changes
+    if not os.path.exists('/configs/' + kube_config_name) or not \
+            filecmp.cmp('/tmp/'+tmp_file_name, '/configs/'+kube_config_name):
+        shutil.move(os.path.join('/tmp', tmp_file_name),
+                    os.path.join('/configs', kube_config_name))
+
+    return '/configs/'+kube_config_name
+
+
+def subscriptions(uow: unit_of_work.AbstractUnitOfWork, **kwargs):
+    pagination = Pagination(**kwargs)
+    query_kwargs = pagination.get_pagination()
+    args = gen_filter(Subscription,
+                      kwargs['filter']) if 'filter' in kwargs else []
+    with uow:
+        li = uow.subscriptions.list_with_count(*args, **query_kwargs)
+    return pagination.get_result(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_create,
+                        uow: unit_of_work.AbstractUnitOfWork):
+    filter = subscriptionDto.get('filter', '')
+    consumer_subs_id = subscriptionDto.get('consumerSubscriptionId', '')
+
+    check_filter(ocloud.Resource, filter)
+
+    sub_uuid = str(uuid.uuid4())
+    subscription = Subscription(
+        sub_uuid, subscriptionDto['callback'],
+        consumer_subs_id, filter)
+    with uow:
+        uow.subscriptions.add(subscription)
+        uow.commit()
+        first = uow.subscriptions.get(sub_uuid)
+        return first.serialize()
+
+
+def subscription_delete(subscriptionId: str,
+                        uow: unit_of_work.AbstractUnitOfWork):
+    with uow:
+        uow.subscriptions.delete(subscriptionId)
+        uow.commit()
+    return True