from playlister.connectors import mysql
from sqlalchemy import BigInteger, Column, Date, MetaData, String, Table, text, Integer


class SpotifyPlaylistDay(mysql.PlaylisterBaseModel):
    __tablename__ = 'spotify_playlist_day'
    id = Column(Integer, primary_key=True)
    download_date = Column('download_date', Date, index=True)
    playlist_user_id = Column('playlist_user_id', String(255), server_default=text("''"))
    playlist_id = Column('playlist_id', String(255))
    listener_country = Column('listener_country', String(5))
    isrc = Column('isrc', String(50))
    streams = Column('streams', BigInteger)


class SpotifyPlaylist30day(mysql.PlaylisterBaseModel):
    __tablename__ = 'spotify_playlist_30day'

    id = Column(Integer, primary_key=True)
    download_date_from = Column(Date)
    download_date_to = Column(Date)
    playlist_user_id = Column(String(255), server_default=text("''"))
    playlist_id = Column(String(255))
    listener_country = Column(String(5))
    isrc = Column(String(50), index=True)
    streams = Column(BigInteger)


class SpotifyPlaylist7day(mysql.PlaylisterBaseModel):
    __tablename__ = 'spotify_playlist_7day'

    id = Column(Integer, primary_key=True)
    download_date_from = Column(Date)
    download_date_to = Column(Date)
    playlist_user_id = Column(String(255), server_default=text("''"))
    playlist_id = Column(String(255))
    listener_country = Column(String(5))
    isrc = Column(String(50), index=True)
    streams = Column(BigInteger)