# coding: utf-8
"""
class StationmetaRole (Base)
============================
"""
from sqlalchemy import Column, ForeignKey, Integer, \
                       CheckConstraint, UniqueConstraint, Table, Sequence
from sqlalchemy.orm import relationship
from toardb.contacts.models import Person
from toardb.base import Base


# many-to-many relationships
stationmeta_core_stationmeta_roles_table = Table('stationmeta_core_timeseries_roles', Base.metadata,
    Column('station_id', Integer, ForeignKey('stationmeta_core.id')),
    Column('role_id', Integer, ForeignKey('stationmeta_roles.id'))
)


STATIONMETA_ROLES_ID_SEQ = Sequence('stationmeta_roles_id_seq')  # define sequence explicitly
class StationmetaRole(Base):
    """ Table "public.stationmeta_roles"

    +------------+---------+-----------+----------+-----------------------------------------------+
    |   Column   |  Type   | Collation | Nullable |                  Default                      |
    +============+=========+===========+==========+===============================================+
    | id         | integer |           | not null | nextval('stationmeta_roles_id_seq'::regclass) |
    +------------+---------+-----------+----------+-----------------------------------------------+
    | role       | integer |           | not null |                                               |
    +------------+---------+-----------+----------+-----------------------------------------------+
    | status     | integer |           | not null |                                               |
    +------------+---------+-----------+----------+-----------------------------------------------+
    | person_id  | integer |           | not null |                                               |
    +------------+---------+-----------+----------+-----------------------------------------------+
    Indexes:
     "stationmeta_roles_pkey" PRIMARY KEY, btree (id)
     "stationmeta_roles_person_id_3bd9c160" btree (person_id)
    Check constraints:
     "stationmeta_roles_role_check" CHECK (role >= 0)
     "stationmeta_roles_status_check" CHECK (status >= 0)
    Foreign-key constraints:
     "stationmeta_roles_person_id_3bd9c160_fk_persons_id" FOREIGN KEY (person_id) REFERENCES persons(id) DEFERRABLE INITIALLY DEFERRED
    """

    __tablename__ = 'stationmeta_roles'
    __table_args__ = (
        CheckConstraint('role >= 0'),
        CheckConstraint('status >= 0')
    )

    id = Column(Integer, STATIONMETA_ROLES_ID_SEQ, primary_key=True, server_default=STATIONMETA_ROLES_ID_SEQ.next_value())
    role = Column(Integer, nullable=False)
    status = Column(Integer, nullable=False)
# do not use string declaration here (not working for pytest)
# use the explicit class name here,
# see: https://groups.google.com/forum/#!topic/sqlalchemy/YjGhE4d6K4U
    person_id = Column(ForeignKey(Person.id, deferrable=True, initially='DEFERRED'), nullable=False, index=True)
# how to reactivate the following two lines?!
#   person = relationship('Person')

    stationmeta_core = relationship("StationmetaCore",
                           secondary=stationmeta_core_stationmeta_roles_table,
                           backref="roles")