class Favourites(db.Model, UserMixin):
__tablename__ = 'Favourites'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer)
stock_name = db.Column(db.String, db.ForeignKey(Stocks.stockName))
def __repr__(self):
return f"Favourites('{self.user_id}', '{self.stock_name}')"
class User(db.Model, UserMixin):
__tablename__ = 'User'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(30), nullable=False)
password = db.Column(db.String(128), unique=False, nullable=False)
def __repr__(self):
return f"User('{self.id}', '{self.name}', '{self.password}')"
class News(db.Model, UserMixin):
__tablename__ = 'News'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String)
newsURL = db.Column(db.String)
text = db.Column(db.String)
title = db.Column(db.String)
def __repr__(self):
return f"News('{self.id}', '{self.name}', {self.newsURL}', '{self.text}', '{self.title}')"
class Stocks(db.Model, UserMixin):
__tablename__ = 'Stocks'
id = db.Column(db.Integer, primary_key=True)
stockName = db.Column(db.String, nullable=False)
stockID = db.Column(db.String, nullable=False)
openPrice = db.Column(db.Integer, unique=False, nullable=False)
wtAvgPrice = db.Column(db.Integer, unique=False, nullable=False)
highPrice = db.Column(db.Integer, unique=False, nullable=False)
lowPrice = db.Column(db.Integer, unique=False, nullable=False)
closePrice = db.Column(db.Integer, unique=False, nullable=False)
def __repr__(self):
return f"Stocks('{self.stockName}', '{self.stockID}', {self.openPrice}', '{self.wtAvgPrice}', '{self.highPrice}', '{self.lowPrice}', '{self.closePrice}')"
class PDFModel(db.Model):
id = db.Column(db.Integer, primary_key=True)
resultID = db.Column(db.String(
36)) #the unique id i generate in React is 36 characters long
file = db.Column(db.LargeBinary)