117 Commits

Author SHA1 Message Date
Power BI Dev a357e0622e throttle polling outside business hours
Single DAG, single 30-min schedule instead of 5-min or two separate
DAGs. run_sync() itself decides whether to do real work: always during
business hours (default 07:00-17:00 WIB), otherwise only once per
EDOXID_OFF_HOURS_INTERVAL_MINUTES (default 120) tracked via a
last_full_sync timestamp in the sqlite state. Off-hours skips return
immediately without touching DB/Calendar/Gmail at all.
2026-07-27 22:33:04 +07:00
Power BI Dev 7a6dc7d9ae fix invalid_scope error on token refresh
Requesting a narrower scope explicitly (scopes=[...]) during refresh
was rejected by Google as invalid_scope in the Airflow container's
google-auth version, even though it worked locally with a newer one.
Drop scopes= entirely — the refresh_token already carries the full
granted scope (calendar + gmail.send), no need to request a subset.
2026-07-27 22:16:31 +07:00
Power BI Dev e0a6efd204 fix python 3.8 compat for edoxid calendar sync
apache/airflow:2.7.1 base image ships Python 3.8, which doesn't have
zoneinfo (3.9+) and can't evaluate `X | Y` / list[X] type hints at
runtime (3.10+). Add `from __future__ import annotations` everywhere
and swap zoneinfo -> pytz (already a dependency in this repo).
2026-07-27 22:10:10 +07:00
Power BI Dev 33f4666bad add edoxid calendar sync dag
Sync jadwal sidang eDOXID ke Google Calendar "Jadwal Sidang" tiap 5 menit
(read-only ke doxid2022), plus reminder email H-1/1-jam via Gmail API
karena reminder Calendar bawaan tidak ikut ke kalender pribadi attendee.
2026-07-27 21:59:27 +07:00
Power BI Dev c6edee7aeb penelitian scheduler 2026-07-18 22:29:29 +07:00
Debby d21fac69aa add condition at framework and edit narrative indicator 2026-07-16 09:57:16 +07:00
Debby 989d3445a0 add condition in framework 2026-07-01 19:50:44 +07:00
Debby f738eacbfb add condition desk 2026-06-29 18:16:08 +07:00
Debby d379b2c729 add a condition for pillar 2026-06-29 10:29:44 +07:00
Debby ebc189f2a0 rename pillar 2026-06-27 13:23:02 +07:00
Debby 17cc7833ad lowercase key 2026-06-07 12:11:13 +07:00
Debby 1007e30764 agg list 2026-06-07 11:39:09 +07:00
Debby f512b73d32 rename indicators 2026-06-07 10:53:44 +07:00
Debby 43f0e36233 delete translator 2026-06-07 09:36:49 +07:00
Debby 355f31b096 add library translated 2026-06-07 09:19:15 +07:00
Debby 777865ffe1 translate indo 2026-06-07 09:10:14 +07:00
Debby ca1e0d3949 country name indo version 2026-06-07 08:09:14 +07:00
Debby 512c08bff3 add sustainability ind version 2026-06-05 17:49:42 +07:00
Debby cfb0df3a15 indonesian version column 2026-05-19 10:09:48 +07:00
Debby 4bab746779 create colomn indonesian text 2026-05-12 09:55:15 +07:00
Debby f9d013f8e6 new narrative teks 2026-04-22 16:02:05 +07:00
Debby 40528766bd add metadata aggregate 2026-04-16 08:14:10 +07:00
Debby 74be63226a dag etl 2026-04-15 13:56:55 +07:00
Debby 76b451b2c1 schdule /3 bulan dan tambah metadata 2026-04-15 13:37:40 +07:00
Debby fa2cf75634 ganti narasi 2026-04-07 23:10:34 +07:00
Debby f13a76756f capek eror 2026-04-07 20:58:34 +07:00
Debby e00e9c569d sum indicator problem solve 2026-04-07 20:04:52 +07:00
Debby 00cdf961a9 ulang 2026-04-07 19:14:10 +07:00
Debby 8aed670267 narrative indicator 2026-04-07 18:15:58 +07:00
Debby 327768cc01 delete mark 2026-04-07 11:48:41 +07:00
Debby 7ccc3ea35d rename pillar 2026-04-07 11:07:58 +07:00
Debby 933c370606 try again 2026-04-07 10:19:35 +07:00
Debby 0384e62b01 bismillah done 2026-04-07 10:00:45 +07:00
Debby cebb6b88eb finish etl code 2026-04-06 16:37:05 +07:00
Debby 5313039b50 bismillah capekk 2026-04-03 08:40:30 +07:00
Debby f652f2f730 agregate fact selected 2026-04-03 08:09:57 +07:00
Debby d4bee86331 finish fact dan dim 2026-04-02 20:31:19 +07:00
Debby 47ea9c0492 code last done 2026-04-02 19:58:05 +07:00
Debby 6030268924 salah file 2026-04-02 17:43:31 +07:00
Debby b54b276c63 done 1 2026-04-02 17:34:33 +07:00
Debby ba4927f620 rename other to supporting 2026-04-02 07:54:23 +07:00
Debby ffd8cdf65e year hardcode sdgs 2026-04-02 07:10:41 +07:00
Debby 189e8895c9 coba 1 2026-04-01 21:30:54 +07:00
Debby b7cab36bd9 framework v2 2026-04-01 20:42:54 +07:00
Debby d948819535 framework v1 2026-04-01 20:33:16 +07:00
Debby c3b7674001 keawal 2026-04-01 15:58:59 +07:00
Debby 6a55a91112 code final 2026-04-01 15:46:20 +07:00
Debby 0f93ff6ecd try1 2026-04-01 08:29:18 +07:00
Debby db60e6e414 sdgs era v5 2026-04-01 08:04:19 +07:00
Debby 236d4b4dc8 sdgs year v4 2026-04-01 07:43:31 +07:00