bambuddy/backend/app/models/ams_history.py

from datetime import datetime
from sqlalchemy import Integer, Float, DateTime, ForeignKey, String, func, Index
from sqlalchemy.orm import Mapped, mapped_column, relationship

from backend.app.core.database import Base


class AMSSensorHistory(Base):
    """Historical sensor data from AMS units (humidity and temperature)."""
    __tablename__ = "ams_sensor_history"

    id: Mapped[int] = mapped_column(primary_key=True)
    printer_id: Mapped[int] = mapped_column(ForeignKey("printers.id", ondelete="CASCADE"))
    ams_id: Mapped[int] = mapped_column(Integer)  # AMS unit index (0, 1, 2, 3)
    humidity: Mapped[float | None] = mapped_column(Float)  # Humidity percentage
    humidity_raw: Mapped[float | None] = mapped_column(Float)  # Raw humidity value
    temperature: Mapped[float | None] = mapped_column(Float)  # Temperature in Celsius
    recorded_at: Mapped[datetime] = mapped_column(
        DateTime, server_default=func.now(), index=True
    )

    # Indexes for efficient querying
    __table_args__ = (
        Index('ix_ams_history_printer_ams_time', 'printer_id', 'ams_id', 'recorded_at'),
    )

    # Relationship
    printer: Mapped["Printer"] = relationship(back_populates="ams_history")


from backend.app.models.printer import Printer  # noqa: E402