from sqlalchemy import (
    BigInteger, Column, Date, DateTime, String, sql, Integer, ForeignKey)
from sqlalchemy.orm import relationship
import collections
import datetime
from datetime import date

from feed_status.connectors import mysql


class EtlLoggerHistory(mysql.ArtRelationsBaseModel):
    __tablename__ = 'fact_analytics_ingestion_history'
    uuid = Column(String(5000))
    storeid = Column(ForeignKey('dim_store.storeId'), index=True)
    downloaddate = Column(Date, primary_key=True)
    status = Column(String(500))
    processed = Column(BigInteger)
    succeeded = Column(BigInteger)
    failed = Column(BigInteger)
    daterangestart = Column(Date)
    daterangeend = Column(Date)
    processeddaytime = Column(DateTime)
    dim_store = relationship('DimStore')