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