Spaces:
Runtime error
Runtime error
File size: 2,463 Bytes
82500fd | 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 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 | 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 |