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 (
\r
27 from sqlalchemy.orm import mapper, relationship
\r
29 from o2ims.domain import ocloud as ocloudModel
\r
31 from o2common.helper import o2logging
\r
32 logger = o2logging.get_logger(__name__)
\r
34 metadata = MetaData()
\r
39 Column("oCloudId", String(255), primary_key=True),
\r
40 Column("globalcloudId", String(255)),
\r
41 Column("name", String(255)),
\r
42 Column("description", String(255)),
\r
43 Column("infrastructureManagementServiceEndpoint", String(255))
\r
44 # Column("extensions", String(1024))
\r
47 resourcetype = Table(
\r
50 Column("resourceTypeId", String(255), primary_key=True),
\r
51 Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
52 Column("name", String(255)),
\r
53 Column("vendor", String(255)),
\r
54 Column("model", String(255)),
\r
55 Column("version", String(255)),
\r
56 Column("description", String(255)),
\r
57 # Column("extensions", String(1024))
\r
60 resourcepool = Table(
\r
63 Column("resourcePoolId", String(255), primary_key=True),
\r
64 Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
65 Column("globalLocationId", String(255)),
\r
66 Column("name", String(255)),
\r
67 Column("location", String(255)),
\r
68 Column("description", String(255)),
\r
69 # Column("resources", String(1024))
\r
70 # Column("extensions", String(1024))
\r
76 Column("resourceId", String(255), primary_key=True),
\r
77 Column("resourceTypeId", ForeignKey("resourcetype.resourceTypeId")),
\r
78 Column("resourcePoolId", ForeignKey("resourcepool.resourcePoolId")),
\r
79 # Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
80 Column("parentId", String(255)),
\r
81 Column("description", String(255)),
\r
82 # Column("elements", String(255))
\r
83 # Column("extensions", String(1024))
\r
86 deploymentmanager = Table(
\r
87 "deploymentmanager",
\r
89 Column("deploymentManagerId", String(255), primary_key=True),
\r
90 Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
91 Column("name", String(255)),
\r
92 Column("description", String(255)),
\r
93 Column("deploymentManagementServiceEndpoint", String(255)),
\r
94 Column("supportedLocations", String(255)),
\r
95 Column("capabilities", String(255)),
\r
96 Column("capacity", String(255)),
\r
97 # Column("extensions", String(1024))
\r
100 subscription = Table(
\r
103 Column("subscriptionId", String(255), primary_key=True),
\r
104 Column("callback", String(255)),
\r
105 Column("consumerSubscriptionId", String(255)),
\r
106 Column("filter", String(255)),
\r
110 def start_o2ims_mappers(engine=None):
\r
111 logger.info("Starting O2 IMS mappers")
\r
113 dm_mapper = mapper(ocloudModel.DeploymentManager, deploymentmanager)
\r
114 resourcepool_mapper = mapper(ocloudModel.ResourcePool, resourcepool)
\r
115 resourcetype_mapper = mapper(ocloudModel.ResourceType, resourcetype)
\r
117 ocloudModel.Ocloud,
\r
120 "deploymentManagers": relationship(dm_mapper),
\r
121 "resourceTypes": relationship(resourcetype_mapper),
\r
122 "resourcePools": relationship(resourcepool_mapper)
\r
125 ocloudModel.Resource,
\r
128 "resourceTypes": relationship(resourcetype_mapper),
\r
129 "resourcePools": relationship(resourcepool_mapper)
\r
132 mapper(ocloudModel.Subscription, subscription)
\r
134 if engine is not None:
\r
135 metadata.create_all(engine)
\r