# limitations under the License.
from typing import List
-# from o2ims.adapter import orm
-from o2ims.domain import ocloud
+
+from o2ims.domain import ocloud, subscription_obj, configuration_obj
from o2ims.domain.ocloud_repo import OcloudRepository, ResourceTypeRepository,\
- ResourcePoolRepository, ResourceRepository, DeploymentManagerRepository,\
- SubscriptionRepository
+ ResourcePoolRepository, ResourceRepository, DeploymentManagerRepository
+from o2ims.domain.subscription_repo import SubscriptionRepository
+from o2ims.domain.configuration_repo import ConfigurationRepository
+from o2common.helper import o2logging
+logger = o2logging.get_logger(__name__)
class OcloudSqlAlchemyRepository(OcloudRepository):
oCloudId=ocloud_id).first()
def _list(self) -> List[ocloud.Ocloud]:
- return self.session.query(ocloud.Ocloud).order_by(
- ocloud.Ocloud.name).all()
+ return self.session.query(ocloud.Ocloud)
def _update(self, ocloud: ocloud.Ocloud):
self.session.add(ocloud)
return self.session.query(ocloud.ResourceType).filter_by(
resourceTypeId=resource_type_id).first()
+ def _get_by_name(self, resource_type_name) -> ocloud.ResourceType:
+ return self.session.query(ocloud.ResourceType).filter_by(
+ name=resource_type_name).first()
+
def _list(self) -> List[ocloud.ResourceType]:
- return self.session.query()
+ return self.session.query(ocloud.ResourceType)
def _update(self, resourceType: ocloud.ResourceType):
self.session.add(resourceType)
resourcePoolId=resource_pool_id).first()
def _list(self) -> List[ocloud.ResourcePool]:
- return self.session.query()
+ return self.session.query(ocloud.ResourcePool)
def _update(self, resourcePool: ocloud.ResourcePool):
self.session.add(resourcePool)
self.session.add(resource)
def _get(self, resource_id) -> ocloud.Resource:
+ # return self.session.query(ocloud.Resource).filter_by(
+ # resourceId=resource_id).first()
+ # topq = uow.session.query(orm.resource).filter(
+ # orm.resource.c.resourceId == resourceId).\
+ # cte('cte', recursive=True)
+ # bootomq = uow.session.query(orm.resource).join(
+ # topq, orm.resource.c.parentId == topq.c.resourceId)
+ # res = uow.session.query(topq.union(bootomq))
+ def recursive(id):
+ res = self.session.query(ocloud.Resource).filter_by(
+ resourceId=id).first()
+ if res is not None:
+ query = self.session.query(ocloud.Resource).filter_by(
+ parentId=res.resourceId)
+ children = []
+ for r in query:
+ child = recursive(r.resourceId)
+ children.append(child)
+ res.set_children(children)
+ return res
+ return recursive(resource_id)
+
+ def _list(self, resourcepool_id, **kwargs) -> List[ocloud.Resource]:
return self.session.query(ocloud.Resource).filter_by(
- resourceId=resource_id).first()
-
- def _list(self) -> List[ocloud.Resource]:
- return self.session.query()
+ resourcePoolId=resourcepool_id, **kwargs)
def _update(self, resource: ocloud.Resource):
self.session.add(resource)
deploymentManagerId=deployment_manager_id).first()
def _list(self) -> List[ocloud.DeploymentManager]:
- return self.session.query()
+ return self.session.query(ocloud.DeploymentManager)
def _update(self, deployment_manager: ocloud.DeploymentManager):
self.session.add(deployment_manager)
super().__init__()
self.session = session
- def _add(self, subscription: ocloud.Subscription):
+ def _add(self, subscription: subscription_obj.Subscription):
self.session.add(subscription)
- def _get(self, subscription_id) -> ocloud.Subscription:
- return self.session.query(ocloud.Subscription).filter_by(
+ def _get(self, subscription_id) -> subscription_obj.Subscription:
+ return self.session.query(subscription_obj.Subscription).filter_by(
subscriptionId=subscription_id).first()
- def _list(self) -> List[ocloud.Subscription]:
- return self.session.query()
+ def _list(self) -> List[subscription_obj.Subscription]:
+ return self.session.query(subscription_obj.Subscription)
- def _update(self, subscription: ocloud.Subscription):
+ def _update(self, subscription: subscription_obj.Subscription):
self.session.add(subscription)
def _delete(self, subscription_id):
- self.session.query(ocloud.Subscription).filter_by(
+ self.session.query(subscription_obj.Subscription).filter_by(
subscriptionId=subscription_id).delete()
+
+
+class ConfigurationSqlAlchemyRepository(ConfigurationRepository):
+ def __init__(self, session):
+ super().__init__()
+ self.session = session
+
+ def _add(self, configuration: configuration_obj.Configuration):
+ self.session.add(configuration)
+
+ def _get(self, configuration_id) -> configuration_obj.Configuration:
+ return self.session.query(configuration_obj.Configuration).filter_by(
+ configurationId=configuration_id).first()
+
+ def _list(self) -> List[configuration_obj.Configuration]:
+ return self.session.query(configuration_obj.Configuration)
+
+ def _update(self, configuration: configuration_obj.Configuration):
+ self.session.add(configuration)
+
+ def _delete(self, configuration_id):
+ self.session.query(configuration_obj.Configuration).filter_by(
+ configurationId=configuration_id).delete()