"""FocusTrack Modeling."""

from sqlalchemy import Column
from sqlalchemy import Date
from sqlalchemy import DateTime
from sqlalchemy import Enum
from sqlalchemy import ForeignKey
from sqlalchemy import Integer
from sqlalchemy.sql import func

from backend.connectors import mysql


class FocusTrack(mysql.BaseModel):
    """Encapsulates Focus Track data.

    Represents focus_track table in the art_relations database.
    """

    __tablename__ = 'focus_track'

    focus_track_id = Column(Integer, primary_key=True, autoincrement=True, nullable=False)
    tuid = Column(
        'unique_track_id', ForeignKey('track.id'), nullable=False)
    product_id = Column('release_id', Integer, nullable=False)
    start_date = Column(Date)
    end_date = Column(Date)
    updated_on = Column(DateTime, default=func.now(), onupdate=func.now())
    updated_by_user_id = Column(Integer)
    updated_by_user_type = Column(Enum('oa', 'alw'))
    created_on = Column(DateTime, default=func.now())
    created_by_user_id = Column(Integer)
    created_by_user_type = Column(Enum('oa', 'alw'))