spool_assignment.py 2.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. from datetime import datetime
  2. from sqlalchemy import DateTime, ForeignKey, Integer, String, UniqueConstraint, func
  3. from sqlalchemy.orm import Mapped, mapped_column, relationship
  4. from backend.app.core.database import Base
  5. class SpoolAssignment(Base):
  6. """Assignment of a spool to a specific AMS slot on a printer."""
  7. __tablename__ = "spool_assignment"
  8. id: Mapped[int] = mapped_column(primary_key=True)
  9. spool_id: Mapped[int] = mapped_column(ForeignKey("spool.id", ondelete="CASCADE"))
  10. printer_id: Mapped[int] = mapped_column(ForeignKey("printers.id", ondelete="CASCADE"))
  11. ams_id: Mapped[int] = mapped_column(Integer) # 0-3, 128+ (HT), 254/255 (ext)
  12. tray_id: Mapped[int] = mapped_column(Integer) # 0-3
  13. fingerprint_color: Mapped[str | None] = mapped_column(String(8)) # tray_color snapshot
  14. fingerprint_type: Mapped[str | None] = mapped_column(String(50)) # tray_type snapshot
  15. # Who assigned it from the inventory route: the signed-in user, or an API
  16. # key's owner. The replay on insert resolves a custom cloud preset with this
  17. # user's cloud sign-in; it has none of its own (#3519).
  18. assigned_by_user_id: Mapped[int | None] = mapped_column(ForeignKey("users.id", ondelete="SET NULL"), nullable=True)
  19. created_at: Mapped[datetime] = mapped_column(DateTime, server_default=func.now())
  20. spool: Mapped["Spool"] = relationship(back_populates="assignments")
  21. printer: Mapped["Printer"] = relationship()
  22. __table_args__ = (UniqueConstraint("printer_id", "ams_id", "tray_id"),)
  23. @property
  24. def printer_name(self) -> str | None:
  25. """Get printer name from loaded relationship."""
  26. return self.printer.name if self.printer else None
  27. @property
  28. def printer_model(self) -> str | None:
  29. """Printer model from the loaded relationship (lets the UI label an H3C's per-hotend external inputs)."""
  30. return self.printer.model if self.printer else None
  31. from backend.app.models.printer import Printer # noqa: E402, F401
  32. from backend.app.models.spool import Spool # noqa: E402, F401