class StockRecall(db.Model):
id = db.Column(db.Integer, primary_key=True)
createDate = db.Column(db.Date, index=True)
stockName = db.Column(db.Integer)
stockPrice = db.Column(db.String(60))
remark = db.Column(db.String(140))
recallDate = db.Column(db.String(200))
class Predict(db.Model):
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.Date, index=True)
sectorId = db.Column(db.Integer)
sectorName = db.Column(db.String(60))
fever = db.Column(db.Integer)
remark = db.Column(db.String(140))
class ReplaySectorFever(PaginatedAPIMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.Date, index=True)
sectorId = db.Column(db.Integer)
sectorName = db.Column(db.String(60))
fever = db.Column(db.Integer)
remark = db.Column(db.String(140))
def __init__(self,
date=None,
sectorId=None,
sectorName=None,
fever=None,
remark=None):
self.date = date
self.sectorId = sectorId
self.sectorName = sectorName
self.fever = fever
self.remark = remark
def from_dict(self, data):
for field in ['date', 'sectorId', 'sectorName', 'fever', 'remark']:
if field in data:
setattr(self, field, data[field])
def to_dict(self):
data = {
'id': self.id,
'date': self.date,
'sectorId': self.sectorId,
'sectorName': self.sectorName,
'fever': self.fever,
'remark': self.remark,
}
return data
class SelectModel(PaginatedAPIMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
modelName = db.Column(db.String(60))
modelDescription = db.Column(db.String(1200))
createTime = db.Column(db.DateTime, default=datetime.utcnow)
updateTime = db.Column(db.DateTime, default=datetime.utcnow)
def from_dict(self, data):
for field in ['modelName', 'modelDescription']:
if field in data:
setattr(self, field, data[field])
def to_dict(self):
data = {
'id': self.id,
'modelName': self.modelName,
'modelDescription': self.modelDescription,
'createTime': self.createTime,
'updateTime': self.updateTime,
}
return data
class Stock(db.Model):
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.Date, index=True, unique=True)
stockName = db.Column(db.String(60))
stockProce = db.Column(db.Float)
remark = db.Column(db.String(140))
def __init__(self,
date=None,
stockName=None,
stockPrice=None,
remark=None):
self.date = date
self.stockName = stockName
self.stockProce = stockPrice
self.remark = remark
def from_dict(self, data):
for field in ['date', 'stockName', 'stockPrice', 'remark']:
if field in data:
setattr(self, field, data[field])
class Sector(PaginatedAPIMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
sectorName = db.Column(db.String(60), index=True, unique=True)
stocks = db.Column(db.String(240))
description = db.Column(db.String(240))
def __init__(self, sectorName=None, stocks=None, description=None):
self.sectorName = sectorName
self.stocks = stocks
self.description = description
def from_dict(self, data):
for field in ['sectorName', 'stocks', 'description']:
if field in data:
setattr(self, field, data[field])
def to_dict(self):
data = {
'id': self.id,
'sectorName': self.sectorName,
'stocks': self.stocks,
'description': self.description,
}
return data
class Replay(PaginatedAPIMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.Date, index=True, unique=True)
limitUp = db.Column(db.Integer)
limitDown = db.Column(db.Integer)
marketFever = db.Column(db.Integer)
summary = db.Column(db.String(120))
def __init__(self, date=None, summary=None):
self.date = date
self.summary = summary
def from_dict(self, data):
for field in [
'date', 'summary', 'limitUp', 'limitDown', 'marketFever'
]:
if field in data:
setattr(self, field, data[field])
def to_dict(self):
data = {
'id': self.id,
'date': self.date,
'summary': self.summary,
'limitUp': self.limitUp,
'limitDown': self.limitDown,
'marketFever': self.marketFever,
}
return data
# def from_dict(self, data, new_user=False):
# for field in ['username', 'email', 'about_me']:
# if field in data:
# setattr(self, field, data[field])
# if new_user and 'password' in data:
# self.set_password(data['password']
def __repr__(self):
return '<Replay {}>'.format(self.date)