spoolbuddy.py 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730
  1. """SpoolBuddy device management API routes."""
  2. import asyncio
  3. import logging
  4. from datetime import datetime, timedelta, timezone
  5. from fastapi import APIRouter, Depends, HTTPException
  6. from sqlalchemy import select
  7. from sqlalchemy.ext.asyncio import AsyncSession
  8. from backend.app.core.auth import RequirePermissionIfAuthEnabled
  9. from backend.app.core.database import get_db
  10. from backend.app.core.permissions import Permission
  11. from backend.app.core.websocket import ws_manager
  12. from backend.app.models.spoolbuddy_device import SpoolBuddyDevice
  13. from backend.app.models.user import User
  14. from backend.app.schemas.spoolbuddy import (
  15. CalibrationResponse,
  16. DeviceRegisterRequest,
  17. DeviceResponse,
  18. DisplaySettingsRequest,
  19. HeartbeatRequest,
  20. HeartbeatResponse,
  21. ScaleReadingRequest,
  22. SetCalibrationFactorRequest,
  23. SetTareRequest,
  24. TagRemovedRequest,
  25. TagScannedRequest,
  26. UpdateSpoolWeightRequest,
  27. WriteTagRequest,
  28. WriteTagResultRequest,
  29. )
  30. from backend.app.services.spool_tag_matcher import get_spool_by_tag
  31. logger = logging.getLogger(__name__)
  32. router = APIRouter(prefix="/spoolbuddy", tags=["spoolbuddy"])
  33. OFFLINE_THRESHOLD_SECONDS = 30
  34. def _is_online(device: SpoolBuddyDevice) -> bool:
  35. if not device.last_seen:
  36. return False
  37. return (
  38. datetime.now(timezone.utc) - device.last_seen.replace(tzinfo=timezone.utc)
  39. ).total_seconds() < OFFLINE_THRESHOLD_SECONDS
  40. def _device_to_response(device: SpoolBuddyDevice) -> DeviceResponse:
  41. return DeviceResponse(
  42. id=device.id,
  43. device_id=device.device_id,
  44. hostname=device.hostname,
  45. ip_address=device.ip_address,
  46. firmware_version=device.firmware_version,
  47. has_nfc=device.has_nfc,
  48. has_scale=device.has_scale,
  49. tare_offset=device.tare_offset,
  50. calibration_factor=device.calibration_factor,
  51. nfc_reader_type=device.nfc_reader_type,
  52. nfc_connection=device.nfc_connection,
  53. display_brightness=device.display_brightness,
  54. display_blank_timeout=device.display_blank_timeout,
  55. has_backlight=device.has_backlight,
  56. last_calibrated_at=device.last_calibrated_at,
  57. last_seen=device.last_seen,
  58. pending_command=device.pending_command,
  59. nfc_ok=device.nfc_ok,
  60. scale_ok=device.scale_ok,
  61. uptime_s=device.uptime_s,
  62. update_status=device.update_status,
  63. update_message=device.update_message,
  64. online=_is_online(device),
  65. created_at=device.created_at,
  66. updated_at=device.updated_at,
  67. )
  68. # --- Device endpoints ---
  69. @router.post("/devices/register", response_model=DeviceResponse)
  70. async def register_device(
  71. req: DeviceRegisterRequest,
  72. db: AsyncSession = Depends(get_db),
  73. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_UPDATE),
  74. ):
  75. """Register or re-register a SpoolBuddy device."""
  76. result = await db.execute(select(SpoolBuddyDevice).where(SpoolBuddyDevice.device_id == req.device_id))
  77. device = result.scalar_one_or_none()
  78. now = datetime.now(timezone.utc)
  79. if device:
  80. device.hostname = req.hostname
  81. device.ip_address = req.ip_address
  82. device.firmware_version = req.firmware_version
  83. device.has_nfc = req.has_nfc
  84. device.has_scale = req.has_scale
  85. device.nfc_reader_type = req.nfc_reader_type
  86. device.nfc_connection = req.nfc_connection
  87. device.has_backlight = req.has_backlight
  88. device.last_seen = now
  89. logger.info("SpoolBuddy device re-registered: %s (%s)", req.device_id, req.hostname)
  90. else:
  91. device = SpoolBuddyDevice(
  92. device_id=req.device_id,
  93. hostname=req.hostname,
  94. ip_address=req.ip_address,
  95. firmware_version=req.firmware_version,
  96. has_nfc=req.has_nfc,
  97. has_scale=req.has_scale,
  98. tare_offset=req.tare_offset,
  99. calibration_factor=req.calibration_factor,
  100. nfc_reader_type=req.nfc_reader_type,
  101. nfc_connection=req.nfc_connection,
  102. has_backlight=req.has_backlight,
  103. last_seen=now,
  104. )
  105. db.add(device)
  106. logger.info("SpoolBuddy device registered: %s (%s)", req.device_id, req.hostname)
  107. await db.commit()
  108. await db.refresh(device)
  109. await ws_manager.broadcast(
  110. {
  111. "type": "spoolbuddy_online",
  112. "device_id": device.device_id,
  113. "hostname": device.hostname,
  114. }
  115. )
  116. response = _device_to_response(device)
  117. # Include SSH public key so the daemon can auto-deploy it
  118. try:
  119. from backend.app.services.spoolbuddy_ssh import get_public_key
  120. response.ssh_public_key = await get_public_key()
  121. except Exception:
  122. pass # Key not generated yet — daemon can still work without it
  123. return response
  124. @router.get("/devices", response_model=list[DeviceResponse])
  125. async def list_devices(
  126. db: AsyncSession = Depends(get_db),
  127. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_READ),
  128. ):
  129. """List all registered SpoolBuddy devices."""
  130. result = await db.execute(select(SpoolBuddyDevice).order_by(SpoolBuddyDevice.hostname))
  131. devices = list(result.scalars().all())
  132. return [_device_to_response(d) for d in devices]
  133. @router.post("/devices/{device_id}/heartbeat", response_model=HeartbeatResponse)
  134. async def device_heartbeat(
  135. device_id: str,
  136. req: HeartbeatRequest,
  137. db: AsyncSession = Depends(get_db),
  138. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_UPDATE),
  139. ):
  140. """Daemon heartbeat — updates status and returns pending commands."""
  141. result = await db.execute(select(SpoolBuddyDevice).where(SpoolBuddyDevice.device_id == device_id))
  142. device = result.scalar_one_or_none()
  143. if not device:
  144. raise HTTPException(status_code=404, detail="Device not registered")
  145. was_offline = not _is_online(device)
  146. now = datetime.now(timezone.utc)
  147. device.last_seen = now
  148. device.nfc_ok = req.nfc_ok
  149. device.scale_ok = req.scale_ok
  150. device.uptime_s = req.uptime_s
  151. if req.firmware_version:
  152. device.firmware_version = req.firmware_version
  153. if req.ip_address:
  154. device.ip_address = req.ip_address
  155. if req.nfc_reader_type:
  156. device.nfc_reader_type = req.nfc_reader_type
  157. if req.nfc_connection:
  158. device.nfc_connection = req.nfc_connection
  159. # Return and clear pending command
  160. pending = device.pending_command
  161. pending_write = None
  162. if pending == "write_tag" and device.pending_write_payload:
  163. # Parse the stored JSON payload to include in response
  164. import json
  165. try:
  166. pending_write = json.loads(device.pending_write_payload)
  167. except (json.JSONDecodeError, TypeError):
  168. pending_write = None
  169. # Don't clear write_tag command — it gets cleared by write-result
  170. else:
  171. device.pending_command = None
  172. await db.commit()
  173. if was_offline:
  174. await ws_manager.broadcast(
  175. {
  176. "type": "spoolbuddy_online",
  177. "device_id": device.device_id,
  178. "hostname": device.hostname,
  179. }
  180. )
  181. return HeartbeatResponse(
  182. pending_command=pending,
  183. pending_write_payload=pending_write,
  184. tare_offset=device.tare_offset,
  185. calibration_factor=device.calibration_factor,
  186. display_brightness=device.display_brightness,
  187. display_blank_timeout=device.display_blank_timeout,
  188. )
  189. # --- NFC endpoints ---
  190. @router.post("/nfc/tag-scanned")
  191. async def nfc_tag_scanned(
  192. req: TagScannedRequest,
  193. db: AsyncSession = Depends(get_db),
  194. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_UPDATE),
  195. ):
  196. """RPi reports NFC tag detected — lookup spool and broadcast."""
  197. spool = await get_spool_by_tag(db, req.tag_uid, req.tray_uuid or "")
  198. if spool:
  199. await ws_manager.broadcast(
  200. {
  201. "type": "spoolbuddy_tag_matched",
  202. "device_id": req.device_id,
  203. "tag_uid": req.tag_uid,
  204. "spool": {
  205. "id": spool.id,
  206. "material": spool.material,
  207. "subtype": spool.subtype,
  208. "color_name": spool.color_name,
  209. "rgba": spool.rgba,
  210. "brand": spool.brand,
  211. "label_weight": spool.label_weight,
  212. "core_weight": spool.core_weight,
  213. "weight_used": spool.weight_used,
  214. },
  215. }
  216. )
  217. logger.info("SpoolBuddy tag matched: %s -> spool %d", req.tag_uid, spool.id)
  218. else:
  219. await ws_manager.broadcast(
  220. {
  221. "type": "spoolbuddy_unknown_tag",
  222. "device_id": req.device_id,
  223. "tag_uid": req.tag_uid,
  224. "sak": req.sak,
  225. "tag_type": req.tag_type,
  226. }
  227. )
  228. logger.info("SpoolBuddy unknown tag: %s", req.tag_uid)
  229. return {"status": "ok", "matched": spool is not None, "spool_id": spool.id if spool else None}
  230. @router.post("/nfc/tag-removed")
  231. async def nfc_tag_removed(
  232. req: TagRemovedRequest,
  233. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_UPDATE),
  234. ):
  235. """RPi reports NFC tag removed — broadcast event."""
  236. await ws_manager.broadcast(
  237. {
  238. "type": "spoolbuddy_tag_removed",
  239. "device_id": req.device_id,
  240. "tag_uid": req.tag_uid,
  241. }
  242. )
  243. return {"status": "ok"}
  244. @router.post("/nfc/write-tag")
  245. async def nfc_write_tag(
  246. req: WriteTagRequest,
  247. db: AsyncSession = Depends(get_db),
  248. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_UPDATE),
  249. ):
  250. """Queue an NFC tag write command for a SpoolBuddy device."""
  251. import json
  252. from backend.app.models.spool import Spool
  253. from backend.app.services.opentag3d import encode_opentag3d
  254. # Find the spool
  255. result = await db.execute(select(Spool).where(Spool.id == req.spool_id))
  256. spool = result.scalar_one_or_none()
  257. if not spool:
  258. raise HTTPException(status_code=404, detail="Spool not found")
  259. # Find the device
  260. result = await db.execute(select(SpoolBuddyDevice).where(SpoolBuddyDevice.device_id == req.device_id))
  261. device = result.scalar_one_or_none()
  262. if not device:
  263. raise HTTPException(status_code=404, detail="Device not registered")
  264. # Encode OpenTag3D NDEF data
  265. ndef_data = encode_opentag3d(spool)
  266. # Store write payload and set pending command
  267. device.pending_write_payload = json.dumps(
  268. {
  269. "spool_id": spool.id,
  270. "ndef_data_hex": ndef_data.hex(),
  271. }
  272. )
  273. device.pending_command = "write_tag"
  274. await db.commit()
  275. logger.info("Write tag queued for device %s, spool %d (%d bytes)", req.device_id, spool.id, len(ndef_data))
  276. return {"status": "queued"}
  277. @router.post("/nfc/write-result")
  278. async def nfc_write_result(
  279. req: WriteTagResultRequest,
  280. db: AsyncSession = Depends(get_db),
  281. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_UPDATE),
  282. ):
  283. """Handle NFC tag write result from SpoolBuddy daemon."""
  284. # Find the device and clear pending state
  285. result = await db.execute(select(SpoolBuddyDevice).where(SpoolBuddyDevice.device_id == req.device_id))
  286. device = result.scalar_one_or_none()
  287. if not device:
  288. raise HTTPException(status_code=404, detail="Device not registered")
  289. device.pending_command = None
  290. device.pending_write_payload = None
  291. if req.success:
  292. # Link the tag to the spool
  293. from backend.app.models.spool import Spool
  294. result = await db.execute(select(Spool).where(Spool.id == req.spool_id))
  295. spool = result.scalar_one_or_none()
  296. if spool:
  297. spool.tag_uid = req.tag_uid.upper()
  298. spool.tag_type = "ntag"
  299. spool.data_origin = "opentag3d"
  300. spool.encode_time = datetime.now(timezone.utc)
  301. logger.info("Tag written and linked: spool %d -> tag %s", spool.id, req.tag_uid)
  302. await db.commit()
  303. await ws_manager.broadcast(
  304. {
  305. "type": "spoolbuddy_tag_written",
  306. "device_id": req.device_id,
  307. "spool_id": req.spool_id,
  308. "tag_uid": req.tag_uid,
  309. }
  310. )
  311. else:
  312. await db.commit()
  313. await ws_manager.broadcast(
  314. {
  315. "type": "spoolbuddy_tag_write_failed",
  316. "device_id": req.device_id,
  317. "spool_id": req.spool_id,
  318. "message": req.message,
  319. }
  320. )
  321. logger.warning("Tag write failed for device %s: %s", req.device_id, req.message)
  322. return {"status": "ok"}
  323. @router.post("/devices/{device_id}/cancel-write")
  324. async def cancel_write(
  325. device_id: str,
  326. db: AsyncSession = Depends(get_db),
  327. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_UPDATE),
  328. ):
  329. """Cancel a pending write-tag command."""
  330. result = await db.execute(select(SpoolBuddyDevice).where(SpoolBuddyDevice.device_id == device_id))
  331. device = result.scalar_one_or_none()
  332. if not device:
  333. raise HTTPException(status_code=404, detail="Device not registered")
  334. if device.pending_command == "write_tag":
  335. device.pending_command = None
  336. device.pending_write_payload = None
  337. await db.commit()
  338. logger.info("Write tag cancelled for device %s", device_id)
  339. return {"status": "ok"}
  340. # --- Scale endpoints ---
  341. @router.post("/scale/reading")
  342. async def scale_reading(
  343. req: ScaleReadingRequest,
  344. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_UPDATE),
  345. ):
  346. """RPi reports scale weight — broadcast to all clients."""
  347. await ws_manager.broadcast(
  348. {
  349. "type": "spoolbuddy_weight",
  350. "device_id": req.device_id,
  351. "weight_grams": req.weight_grams,
  352. "stable": req.stable,
  353. "raw_adc": req.raw_adc,
  354. }
  355. )
  356. return {"status": "ok"}
  357. @router.post("/scale/update-spool-weight")
  358. async def update_spool_weight(
  359. req: UpdateSpoolWeightRequest,
  360. db: AsyncSession = Depends(get_db),
  361. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_UPDATE),
  362. ):
  363. """Update spool's used weight from scale reading."""
  364. from backend.app.models.spool import Spool
  365. result = await db.execute(select(Spool).where(Spool.id == req.spool_id))
  366. spool = result.scalar_one_or_none()
  367. if not spool:
  368. raise HTTPException(status_code=404, detail="Spool not found")
  369. # net weight = total on scale minus empty spool core
  370. net_filament = max(0, req.weight_grams - spool.core_weight)
  371. spool.weight_used = max(0, spool.label_weight - net_filament)
  372. spool.last_scale_weight = req.weight_grams
  373. spool.last_weighed_at = datetime.now(timezone.utc)
  374. await db.commit()
  375. logger.info(
  376. "SpoolBuddy updated spool %d weight: %.1fg on scale, %.1fg used",
  377. spool.id,
  378. req.weight_grams,
  379. spool.weight_used,
  380. )
  381. return {"status": "ok", "weight_used": spool.weight_used}
  382. # --- Calibration endpoints ---
  383. @router.post("/devices/{device_id}/calibration/tare")
  384. async def tare_scale(
  385. device_id: str,
  386. db: AsyncSession = Depends(get_db),
  387. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_UPDATE),
  388. ):
  389. """Set pending tare command for the device to pick up."""
  390. result = await db.execute(select(SpoolBuddyDevice).where(SpoolBuddyDevice.device_id == device_id))
  391. device = result.scalar_one_or_none()
  392. if not device:
  393. raise HTTPException(status_code=404, detail="Device not registered")
  394. device.pending_command = "tare"
  395. await db.commit()
  396. return {"status": "ok", "message": "Tare command queued"}
  397. @router.post("/devices/{device_id}/calibration/set-tare")
  398. async def set_tare_offset(
  399. device_id: str,
  400. req: SetTareRequest,
  401. db: AsyncSession = Depends(get_db),
  402. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_UPDATE),
  403. ):
  404. """Store tare offset reported by the daemon after executing a tare."""
  405. result = await db.execute(select(SpoolBuddyDevice).where(SpoolBuddyDevice.device_id == device_id))
  406. device = result.scalar_one_or_none()
  407. if not device:
  408. raise HTTPException(status_code=404, detail="Device not registered")
  409. device.tare_offset = req.tare_offset
  410. device.last_calibrated_at = datetime.now(timezone.utc)
  411. await db.commit()
  412. logger.info("SpoolBuddy %s tare offset set to %d", device_id, req.tare_offset)
  413. return CalibrationResponse(
  414. tare_offset=device.tare_offset,
  415. calibration_factor=device.calibration_factor,
  416. )
  417. @router.post("/devices/{device_id}/calibration/set-factor")
  418. async def set_calibration_factor(
  419. device_id: str,
  420. req: SetCalibrationFactorRequest,
  421. db: AsyncSession = Depends(get_db),
  422. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_UPDATE),
  423. ):
  424. """Calculate and store calibration factor from a known weight."""
  425. result = await db.execute(select(SpoolBuddyDevice).where(SpoolBuddyDevice.device_id == device_id))
  426. device = result.scalar_one_or_none()
  427. if not device:
  428. raise HTTPException(status_code=404, detail="Device not registered")
  429. tare = req.tare_raw_adc if req.tare_raw_adc is not None else device.tare_offset
  430. raw_delta = req.raw_adc - tare
  431. if raw_delta == 0:
  432. raise HTTPException(status_code=400, detail="Raw ADC value equals tare offset — place weight on scale")
  433. device.calibration_factor = req.known_weight_grams / raw_delta
  434. if req.tare_raw_adc is not None:
  435. device.tare_offset = tare
  436. device.last_calibrated_at = datetime.now(timezone.utc)
  437. await db.commit()
  438. logger.info(
  439. "SpoolBuddy %s calibration factor set to %.6f (known=%.1fg, raw=%d, tare=%d)",
  440. device_id,
  441. device.calibration_factor,
  442. req.known_weight_grams,
  443. req.raw_adc,
  444. tare,
  445. )
  446. return CalibrationResponse(
  447. tare_offset=device.tare_offset,
  448. calibration_factor=device.calibration_factor,
  449. )
  450. @router.get("/devices/{device_id}/calibration", response_model=CalibrationResponse)
  451. async def get_calibration(
  452. device_id: str,
  453. db: AsyncSession = Depends(get_db),
  454. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_READ),
  455. ):
  456. """Get current calibration values for a device."""
  457. result = await db.execute(select(SpoolBuddyDevice).where(SpoolBuddyDevice.device_id == device_id))
  458. device = result.scalar_one_or_none()
  459. if not device:
  460. raise HTTPException(status_code=404, detail="Device not registered")
  461. return CalibrationResponse(
  462. tare_offset=device.tare_offset,
  463. calibration_factor=device.calibration_factor,
  464. )
  465. # --- Display settings ---
  466. @router.put("/devices/{device_id}/display")
  467. async def update_display_settings(
  468. device_id: str,
  469. req: DisplaySettingsRequest,
  470. db: AsyncSession = Depends(get_db),
  471. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_UPDATE),
  472. ):
  473. """Update display brightness and screen blank timeout for a device."""
  474. result = await db.execute(select(SpoolBuddyDevice).where(SpoolBuddyDevice.device_id == device_id))
  475. device = result.scalar_one_or_none()
  476. if not device:
  477. raise HTTPException(status_code=404, detail="Device not registered")
  478. device.display_brightness = req.brightness
  479. device.display_blank_timeout = req.blank_timeout
  480. await db.commit()
  481. logger.info(
  482. "SpoolBuddy %s display updated: brightness=%d%%, blank_timeout=%ds",
  483. device_id,
  484. req.brightness,
  485. req.blank_timeout,
  486. )
  487. return {"status": "ok", "brightness": req.brightness, "blank_timeout": req.blank_timeout}
  488. # --- Update check ---
  489. @router.get("/devices/{device_id}/update-check")
  490. async def check_daemon_update(
  491. device_id: str,
  492. db: AsyncSession = Depends(get_db),
  493. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_READ),
  494. ):
  495. """Check if the SpoolBuddy daemon needs updating to match the Bambuddy backend version."""
  496. from backend.app.api.routes.updates import is_newer_version
  497. from backend.app.core.config import APP_VERSION
  498. result = await db.execute(select(SpoolBuddyDevice).where(SpoolBuddyDevice.device_id == device_id))
  499. device = result.scalar_one_or_none()
  500. if not device:
  501. raise HTTPException(status_code=404, detail="Device not registered")
  502. current = device.firmware_version or "0.0.0"
  503. return {
  504. "current_version": current,
  505. "latest_version": APP_VERSION,
  506. "update_available": is_newer_version(APP_VERSION, current),
  507. }
  508. @router.post("/devices/{device_id}/update")
  509. async def trigger_daemon_update(
  510. device_id: str,
  511. req: dict | None = None,
  512. db: AsyncSession = Depends(get_db),
  513. _: User | None = RequirePermissionIfAuthEnabled(Permission.SETTINGS_UPDATE),
  514. ):
  515. """Trigger a SpoolBuddy update over SSH.
  516. Bambuddy SSHes into the device, pulls the matching branch, installs deps,
  517. and restarts the daemon. Progress is broadcast via WebSocket.
  518. """
  519. from backend.app.services.spoolbuddy_ssh import perform_ssh_update
  520. result = await db.execute(select(SpoolBuddyDevice).where(SpoolBuddyDevice.device_id == device_id))
  521. device = result.scalar_one_or_none()
  522. if not device:
  523. raise HTTPException(status_code=404, detail="Device not registered")
  524. if not _is_online(device):
  525. raise HTTPException(status_code=409, detail="Device is offline")
  526. if device.update_status == "updating":
  527. return {"status": "already_updating", "message": "Update already in progress"}
  528. device.update_status = "pending"
  529. device.update_message = "Starting SSH update..."
  530. await db.commit()
  531. logger.info("SpoolBuddy %s: SSH update triggered (ip=%s)", device_id, device.ip_address)
  532. await ws_manager.broadcast(
  533. {
  534. "type": "spoolbuddy_update",
  535. "device_id": device_id,
  536. "update_status": "pending",
  537. }
  538. )
  539. # Run the SSH update in the background
  540. asyncio.create_task(perform_ssh_update(device_id, device.ip_address))
  541. return {"status": "ok", "message": "SSH update started"}
  542. @router.get("/ssh/public-key")
  543. async def get_ssh_public_key(
  544. _: User | None = RequirePermissionIfAuthEnabled(Permission.SETTINGS_READ),
  545. ):
  546. """Return the SSH public key for SpoolBuddy pairing."""
  547. from backend.app.services.spoolbuddy_ssh import get_public_key
  548. try:
  549. key = await get_public_key()
  550. return {"public_key": key}
  551. except Exception as e:
  552. raise HTTPException(status_code=500, detail=f"Failed to get SSH key: {e}") from e
  553. @router.post("/devices/{device_id}/update-status")
  554. async def report_update_status(
  555. device_id: str,
  556. req: dict,
  557. db: AsyncSession = Depends(get_db),
  558. _: User | None = RequirePermissionIfAuthEnabled(Permission.INVENTORY_UPDATE),
  559. ):
  560. """Daemon reports update progress back to the backend."""
  561. result = await db.execute(select(SpoolBuddyDevice).where(SpoolBuddyDevice.device_id == device_id))
  562. device = result.scalar_one_or_none()
  563. if not device:
  564. raise HTTPException(status_code=404, detail="Device not registered")
  565. status = req.get("status", "")
  566. message = req.get("message", "")
  567. if status in ("updating", "complete", "error"):
  568. device.update_status = status
  569. device.update_message = message[:255] if message else None
  570. if status == "complete":
  571. device.pending_command = None
  572. await db.commit()
  573. logger.info("SpoolBuddy %s: update status=%s msg=%s", device_id, status, message)
  574. await ws_manager.broadcast(
  575. {
  576. "type": "spoolbuddy_update",
  577. "device_id": device_id,
  578. "update_status": status,
  579. "update_message": message,
  580. }
  581. )
  582. return {"status": "ok"}
  583. # --- Background watchdog ---
  584. async def spoolbuddy_watchdog():
  585. """Check for devices that have gone offline (no heartbeat for 30s).
  586. Called periodically from the main app's background task loop.
  587. """
  588. from backend.app.core.database import async_session
  589. async with async_session() as db:
  590. result = await db.execute(select(SpoolBuddyDevice).where(SpoolBuddyDevice.last_seen.isnot(None)))
  591. devices = list(result.scalars().all())
  592. threshold = datetime.now(timezone.utc) - timedelta(seconds=OFFLINE_THRESHOLD_SECONDS)
  593. for device in devices:
  594. last_seen = device.last_seen.replace(tzinfo=timezone.utc) if device.last_seen else None
  595. if last_seen and last_seen < threshold:
  596. # Only broadcast once — clear last_seen after marking offline
  597. await ws_manager.broadcast(
  598. {
  599. "type": "spoolbuddy_offline",
  600. "device_id": device.device_id,
  601. }
  602. )
  603. device.last_seen = None
  604. logger.info("SpoolBuddy device offline: %s", device.device_id)
  605. await db.commit()