models

models.py

from cryptolizzard.db.peewee import *

db = MySQLDatabase('cryptolizzard', user='clizzard', passwd='<pass>', host='192.168.0.2')
db.connect()

class BaseModel(Model):
  class Meta:
    database    = db

# Operational models
class Menu(BaseModel):
  link          = CharField()
  text          = CharField()

# Metrics related models
class Currency(BaseModel):
  symbol        = CharField()

class Exchange(BaseModel):
  name          = CharField()

class ExchangeEntry(BaseModel):
  currency      = ForeignKeyField(Currency)
  exchange      = ForeignKeyField(Exchange)
  datetime      = IntegerField()
  ask           = FloatField()
  bid           = FloatField()
  last          = FloatField()
  volume_btc    = FloatField()
  volume_total  = FloatField()