"""
SQLAlchemy model for API call results persistence
=================================================

We have an option in config - TRACK_SUCCESSFUL_API_CALLS, it configures,
whether successful API calls should be saved. It will be enabled for the
stabilization period. Later, we should disable it to decrease the speed of
RDS table growth
"""

from sqlalchemy import Column, DateTime, Enum, Integer, String, Text

from ytownership.connectors.mysql import BaseModel


class YouTubeApiLog(BaseModel):
    """Model that stores YouTube API call results
    """

    __tablename__ = 'yt_api_log'

    id = Column(Integer, primary_key=True)
    content_owner_id = Column(String(100), nullable=False)
    correlation_id = Column(String(100), nullable=False)
    isrc = Column(String(20), nullable=False)
    territories = Column(Text, nullable=False)
    created_date_utc = Column(DateTime, nullable=False)
    status = Column(Enum('success', 'error'), nullable=False)
    code = Column(Integer, nullable=False)
    message = Column(Text, nullable=False)