Add tox

[pti/o2.git] / o2ims / views / ocloud_view.py

diff --git a/o2ims/views/ocloud_view.py b/o2ims/views/ocloud_view.py
new file mode 100644 (file)
index 0000000..7005b5a
--- /dev/null
+++ b/o2ims/views/ocloud_view.py
@@ -0,0 +1,36 @@
+# 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 o2ims.service import unit_of_work\r
+\r
+\r
+def ocloud_one(ocloudid: str, uow: unit_of_work.SqlAlchemyUnitOfWork):\r
+    with uow:\r
+        results = uow.session.execute(\r
+            """\r
+            SELECT oCloudId, name FROM ocloud WHERE oCloudId = :ocloudid\r
+            """,\r
+            dict(ocloudid=ocloudid),\r
+        )\r
+    return dict(results[0]) if len(results) > 0 else None\r
+\r
+\r
+def oclouds(uow: unit_of_work.SqlAlchemyUnitOfWork):\r
+    with uow:\r
+        results = uow.session.execute(\r
+            """\r
+            SELECT oCloudId, name FROM ocloud\r
+            """,\r
+        )\r
+    return [dict(r) for r in results]\r