notification_service.py 53 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365
  1. """Notification service for sending push notifications via various providers."""
  2. import asyncio
  3. import json
  4. import logging
  5. import re
  6. import smtplib
  7. from datetime import datetime
  8. from email.mime.multipart import MIMEMultipart
  9. from email.mime.text import MIMEText
  10. from typing import Any
  11. from urllib.parse import quote
  12. import httpx
  13. from sqlalchemy import select
  14. from sqlalchemy.ext.asyncio import AsyncSession
  15. from backend.app.models.notification import NotificationDigestQueue, NotificationLog, NotificationProvider
  16. from backend.app.models.notification_template import NotificationTemplate
  17. logger = logging.getLogger(__name__)
  18. class NotificationService:
  19. """Service for sending notifications through various providers."""
  20. def __init__(self):
  21. self._http_client: httpx.AsyncClient | None = None
  22. self._template_cache: dict[str, NotificationTemplate] = {}
  23. self._digest_scheduler_task: asyncio.Task | None = None
  24. self._last_digest_check: str = "" # "HH:MM" to avoid duplicate checks
  25. async def _get_client(self) -> httpx.AsyncClient:
  26. """Get or create HTTP client."""
  27. if self._http_client is None or self._http_client.is_closed:
  28. self._http_client = httpx.AsyncClient(timeout=30.0)
  29. return self._http_client
  30. async def close(self):
  31. """Close HTTP client."""
  32. if self._http_client and not self._http_client.is_closed:
  33. await self._http_client.aclose()
  34. def _is_in_quiet_hours(self, provider: NotificationProvider) -> bool:
  35. """Check if current time is within provider's quiet hours."""
  36. if not provider.quiet_hours_enabled:
  37. return False
  38. if not provider.quiet_hours_start or not provider.quiet_hours_end:
  39. return False
  40. try:
  41. now = datetime.now()
  42. current_time = now.hour * 60 + now.minute
  43. start_parts = provider.quiet_hours_start.split(":")
  44. end_parts = provider.quiet_hours_end.split(":")
  45. start_minutes = int(start_parts[0]) * 60 + int(start_parts[1])
  46. end_minutes = int(end_parts[0]) * 60 + int(end_parts[1])
  47. # Handle overnight quiet hours (e.g., 22:00 to 07:00)
  48. if start_minutes > end_minutes:
  49. # Quiet hours span midnight
  50. return current_time >= start_minutes or current_time < end_minutes
  51. else:
  52. # Same day quiet hours
  53. return start_minutes <= current_time < end_minutes
  54. except (ValueError, TypeError, AttributeError):
  55. logger.warning("Invalid quiet hours format for provider %s", provider.name)
  56. return False
  57. async def _get_template(self, db: AsyncSession, event_type: str) -> NotificationTemplate | None:
  58. """Get a notification template by event type."""
  59. # Check cache first
  60. if event_type in self._template_cache:
  61. return self._template_cache[event_type]
  62. result = await db.execute(select(NotificationTemplate).where(NotificationTemplate.event_type == event_type))
  63. template = result.scalar_one_or_none()
  64. if template:
  65. self._template_cache[event_type] = template
  66. return template
  67. def _render_template(self, template_str: str, variables: dict[str, Any]) -> str:
  68. """Render a template string with variables. Missing variables become empty."""
  69. result = template_str
  70. for key, value in variables.items():
  71. result = result.replace("{" + key + "}", str(value) if value is not None else "")
  72. # Remove any remaining unreplaced placeholders
  73. result = re.sub(r"\{[a-z_]+\}", "", result)
  74. return result
  75. def _format_duration(self, seconds: int | None) -> str:
  76. """Format duration in seconds to human-readable string."""
  77. if seconds is None:
  78. return "Unknown"
  79. hours = seconds // 3600
  80. minutes = (seconds % 3600) // 60
  81. if hours > 0:
  82. return f"{hours}h {minutes}m"
  83. return f"{minutes}m"
  84. def _clean_filename(self, filename: str) -> str:
  85. """Extract filename and remove file extensions."""
  86. import os
  87. # Strip path prefix (e.g., /data/Metadata/plate_5.gcode -> plate_5.gcode)
  88. filename = os.path.basename(filename)
  89. # Remove common extensions
  90. if filename.endswith(".gcode.3mf"):
  91. return filename[:-10]
  92. elif filename.endswith(".gcode"):
  93. return filename[:-6]
  94. elif filename.endswith(".3mf"):
  95. return filename[:-4]
  96. return filename
  97. async def _build_message_from_template(
  98. self, db: AsyncSession, event_type: str, variables: dict[str, Any]
  99. ) -> tuple[str, str]:
  100. """Build notification title and body from template."""
  101. # Add common variables
  102. variables["timestamp"] = datetime.now().strftime("%Y-%m-%d %H:%M")
  103. variables["app_name"] = "Bambuddy"
  104. template = await self._get_template(db, event_type)
  105. if not template:
  106. # Fallback to simple message
  107. logger.warning("Template not found for event type: %s", event_type)
  108. return event_type.replace("_", " ").title(), str(variables)
  109. title = self._render_template(template.title_template, variables)
  110. body = self._render_template(template.body_template, variables)
  111. return title, body
  112. async def send_test_notification(
  113. self, provider_type: str, config: dict[str, Any], db: AsyncSession | None = None
  114. ) -> tuple[bool, str]:
  115. """Send a test notification to verify configuration."""
  116. if db:
  117. title, message = await self._build_message_from_template(db, "test", {})
  118. else:
  119. title = "Bambuddy Test"
  120. message = "This is a test notification. If you see this, notifications are working!"
  121. try:
  122. if provider_type == "callmebot":
  123. return await self._send_callmebot(config, f"{title}\n{message}")
  124. elif provider_type == "ntfy":
  125. return await self._send_ntfy(config, title, message)
  126. elif provider_type == "pushover":
  127. return await self._send_pushover(config, title, message)
  128. elif provider_type == "telegram":
  129. return await self._send_telegram(config, f"*{title}*\n{message}")
  130. elif provider_type == "email":
  131. return await self._send_email(config, title, message)
  132. elif provider_type == "discord":
  133. return await self._send_discord(config, title, message)
  134. elif provider_type == "webhook":
  135. return await self._send_webhook(config, title, message)
  136. else:
  137. return False, f"Unknown provider type: {provider_type}"
  138. except Exception as e:
  139. logger.exception("Error sending test notification via %s", provider_type)
  140. return False, str(e)
  141. async def _send_callmebot(self, config: dict, message: str) -> tuple[bool, str]:
  142. """Send notification via CallMeBot (WhatsApp)."""
  143. phone = config.get("phone", "").strip()
  144. apikey = config.get("apikey", "").strip()
  145. if not phone or not apikey:
  146. return False, "Phone number and API key are required"
  147. # URL encode the message
  148. encoded_message = quote(message)
  149. url = f"https://api.callmebot.com/whatsapp.php?phone={phone}&text={encoded_message}&apikey={apikey}"
  150. client = await self._get_client()
  151. response = await client.get(url)
  152. if response.status_code == 200:
  153. return True, "Message sent successfully"
  154. else:
  155. return False, f"HTTP {response.status_code}: {response.text[:200]}"
  156. async def _send_ntfy(
  157. self, config: dict, title: str, message: str, image_data: bytes | None = None
  158. ) -> tuple[bool, str]:
  159. """Send notification via ntfy."""
  160. server = config.get("server", "https://ntfy.sh").rstrip("/")
  161. topic = config.get("topic", "").strip()
  162. auth_token = config.get("auth_token", "").strip()
  163. if not topic:
  164. return False, "Topic is required"
  165. url = f"{server}/{topic}"
  166. headers = {"Title": title}
  167. if auth_token:
  168. headers["Authorization"] = f"Bearer {auth_token}"
  169. client = await self._get_client()
  170. if image_data:
  171. # ntfy supports image attachments via multipart form-data
  172. headers["Filename"] = "photo.jpg"
  173. headers["Message"] = message
  174. response = await client.put(url, content=image_data, headers=headers)
  175. else:
  176. response = await client.post(url, content=message, headers=headers)
  177. if response.status_code in (200, 204):
  178. return True, "Message sent successfully"
  179. else:
  180. return False, f"HTTP {response.status_code}: {response.text[:200]}"
  181. async def _send_pushover(
  182. self, config: dict, title: str, message: str, image_data: bytes | None = None
  183. ) -> tuple[bool, str]:
  184. """Send notification via Pushover.
  185. Args:
  186. config: Provider configuration with user_key, app_token, priority
  187. title: Notification title
  188. message: Notification body
  189. image_data: Optional JPEG image bytes to attach (max 2.5MB)
  190. """
  191. user_key = config.get("user_key", "").strip()
  192. app_token = config.get("app_token", "").strip()
  193. priority = config.get("priority", 0)
  194. if not user_key or not app_token:
  195. return False, "User key and app token are required"
  196. url = "https://api.pushover.net/1/messages.json"
  197. data = {
  198. "token": app_token,
  199. "user": user_key,
  200. "title": title,
  201. "message": message,
  202. "priority": priority,
  203. }
  204. client = await self._get_client()
  205. if image_data:
  206. # Pushover supports image attachments via multipart form-data
  207. files = {"attachment": ("photo.jpg", image_data, "image/jpeg")}
  208. response = await client.post(url, data=data, files=files)
  209. else:
  210. response = await client.post(url, data=data)
  211. if response.status_code == 200:
  212. return True, "Message sent successfully"
  213. else:
  214. try:
  215. error_data = response.json()
  216. errors = error_data.get("errors", [])
  217. return False, f"Pushover error: {', '.join(errors)}"
  218. except Exception:
  219. return False, f"HTTP {response.status_code}: {response.text[:200]}"
  220. async def _send_telegram(self, config: dict, message: str, image_data: bytes | None = None) -> tuple[bool, str]:
  221. """Send notification via Telegram bot."""
  222. bot_token = config.get("bot_token", "").strip()
  223. chat_id = config.get("chat_id", "").strip()
  224. if not bot_token or not chat_id:
  225. return False, "Bot token and chat ID are required"
  226. # Escape underscores in the message body so Telegram Markdown
  227. # parsing doesn't break on job names like "A1_plate_8" or error
  228. # codes like "0300_0001". The title is already wrapped in *bold*
  229. # markers, so only escape after the first newline.
  230. if "\n" in message:
  231. title_part, body_part = message.split("\n", 1)
  232. body_part = body_part.replace("_", "\\_")
  233. message = f"{title_part}\n{body_part}"
  234. client = await self._get_client()
  235. if image_data:
  236. # Use sendPhoto to attach the thumbnail with the caption
  237. url = f"https://api.telegram.org/bot{bot_token}/sendPhoto"
  238. response = await client.post(
  239. url,
  240. data={"chat_id": chat_id, "caption": message, "parse_mode": "Markdown"},
  241. files={"photo": ("photo.jpg", image_data, "image/jpeg")},
  242. )
  243. else:
  244. url = f"https://api.telegram.org/bot{bot_token}/sendMessage"
  245. data = {
  246. "chat_id": chat_id,
  247. "text": message,
  248. "parse_mode": "Markdown",
  249. }
  250. response = await client.post(url, json=data)
  251. if response.status_code == 200:
  252. result = response.json()
  253. if result.get("ok"):
  254. return True, "Message sent successfully"
  255. else:
  256. return False, f"Telegram error: {result.get('description', 'Unknown error')}"
  257. else:
  258. return False, f"HTTP {response.status_code}: {response.text[:200]}"
  259. async def _send_email(self, config: dict, subject: str, body: str) -> tuple[bool, str]:
  260. """Send notification via email (SMTP)."""
  261. smtp_server = config.get("smtp_server", "").strip()
  262. smtp_port = int(config.get("smtp_port", 587))
  263. username = config.get("username", "").strip()
  264. password = config.get("password", "").strip()
  265. from_email = config.get("from_email", "").strip()
  266. to_email = config.get("to_email", "").strip()
  267. # Security: "starttls" (port 587), "ssl" (port 465), "none" (port 25)
  268. security = config.get("security", "starttls")
  269. # Authentication: "true" or "false"
  270. auth_enabled = config.get("auth_enabled", "true").lower() == "true"
  271. if not all([smtp_server, from_email, to_email]):
  272. return False, "SMTP server, from email, and to email are required"
  273. if auth_enabled and not all([username, password]):
  274. return False, "Username and password are required when authentication is enabled"
  275. try:
  276. msg = MIMEMultipart()
  277. msg["From"] = from_email
  278. msg["To"] = to_email
  279. msg["Subject"] = f"[Bambuddy] {subject}"
  280. msg.attach(MIMEText(body, "plain"))
  281. if security == "ssl":
  282. # Direct SSL connection (typically port 465)
  283. server = smtplib.SMTP_SSL(smtp_server, smtp_port)
  284. elif security == "starttls":
  285. # STARTTLS upgrade (typically port 587)
  286. server = smtplib.SMTP(smtp_server, smtp_port)
  287. server.starttls()
  288. else:
  289. # No encryption (typically port 25) - use with caution
  290. server = smtplib.SMTP(smtp_server, smtp_port)
  291. if auth_enabled:
  292. server.login(username, password)
  293. server.sendmail(from_email, to_email, msg.as_string())
  294. server.quit()
  295. return True, "Email sent successfully"
  296. except smtplib.SMTPAuthenticationError:
  297. return False, "SMTP authentication failed - check username/password"
  298. except smtplib.SMTPException as e:
  299. return False, f"SMTP error: {str(e)}"
  300. except Exception as e:
  301. return False, f"Email error: {str(e)}"
  302. async def _send_discord(
  303. self, config: dict, title: str, message: str, image_data: bytes | None = None
  304. ) -> tuple[bool, str]:
  305. """Send notification via Discord webhook."""
  306. webhook_url = config.get("webhook_url", "").strip()
  307. if not webhook_url:
  308. return False, "Webhook URL is required"
  309. if not webhook_url.startswith("https://discord.com/api/webhooks/"):
  310. return False, "Invalid Discord webhook URL"
  311. # Discord embed format for nicer messages
  312. embed = {
  313. "title": title,
  314. "description": message,
  315. "color": 0x00AE42, # Bambu green
  316. }
  317. client = await self._get_client()
  318. if image_data:
  319. # Attach image via multipart form-data and reference in embed
  320. embed["image"] = {"url": "attachment://photo.jpg"}
  321. payload = {"embeds": [embed]}
  322. response = await client.post(
  323. webhook_url,
  324. data={"payload_json": json.dumps(payload)},
  325. files={"files[0]": ("photo.jpg", image_data, "image/jpeg")},
  326. )
  327. else:
  328. response = await client.post(webhook_url, json={"embeds": [embed]})
  329. if response.status_code in (200, 204):
  330. return True, "Message sent successfully"
  331. else:
  332. return False, f"HTTP {response.status_code}: {response.text[:200]}"
  333. async def _send_webhook(self, config: dict, title: str, message: str) -> tuple[bool, str]:
  334. """Send notification via generic webhook (POST JSON).
  335. Supports two payload formats:
  336. - generic: Custom field names with timestamp/source metadata
  337. - slack: Slack/Mattermost compatible format (just {"text": "..."})
  338. """
  339. webhook_url = config.get("webhook_url", "").strip()
  340. auth_header = config.get("auth_header", "").strip()
  341. payload_format = config.get("payload_format", "generic").strip()
  342. if not webhook_url:
  343. return False, "Webhook URL is required"
  344. # Build payload based on format
  345. if payload_format == "slack":
  346. # Slack/Mattermost format - just text field
  347. data = {"text": f"*{title}*\n{message}"}
  348. else:
  349. # Generic format with custom field names
  350. custom_field_title = config.get("field_title", "title").strip() or "title"
  351. custom_field_message = config.get("field_message", "message").strip() or "message"
  352. data = {
  353. custom_field_title: title,
  354. custom_field_message: message,
  355. "timestamp": datetime.now().isoformat(),
  356. "source": "Bambuddy",
  357. }
  358. headers = {"Content-Type": "application/json"}
  359. if auth_header:
  360. # Support "Bearer token" or just "token" format
  361. if " " in auth_header:
  362. headers["Authorization"] = auth_header
  363. else:
  364. headers["Authorization"] = f"Bearer {auth_header}"
  365. client = await self._get_client()
  366. try:
  367. response = await client.post(webhook_url, json=data, headers=headers)
  368. if response.status_code in (200, 201, 202, 204):
  369. return True, "Webhook delivered successfully"
  370. else:
  371. return False, f"HTTP {response.status_code}: {response.text[:200]}"
  372. except Exception as e:
  373. return False, f"Webhook error: {str(e)}"
  374. async def _send_to_provider(
  375. self,
  376. provider: NotificationProvider,
  377. title: str,
  378. message: str,
  379. db: AsyncSession | None = None,
  380. image_data: bytes | None = None,
  381. ) -> tuple[bool, str]:
  382. """Send notification to a specific provider."""
  383. # Check quiet hours
  384. if self._is_in_quiet_hours(provider):
  385. logger.info("Skipping notification to %s - quiet hours active", provider.name)
  386. return True, "Skipped - quiet hours"
  387. config = json.loads(provider.config) if isinstance(provider.config, str) else provider.config
  388. try:
  389. if provider.provider_type == "callmebot":
  390. return await self._send_callmebot(config, f"{title}\n{message}")
  391. elif provider.provider_type == "ntfy":
  392. return await self._send_ntfy(config, title, message, image_data=image_data)
  393. elif provider.provider_type == "pushover":
  394. return await self._send_pushover(config, title, message, image_data=image_data)
  395. elif provider.provider_type == "telegram":
  396. return await self._send_telegram(config, f"*{title}*\n{message}", image_data=image_data)
  397. elif provider.provider_type == "email":
  398. return await self._send_email(config, title, message)
  399. elif provider.provider_type == "discord":
  400. return await self._send_discord(config, title, message, image_data=image_data)
  401. elif provider.provider_type == "webhook":
  402. return await self._send_webhook(config, title, message)
  403. else:
  404. return False, f"Unknown provider type: {provider.provider_type}"
  405. except Exception as e:
  406. logger.exception("Error sending notification via %s", provider.provider_type)
  407. return False, str(e)
  408. async def _update_provider_status(
  409. self, db: AsyncSession, provider_id: int, success: bool, error: str | None = None
  410. ):
  411. """Update provider status after sending notification."""
  412. result = await db.execute(select(NotificationProvider).where(NotificationProvider.id == provider_id))
  413. provider = result.scalar_one_or_none()
  414. if provider:
  415. if success:
  416. provider.last_success = datetime.utcnow()
  417. else:
  418. provider.last_error = error
  419. provider.last_error_at = datetime.utcnow()
  420. await db.commit()
  421. async def _get_providers_for_event(
  422. self,
  423. db: AsyncSession,
  424. event_field: str,
  425. printer_id: int | None = None,
  426. ) -> list[NotificationProvider]:
  427. """Get all enabled providers that want a specific event type."""
  428. # Build the query dynamically based on event field
  429. query = select(NotificationProvider).where(
  430. NotificationProvider.enabled.is_(True),
  431. getattr(NotificationProvider, event_field).is_(True),
  432. )
  433. if printer_id is not None:
  434. query = query.where(
  435. (NotificationProvider.printer_id.is_(None)) | (NotificationProvider.printer_id == printer_id)
  436. )
  437. result = await db.execute(query)
  438. return list(result.scalars().all())
  439. async def _log_notification(
  440. self,
  441. db: AsyncSession,
  442. provider_id: int,
  443. event_type: str,
  444. title: str,
  445. message: str,
  446. success: bool,
  447. error_message: str | None = None,
  448. printer_id: int | None = None,
  449. printer_name: str | None = None,
  450. ):
  451. """Create a log entry for a sent notification."""
  452. try:
  453. log = NotificationLog(
  454. provider_id=provider_id,
  455. event_type=event_type,
  456. title=title,
  457. message=message,
  458. success=success,
  459. error_message=error_message,
  460. printer_id=printer_id,
  461. printer_name=printer_name,
  462. )
  463. db.add(log)
  464. await db.commit()
  465. except Exception as e:
  466. logger.warning("Failed to log notification: %s", e)
  467. # Don't fail the notification just because logging failed
  468. async def _send_to_providers(
  469. self,
  470. providers: list[NotificationProvider],
  471. title: str,
  472. message: str,
  473. db: AsyncSession,
  474. event_type: str = "unknown",
  475. printer_id: int | None = None,
  476. printer_name: str | None = None,
  477. force_immediate: bool = False,
  478. image_data: bytes | None = None,
  479. ):
  480. """Send notification to multiple providers and log the results.
  481. All notifications are always sent immediately. If digest mode is enabled,
  482. the notification is ALSO queued for the daily digest summary.
  483. """
  484. for provider in providers:
  485. try:
  486. # Always send notification immediately
  487. success, error = await self._send_to_provider(provider, title, message, db, image_data=image_data)
  488. # Also queue for digest if enabled (digest is a summary, not a queue)
  489. if provider.daily_digest_enabled and provider.daily_digest_time:
  490. await self._queue_for_digest(
  491. provider=provider,
  492. event_type=event_type,
  493. title=title,
  494. message=message,
  495. db=db,
  496. printer_id=printer_id,
  497. printer_name=printer_name,
  498. )
  499. await self._update_provider_status(db, provider.id, success, error if not success else None)
  500. await self._log_notification(
  501. db=db,
  502. provider_id=provider.id,
  503. event_type=event_type,
  504. title=title,
  505. message=message,
  506. success=success,
  507. error_message=error if not success else None,
  508. printer_id=printer_id,
  509. printer_name=printer_name,
  510. )
  511. if success:
  512. logger.info("Sent notification via %s", provider.name)
  513. else:
  514. logger.warning("Failed to send notification via %s: %s", provider.name, error)
  515. except Exception as e:
  516. logger.exception("Error sending notification via %s", provider.name)
  517. await self._update_provider_status(db, provider.id, False, str(e))
  518. await self._log_notification(
  519. db=db,
  520. provider_id=provider.id,
  521. event_type=event_type,
  522. title=title,
  523. message=message,
  524. success=False,
  525. error_message=str(e),
  526. printer_id=printer_id,
  527. printer_name=printer_name,
  528. )
  529. async def on_print_start(
  530. self,
  531. printer_id: int,
  532. printer_name: str,
  533. data: dict,
  534. db: AsyncSession,
  535. archive_data: dict | None = None,
  536. ):
  537. """Handle print start event - send notifications to relevant providers.
  538. Args:
  539. printer_id: The printer ID
  540. printer_name: The printer name
  541. data: MQTT event data with filename, subtask_name, remaining_time, raw_data
  542. db: Database session
  543. archive_data: Optional archive data with print_time_seconds from 3MF parsing
  544. """
  545. logger.info("on_print_start called for printer %s (%s)", printer_id, printer_name)
  546. providers = await self._get_providers_for_event(db, "on_print_start", printer_id)
  547. if not providers:
  548. logger.info("No notification providers configured for print_start event on printer %s", printer_id)
  549. return
  550. # Use subtask_name (project name) if available, otherwise use filename
  551. subtask_name = data.get("subtask_name")
  552. if subtask_name:
  553. # Replace underscores with spaces for readability
  554. filename = subtask_name.replace("_", " ")
  555. else:
  556. filename = self._clean_filename(data.get("filename", "Unknown"))
  557. # Priority for estimated_time:
  558. # 1. Archive's print_time_seconds from 3MF parsing (most reliable)
  559. # 2. MQTT remaining_time (may be 0 at print start)
  560. # 3. raw_data mc_remaining_time
  561. estimated_time = None
  562. # Try archive data first (from 3MF parsing - most reliable)
  563. if archive_data and archive_data.get("print_time_seconds"):
  564. estimated_time = archive_data["print_time_seconds"]
  565. logger.debug("Using print_time_seconds from archive: %s", estimated_time)
  566. # Fall back to MQTT remaining_time
  567. if estimated_time is None:
  568. estimated_time = data.get("remaining_time")
  569. if estimated_time:
  570. logger.debug("Using remaining_time from MQTT: %s", estimated_time)
  571. # Last resort: raw_data mc_remaining_time (in minutes, convert to seconds)
  572. if estimated_time is None:
  573. raw_time = data.get("raw_data", {}).get("mc_remaining_time")
  574. if raw_time:
  575. estimated_time = raw_time * 60
  576. logger.debug("Using mc_remaining_time from raw_data: %s", estimated_time)
  577. time_str = self._format_duration(estimated_time)
  578. variables = {
  579. "printer": printer_name,
  580. "filename": filename,
  581. "estimated_time": time_str,
  582. }
  583. # Extract image data for providers that support attachments (e.g. Pushover)
  584. image_data = None
  585. if archive_data:
  586. image_data = archive_data.get("image_data")
  587. logger.info("Found %s providers for print_start: %s", len(providers), [p.name for p in providers])
  588. title, message = await self._build_message_from_template(db, "print_start", variables)
  589. await self._send_to_providers(
  590. providers, title, message, db, "print_start", printer_id, printer_name, image_data=image_data
  591. )
  592. async def on_print_complete(
  593. self,
  594. printer_id: int,
  595. printer_name: str,
  596. status: str,
  597. data: dict,
  598. db: AsyncSession,
  599. archive_data: dict | None = None,
  600. ):
  601. """Handle print complete event - send notifications to relevant providers."""
  602. logger.info("on_print_complete called for printer %s (%s), status=%s", printer_id, printer_name, status)
  603. # Determine event type based on status
  604. if status == "completed":
  605. event_field = "on_print_complete"
  606. event_type = "print_complete"
  607. elif status in ("failed",):
  608. event_field = "on_print_failed"
  609. event_type = "print_failed"
  610. elif status in ("aborted", "stopped", "cancelled"):
  611. event_field = "on_print_stopped"
  612. event_type = "print_stopped"
  613. else:
  614. logger.warning("Unknown print status '%s', defaulting to on_print_complete", status)
  615. event_field = "on_print_complete"
  616. event_type = "print_complete"
  617. providers = await self._get_providers_for_event(db, event_field, printer_id)
  618. if not providers:
  619. logger.info("No notification providers configured for %s event on printer %s", event_field, printer_id)
  620. return
  621. # Use subtask_name (project name) if available, otherwise use filename
  622. subtask_name = data.get("subtask_name")
  623. if subtask_name:
  624. filename = subtask_name.replace("_", " ")
  625. else:
  626. filename = self._clean_filename(data.get("filename", "Unknown"))
  627. variables = {
  628. "printer": printer_name,
  629. "filename": filename,
  630. "duration": "Unknown",
  631. "filament_grams": "Unknown",
  632. "reason": "Unknown",
  633. }
  634. if archive_data:
  635. if archive_data.get("print_time_seconds"):
  636. variables["duration"] = self._format_duration(archive_data["print_time_seconds"])
  637. if archive_data.get("actual_filament_grams"):
  638. variables["filament_grams"] = f"{archive_data['actual_filament_grams']:.1f}"
  639. if status == "failed" and archive_data.get("failure_reason"):
  640. variables["reason"] = archive_data["failure_reason"]
  641. if archive_data.get("finish_photo_url"):
  642. variables["finish_photo_url"] = archive_data["finish_photo_url"]
  643. # Build per-slot breakdown string with AMS info when available
  644. if archive_data.get("usage_results"):
  645. parts = []
  646. for u in archive_data["usage_results"]:
  647. ams_id = u.get("ams_id", 0)
  648. tray_id = u.get("tray_id", 0)
  649. material = u.get("material", "Unknown") or "Unknown"
  650. used = u.get("weight_used", 0)
  651. if ams_id >= 128:
  652. slot_label = "Ext"
  653. else:
  654. slot_label = f"AMS-{chr(65 + ams_id)} T{tray_id + 1}"
  655. parts.append(f"{slot_label} {material}: {used:.1f}g")
  656. variables["filament_details"] = " | ".join(parts)
  657. elif archive_data.get("filament_slots"):
  658. parts = []
  659. for slot in archive_data["filament_slots"]:
  660. ftype = slot.get("type", "Unknown") or "Unknown"
  661. used = slot.get("used_g", 0)
  662. parts.append(f"{ftype}: {used:.1f}g")
  663. variables["filament_details"] = " | ".join(parts)
  664. # Add progress for partial prints
  665. if archive_data.get("progress") is not None:
  666. variables["progress"] = str(archive_data["progress"])
  667. # Extract image data for providers that support attachments (e.g. Pushover)
  668. image_data = None
  669. if archive_data:
  670. image_data = archive_data.get("image_data")
  671. logger.info("Found %s providers for %s: %s", len(providers), event_field, [p.name for p in providers])
  672. title, message = await self._build_message_from_template(db, event_type, variables)
  673. await self._send_to_providers(
  674. providers, title, message, db, event_type, printer_id, printer_name, image_data=image_data
  675. )
  676. async def on_print_progress(
  677. self,
  678. printer_id: int,
  679. printer_name: str,
  680. filename: str,
  681. progress: int,
  682. db: AsyncSession,
  683. remaining_time: int | None = None,
  684. image_data: bytes | None = None,
  685. ):
  686. """Handle print progress milestone (25%, 50%, 75%)."""
  687. providers = await self._get_providers_for_event(db, "on_print_progress", printer_id)
  688. if not providers:
  689. return
  690. variables = {
  691. "printer": printer_name,
  692. "filename": self._clean_filename(filename),
  693. "progress": str(progress),
  694. "remaining_time": self._format_duration(remaining_time) if remaining_time else "Unknown",
  695. }
  696. title, message = await self._build_message_from_template(db, "print_progress", variables)
  697. await self._send_to_providers(
  698. providers, title, message, db, "print_progress", printer_id, printer_name, image_data=image_data
  699. )
  700. async def on_printer_offline(self, printer_id: int, printer_name: str, db: AsyncSession):
  701. """Handle printer offline event."""
  702. providers = await self._get_providers_for_event(db, "on_printer_offline", printer_id)
  703. if not providers:
  704. return
  705. variables = {"printer": printer_name}
  706. title, message = await self._build_message_from_template(db, "printer_offline", variables)
  707. await self._send_to_providers(providers, title, message, db, "printer_offline", printer_id, printer_name)
  708. async def on_printer_error(
  709. self,
  710. printer_id: int,
  711. printer_name: str,
  712. error_type: str,
  713. db: AsyncSession,
  714. error_detail: str | None = None,
  715. image_data: bytes | None = None,
  716. ):
  717. """Handle printer error event (AMS issues, etc.)."""
  718. providers = await self._get_providers_for_event(db, "on_printer_error", printer_id)
  719. if not providers:
  720. return
  721. variables = {
  722. "printer": printer_name,
  723. "error_type": error_type,
  724. "error_detail": error_detail or "No details available",
  725. }
  726. title, message = await self._build_message_from_template(db, "printer_error", variables)
  727. await self._send_to_providers(
  728. providers, title, message, db, "printer_error", printer_id, printer_name, image_data=image_data
  729. )
  730. async def on_plate_not_empty(
  731. self,
  732. printer_id: int,
  733. printer_name: str,
  734. db: AsyncSession,
  735. difference_percent: float | None = None,
  736. ):
  737. """Handle plate not empty event - objects detected on build plate before print."""
  738. providers = await self._get_providers_for_event(db, "on_plate_not_empty", printer_id)
  739. if not providers:
  740. return
  741. variables = {
  742. "printer": printer_name,
  743. "difference_percent": f"{difference_percent:.1f}" if difference_percent else "N/A",
  744. }
  745. title, message = await self._build_message_from_template(db, "plate_not_empty", variables)
  746. await self._send_to_providers(
  747. providers, title, message, db, "plate_not_empty", printer_id, printer_name, force_immediate=True
  748. )
  749. async def on_filament_low(
  750. self,
  751. printer_id: int,
  752. printer_name: str,
  753. slot: int,
  754. remaining_percent: int,
  755. db: AsyncSession,
  756. color: str | None = None,
  757. ):
  758. """Handle low filament event."""
  759. providers = await self._get_providers_for_event(db, "on_filament_low", printer_id)
  760. if not providers:
  761. return
  762. variables = {
  763. "printer": printer_name,
  764. "slot": str(slot),
  765. "remaining_percent": str(remaining_percent),
  766. "color": color or "",
  767. }
  768. title, message = await self._build_message_from_template(db, "filament_low", variables)
  769. await self._send_to_providers(providers, title, message, db, "filament_low", printer_id, printer_name)
  770. async def on_maintenance_due(
  771. self,
  772. printer_id: int,
  773. printer_name: str,
  774. maintenance_items: list[dict],
  775. db: AsyncSession,
  776. ):
  777. """Handle maintenance due event - sends notification when maintenance is due or warning."""
  778. if not maintenance_items:
  779. return
  780. providers = await self._get_providers_for_event(db, "on_maintenance_due", printer_id)
  781. if not providers:
  782. logger.info("No notification providers configured for maintenance_due event on printer %s", printer_id)
  783. return
  784. # Format maintenance items list
  785. items_list = []
  786. for item in maintenance_items:
  787. status = "OVERDUE" if item.get("is_due") else "Soon"
  788. items_list.append(f"- {item['name']} ({status})")
  789. items_str = "\n".join(items_list)
  790. variables = {
  791. "printer": printer_name,
  792. "items": items_str,
  793. }
  794. logger.info("Found %s providers for maintenance_due: %s", len(providers), [p.name for p in providers])
  795. title, message = await self._build_message_from_template(db, "maintenance_due", variables)
  796. await self._send_to_providers(providers, title, message, db, "maintenance_due", printer_id, printer_name)
  797. async def on_ams_humidity_high(
  798. self,
  799. printer_id: int,
  800. printer_name: str,
  801. ams_label: str,
  802. humidity: float,
  803. threshold: float,
  804. db: AsyncSession,
  805. ):
  806. """Handle AMS high humidity alarm event. Always sends immediately (bypasses digest)."""
  807. providers = await self._get_providers_for_event(db, "on_ams_humidity_high", printer_id)
  808. if not providers:
  809. return
  810. variables = {
  811. "printer": printer_name,
  812. "ams_label": ams_label,
  813. "humidity": f"{humidity:.0f}",
  814. "threshold": f"{threshold:.0f}",
  815. }
  816. title, message = await self._build_message_from_template(db, "ams_humidity_high", variables)
  817. # Alarms always send immediately, bypassing digest mode
  818. await self._send_to_providers(
  819. providers, title, message, db, "ams_humidity_high", printer_id, printer_name, force_immediate=True
  820. )
  821. async def on_ams_temperature_high(
  822. self,
  823. printer_id: int,
  824. printer_name: str,
  825. ams_label: str,
  826. temperature: float,
  827. threshold: float,
  828. db: AsyncSession,
  829. ):
  830. """Handle AMS high temperature alarm event. Always sends immediately (bypasses digest)."""
  831. providers = await self._get_providers_for_event(db, "on_ams_temperature_high", printer_id)
  832. if not providers:
  833. return
  834. variables = {
  835. "printer": printer_name,
  836. "ams_label": ams_label,
  837. "temperature": f"{temperature:.1f}",
  838. "threshold": f"{threshold:.1f}",
  839. }
  840. title, message = await self._build_message_from_template(db, "ams_temperature_high", variables)
  841. # Alarms always send immediately, bypassing digest mode
  842. await self._send_to_providers(
  843. providers, title, message, db, "ams_temperature_high", printer_id, printer_name, force_immediate=True
  844. )
  845. async def on_ams_ht_humidity_high(
  846. self,
  847. printer_id: int,
  848. printer_name: str,
  849. ams_label: str,
  850. humidity: float,
  851. threshold: float,
  852. db: AsyncSession,
  853. ):
  854. """Handle AMS-HT high humidity alarm event. Always sends immediately (bypasses digest)."""
  855. providers = await self._get_providers_for_event(db, "on_ams_ht_humidity_high", printer_id)
  856. if not providers:
  857. return
  858. variables = {
  859. "printer": printer_name,
  860. "ams_label": ams_label,
  861. "humidity": f"{humidity:.0f}",
  862. "threshold": f"{threshold:.0f}",
  863. }
  864. # Use the same template as regular AMS (can create separate templates later if needed)
  865. title, message = await self._build_message_from_template(db, "ams_humidity_high", variables)
  866. # Alarms always send immediately, bypassing digest mode
  867. await self._send_to_providers(
  868. providers, title, message, db, "ams_ht_humidity_high", printer_id, printer_name, force_immediate=True
  869. )
  870. async def on_ams_ht_temperature_high(
  871. self,
  872. printer_id: int,
  873. printer_name: str,
  874. ams_label: str,
  875. temperature: float,
  876. threshold: float,
  877. db: AsyncSession,
  878. ):
  879. """Handle AMS-HT high temperature alarm event. Always sends immediately (bypasses digest)."""
  880. providers = await self._get_providers_for_event(db, "on_ams_ht_temperature_high", printer_id)
  881. if not providers:
  882. return
  883. variables = {
  884. "printer": printer_name,
  885. "ams_label": ams_label,
  886. "temperature": f"{temperature:.1f}",
  887. "threshold": f"{threshold:.1f}",
  888. }
  889. # Use the same template as regular AMS (can create separate templates later if needed)
  890. title, message = await self._build_message_from_template(db, "ams_temperature_high", variables)
  891. # Alarms always send immediately, bypassing digest mode
  892. await self._send_to_providers(
  893. providers, title, message, db, "ams_ht_temperature_high", printer_id, printer_name, force_immediate=True
  894. )
  895. async def on_bed_cooled(
  896. self,
  897. printer_id: int,
  898. printer_name: str,
  899. bed_temp: float,
  900. threshold: float,
  901. filename: str,
  902. db: AsyncSession,
  903. ):
  904. """Handle bed cooled event - bed temperature dropped below threshold after print."""
  905. providers = await self._get_providers_for_event(db, "on_bed_cooled", printer_id)
  906. if not providers:
  907. return
  908. variables = {
  909. "printer": printer_name,
  910. "bed_temp": f"{bed_temp:.0f}",
  911. "threshold": f"{threshold:.0f}",
  912. "filename": self._clean_filename(filename) if filename else "Unknown",
  913. }
  914. title, message = await self._build_message_from_template(db, "bed_cooled", variables)
  915. await self._send_to_providers(providers, title, message, db, "bed_cooled", printer_id, printer_name)
  916. def clear_template_cache(self):
  917. """Clear the template cache. Call this when templates are updated."""
  918. self._template_cache.clear()
  919. # ==================== Queue Notifications ====================
  920. async def on_queue_job_added(
  921. self,
  922. job_name: str,
  923. target: str,
  924. db: AsyncSession,
  925. printer_id: int | None = None,
  926. printer_name: str | None = None,
  927. ):
  928. """Handle queue job added event."""
  929. providers = await self._get_providers_for_event(db, "on_queue_job_added", printer_id)
  930. if not providers:
  931. return
  932. variables = {
  933. "job_name": job_name,
  934. "target": target, # e.g., "Printer1" or "Any X1C"
  935. "printer": printer_name or target,
  936. }
  937. title, message = await self._build_message_from_template(db, "queue_job_added", variables)
  938. await self._send_to_providers(providers, title, message, db, "queue_job_added", printer_id, printer_name)
  939. async def on_queue_job_assigned(
  940. self,
  941. job_name: str,
  942. printer_id: int,
  943. printer_name: str,
  944. target_model: str,
  945. db: AsyncSession,
  946. ):
  947. """Handle model-based job assigned to printer event."""
  948. providers = await self._get_providers_for_event(db, "on_queue_job_assigned", printer_id)
  949. if not providers:
  950. return
  951. variables = {
  952. "job_name": job_name,
  953. "printer": printer_name,
  954. "target_model": target_model,
  955. }
  956. title, message = await self._build_message_from_template(db, "queue_job_assigned", variables)
  957. await self._send_to_providers(providers, title, message, db, "queue_job_assigned", printer_id, printer_name)
  958. async def on_queue_job_started(
  959. self,
  960. job_name: str,
  961. printer_id: int,
  962. printer_name: str,
  963. db: AsyncSession,
  964. estimated_time: int | None = None,
  965. ):
  966. """Handle queue job started printing event."""
  967. providers = await self._get_providers_for_event(db, "on_queue_job_started", printer_id)
  968. if not providers:
  969. return
  970. variables = {
  971. "job_name": job_name,
  972. "printer": printer_name,
  973. "estimated_time": self._format_duration(estimated_time),
  974. }
  975. title, message = await self._build_message_from_template(db, "queue_job_started", variables)
  976. await self._send_to_providers(providers, title, message, db, "queue_job_started", printer_id, printer_name)
  977. async def on_queue_job_waiting(
  978. self,
  979. job_name: str,
  980. target_model: str,
  981. waiting_reason: str,
  982. db: AsyncSession,
  983. ):
  984. """Handle job waiting for filament event."""
  985. providers = await self._get_providers_for_event(db, "on_queue_job_waiting", None)
  986. if not providers:
  987. return
  988. variables = {
  989. "job_name": job_name,
  990. "target_model": target_model,
  991. "waiting_reason": waiting_reason,
  992. }
  993. title, message = await self._build_message_from_template(db, "queue_job_waiting", variables)
  994. await self._send_to_providers(providers, title, message, db, "queue_job_waiting")
  995. async def on_queue_job_skipped(
  996. self,
  997. job_name: str,
  998. printer_id: int,
  999. printer_name: str,
  1000. reason: str,
  1001. db: AsyncSession,
  1002. ):
  1003. """Handle job skipped event (e.g., previous print failed)."""
  1004. providers = await self._get_providers_for_event(db, "on_queue_job_skipped", printer_id)
  1005. if not providers:
  1006. return
  1007. variables = {
  1008. "job_name": job_name,
  1009. "printer": printer_name,
  1010. "reason": reason,
  1011. }
  1012. title, message = await self._build_message_from_template(db, "queue_job_skipped", variables)
  1013. await self._send_to_providers(providers, title, message, db, "queue_job_skipped", printer_id, printer_name)
  1014. async def on_queue_job_failed(
  1015. self,
  1016. job_name: str,
  1017. printer_id: int | None,
  1018. printer_name: str | None,
  1019. reason: str,
  1020. db: AsyncSession,
  1021. ):
  1022. """Handle job failed to start event (upload error, etc.)."""
  1023. providers = await self._get_providers_for_event(db, "on_queue_job_failed", printer_id)
  1024. if not providers:
  1025. return
  1026. variables = {
  1027. "job_name": job_name,
  1028. "printer": printer_name or "Unknown",
  1029. "reason": reason,
  1030. }
  1031. title, message = await self._build_message_from_template(db, "queue_job_failed", variables)
  1032. await self._send_to_providers(providers, title, message, db, "queue_job_failed", printer_id, printer_name)
  1033. async def on_queue_completed(
  1034. self,
  1035. completed_count: int,
  1036. db: AsyncSession,
  1037. ):
  1038. """Handle all queue jobs completed event."""
  1039. providers = await self._get_providers_for_event(db, "on_queue_completed", None)
  1040. if not providers:
  1041. return
  1042. variables = {
  1043. "completed_count": str(completed_count),
  1044. }
  1045. title, message = await self._build_message_from_template(db, "queue_completed", variables)
  1046. await self._send_to_providers(providers, title, message, db, "queue_completed")
  1047. async def _queue_for_digest(
  1048. self,
  1049. provider: NotificationProvider,
  1050. event_type: str,
  1051. title: str,
  1052. message: str,
  1053. db: AsyncSession,
  1054. printer_id: int | None = None,
  1055. printer_name: str | None = None,
  1056. ):
  1057. """Queue a notification for later delivery in the daily digest."""
  1058. try:
  1059. queue_entry = NotificationDigestQueue(
  1060. provider_id=provider.id,
  1061. event_type=event_type,
  1062. title=title,
  1063. message=message,
  1064. printer_id=printer_id,
  1065. printer_name=printer_name,
  1066. )
  1067. db.add(queue_entry)
  1068. await db.commit()
  1069. logger.info("Queued notification for digest: %s for provider %s", event_type, provider.name)
  1070. except Exception as e:
  1071. logger.warning("Failed to queue notification for digest: %s", e)
  1072. async def send_digest(self, provider_id: int):
  1073. """Send all queued notifications as a single digest for a provider."""
  1074. from backend.app.core.database import async_session
  1075. async with async_session() as db:
  1076. # Get the provider
  1077. result = await db.execute(select(NotificationProvider).where(NotificationProvider.id == provider_id))
  1078. provider = result.scalar_one_or_none()
  1079. if not provider or not provider.enabled:
  1080. return
  1081. # Get all queued notifications for this provider
  1082. result = await db.execute(
  1083. select(NotificationDigestQueue)
  1084. .where(NotificationDigestQueue.provider_id == provider_id)
  1085. .order_by(NotificationDigestQueue.created_at)
  1086. )
  1087. queue_entries = list(result.scalars().all())
  1088. if not queue_entries:
  1089. logger.debug("No queued notifications for provider %s", provider.name)
  1090. return
  1091. # Build digest message
  1092. title = f"Daily Digest - {len(queue_entries)} Events"
  1093. # Group by event type
  1094. events_by_type: dict[str, list] = {}
  1095. for entry in queue_entries:
  1096. if entry.event_type not in events_by_type:
  1097. events_by_type[entry.event_type] = []
  1098. events_by_type[entry.event_type].append(entry)
  1099. # Format the digest body
  1100. body_parts = []
  1101. for event_type, entries in events_by_type.items():
  1102. event_label = event_type.replace("_", " ").title()
  1103. body_parts.append(f"== {event_label} ({len(entries)}) ==")
  1104. for entry in entries:
  1105. time_str = entry.created_at.strftime("%H:%M")
  1106. printer_info = f"[{entry.printer_name}] " if entry.printer_name else ""
  1107. body_parts.append(f" {time_str} {printer_info}{entry.title}")
  1108. body_parts.append("")
  1109. body = "\n".join(body_parts)
  1110. # Send the digest
  1111. success, error = await self._send_to_provider(provider, title, body, db)
  1112. # Log the digest
  1113. await self._log_notification(
  1114. db=db,
  1115. provider_id=provider.id,
  1116. event_type="daily_digest",
  1117. title=title,
  1118. message=body,
  1119. success=success,
  1120. error_message=error if not success else None,
  1121. )
  1122. # Clear the queue
  1123. for entry in queue_entries:
  1124. await db.delete(entry)
  1125. await db.commit()
  1126. if success:
  1127. logger.info("Sent daily digest with %s events to %s", len(queue_entries), provider.name)
  1128. else:
  1129. logger.warning("Failed to send daily digest to %s: %s", provider.name, error)
  1130. async def check_and_send_digests(self):
  1131. """Check all providers and send digests if it's their scheduled time."""
  1132. from backend.app.core.database import async_session
  1133. current_time = datetime.now().strftime("%H:%M")
  1134. # Avoid duplicate checks within the same minute
  1135. if current_time == self._last_digest_check:
  1136. return
  1137. self._last_digest_check = current_time
  1138. async with async_session() as db:
  1139. # Find all providers with digest enabled at this time
  1140. result = await db.execute(
  1141. select(NotificationProvider).where(
  1142. NotificationProvider.enabled.is_(True),
  1143. NotificationProvider.daily_digest_enabled.is_(True),
  1144. NotificationProvider.daily_digest_time == current_time,
  1145. )
  1146. )
  1147. providers = result.scalars().all()
  1148. for provider in providers:
  1149. try:
  1150. await self.send_digest(provider.id)
  1151. except Exception as e:
  1152. logger.error("Error sending digest for provider %s: %s", provider.id, e)
  1153. def start_digest_scheduler(self):
  1154. """Start the background scheduler for daily digest notifications."""
  1155. if self._digest_scheduler_task is None:
  1156. self._digest_scheduler_task = asyncio.create_task(self._digest_scheduler_loop())
  1157. logger.info("Notification digest scheduler started")
  1158. def stop_digest_scheduler(self):
  1159. """Stop the background scheduler for daily digests."""
  1160. if self._digest_scheduler_task:
  1161. self._digest_scheduler_task.cancel()
  1162. self._digest_scheduler_task = None
  1163. logger.info("Notification digest scheduler stopped")
  1164. async def _digest_scheduler_loop(self):
  1165. """Background loop that checks for scheduled digests every minute."""
  1166. while True:
  1167. try:
  1168. await self.check_and_send_digests()
  1169. except Exception as e:
  1170. logger.error("Error in digest scheduler: %s", e)
  1171. # Wait until the next minute
  1172. await asyncio.sleep(60)
  1173. # Global instance
  1174. notification_service = NotificationService()