from db import db


class Track(db.Model):
    """Track model"""

    __tablename__ = "Track"

    id = db.Column(db.BigInteger, primary_key=True)
    name = db.Column(db.String, nullable=False)
    isrc = db.Column(db.String(12), nullable=False)
    album_id = db.Column(db.BigInteger, db.ForeignKey("Album.id"), nullable=False)

    __table_args__ = (
        db.CheckConstraint(r"isrc ~ '^[A-Z]{2}[A-Z0-9]{3}\d{7}$'", name="ck_Isrc_value_format"),
        db.UniqueConstraint("isrc", "album_id", name="uq_Track_isrc_album_id"),
    )

    def __str__(self):
        return self.name