OpticalLinkModel.py

# Copyright 2022-2023 ETSI TeraFlowSDN - TFS OSG (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, ForeignKey, Integer, String ,Boolean
from sqlalchemy.dialects.postgresql import UUID
from sqlalchemy.types import  PickleType , TypeDecorator
from sqlalchemy.orm import relationship
import json,logging
from typing import Dict
from ._Base import _Base




class SlotType(TypeDecorator):

    impl = String

    def process_bind_param(self, value, dialect):
        if value is not None:
            slot={}
            for k,v in value.items():
                slot[k]=v
            logging.info(f"dict from slotType {slot}")    
            value = json.dumps(slot)

        return value

    def process_result_value(self, value, dialect):
        if value is not None:
            value = json.loads(value)
        return value
    
    



class OpticalLinkModel(_Base):
    __tablename__ = 'opticallink'

    opticallink_uuid          = Column(UUID(as_uuid=False), primary_key=True)
    name                      = Column(String, nullable=False)
    created_at                = Column(DateTime, nullable=False)
    updated_at                = Column(DateTime, nullable=False)
    length                    = Column(Integer, nullable=True)
    src_port                  = Column(String, nullable=True)
    dst_port                  = Column(String, nullable=True)
    local_peer_port           = Column(String, nullable=True)
    remote_peer_port          = Column(String, nullable=True)
    used                      = Column(Boolean ,nullable=True)
    c_slots                   = Column (SlotType,nullable=True)
    l_slots                   = Column (SlotType,nullable=True)
    s_slots                   = Column (SlotType,nullable=True)
    opticallink_endpoints     = relationship("OpticalLinkEndPointModel")
    topology_optical_links    = relationship('TopologyOpticalLinkModel', back_populates='optical_link')
   

 
   

    def dump_id(self) -> Dict:
        return {'link_uuid': {'uuid': self.opticallink_uuid}}

    def dump(self) -> Dict:
       
        result = {
            
            'link_id'            : self.dump_id(),
            'name'               : self.name,
            'optical_details'    :{
                 
                                'length'           : self.length,
                                "src_port"         : self.src_port,
                                "dst_port"         : self.dst_port,
                                "local_peer_port"  : self.local_peer_port,
                                "remote_peer_port" : self.remote_peer_port,
                                "used"             : self.used,
                                "c_slots"          : self.c_slots ,
                                "l_slots"          : self.l_slots,
                                "s_slots"          : self.s_slots
                },
            "link_endpoint_ids" : [optical_endpoint.endpoint.dump_id() for optical_endpoint in self.opticallink_endpoints]
            
        }
       
        return result




class OpticalLinkEndPointModel(_Base):
    __tablename__ = 'opticallink_endpoint'

    link_uuid     = Column(ForeignKey('opticallink.opticallink_uuid',         ondelete='CASCADE' ), primary_key=True)
    endpoint_uuid = Column(ForeignKey('optical_endpoint.endpoint_uuid', ondelete='RESTRICT'), primary_key=True, index=True)


    optical_link     = relationship('OpticalLinkModel',     back_populates='opticallink_endpoints') #, lazy='selectin'
    endpoint = relationship('OpticalEndPointModel', lazy='selectin') # back_populates='link_endpoints'