from atlas_um.pgdb import pgdb
from atlas_um.pgdb.associations import dna_account_tag_table
from atlas_um.pgdb.queries.tag import TagQuery


class Tag(pgdb.Model):
    __tablename__ = "tag"
    query_class = TagQuery

    id = pgdb.Column(pgdb.Integer, primary_key=True)
    name = pgdb.Column(pgdb.String(), nullable=False, unique=True)
    slug = pgdb.Column(pgdb.String(), nullable=False, unique=True)
    is_deleted = pgdb.Column(pgdb.Boolean(), nullable=False, default=False)

    # Relations
    dna_accounts = pgdb.relationship(
        "DNAAccount", secondary=dna_account_tag_table, back_populates="tags"
    )

    def __str__(self):
        return self.name