"""Vat summary file model."""

from datetime import datetime

from sqlalchemy import Column
from sqlalchemy import DateTime
from sqlalchemy import ForeignKey
from sqlalchemy import Integer
from sqlalchemy import String

from moneyhub.constants.constants import SYSTEM_TIMEZONE
from moneyhub.models.mysql_base import BaseModel
from moneyhub.models.statement_period import StatementPeriod


class VatSummaryFile(BaseModel):
    """Vat summary file model."""

    __tablename__ = 'vat_summary_file'

    vat_summary_file_id = Column(Integer, primary_key=True)
    statement_period_id = Column(
        Integer, ForeignKey(StatementPeriod.statement_period_id), nullable=True)
    file_location = Column(String(255), nullable=False)
    created_by = Column(String(255), nullable=False)
    created_at = Column(DateTime, nullable=False)

    def __init__(self, *args, **kwargs):
        """Initialize model with default values."""
        date_now = datetime.now(SYSTEM_TIMEZONE)
        self.created_at = date_now
        super().__init__(*args, **kwargs)