Spaces:
Sleeping
Sleeping
Download app/db/models.py from HFShishir/tech-updates: direct link, hf CLI and curl.
- Browser
- Download file 1.96 kB
-
https://huggingface.co/spaces/HFShishir/tech-updates/resolve/main/app/db/models.py
- Command line
-
hf download hf://spaces/HFShishir/tech-updates/app/db/models.py
-
curl -L -o models.py https://huggingface.co/spaces/HFShishir/tech-updates/resolve/main/app/db/models.py
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) | |