Spaces:
Runtime error
Runtime error
Download database/models.py from Anant0712/StockGuard: direct link, hf CLI and curl.
- Browser
- Download file 1.86 kB
-
https://huggingface.co/spaces/Anant0712/StockGuard/resolve/main/database/models.py
- Command line
-
hf download hf://spaces/Anant0712/StockGuard/database/models.py
-
curl -L -o models.py https://huggingface.co/spaces/Anant0712/StockGuard/resolve/main/database/models.py
1.86 kB
| 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) |