from sqlalchemy import create_engine, ForeignKey
from sqlalchemy import Column, Date, Integer, String, DateTime, FLOAT
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship, backref

engine = create_engine('sqlite:///coins.db', echo=False)
Base = declarative_base()
 
########################################################################
class Coin(Base):
    """"""
    __tablename__ = "coin"
 
    row_id = Column(Integer, primary_key=True)
    id = Column(String)
    name = Column(String)
    symbol = Column(String)
    
    #----------------------------------------------------------------------
    def __init__(self, id, name, symbol):
        """"""
        self.id = id
        self.name = name
        self.symbol = symbol

    def __repr__(self):
        return "<Coin id='" + str(self.id) + "'>" 

class CoinMarketPosition(Base):
    """"""
    __tablename__ = "coin_position"
 
    row_id = Column(Integer, primary_key=True)
    coin_id = Column(Integer, ForeignKey("coin.row_id"))
    date = Column(DateTime)
    total_volumes = Column(FLOAT)
    market_caps = Column(FLOAT)
    prices = Column(FLOAT)
    
    #----------------------------------------------------------------------
    def __init__(self, coin_id, date, total_volumes, market_caps, prices):
        """"""
        self.coin_id = coin_id
        self.date = date
        self.total_volumes = total_volumes
        self.market_caps = market_caps
        self.prices = prices

    def __repr__(self):
        return "<CoinMarketPosition coin='" + str(self.coin_id) +"' date='" + str(self.date) + "'>"

# create tables
Base.metadata.create_all(engine)