from db import db


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

    __tablename__ = "Album"

    id = db.Column(db.BigInteger, primary_key=True)
    name = db.Column(db.String, nullable=False)
    upc = db.Column(db.String(12), unique=True, nullable=False)

    __table_args__ = (db.CheckConstraint(r"upc ~ '^\d{12}$'", name="ck_Upc_value_format"),)

    def __str__(self):
        return self.name