tech-updates / app /db /models.py
HFShishir's picture
Deploy BytePulse AI Backend v1.0
ef58e1a verified
Raw History Blame Contribute Delete
1.96 kB
from sqlalchemy import Column, Integer, String, Text, DateTime, ForeignKey, Float
from sqlalchemy.orm import relationship
from datetime import datetime
from app.db.database import Base
class DailyDigest(Base):
__tablename__ = "daily_digests"
id = Column(Integer, primary_key=True, index=True)
date_str = Column(String(50), unique=True, index=True) # e.g., "2026-07-22"
title = Column(String(255), nullable=False)
overall_summary = Column(Text, nullable=False)
top_highlights = Column(Text, nullable=True) # JSON or markdown string of top 3 highlights
created_at = Column(DateTime, default=datetime.utcnow)
items = relationship("DigestItem", back_populates="daily_digest", cascade="all, delete-orphan")
class DigestItem(Base):
__tablename__ = "digest_items"
id = Column(Integer, primary_key=True, index=True)
daily_digest_id = Column(Integer, ForeignKey("daily_digests.id"), nullable=True)
title = Column(String(500), nullable=False)
url = Column(String(1000), nullable=False)
source = Column(String(100), nullable=False) # HackerNews, TechCrunch, GitHub Trends
category = Column(String(100), default="Tech") # AI, Web, Security, Mobile, Open Source, etc.
summary = Column(Text, nullable=False)
key_takeaway = Column(Text, nullable=True)
importance_score = Column(Float, default=5.0)
published_at = Column(DateTime, default=datetime.utcnow)
created_at = Column(DateTime, default=datetime.utcnow)
daily_digest = relationship("DailyDigest", back_populates="items")
class DeviceToken(Base):
__tablename__ = "device_tokens"
id = Column(Integer, primary_key=True, index=True)
token = Column(String(500), unique=True, index=True, nullable=False)
device_type = Column(String(50), default="android") # android | ios
created_at = Column(DateTime, default=datetime.utcnow)
updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)