# Copyright 2022-2024 ETSI OSG/SDG TeraFlowSDN (TFS) (https://tfs.etsi.org/) # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. import operator from sqlalchemy import CheckConstraint, Column, DateTime, Float, Enum, ForeignKey, Integer, String from sqlalchemy.dialects.postgresql import UUID, ARRAY from sqlalchemy.orm import relationship from typing import Dict from ._Base import _Base from .enums.QKDAppStatus import ORM_QKDAppStatusEnum from .enums.QKDAppTypes import ORM_QKDAppTypesEnum class AppModel(_Base): __tablename__ = 'qkd_app' app_uuid = Column(UUID(as_uuid=False), primary_key=True) context_uuid = Column(UUID(as_uuid=False), nullable=False) # Supposed to be Foreign Key app_status = Column(Enum(ORM_QKDAppStatusEnum), nullable=False) app_type = Column(Enum(ORM_QKDAppTypesEnum), nullable=False) server_app_id = Column(String, nullable=False) client_app_id = Column(ARRAY(String), nullable=False) backing_qkdl_uuid = Column(ARRAY(UUID(as_uuid=False)), nullable=False) local_device_uuid = Column(UUID(as_uuid=False), nullable=False) remote_device_uuid = Column(UUID(as_uuid=False), nullable=True) # Optare: Created_at and Updated_at are only used to know if an app was updated later on the code. Don't change it created_at = Column(DateTime, nullable=False) updated_at = Column(DateTime, nullable=False) #__table_args__ = ( # CheckConstraint(... >= 0, name='name_value_...'), #) def dump_id(self) -> Dict: return { 'context_id': {'context_uuid': {'uuid': self.context_uuid}}, 'app_uuid': {'uuid': self.app_uuid} } def dump(self) -> Dict: result = { 'app_id' : self.dump_id(), 'app_status' : self.app_status.value, 'app_type' : self.app_type.value, 'server_app_id' : self.server_app_id, 'client_app_id' : self.client_app_id, 'backing_qkdl_id' : [{'qkdl_uuid': {'uuid': qkdl_id}} for qkdl_id in self.backing_qkdl_uuid], 'local_device_id' : {'device_uuid': {'uuid': self.local_device_uuid}}, 'remote_device_id' : {'device_uuid': {'uuid': self.remote_device_uuid}}, } return result