Add ocloud query parameter; add and delete subscription
[pti/o2.git] / o2ims / views / ocloud_view.py
index 513e9e0..90850e8 100644 (file)
@@ -17,30 +17,17 @@ from sqlalchemy import select
 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 Ocloud\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(\r
-        #     """\r
-        #     SELECT "oCloudId", "name" FROM ocloud\r
-        #     """,\r
-        # )\r
-\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
-        #     """\r
-        #     SELECT "oCloudId", "name" FROM ocloud\r
-        #     WHERE "oCloudId" = :oCloudId\r
-        #     """,\r
-        #     dict(oCloudId=ocloudid),\r
-        # )\r
         res = uow.session.execute(\r
             select(ocloud).where(ocloud.c.oCloudId == ocloudid))\r
         first = res.first()\r
@@ -49,11 +36,6 @@ def ocloud_one(ocloudid: str, uow: unit_of_work.AbstractUnitOfWork):
 \r
 def resource_types(uow: unit_of_work.SqlAlchemyUnitOfWork):\r
     with uow:\r
-        # res = uow.session.execute(\r
-        #     """\r
-        #     SELECT "resourceTypeId", "oCloudId", "name" FROM resourcetype\r
-        #     """,\r
-        # )\r
         res = uow.session.execute(select(resourcetype))\r
     return [dict(r) for r in res]\r
 \r
@@ -61,13 +43,6 @@ def resource_types(uow: unit_of_work.SqlAlchemyUnitOfWork):
 def resource_type_one(resourceTypeId: str,\r
                       uow: unit_of_work.SqlAlchemyUnitOfWork):\r
     with uow:\r
-        # res = uow.session.execute(\r
-        #     """\r
-        #     SELECT "resourceTypeId", "oCloudId", "name"\r
-        #     FROM resourcetype WHERE "resourceTypeId" = :resourceTypeId\r
-        #     """,\r
-        #     dict(resourceTypeId=resourceTypeId),\r
-        # )\r
         res = uow.session.execute(select(resourcetype).where(\r
             resourcetype.c.resourceTypeId == resourceTypeId))\r
         first = res.first()\r
@@ -76,12 +51,6 @@ def resource_type_one(resourceTypeId: str,
 \r
 def resource_pools(uow: unit_of_work.SqlAlchemyUnitOfWork):\r
     with uow:\r
-        # res = uow.session.execute(\r
-        #     """\r
-        #     SELECT "resourcePoolId", "oCloudId", "location", "name"\r
-        #     FROM resourcepool\r
-        #     """,\r
-        # )\r
         res = uow.session.execute(select(resourcepool))\r
     return [dict(r) for r in res]\r
 \r
@@ -89,14 +58,6 @@ def resource_pools(uow: unit_of_work.SqlAlchemyUnitOfWork):
 def resource_pool_one(resourcePoolId: str,\r
                       uow: unit_of_work.SqlAlchemyUnitOfWork):\r
     with uow:\r
-        # res = uow.session.execute(\r
-        #     """\r
-        #     SELECT "resourcePoolId", "oCloudId", "location", "name"\r
-        #     FROM resourcepool\r
-        #     WHERE "resourcePoolId" = :resourcePoolId\r
-        #     """,\r
-        #     dict(resourcePoolId=resourcePoolId),\r
-        # )\r
         res = uow.session.execute(select(resourcepool).where(\r
             resourcepool.c.resourcePoolId == resourcePoolId))\r
         first = res.first()\r
@@ -105,15 +66,6 @@ def resource_pool_one(resourcePoolId: str,
 \r
 def resources(resourcePoolId: str, uow: unit_of_work.SqlAlchemyUnitOfWork):\r
     with uow:\r
-        # res = uow.session.execute(\r
-        #     """\r
-        #     SELECT "resourceId", "parentId", "resourceTypeId",\r
-        #           "resourcePoolId", "oCloudId"\r
-        #     FROM resource\r
-        #     WHERE "resourcePoolId" = :resourcePoolId\r
-        #     """,\r
-        #     dict(resourcePoolId=resourcePoolId),\r
-        # )\r
         res = uow.session.execute(select(resource).where(\r
             resource.c.resourcePoolId == resourcePoolId))\r
     return [dict(r) for r in res]\r
@@ -121,17 +73,12 @@ def resources(resourcePoolId: str, uow: unit_of_work.SqlAlchemyUnitOfWork):
 \r
 def resource_one(resourceId: str, uow: unit_of_work.SqlAlchemyUnitOfWork):\r
     with uow:\r
-        # res = uow.session.execute(\r
-        #     """\r
-        #     SELECT "resourceId", "parentId", "resourceTypeId",\r
-        #           "resourcePoolId", "oCloudId"\r
-        #     FROM resource\r
-        #     WHERE "resourceId" = :resourceId\r
-        #     """,\r
-        #     # AND "resourcePoolId" = :resourcePoolId\r
-        #     # dict(resourcePoolId=resourcePoolId,\r
-        #     dict(resourceId=resourceId),\r
-        # )\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
@@ -140,13 +87,6 @@ def resource_one(resourceId: str, uow: unit_of_work.SqlAlchemyUnitOfWork):
 \r
 def deployment_managers(uow: unit_of_work.SqlAlchemyUnitOfWork):\r
     with uow:\r
-        # res = uow.session.execute(\r
-        #     """\r
-        #     SELECT "deploymentManagerId", "oCloudId",\r
-        #           "deploymentManagementServiceEndpoint", "name"\r
-        #     FROM deploymentmanager\r
-        #     """,\r
-        # )\r
         res = uow.session.execute(select(deploymentmanager))\r
     return [dict(r) for r in res]\r
 \r
@@ -154,15 +94,6 @@ def deployment_managers(uow: unit_of_work.SqlAlchemyUnitOfWork):
 def deployment_manager_one(deploymentManagerId: str,\r
                            uow: unit_of_work.SqlAlchemyUnitOfWork):\r
     with uow:\r
-        # res = uow.session.execute(\r
-        #     """\r
-        #     SELECT "deploymentManagerId", "oCloudId",\r
-        #           "deploymentManagementServiceEndpoint", "name"\r
-        #     FROM deploymentmanager\r
-        #     WHERE "deploymentManagerId" = :deploymentManagerId\r
-        #     """,\r
-        #     dict(deploymentManagerId=deploymentManagerId),\r
-        # )\r
         res = uow.session.execute(select(deploymentmanager).where(\r
             deploymentmanager.c.deploymentManagerId == deploymentManagerId))\r
         first = res.first()\r
@@ -182,3 +113,18 @@ def subscription_one(subscriptionId: str,
             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