Spaces:
Runtime error
Runtime error
Download database/db_operations.py from Anant0712/StockGuard: direct link, hf CLI and curl.
- Browser
- Download file 2.46 kB
-
https://huggingface.co/spaces/Anant0712/StockGuard/resolve/main/database/db_operations.py
- Command line
-
hf download hf://spaces/Anant0712/StockGuard/database/db_operations.py
-
curl -L -o db_operations.py https://huggingface.co/spaces/Anant0712/StockGuard/resolve/main/database/db_operations.py
2.46 kB
| from datetime import datetime | |
| from .models import db, User, PortfolioItem, UserSettings, Alert | |
| def get_user_portfolio(user_id): | |
| items = PortfolioItem.query.filter_by(user_id=user_id).all() | |
| return [{ | |
| 'id': item.id, | |
| 'symbol': item.symbol, | |
| 'name': item.name, | |
| 'shares': item.shares, | |
| 'avg_price': item.avg_price, | |
| 'notes': item.notes | |
| } for item in items] | |
| def add_stock_to_portfolio(user_id, symbol, name, shares, avg_price): | |
| item = PortfolioItem( | |
| user_id=user_id, | |
| symbol=symbol, | |
| name=name, | |
| shares=shares, | |
| avg_price=avg_price | |
| ) | |
| db.session.add(item) | |
| db.session.commit() | |
| return item | |
| def get_user_settings(user_id): | |
| settings = UserSettings.query.filter_by(user_id=user_id).first() | |
| if not settings: | |
| # Create default settings if none exist | |
| settings = UserSettings(user_id=user_id) | |
| db.session.add(settings) | |
| db.session.commit() | |
| return { | |
| 'price_alerts': settings.price_alerts, | |
| 'volume_alerts': settings.volume_alerts, | |
| 'news_alerts': settings.news_alerts, | |
| 'alert_threshold': settings.alert_threshold | |
| } | |
| def update_user_settings(user_id, new_settings): | |
| settings = UserSettings.query.filter_by(user_id=user_id).first() | |
| if not settings: | |
| settings = UserSettings(user_id=user_id) | |
| settings.price_alerts = new_settings.get('price_alerts', settings.price_alerts) | |
| settings.volume_alerts = new_settings.get('volume_alerts', settings.volume_alerts) | |
| settings.news_alerts = new_settings.get('news_alerts', settings.news_alerts) | |
| settings.alert_threshold = new_settings.get('alert_threshold', settings.alert_threshold) | |
| db.session.add(settings) | |
| db.session.commit() | |
| return settings | |
| def get_user_alerts(user_id, limit=10): | |
| alerts = Alert.query.filter_by(user_id=user_id).order_by(Alert.date.desc()).limit(limit).all() | |
| return [{ | |
| 'id': alert.id, | |
| 'symbol': alert.symbol, | |
| 'message': alert.message, | |
| 'date': alert.date.isoformat(), | |
| 'severity': alert.severity, | |
| 'read': alert.read | |
| } for alert in alerts] | |
| def create_alert(user_id, symbol, message, severity='medium'): | |
| alert = Alert( | |
| user_id=user_id, | |
| symbol=symbol, | |
| message=message, | |
| date=datetime.now(), | |
| severity=severity | |
| ) | |
| db.session.add(alert) | |
| db.session.commit() | |
| return alert |