app/models/api_usage.py

from sqlalchemy import Column, Integer, String, Date, DateTime, func
from app.database import Base


class ApiUsage(Base):
    __tablename__ = "api_usage"

    id = Column(Integer, primary_key=True, autoincrement=True)
    service = Column(String(100), nullable=False)  # huggingface, nvidia, gemini, edge_tts
    endpoint = Column(String(500), nullable=True)
    request_count = Column(Integer, default=1)
    date = Column(Date, nullable=False)
    created_at = Column(DateTime, server_default=func.now())