projects.py 886 B

12345678910111213141516171819202122232425262728293031323334
  1. # -*- coding: utf-8 -*-
  2. """
  3. Created on Wed Jul 23 20:50:24 2025
  4. @author: USER
  5. """
  6. from notion_client import Client
  7. # --- CONFIGURATION ---
  8. NOTION_TOKEN = "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"
  9. PROJECTS_DB_ID = "3a13ae080e7d4cda9865008812fd97fa"
  10. notion = Client(auth=NOTION_TOKEN)
  11. # --- RÉCUPÉRER TOUS LES PROJETS ---
  12. def get_project_pages():
  13. pages = []
  14. cursor = None
  15. while True:
  16. res = notion.databases.query(database_id=PROJECTS_DB_ID, start_cursor=cursor)
  17. pages.extend(res["results"])
  18. if not res.get("has_more"):
  19. break
  20. cursor = res.get("next_cursor")
  21. result = []
  22. for p in pages:
  23. props = p["properties"]
  24. name_data = props.get("Name", {}).get("title", [])
  25. name = name_data[0]["plain_text"] if name_data else ""
  26. result.append((p["id"], name))
  27. return result