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