class TradePair(db.Model):
exchange = db.Column(db.String(30),
db.ForeignKey('exchange.id'),
primary_key=True,
nullable=False)
coin = db.Column(db.String(10),
db.ForeignKey('coin.id'),
primary_key=True,
nullable=False)
base_coin = db.Column(db.String(10),
db.ForeignKey('coin.id'),
primary_key=True,
nullable=False)
volume = db.Column(db.Float)
def __repr__(self):
return ("TradePair({} [{}/{}]: volume={})".format(
self.exchange, self.coin, self.base_coin, self.volume))
class Fee(db.Model):
exchange = db.Column(db.String(30),
db.ForeignKey('exchange.id'),
primary_key=True,
nullable=False)
action = db.Column(db.String(30), primary_key=True, nullable=False)
scope = db.Column(db.String(30), primary_key=True, nullable=False)
amount = db.Column(db.Float)
min_amount = db.Column(db.Float)
fee_coin = db.Column(db.String(10))
type = db.Column(db.String(10))
def __repr__(self):
return ("Fee({}-{}-{}: {})".format(self.exchange, self.action,
self.scope, self.amount))
from flask_security import UserMixin, RoleMixin
from crypto_exchange_path import db
# Define models
roles_users = db.Table(
'roles_users', db.Column('user_id', db.Integer(),
db.ForeignKey('user.id')),
db.Column('role_id', db.Integer(), db.ForeignKey('role.id')))
class Role(db.Model, RoleMixin):
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(80), unique=True)
description = db.Column(db.String(255))
def __str__(self):
return self.name
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80), unique=True)
email = db.Column(db.String(255), unique=True)
password = db.Column(db.String(255))
active = db.Column(db.Boolean())
confirmed_at = db.Column(db.DateTime())
roles = db.relationship('Role',
secondary=roles_users,
backref=db.backref('users', lazy='dynamic'))
def __str__(self):