from sqlalchemy import Column, String, Integer, DateTime, JSON
from sqlalchemy.sql import func
from .database import Base

class RequestLogDB(Base):
    __tablename__ = "request_logs"

    id = Column(Integer, primary_key=True, autoincrement=True)
    path = Column(String(200), nullable=False)
    method = Column(String(10), nullable=False)
    headers = Column(JSON)
    query_params = Column(JSON)
    body = Column(JSON, nullable=True)
    user_id = Column(Integer, nullable=True)
    ip_address = Column(String(50))
    status_code = Column(Integer)
    response_time = Column(Integer)  # 毫秒
    create_time = Column(DateTime(timezone=True), server_default=func.now())