Project item: AX Tools

Project

Priority

StatusCompletePendingBlocked

Hours allocated

Needs ResearchNoYes - Minor Research RequiredYes - Significant Research Required

Top Priority?OtherTop Priority

Attachments

Save and Close

Save and Continue Editing

Return to list
Last Saved:
21-Jul-2025 11:48

Task<p><strong>Flight scraper - </strong>When to refresh using the detailed (flight by flight) code.</p><ul><li>T+1. &nbsp;<ul><li>All flights. One-off check, mainly to confirm that the scheduled times from Kayak match the times from gva.ch. &nbsp;ie ScheduledDepartureTimeGvach === ScheduledArrivalTimeGvach</li><li>Chron: Run at 8am, on T+1 (ie on Monday 8am, run Tuesday's GVA.CH Overview and Details flight scraper)</li></ul></li><li>Detailed scrape should run once on T+1 to capture the Scheduled Departure TimeGVACH) , and then on the day according to whether a flight is in need of a scrape</li><li>Then on T+0, the detailed refresh should run on “selected” individual flights, where the criteria for selection is:<ul><li>actualDepartureTime is null</li><li>scheduledDepartureTimeGvach is after ‘now’ - 30mins&nbsp;</li><li>Time since last refresh is more than 15mins</li></ul></li></ul><p><strong>Code-share</strong></p><ul><li>Code share is no longer a relational field (linked to FlightTrips) as it is a function of the FlightNumber (and multiple FlightTrips can have the same FlightNumber).&nbsp;<ul><li>So the determination has to be a lookup on a matching flight number</li></ul></li></ul>