1 # Copyright (C) 2021 Wind River Systems, Inc.
\r
3 # Licensed under the Apache License, Version 2.0 (the "License");
\r
4 # you may not use this file except in compliance with the License.
\r
5 # You may obtain a copy of the License at
\r
7 # http://www.apache.org/licenses/LICENSE-2.0
\r
9 # Unless required by applicable law or agreed to in writing, software
\r
10 # distributed under the License is distributed on an "AS IS" BASIS,
\r
11 # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
\r
12 # See the License for the specific language governing permissions and
\r
13 # limitations under the License.
\r
15 from sqlalchemy import select
\r
17 from o2common.service import unit_of_work
\r
18 from o2ims.adapter.orm import deploymentmanager
\r
19 from o2dms.adapter.orm import nfDeploymentDesc
\r
22 def deployment_managers(uow: unit_of_work.AbstractUnitOfWork):
\r
24 res = uow.session.execute(select(deploymentmanager))
\r
25 return [dict(r) for r in res]
\r
28 def deployment_manager_one(deploymentManagerId: str,
\r
29 uow: unit_of_work.AbstractUnitOfWork):
\r
31 res = uow.session.execute(select(deploymentmanager).where(
\r
32 deploymentmanager.c.deploymentManagerId == deploymentManagerId))
\r
34 return None if first is None else dict(first)
\r
37 def lcm_nfdeploymentdesc_list(deploymentManagerID: str,
\r
38 uow: unit_of_work.AbstractUnitOfWork):
\r
40 res = uow.session.execute(select(nfDeploymentDesc).where(
\r
41 nfDeploymentDesc.c.deploymentManagerId == deploymentManagerID))
\r
42 return [dict(r) for r in res]
\r
45 def lcm_nfdeploymentdesc_one(nfdeploymentdescriptorid: str,
\r
46 deploymentManagerID: str,
\r
47 uow: unit_of_work.AbstractUnitOfWork):
\r
49 res = uow.session.execute(select(deploymentmanager).where(
\r
50 nfDeploymentDesc.c.deploymentManagerId == deploymentManagerID,
\r
51 nfDeploymentDesc.c.id == nfdeploymentdescriptorid))
\r
53 return None if first is None else dict(first)
\r
56 # def lcm_nfdeploymentdesc_create(nfdeploymentdescriptorid: str,
\r
57 # uow: unit_of_work.AbstractUnitOfWork):
\r
59 # res = uow.session.execute(select(deploymentmanager).where(
\r
60 # deploymentmanager.c.id == nfdeploymentdescriptorid))
\r
61 # first = res.first()
\r
62 # return None if first is None else dict(first)
\r
65 # def lcm_nfdeploymentdesc_delete(nfdeploymentdescriptorid: str,
\r
66 # uow: unit_of_work.AbstractUnitOfWork):
\r
68 # res = uow.session.execute(select(deploymentmanager).where(
\r
69 # deploymentmanager.c.id == nfdeploymentdescriptorid))
\r
70 # first = res.first()
\r
71 # return None if first is None else dict(first)
\r