from buyercall.lib.util_sqlalchemy import ResourceMixin
from buyercall.extensions import db
from sqlalchemy.dialects import postgresql as pg


class ReportUserTie(ResourceMixin, db.Model):
    __tablename__ = 'report_user_tie'

    report_id = db.Column(db.Integer, db.ForeignKey('reports.id'), primary_key=True)

    user_id = db.Column(db.Integer, db.ForeignKey('users.id'), primary_key=True)

    partnership_accounts_id = db.Column(
        db.Integer,
        db.ForeignKey('partnership_accounts.id', name='reports_partnership_accounts_id_tie_fkey'),
        index=True, primary_key=False
    )

    emails = db.Column(pg.JSON, nullable=False, server_default='{}')

    report = db.relationship("Report", back_populates="users")
    user = db.relationship("User", back_populates="reports")


class Report(db.Model):
    __tablename__ = 'reports'
    id = db.Column(db.Integer, primary_key=True)

    name = db.Column(db.String(255), index=True, nullable=False,
                     server_default='')

    users = db.relationship(ReportUserTie, back_populates="report")