--- /dev/null
+# 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
+from o2common.service import unit_of_work\r
+from o2dms.adapter.orm import nfOCloudVResource\r
+from o2common.helper import o2logging\r
+logger = o2logging.get_logger(__name__)\r
+\r
+\r
+def lcm_nfocloudvresource_list(\r
+ nfDeploymentId: str, uow: unit_of_work.AbstractUnitOfWork):\r
+ with uow:\r
+ res = uow.session.execute(select(nfOCloudVResource).where(\r
+ nfOCloudVResource.c.nfDeploymentId == nfDeploymentId))\r
+ return [dict(r) for r in res]\r
+\r
+\r
+def lcm_nfocloudvresource_one(\r
+ ocloudvresourceId: str, uow: unit_of_work.AbstractUnitOfWork):\r
+ with uow:\r
+ res = uow.session.execute(select(nfOCloudVResource).where(\r
+ nfOCloudVResource.c.id == ocloudvresourceId))\r
+ first = res.first()\r
+ return None if first is None else dict(first)\r