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 typing_extensions import Required
\r
16 from sqlalchemy import (
\r
31 from sqlalchemy.orm import mapper, relationship
\r
32 # from sqlalchemy.sql.sqltypes import Integer
\r
34 from o2ims.domain import ocloud as ocloudModel
\r
35 from o2ims.domain.resource_type import ResourceTypeEnum
\r
37 from o2common.helper import o2logging
\r
38 logger = o2logging.get_logger(__name__)
\r
40 metadata = MetaData()
\r
45 Column("updatetime", DateTime),
\r
46 Column("createtime", DateTime),
\r
47 Column("hash", String(255)),
\r
48 Column("version_number", Integer),
\r
50 Column("oCloudId", String(255), primary_key=True),
\r
51 Column("globalcloudId", String(255)),
\r
52 Column("name", String(255)),
\r
53 Column("description", String(255)),
\r
54 Column("infrastructureManagementServiceEndpoint", String(255))
\r
55 # Column("extensions", String(1024))
\r
58 resourcetype = Table(
\r
61 Column("updatetime", DateTime),
\r
62 Column("createtime", DateTime),
\r
63 Column("hash", String(255)),
\r
65 Column("resourceTypeId", String(255), primary_key=True),
\r
66 Column("resourceTypeEnum", Enum(ResourceTypeEnum), nullable=False),
\r
67 Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
68 Column("name", String(255)),
\r
69 Column("vendor", String(255)),
\r
70 Column("model", String(255)),
\r
71 Column("version", String(255)),
\r
72 Column("description", String(255)),
\r
73 # Column("extensions", String(1024))
\r
76 resourcepool = Table(
\r
79 Column("updatetime", DateTime),
\r
80 Column("createtime", DateTime),
\r
81 Column("hash", String(255)),
\r
82 Column("version_number", Integer),
\r
84 Column("resourcePoolId", String(255), primary_key=True),
\r
85 Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
86 Column("globalLocationId", String(255)),
\r
87 Column("name", String(255)),
\r
88 Column("location", String(255)),
\r
89 Column("description", String(255)),
\r
90 # Column("resources", String(1024))
\r
91 # Column("extensions", String(1024))
\r
97 Column("updatetime", DateTime),
\r
98 Column("createtime", DateTime),
\r
99 Column("hash", String(255)),
\r
100 Column("version_number", Integer),
\r
102 Column("resourceId", String(255), primary_key=True),
\r
103 Column("resourceTypeId", ForeignKey("resourcetype.resourceTypeId")),
\r
104 Column("resourcePoolId", ForeignKey("resourcepool.resourcePoolId")),
\r
105 Column("name", String(255)),
\r
106 # Column("globalAssetId", String(255)),
\r
107 Column("parentId", String(255)),
\r
108 Column("description", String(255)),
\r
109 Column("elements", Text())
\r
110 # Column("extensions", String(1024))
\r
113 deploymentmanager = Table(
\r
114 "deploymentmanager",
\r
116 Column("updatetime", DateTime),
\r
117 Column("createtime", DateTime),
\r
118 Column("hash", String(255)),
\r
119 Column("version_number", Integer),
\r
121 Column("deploymentManagerId", String(255), primary_key=True),
\r
122 Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
123 Column("name", String(255)),
\r
124 Column("description", String(255)),
\r
125 Column("deploymentManagementServiceEndpoint", String(255)),
\r
126 Column("supportedLocations", String(255)),
\r
127 Column("capabilities", String(255)),
\r
128 Column("capacity", String(255)),
\r
129 # Column("extensions", String(1024))
\r
132 subscription = Table(
\r
135 Column("updatetime", DateTime),
\r
136 Column("createtime", DateTime),
\r
137 Column("hash", String(255)),
\r
138 Column("version_number", Integer),
\r
140 Column("subscriptionId", String(255), primary_key=True),
\r
141 Column("callback", String(255)),
\r
142 Column("consumerSubscriptionId", String(255)),
\r
143 Column("filter", String(255)),
\r
147 def start_o2ims_mappers(engine=None):
\r
148 logger.info("Starting O2 IMS mappers")
\r
150 dm_mapper = mapper(ocloudModel.DeploymentManager, deploymentmanager)
\r
151 resourcepool_mapper = mapper(ocloudModel.ResourcePool, resourcepool)
\r
152 resourcetype_mapper = mapper(ocloudModel.ResourceType, resourcetype)
\r
154 ocloudModel.Ocloud,
\r
157 "deploymentManagers": relationship(dm_mapper),
\r
158 "resourceTypes": relationship(resourcetype_mapper),
\r
159 "resourcePools": relationship(resourcepool_mapper)
\r
162 ocloudModel.Resource,
\r
165 "resourceTypes": relationship(resourcetype_mapper),
\r
166 "resourcePools": relationship(resourcepool_mapper)
\r
169 mapper(ocloudModel.Subscription, subscription)
\r
171 if engine is not None:
\r
172 metadata.create_all(engine)
\r