mail_clean_document_notify_task.py 2.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. import logging
  2. import time
  3. from collections import defaultdict
  4. import click
  5. from celery import shared_task # type: ignore
  6. from extensions.ext_mail import mail
  7. from models.account import Account, Tenant, TenantAccountJoin
  8. from models.dataset import Dataset, DatasetAutoDisableLog
  9. @shared_task(queue="mail")
  10. def send_document_clean_notify_task():
  11. """
  12. Async Send document clean notify mail
  13. Usage: send_document_clean_notify_task.delay()
  14. """
  15. if not mail.is_inited():
  16. return
  17. logging.info(click.style("Start send document clean notify mail", fg="green"))
  18. start_at = time.perf_counter()
  19. # send document clean notify mail
  20. try:
  21. dataset_auto_disable_logs = DatasetAutoDisableLog.query.filter(DatasetAutoDisableLog.notified == False).all()
  22. # group by tenant_id
  23. dataset_auto_disable_logs_map: dict[str, list[DatasetAutoDisableLog]] = defaultdict(list)
  24. for dataset_auto_disable_log in dataset_auto_disable_logs:
  25. dataset_auto_disable_logs_map[dataset_auto_disable_log.tenant_id].append(dataset_auto_disable_log)
  26. for tenant_id, tenant_dataset_auto_disable_logs in dataset_auto_disable_logs_map.items():
  27. knowledge_details = []
  28. tenant = Tenant.query.filter(Tenant.id == tenant_id).first()
  29. if not tenant:
  30. continue
  31. current_owner_join = TenantAccountJoin.query.filter_by(tenant_id=tenant.id, role="owner").first()
  32. if not current_owner_join:
  33. continue
  34. account = Account.query.filter(Account.id == current_owner_join.account_id).first()
  35. if not account:
  36. continue
  37. dataset_auto_dataset_map = {} # type: ignore
  38. for dataset_auto_disable_log in tenant_dataset_auto_disable_logs:
  39. dataset_auto_dataset_map[dataset_auto_disable_log.dataset_id].append(
  40. dataset_auto_disable_log.document_id
  41. )
  42. for dataset_id, document_ids in dataset_auto_dataset_map.items():
  43. dataset = Dataset.query.filter(Dataset.id == dataset_id).first()
  44. if dataset:
  45. document_count = len(document_ids)
  46. knowledge_details.append(f"<li>Knowledge base {dataset.name}: {document_count} documents</li>")
  47. end_at = time.perf_counter()
  48. logging.info(
  49. click.style("Send document clean notify mail succeeded: latency: {}".format(end_at - start_at), fg="green")
  50. )
  51. except Exception:
  52. logging.exception("Send invite member mail to failed")