You're offline — showing cached data

Pull booking curve data from Neon DB

booking-curve-pull
2026-06-13 06:11:47 SAST
← Back to Tasks

OVERRIDES runtime profile: uses direct_python (plain Python, no model) because the command chain never invokes the claude CLI or any LLM API — pure-infra task; scheduler provider env injection is a no-op (MC-4942 U12 sweep).

Weekday booking curve pull. Queries the FlySafair Neon PostgreSQL database for the current month route-level daily snapshot data and uploads as CSV to the Booking Curves folder on Google Drive.

Runs weekdays at 8:10am SAST (6:10 UTC) — after ACSA monthly (7am), before ACSA website (8am Tue) and IATA fuel (8:30am Tue).

100% Python, zero AI cost. ~5 seconds per run.

Source: Neon DB (summary_route_daily_snapshots) Target: Google Drive Booking Curves folder (ID: 1wcTbDjNWytoMpCqFZHwlNdP4qLvto3DG) Output: YYYYMM Booking Curve.csv

Weekdays at 06:000 6 * * 1-5
Yes
shell
120s
Yes
in 2d (2026-06-15 06:00)

Task Definition

tasks/booking-curve-pull.md
shell
set
No
No
cd /home/lucienne/workspace && python3 scripts/booking_curve_pull.py

Edit Schedule

Result:
5
Runs (7d)
5
Completed
0
Failed
0
Timeout
100%
Success (7d)
25s
Avg Duration
flysafair booking-curve neondb data

Run History (5)

StartedFinishedStatusDurationOutputLog
1d ago 1d ago completed 30s
=== Booking Curve Pull — 2026-06-12 === Pulling data for June 2026 Query returned 156731 rows Saved to /home/lucienne/wo ...
View log
2d ago 2d ago completed 29s
=== Booking Curve Pull — 2026-06-11 === Pulling data for June 2026 Query returned 155607 rows Saved to /home/lucienne/wo ...
View log
3d ago 3d ago completed 28s
=== Booking Curve Pull — 2026-06-10 === Pulling data for June 2026 Query returned 154414 rows Saved to /home/lucienne/wo ...
View log
4d ago 4d ago completed 19s
=== Booking Curve Pull — 2026-06-09 === Pulling data for June 2026 Query returned 153221 rows Saved to /home/lucienne/wo ...
View log
5d ago 5d ago completed 19s
=== Booking Curve Pull — 2026-06-08 === Pulling data for June 2026 Query returned 152028 rows Saved to /home/lucienne/wo ...
View log

Comments (2)

elmar 39d ago
test from luci
luci 38d ago
Read 1 comment(s). Action: RUN
Help