# Copyright 2015 OpenStack Foundation
# Copyright (c) 2015 Hewlett-Packard Development Company, L.P.
#
# 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 neutron.db import standard_attr
from neutron_lib.db import model_base
import sqlalchemy as sa
from sqlalchemy import orm


class L2GatewayConnection(standard_attr.HasStandardAttributes,
                          model_base.BASEV2, model_base.HasProject,
                          model_base.HasId):
    """Define an l2 gateway connection between a l2 gateway and a network."""
    l2_gateway_id = sa.Column(sa.String(36),
                              sa.ForeignKey('l2gateways.id',
                                            ondelete='CASCADE'))
    network_id = sa.Column(sa.String(36),
                           sa.ForeignKey('networks.id', ondelete='CASCADE'),
                           nullable=False)
    segmentation_id = sa.Column(sa.Integer)
    __table_args__ = (sa.UniqueConstraint(l2_gateway_id,
                                          network_id),)
    api_collections = ["l2_gateway_connections"]


class L2GatewayInterface(model_base.BASEV2, model_base.HasId):
    """Define an l2 gateway interface."""
    interface_name = sa.Column(sa.String(255))
    device_id = sa.Column(sa.String(36),
                          sa.ForeignKey('l2gatewaydevices.id',
                                        ondelete='CASCADE'),
                          nullable=False)
    segmentation_id = sa.Column(sa.Integer)
    revises_on_change = ('devices', )


class L2GatewayDevice(standard_attr.HasStandardAttributes,
                      model_base.BASEV2, model_base.HasId):
    """Define an l2 gateway device."""
    device_name = sa.Column(sa.String(255), nullable=False)
    interfaces = orm.relationship(
        L2GatewayInterface,
        backref=sa.orm.backref("devices", uselist=False,
                               lazy='joined', load_on_pending=True),
        cascade='all,delete')
    l2_gateway_id = sa.Column(sa.String(36),
                              sa.ForeignKey('l2gateways.id',
                                            ondelete='CASCADE'),
                              nullable=False)
    revises_on_change = ('gateways', )
    api_collections = ["l2_gateway_devices"]


class L2Gateway(standard_attr.HasStandardAttributes,
                model_base.BASEV2, model_base.HasId, model_base.HasProject):
    """Define an l2 gateway."""
    name = sa.Column(sa.String(255))
    devices = orm.relationship(
        L2GatewayDevice,
        backref=sa.orm.backref("gateways", uselist=False,
                               lazy='joined', load_on_pending=True),
        cascade='all,delete')
    network_connections = orm.relationship(L2GatewayConnection,
                                           lazy='joined')
    api_collections = ["l2_gateways"]