"""VideoDashboardItem model."""

from typing import Any

from sqlalchemy import Column
from sqlalchemy.dialects.mysql import INTEGER

from video.connectors import mysql


class VideoDashboardItem(mysql.ArModel):
    """Video Dashboard Item model."""

    __tablename__ = "video_dashboard_item"

    dashboard_item_id = Column(
        INTEGER(unsigned=True), nullable=False, primary_key=True, autoincrement=True
    )
    asset_id = Column(INTEGER(unsigned=True))
    upc = Column(INTEGER(unsigned=True))

    def to_dict(self) -> dict[str, Any]:
        """Get a dict representation of a Video Dashboard Item."""
        return {
            "dashboard_item_id": self.dashboard_item_id,
            "asset_id": self.asset_id,
            "upc": self.upc,
        }