from sqlalchemy import Column, BigInteger, DateTime, String, Float, func
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class PerformanceData(Base):
    __tablename__ = 'performance_data'

    id = Column(BigInteger, primary_key=True, autoincrement=True)
    record_time = Column(DateTime, nullable=False, server_default=func.now(), comment='记录时间')
    endpoint = Column(String(255), nullable=True, comment='请求接口路径')
    elapsed_time = Column(Float, nullable=False, comment='总耗时（秒）')
    cpu_user = Column(Float, nullable=False, comment='用户态 CPU 时间差（秒）')
    cpu_system = Column(Float, nullable=False, comment='系统态 CPU 时间差（秒）')
    memory_rss = Column(BigInteger, nullable=False, comment='RSS 内存增量（字节）')