Spaces:
Runtime error
Runtime error
File size: 1,859 Bytes
fa83799 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 | from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy()
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
phone = db.Column(db.String(20))
notification_prefs = db.Column(db.String(20), default='all')
portfolio_items = db.relationship('PortfolioItem', backref='user', lazy=True)
settings = db.relationship('UserSettings', backref='user', uselist=False)
class PortfolioItem(db.Model):
__tablename__ = 'portfolio_items'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
symbol = db.Column(db.String(20), nullable=False)
name = db.Column(db.String(100), nullable=False)
shares = db.Column(db.Float, nullable=False)
avg_price = db.Column(db.Float, nullable=False)
notes = db.Column(db.Text)
class UserSettings(db.Model):
__tablename__ = 'user_settings'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
price_alerts = db.Column(db.Boolean, default=True)
volume_alerts = db.Column(db.Boolean, default=True)
news_alerts = db.Column(db.Boolean, default=False)
alert_threshold = db.Column(db.Integer, default=5)
class Alert(db.Model):
__tablename__ = 'alerts'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
symbol = db.Column(db.String(20), nullable=False)
message = db.Column(db.String(255), nullable=False)
date = db.Column(db.DateTime, nullable=False)
severity = db.Column(db.String(20), nullable=False)
read = db.Column(db.Boolean, default=False) |