models/Post.py

from sqlalchemy import Column, Integer, String, DateTime, Float
from db.database import Base
import datetime

class Post(Base):
    __tablename__ = "posts"

    id = Column(Integer, primary_key=True)
    title = Column(String)
    slug = Column(String, unique=True)
    excerpt = Column(String)
    content = Column(String)
    thumbnail_url = Column(String, nullable=True)   # ✅ Optional thumbnail
    product_url = Column(String, nullable=True)     # ✅ Product link (Amazon, etc.)
    image_urls = Column(String, nullable=True)      # ✅ Comma-separated image URLs
    published_at = Column(DateTime, default=datetime.datetime.utcnow)
    tags = Column(String, nullable=True)            # ✅ Comma-separated tags
    rating = Column(Float, nullable=True)           # ✅ ⭐ New: e.g. 4.4
    repeat_purchases = Column(String, nullable=True)  # ✅ New: e.g. "2K+ bought again"