main.py 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. # -*- coding: utf-8 -*-
  2. """
  3. Created on Wed Jul 23 20:29:03 2025
  4. @author: USER
  5. """
  6. from projects import get_project_pages
  7. from getDB import find_database_in_page
  8. from notion_tasks import extract_tasks
  9. import csv
  10. def main():
  11. tasks_mirror = []
  12. projects = get_project_pages()
  13. #projects = projects[:3] # ⬅️ Limité à 3 projets
  14. for page_id, project_name in projects:
  15. task_db_id = find_database_in_page(page_id)
  16. if task_db_id:
  17. tasks = extract_tasks(task_db_id)
  18. # Injecter le nom du projet dans chaque tâche
  19. tasks = [(name, status, deadline, person, url, project_name) for (name, status, deadline, person, url) in tasks]
  20. tasks_mirror.extend(tasks)
  21. print(f"✅ {project_name} → {len(tasks)} tâches récupérées")
  22. else:
  23. print(f"⚠️ Pas de base 'To do' dans {project_name}")
  24. print(f"\n📊 Total : {len(tasks_mirror)} tâches dans le miroir.")
  25. with open("tasks_export.csv", "w", newline='', encoding="utf-8") as f:
  26. writer = csv.writer(f)
  27. writer.writerow(["Nom", "Statut", "Deadline", "Responsable", "Lien", "Projet"])
  28. writer.writerows(tasks_mirror)
  29. print("✅ Export global terminé → tasks_export.csv")
  30. if __name__ == "__main__":
  31. main()