StockGuard / database /db_operations.py
Anant0712's picture
Rename backend/database/db_operations.py to database/db_operations.py
9f810dd verified
Raw History Blame Contribute Delete
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