# 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. from sqlalchemy import Column, Integer, String, JSON from sqlalchemy.dialects.postgresql import UUID from ._Base import _Base class QoSProfileModel(_Base): __tablename__ = 'qos_profile' qos_profile_id = Column(UUID(as_uuid=False), primary_key=True) name = Column(String, nullable=False) description = Column(String, nullable=False) status = Column(String, nullable=False) targetMinUpstreamRate = Column(JSON, nullable=False) maxUpstreamRate = Column(JSON, nullable=False) maxUpstreamBurstRate = Column(JSON, nullable=False) targetMinDownstreamRate = Column(JSON, nullable=False) maxDownstreamRate = Column(JSON, nullable=False) maxDownstreamBurstRate = Column(JSON, nullable=False) minDuration = Column(JSON, nullable=False) maxDuration = Column(JSON, nullable=False) priority = Column(Integer, nullable=False) packetDelayBudget = Column(JSON, nullable=False) jitter = Column(JSON, nullable=False) packetErrorLossRate = Column(Integer, nullable=False)