from sync.connectors import mysql
from sqlalchemy import Column, BigInteger, Integer, String, Float


class Song(mysql.SyncBaseModel):
    __tablename__ = 'catalog'
    unique_track_id = Column(
        Integer, primary_key=True, autoincrement=True, nullable=False)
    artist_id = Column(Integer)
    release_name = Column(String(3000))
    upc = Column(BigInteger)
    cd = Column(Integer)
    track_id = Column(Integer)
    isrc = Column(String(200))
    genre_id = Column(Integer)
    genre_name = Column(String(1000))
    label_name = Column(String(2000))
    mode = Column(Float(precision=18, decimal_return_scale=6))
    speechiness = Column(Float(precision=18, decimal_return_scale=6))
    key = Column(Float(precision=18, decimal_return_scale=6))
    instrumentalness = Column(Float(precision=18, decimal_return_scale=6))
    audio_md5 = Column(String(3000))
    acousticness = Column(Float(precision=18, decimal_return_scale=6))
    track_name = Column(String(5000))
    analysis_url = Column(String(3000))
    time_signature = Column(Integer)
    energy = Column(Float(precision=18, decimal_return_scale=6))
    duration = Column(Float(precision=18, decimal_return_scale=6))
    tempo = Column(Float(precision=18, decimal_return_scale=6))
    artist_name = Column(String(3000))
    danceability = Column(Float(precision=18, decimal_return_scale=6))
    valence = Column(Float(precision=18, decimal_return_scale=6))
    loudness = Column(Float(precision=18, decimal_return_scale=6))
    liveness = Column(Float(precision=18, decimal_return_scale=6))
    cover_art_sm = Column(String(1000))