from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, Float, DateTime

Base = declarative_base()

class ExchangePair(Base):
    __tablename__ = 'exchange_pairs'
    id = Column(Integer, primary_key=True)
    target_currency_id = Column(String)
    base_currency_id = Column(String)
    last = Column(Float)
    volume = Column(Float)
    exchange_id = Column(String)
    date = Column(DateTime)
    time = Column(Integer)

    def __repr__(self):
        return "<ExchangePair(target='{}', base='{}', last='{}', exchange='{}')>".format(
            self.target_currency_id, self.base_currency_id, self.last, self.volume)

class Currency(Base):
    __tablename__ = 'currencies'
    id = Column(Integer, primary_key=True)
    currency_id = Column(String)
    price = Column(Float)
    time = Column(Integer)

    def __repr__(self):
        return "<Currency(currency_id='{}', time='{}', price='{}')>".format(
            self.currency_id, self.time, self.price)